Re: Can't query system tables during transaction

Поиск
Список
Период
Сортировка
От Igor Korot
Тема Re: Can't query system tables during transaction
Дата
Msg-id CA+FnnTy9QHT5DeTis28wQY4mXkkyoskF6-GFw2g3H7rnXeK5UA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Can't query system tables during transaction  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

On Sun, Oct 4, 2020 at 3:30 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> Igor Korot <ikorot01@gmail.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



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Can't query system tables during transaction
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Can I get some PostgreSQL developer feedback on these five general issues I have with PostgreSQL and its ecosystem?