postgresql INSERT ... RETURNING query keeps failing?

Question

The error message is kinda vague... The query below works on one server, but fails on another:

INSERT INTO searches (status, uid, datecreated, searchname, options) 
VALUES (0, 1, NOW(), 'TEST', '16') RETURNING sid;

And I get this error:

Query failed: ERROR: syntax error at or near "RETURNING"

Am I missing something here?

Magnus Hagander · Accepted Answer · 2010-04-20 12:20:29Z

2

Query certainly looks right - assuming the field sid does exist (I take it it's a SERIAL field).

Are you sure you're using a PostgreSQL version that has support for RETURNING? You need version 8.2 or newer for this.

answered Apr 20, 2010 at 12:20

Magnus Hagander

25.5k6 gold badges60 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1