That query looks suspiciously similar to a SQL Server (Sybase or
Microsoft) query.
@@options is the name of a SQL Server global variable. It looks like
your client application thinks that it is connected to a copy of SQL
Server, not Postgres.
-- Korry
On Sep 9, 2009, at 4:27 AM, Chris Leahy <cleahy@xxxxxxxxxxxxxxx> 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'.
I am not aware of this call being made, but it is filling up the
error logs at an alarming rate.
All connections to the databases are through unixODBC.
I hope someone can shine some light on this problem. It would have
to be affecting the performance of the DB.
The DB's have been running for a few years and appear to be stable.
Just this error reoccurring.
My concern is that it could mask a real error when it happens.
Many thanks <stock_smiley-3.png>
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
