Re: [GENERAL] Sequence Not created with pg_dump

2009-08-06 Thread Alvaro Herrera
sw...@opspl.com wrote: > > > > > > Seems unlikely (IOW, if so, you've found a bug no one else has ever > > seen). Maybe they are being created implicitly by SERIAL column > > declarations? > > > > Yeah they are created by the Serial column . He means: are they output as SERIAL columns i

Re: [GENERAL] Sequence Not created with pg_dump

2009-08-05 Thread sweta
> > Seems unlikely (IOW, if so, you've found a bug no one else has ever > seen). Maybe they are being created implicitly by SERIAL column > declarations? > Yeah they are created by the Serial column . Regards Sweta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org)

Re: [GENERAL] Sequence Not created with pg_dump

2009-08-05 Thread John R Pierce
sw...@opspl.com wrote: Hello all, When I create a db dump using -- pg_dump -s dbname > mydump.sql Sequences present are not being added to the mydump.sql file you'll need to be a -little- more specific... sure seems to me like its working on this centos5 linux + pg 8.3.7 system [

Re: [GENERAL] Sequence Not created with pg_dump

2009-08-05 Thread Tom Lane
sw...@opspl.com writes: > When I create a db dump using -- > pg_dump -s dbname > mydump.sql > Sequences present are not being added to the mydump.sql file Seems unlikely (IOW, if so, you've found a bug no one else has ever seen). Maybe they are being created implicitly by SERIAL column dec

[GENERAL] Sequence Not created with pg_dump

2009-08-05 Thread sweta
Hello all, When I create a db dump using -- pg_dump -s dbname > mydump.sql Sequences present are not being added to the mydump.sql file PS Cannot paste the contents of the file . Its too large :P Regards Sweta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To