relations does not exist

From: ctorres <ctorres(at)quantumcomposers(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: relations does not exist
Date: 2007-10-16 19:20:10
Message-ID: 13240608.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I doing a simple insert into a table re Perl/DBI
"INSERT INTO party (party_id, party_type_id, description, status_id)
VALUES ($partyId, 'PERSON', 'Initial Import','PARTY_ENABLED')

and I'm getting a
"ERROR: relations "party" does not exist"
I get the same error message in pgadmin.

The table "party" certainly exists.

I have searched for answers without any luck.
Anyone know what might be going on and how to fix it?

Thanks in advance, Case

--
View this message in context: http://www.nabble.com/relations-does-not-exist-tf4636218.html#a13240608
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-10-16 19:27:50 Re: need help with rebuilding postgresql
Previous Message Jeff Lanzarotta 2007-10-16 19:18:56 Re: Group By question