Re: Can't query system tables during transaction

2020-10-04 Thread Igor Korot
Hi, On Sun, Oct 4, 2020 at 3:30 PM Tom Lane wrote: > > Igor Korot 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 s

Re: Can't query system tables during transaction

2020-10-04 Thread Tom Lane
Igor Korot 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 ab

Re: Can't query system tables during transaction

2020-10-04 Thread Adrian Klaver
On 10/4/20 1:14 PM, Igor Korot wrote: Hi, ALL, 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; inside the transaction. I'm getting the following error: ERROR: current transaction is aborted,

Can't query system tables during transaction

2020-10-04 Thread Igor Korot
Hi, ALL, 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; inside the transaction. I'm getting the following error: ERROR: current transaction is aborted, commands ignored until end of transactio