> -----Original Message----- > From: Hannu Krosing [mailto:[EMAIL PROTECTED]] > Sent: 20 January 2003 18:05 > To: Dave Page > Cc: Tom Lane; PostgreSQL Hackers Mailing List; Didier Moens > Subject: Re: [HACKERS] Foreign key wierdness > > > > I've been looking at his for some time now (couple of weeks > or more), > > and the only thing I can find is the SELECT ... FOR UPDATE in the > > PostgreSQL logs that I quoted. > > does this SELECT ... FOR UPDATE occur only when schemas are used ?
No, in both case, just significantly more slowly with schema qualification. Note that the qualification is added to the ALTER TABLE statement though - PostgreSQL's qualifying the name in the SELECT for every case. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster