[GENERAL] pg_dump serial UNIQUE NOT NULL PRIMARY KEY

2005-04-22 Thread Michael Hipp
Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table like this: CREATE TABLE cases ( id serial PRIMARY KEY, Works fine, but when I pg_dump the database, what shows up in the dump is: CREATE TABLE cases ( id serial NOT NULL, The documentation seems to say that 'serial

Re: [GENERAL] pg_dump serial UNIQUE NOT NULL PRIMARY KEY

2005-04-22 Thread Michael Fuhr
On Fri, Apr 22, 2005 at 04:44:05PM -0500, Michael Hipp wrote: > > Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table > like this: > > CREATE TABLE cases ( > id serial PRIMARY KEY, > > Works fine, but when I pg_dump the database, what shows up in the dump is: > > CREAT

Re: [GENERAL] pg_dump serial UNIQUE NOT NULL PRIMARY KEY

2005-04-22 Thread Tom Lane
Michael Hipp <[EMAIL PROTECTED]> writes: > Hello, I'm a fairly new user of PostgreSQL 8.0.2 and I'm creating a table > like > this: > CREATE TABLE cases ( > id serial PRIMARY KEY, > Works fine, but when I pg_dump the database, what shows up in the dump is: > CREATE TABLE cases ( > id