[database] [Database] Toward better databases

[Joshua D. Drake]

On Mon, 2008-07-07 at 20:42 -0500, Larry Garfield wrote:
> On Monday 07 July 2008 8:44:40 am you wrote:
> > Howdy, everyone.  Here's my current brain-dump:
> >
> > 1.  Larry is correct that the pgsql driver is not currently working.
> > I haven't had a chance to bring it up to date with the latest API/
> > internal changes Larry made in the PDO patch.  However, there is not
> > actually any difficulty related to pgsql specifically; interacting
> > with pgsql through the PDO_PGSQL interface works fine and I've had
> > everything (including the blob support) working fine before.  It's
> > just a question of updating it for the latest version of the patch,
> > which I haven't done yet.  You know, the day job keeps me pretty
> > busy. :-)
> 
> I know the feeling. :-)
> 
> However, the problem I'm running into I have managed to track down (10 minutes 
> with a working debugger is worth weeks without one, dear god!), and it is 
> highly confusing.  The problem comes when creating the variable table.  All 
> of the test queries run fine, but when it gets to this query:
> 
> CREATE TABLE variable (
> 	name varchar(128) NOT NULL default '',
> 	value text NOT NULL,
> 	PRIMARY KEY (name)
> )
> 
> PHP dies completely.  I have not figured out why.  That query runs fine within 
> the psql command line, and it runs fine in a sample script I've created that, 
> I think, is mimicing the way the new Drupal driver works.  I am highly 
> confused by this, and it is making me sad. :-(
> 
> Josh, do you have any idea why the above query could be failing?

Well what does the database say?

log_min_messages = debug2
log_min_error_statement = error

reload, produce error, produce log, post :)

Joshua D. Drake