From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
---|---|
To: | cleahy(at)mystrata(dot)com(dot)au |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Error log fillingup |
Date: | 2009-09-09 08:54:08 |
Message-ID: | 4AA76D30.20902@iol.ie |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 09/09/2009 09:27, Chris Leahy wrote:
> Hi All
>
> I'm running postgreSQL 7.3 on 2 installations, both with the same problem.
>
> The error logs for both installations are filling up with the following;
>
> ESTERROR: 42703: column "options" does not exist
> ESTLOCATION: transformColumnRef, parse_expr.c: 396
> ESTSTATEMENT: select @@options
>
> This has become a real nuisance.
> I have not defined a table 'options' and non of the tables I have
> defined have a column called 'options'.
That may well be the problem - a query is referring to a column called
"options" which as you've said doesn't exist, hence the error message.
I've also seen this when a string value isn't quoted, e.g. -
insert into (....) values ('abc', options, ...) ...
When this happens the server thinks that the query is taking the value
of a column called 'options', instead of the literal value 'options'.
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Korry | 2009-09-09 09:35:18 | Re: Error log fillingup |
Previous Message | Andrus | 2009-09-09 08:49:29 | Re: pg_dump exists without any message when running from windows task scheduler |