Re: [BUGS] Sequence Start number not dumped correctly

2002-11-08 Thread Reto Stamm
Hello Tom, I am sorry, I can not reproduce it any more either. I must have made a mistake. It works perfectly (like the rest of Postgres). Thank you very much, I am sorry for the waste of time. Best regards --reto Quoting Tom Lane <[EMAIL PROTECTED]>: > Reto Stamm <[EMAIL PROTECTED]> writes

Re: [BUGS] Sequence Start number not dumped correctly

2002-11-07 Thread Tom Lane
Reto Stamm <[EMAIL PROTECTED]> writes: > When I have a sequence like this: > CREATE SEQUENCE "test_id_seq" start -32768 increment 1 maxvalue 32767 minvalue > -32768 cache 1; > it will show up in schema.txt like this: > CREATE SEQUENCE "test_id_seq" start 1 increment 1 maxvalue 32767 minvalue -327

[BUGS] Sequence Start number not dumped correctly

2002-11-07 Thread Reto Stamm
Hi, When I have a sequence like this: CREATE SEQUENCE "test_id_seq" start -32768 increment 1 maxvalue 32767 minvalue -32768 cache 1; and dump it using pg_dump -s -c -f schema.txt testdb it will show up in schema.txt like this: CREATE SEQUENCE "test_id_seq" start 1 increment 1 maxvalue 32767