Re: pg_dump bug in 7.3.9 with sequences
От | Christopher Kings-Lynne |
---|---|
Тема | Re: pg_dump bug in 7.3.9 with sequences |
Дата | |
Msg-id | 4201EE8D.4010408@familyhealth.com.au обсуждение исходный текст |
Ответ на | Re: pg_dump bug in 7.3.9 with sequences (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: pg_dump bug in 7.3.9 with sequences
|
Список | pgsql-hackers |
> pg_dump will just emit "create table t1 (f1 serial)" with no hint that > the sequence ought to be set to CYCLE mode. I'm not sure about an > appropriate fix offhand --- we can't very well use ALTER SEQUENCE in > just this way in the dump, because of the risk of the sequence name > being possibly different at reload. (Come to think of it, we are not > very good about propagating GRANTs on the sequence either, because of > the same risk.) I suggest some time ago an alternative syntax for ALTER SEQUENCE. So, you'd have: ALTER SEQUENCE seqname ... or ALTER SEQUENCE ON table.column ... or something. Then it would be similar to have pg_get_serial_sequence() works. Chris
В списке pgsql-hackers по дате отправления: