Re: could not open relation:no such file or directory

On þri, 2006-12-26 at 02:43 -0800, karthik wrote:

> i facing a problem when trying to select values from a table in
> postgresql.

do you face this problem with any table or only from a
particular table?

> when i execute a query like "select title from itemsbytitle;"

what do you mean by 'a query like' ?
please show us the exact query

> i
> get error as
>
> Error:Could not open relation "itemsbytitle". no such file or
> directory.

please show us the exact error.

what version postgres are you using ?
are you using psql for your tests ?

if would be best is you cut'n'pasted a short psql session
that demonstrates the problem. something like:

+++++++++++++++++++
$ psql -d test
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

test=# create table blah (i int);
CREATE TABLE
test=# insert into blah values (1);
INSERT 0 1
test=# select * from blah;
i
---
1
(1 row)

test=# select * from blax;
ERROR: relation "blax" does not exist
++++++++++++++++++++++

this makes it easier for us to guess at what your problem is,
and simplifies reproducing it.

gnari