Re: MDB2 postgres error in prepare
| From: | Mario Gzuk | Date: | Thu, 14 Jul 2011 11:38:12 +0000 |
| Subject: | Re: MDB2 postgres error in prepare | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-31171@lists.php.net to get a copy of this message | ||
Ah ok. Thank you for this fast answer! (both)
I use quoteIdentifier(), but only as a global option. But I will rename the table... thank you again!
Cheers and have a nice weekend!
Am 14.07.2011 13:32, schrieb Lorenzo Alberton:
Mario Gzuk wrote:I am running:"user" is a reserved keyword in PostgreSQL, I wouldn't use it as a table name. If you do, remember to quote it in every query: if you use MDB2, use quoteIdentifier(). Best regards,MDB2 2.5.0b3 betaMDB2_Driver_pgsql 1.5.0b3 beta When running a prepare I got the following error: Native message: FEHLER: Syntaxfehler bei »user« Native message: ERROR: Syntaxerror on »user« The error is directly after the prepare statement.