BUG #4704: syntax error at or near "RETURNING"
От | Brad Constantinescu |
---|---|
Тема | BUG #4704: syntax error at or near "RETURNING" |
Дата | |
Msg-id | 200903141247.n2EClmEJ057618@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4704: syntax error at or near "RETURNING"
Re: BUG #4704: syntax error at or near "RETURNING" |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 4704 Logged by: Brad Constantinescu Email address: brad.constantinescu@gmail.com PostgreSQL version: 8.1.4 Operating system: FreeBSD Description: syntax error at or near "RETURNING" Details: This is how the table looks like: CREATE TABLE orase ( id serial NOT NULL, judet_id bigint NOT NULL, nume character varying(256), nr_sectoare numeric(2), CONSTRAINT orase_pk PRIMARY KEY (id) ) WITH OIDS; ALTER TABLE orase OWNER TO erp; This is my code: INSERT INTO orase (id, nume, judet_id, nr_sectoare) VALUES (DEFAULT,'Medias', 34, 0) RETURNING id; This is the error I get: ERROR: syntax error at or near "RETURNING" LINE 3: RETURNING id; ^ ********** Error ********** ERROR: syntax error at or near "RETURNING" SQL state: 42601 Character: 92
В списке pgsql-bugs по дате отправления: