Oliver Elphick wrote: > > On Wed, 2002-11-20 at 21:35, Robert Treat wrote: > > On Wed, 2002-11-20 at 03:53, Oliver Elphick wrote: > > > On Mon, 2002-11-18 at 15:45, Thomas Aichinger wrote: > > > > Hi, > > > > > > > > I recently installed pg 7.2.3 on my linux box and discovered that > > > > there are some problems with datatype serial and sequence. > > > > > > > > 1.) If you create a table with a datatype serial, the corrsponding > > > > sequence will be created, but if you drop the table the sequence is > > > > not dropped. > > > > > > This is fixed in 7.3 > > > > > > > out of curiosity, do you know the logic that implements this fix? I have > > a couple of tables that use the same sequence; I'm wondering if dropping > > one of the tables removes the sequence or if I have to drop all tables > > before the sequence is removed > > I just tried it. > > I created a sequence using SERIAL when I created a table. I used the > same sequence for another table by setting a column default to > nextval(sequence). > > I deleted the first table. The sequence was deleted too, leaving the > default of the second table referring to a non-existent sequence.
This sounds like a serious bug in our behaviour, and not something we'd like to release. Specifically in relation to people's existing scripts, and also to people who are doing dump/restore of specific tables (it'll kill the sequences that other tables depend on too!) No real issue with the nicety for newbies, but am very concerned about the lack of a dependancy check here. :-/ Regards and best wishes, Justin Clift > Could this be a TODO item in 7.4, to add a dependency check when a > sequence is set as the default without being created at the same time? > > -- > Oliver Elphick [EMAIL PROTECTED] > Isle of Wight, UK > http://www.lfix.co.uk/oliver > GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C > ======================================== > "If my people, which are called by my name, shall > humble themselves, and pray, and seek my face, and > turn from their wicked ways; then will I hear from > heaven, and will forgive their sin, and will heal > their land." II Chronicles 7:14 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
