this happens in 7.1.3 (included in red hat 7.2).
e.g.
CREATE TABLE items (
item_id SERIAL,
name VARCHAR(32)
);
copy pasted in psql gives this
marius=> CREATE TABLE items (
marius(> item_id
marius(> item_idSERIAL,
marius(> name
marius(> nameVARCHAR(32)
marius(> );
ERROR: parser: parse error at or near "("
this will work:
CREATE TABLE items (
item_id SERIAL,
name VARCHAR(32)
);
I've seen this behavior on sybase's sqsh once, perhaps it's something
system wide, and not psql's fault?
--
Marius Andreiana
--
You don't have to go to jail for helping your neighbour
http://www.gnu.org/philosophy/