Re: regclass without error? - Mailing list pgsql-hackers

From Marko Tiikkaja
Subject Re: regclass without error?
Date
Msg-id 4C8101E4.4040104@cs.helsinki.fi
Whole thread Raw
In response to Re: regclass without error?  (Tatsuo Ishii <ishii@postgresql.org>)
Responses Re: regclass without error?
List pgsql-hackers
On 2010-09-03 4:46 PM, Tatsuo Ishii wrote:
>> You can write a query against the system catalog tables.
>
> That was pretty hard than I though(schema search path etc.).
>
>> Or you could
>> install a function that wraps the regclass cast in an exception
>> handler.
>
> That requires users to install the function. Annoying for users.

How about using a SAVEPOINT before the cast?  Wouldn't fail your 
transaction..


Regards,
Marko Tiikkaja


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Interruptible sleeps (was Re: CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)
Next
From: David Fetter
Date:
Subject: Re: regclass without error?