Re: [PHP] PDO and PGSQL: ERROR: syntax error at or near "SET"

2006-08-07 Thread Richard Lynch
On Mon, August 7, 2006 6:48 am, Erik Gyepes wrote: > I'm trying to learn using PDO and PostgreSQL together a little bit and > I > have some problems with (I thinks, auto incrementing fields) > I have the following sample DB: > > CREATE TABLE users ( > uid SERIAL UNIQUE NOT NULL, My PostgreSQL know

Re: [PHP] PDO and PGSQL: ERROR: syntax error at or near "SET"

2006-08-07 Thread David Tulloh
Erik Gyepes wrote: > ... > $query = "INSERT INTO users SET uid = :uid, login = :login, password = > :password"; > ... > When running the script I get the following error message: Error!: > SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "SET" at > character 19 > The INSERT INT

[PHP] PDO and PGSQL: ERROR: syntax error at or near "SET"

2006-08-07 Thread Erik Gyepes
Hi all! I'm trying to learn using PDO and PostgreSQL together a little bit and I have some problems with (I thinks, auto incrementing fields) I have the following sample DB: CREATE TABLE users ( uid SERIAL UNIQUE NOT NULL, login TEXT NOT NULL, password TEXT NOT NULL, PRIMARY KEY (uid) ); and