Re: relations does not exist

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: relations does not exist
Date: 2007-10-18 20:19:32
Message-ID: 200710181319.32523@hal.medialogik.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tuesday 16 October 2007, ctorres <ctorres(at)quantumcomposers(dot)com> wrote:
> 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.

Are you really connecting to the database you think you are?

--
Peak Oil is now accepted as inevitable, and the debate only becomes as
to when - James Schlesinger, former US Secretary of Energy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-10-18 20:29:25 Re: pg_dump SERIAL and SEQUENCE
Previous Message Ralph Smith 2007-10-18 20:19:27 pg_dumpall's subseq IMPORT ERRORS