Re: psql problem

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: "Rick Parker" <Rick_Parker(at)boscomm(dot)net>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: psql problem
Date: 2000-05-31 17:36:20
Message-ID: 012001bfcb26$bb8032c0$4100000a@venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> > Does anyone know why when I am in a particular DB as user postgres and
use
> > the following statement, why I get this error?"
> >
> > This is the statement;
> > SELECT * FROM some_file where ID = 1;
> >
>
> --------------------------------------------------------------------------
--
> > Error: ERROR: attribute 'id' not found
> > Execution time 0.02 sec.

That indicates that you have no column named 'id'..

> > But if I use the following statement, everything is returned fine.
> >
> > SELECT * FROM servlet_file;

That's a totally different query which would yeild totally different
results..

-Mitch

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message mikeo 2000-05-31 18:41:17 TOP SESSIONS?
Previous Message Ed Loehr 2000-05-31 17:21:07 Re: psql problem