| From: | Igor Korot <ikorot01(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Can't query system tables during transaction |
| Date: | 2020-10-04 20:58:08 |
| Message-ID: | CA+FnnTy9QHT5DeTis28wQY4mXkkyoskF6-GFw2g3H7rnXeK5UA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
On Sun, Oct 4, 2020 at 3:30 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Igor Korot <ikorot01(at)gmail(dot)com> 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 suppose so as well. ;-)
>
> > 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.
Thank you.
I will try to track down the error.
>
> regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2020-10-04 21:40:49 | Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem? |
| Previous Message | Tom Lane | 2020-10-04 20:30:35 | Re: Can't query system tables during transaction |