Re: Foreign key wierdness - Mailing list pgsql-hackers

From Dave Page
Subject Re: Foreign key wierdness
Date
Msg-id 03AF4E498C591348A42FC93DEA9661B8259AE6@mail.vale-housing.co.uk
Whole thread Raw
In response to Foreign key wierdness  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-hackers

> -----Original Message-----
> From: Hannu Krosing [mailto:hannu@tm.ee]
> 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.


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Foreign key wierdness
Next
From: Emmanuel Charpentier
Date:
Subject: Re: Survey results from the PostgreSQL portal page