Re: MDB2 postgres error in prepare
| From: | Alexey Borzov | Date: | Thu, 14 Jul 2011 11:21:10 +0000 |
| Subject: | Re: MDB2 postgres error in prepare | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-31169@lists.php.net to get a copy of this message | ||
Hi Mario,
On 14.07.2011 15:15, Mario Gzuk wrote:
When running a prepare I got the following error: Native message: FEHLER: Syntaxfehler bei »user« Native message: ERROR: Syntaxerror on »user«
[Native message: FEHLER: Syntaxfehler bei »user« LINE 1: INSERT INTO user ("uidnumber","uid","cn","gidnumber","teleph... ^] The error is directly after the prepare statement.Your error has little to do with MDB2. 'user' is a reserved word [1] in Postgres, so you either don't name your objects 'user' or put the word in double quotes: INSERT INTO "user" (... [1] http://www.postgresql.org/docs/9.0/interactive/sql-keywords-appendix.html