[BUGS] Drop table doesn't drop serial sequences.

2000-10-13 Thread pgsql-bugs
Antonio GarcĂ­a ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Drop table doesn't drop serial sequences. Long Description The SERIAL special type automatically creates a sequence for the field when you create a table. The seque

Re: [BUGS] PostgreSQL BugTool Submission

2000-10-13 Thread Bruce Momjian
Can someone give me a good description of this for TODO? > > Yes, this is a known issue due to the fact that the > triggers use SPI and need to use SELECT ... FOR UPDATE > to lock the rows it is reading (and select for update > requires the update permission). The workaround I > know about for