Hello, guys. You wrote:
TI> Hi, TI> Is there any way to use regclass without having ERROR? TI> pgpool-II needs to find the oid from table name and for the purpose it TI> issues something like "SELECT 'table_name'::regproc::oid". Problem is, TI> if the table does not exist, an error occured and the transaction TI> aborts. Ideally if the table does not exist, the SELECT returns 0 TI> (InvalidOid). Agreed with Tatsuo about having InvalidOid. TI> Any idea? TI> -- TI> Tatsuo Ishii TI> SRA OSS, Inc. Japan TI> English: http://www.sraoss.co.jp/index_en.php TI> Japanese: http://www.sraoss.co.jp -- With best wishes, Pavel mailto:pa...@gf.microolap.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
