Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group