Re: [GENERAL] PostgreSQL driver for Joomla review - Mailing list pgsql-php

From Thom Brown
Subject Re: [GENERAL] PostgreSQL driver for Joomla review
Date
Msg-id bddc86150910201200s6535464o42bc480ed2eb56b8@mail.gmail.com
Whole thread Raw
In response to PostgreSQL driver for Joomla review  (Thom Brown <thombrown@gmail.com>)
List pgsql-php
2009/10/20 Alban Hertroys <dalroi@solfertje.student.utwente.nl>:
> You miss a keyword in your query in renameTable; it should be " RENAME TO ",
> not " TO ".

Thanks for spotting that.  I've made my amendments for next submit.

> Wouldn't it be convenient to have an EXPLAIN ANALYSE version of explain()?
> Maybe with a boolean parameter?

The problem is, I don't see where they're using this function, so if
they're using it to EXPLAIN an INSERT, UPDATE or DELETE statement,
ANALYZE would execute it... unless I roll it back straight after.

> In insertObject() you have a query "SELECT $keyName AS 'id' FROM $table'" -
> That line contains two syntax errors: 'id' (You probably meant "id") and
> $table' (spurious trailing quote).

Again, you're right and well spotted. :)  Fixed both of those.

Cheers for helping out Alban! :D

Thom

pgsql-php by date:

Previous
From: Thom Brown
Date:
Subject: Re: [GENERAL] PostgreSQL driver for Joomla review
Next
From: Thom Brown
Date:
Subject: Re: [GENERAL] PostgreSQL driver for Joomla review