Re: Postgre cannot delete from a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: developer_student <juamagb1(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Postgre cannot delete from a table
Date: 2006-09-27 15:31:27
Message-ID: 17037.1159371087@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

developer_student <juamagb1(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message developer_student 2006-09-27 18:18:58 Re: Postgre cannot delete from a table
Previous Message developer_student 2006-09-27 15:18:40 Postgre cannot delete from a table