Re: Can't query system tables during transaction

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Igor Korot <ikorot01@xxxxxxxxx> writes:
> I'm trying to execute following:

> SELECT 1 FROM pg_class c, pg_namespace n WHERE n.oid = c.relnamespace
> AND c.relname = 'foo' AND n.nspname = public;

I suppose you meant to put quotes around 'public'?

> I'm getting the following error:
> ERROR:  current transaction is aborted, commands ignored until end of
> transaction block

This has nothing to do with the current command, but with failure
of some previous command in the transaction.

			regards, tom lane