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 по дате отправления:

Предыдущее
От: "Prem Kumar"
Дата:
Сообщение: BUG #4703: Client Encoding Mis match
Следующее
От: Tomasz Olszak
Дата:
Сообщение: Bug? Problem with accesing Oracle from plperlu function when using remote pg client.