> 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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

In response to

• Re: regclass without error? at 2010-09-03 13:33:02 from Robert Haas

Responses

• Re: regclass without error? at 2010-09-03 14:10:44 from Marko Tiikkaja

pgsql-hackers by date

Next:	From: Stephen Frost	Date: 2010-09-03 13:56:12
	Subject: Re: Streaming a base backup from master
Previous:	From: Robert Haas	Date: 2010-09-03 13:44:40
	Subject: Re: english parser in text search: support for multiple words in the same position