Re: a modest improvement to get_object_address() - Mailing list pgsql-hackers

From Robert Haas
Subject Re: a modest improvement to get_object_address()
Date
Msg-id CA+TgmobeCrQb-2kuL6BACHBy7T_pexOUn3C8HahSPF-i74S9sg@mail.gmail.com
Whole thread Raw
In response to Re: a modest improvement to get_object_address()  (Cédric Villemain <cedric.villemain.debian@gmail.com>)
Responses Re: a modest improvement to get_object_address()
List pgsql-hackers
On Wed, Nov 9, 2011 at 8:37 AM, Cédric Villemain
<cedric.villemain.debian@gmail.com> wrote:
> Maybe I miss something but:
> The ERROR message is misleading:  the schema 'x' does exist.

No, it doesn't.  The concurrent transaction has dropped it.

> And also
> why a drop schema would fail and a drop+create would success ?!

Because you can't comment on a schema that doesn't exist any more, but
you can comment on one that does.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Materialized views
Next
From: Jaime Casanova
Date:
Subject: Re: Syntax for partitioning