Re: pg_dump SERIAL and SEQUENCE
От | Andreas Kretschmer |
---|---|
Тема | Re: pg_dump SERIAL and SEQUENCE |
Дата | |
Msg-id | 20071018180247.GA4704@KanotixBox обсуждение исходный текст |
Ответ на | pg_dump SERIAL and SEQUENCE (Laurent ROCHE <laurent_roche@yahoo.com>) |
Ответы |
Re: pg_dump SERIAL and SEQUENCE
|
Список | pgsql-general |
Laurent ROCHE <laurent_roche@yahoo.com> schrieb: > Then when I drop tab_b, the SEQUENCE tab_b_colb1_seq is not dropped, however > when I drop tab_a, the SEQUENCE tab_a_cola1_seq is dropped too ! > I am using PG 8.1 and ALTER SEQUENCE ... OWNED BY does not exist ! ! ! Read this message: <28684.1192378480@sss.pgh.pa.us> ,----[ quote Tom Lane ] | In 8.2 and up you can use ALTER SEQUENCE ... OWNED BY ... to establish `---- You see the difference? Regards, Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
В списке pgsql-general по дате отправления: