Re: relation does not exist

From: Kris Jurka <books(at)ejurka(dot)com>
To: eric cartman <panefsky(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: relation does not exist
Date: 2006-02-21 20:00:34
Message-ID: Pine.BSO.4.63.0602211459460.4950@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, 21 Feb 2006, eric cartman wrote:

> Hello to everyone,
>
> The problem is that I create a database and some tables through ant and
> an .sql file. Then by using DatabaseMetaData class and method
> getTables(..)I can make a list of the newly created tables, implying
> that everything worked fine.
>
> But when I am trying to Insert values into tables, i get the message
> 'relation <name> does not exist'.
>

getTables will tell you about all tables in all schemas. Perhaps there's
a table that is not in your search_path when you try and insert into it.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message eric cartman 2006-02-22 10:48:18 relation does not exist
Previous Message Mark Lewis 2006-02-21 19:29:34 Re: relation does not exist