Re: Postgre cannot delete from a table

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgre cannot delete from a table
Дата
Msg-id 17037.1159371087@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Postgre cannot delete from a table  (developer_student <juamagb1@gmail.com>)
Ответы Re: Postgre cannot delete from a table  (developer_student <juamagb1@gmail.com>)
Список pgsql-novice
developer_student <juamagb1@gmail.com> writes:
> Then, when I write this statement from pgAdmin III Query:
> delete from Lacaja.public.messagetbl;

> I get the next message:
> ERROR:  cross-database references are not implemented:
> "Lacaja.public.messagetbl"

> Am I trying to accede multiple databases?

The code thinks so.  Are you actually doing this in a database named
Lacaja, or something else?  I'm wondering in particular about
the capitalization of the name ("lacaja" and "Lacaja" are different).

You could avoid the whole question by not writing the database name,
which you don't need anyway.

            regards, tom lane

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

Предыдущее
От: developer_student
Дата:
Сообщение: Postgre cannot delete from a table
Следующее
От: developer_student
Дата:
Сообщение: Re: Postgre cannot delete from a table