Postgres Pro
Downloads
Home   >   mailing lists

potential bug in error message in with clause - Mailing list pgsql-hackers

From Szymon Guz
Subject potential bug in error message in with clause
Date
Msg-id CAFjNrYsjzd3SCsNzrg9tywwXDX6thNqwvagBBkQCc9OP8ur3dw@mail.gmail.com
Whole thread Raw
Responses Re: potential bug in error message in with clause
List pgsql-hackers
Tree view
Hi,
today on IRC there was a strange problem shown. The small working example looks like this:

x=# with x as (insert into a(t) values('1') returning *) select * from x;
 t 
---
 1
(1 row)

x=# with x (insert into a(t) values('1') returning *) select * from x;
ERROR:  syntax error at or near "into"
LINE 1: with x (insert into a(t) values('1') returning *) select * f...
                       ^

The initial code was run on 9.2; I've checked that on 9.4devel.

The error message is really not useful, as there is missing "as" after "with x". There is no problem with "into".

regards
Szymon

pgsql-hackers by date:

Previous
From: KONDO Mitsumasa
Date:
Subject: Re: Design proposal: fsync absorb linear slider
Next
From: Andrew Tipton
Date:
Subject: Add json_typeof() and json_is_*() functions.