Laurent ROCHE <laurent_roche@xxxxxxxxx> 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@xxxxxxxxxxxxx> ,----[ 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° ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/