-------------- Original message ----------------------
From: "Fred Parkinson" <FredP@[EMAIL PROTECTED]
>
> When I create a query in MS Access and execute via ODBC, is there a way
to tell
> exactly what query is executed by postgres?
>
> When I create and execute a query in Access I get what I want, but when
I run
> the same query at the pgsql command prompt I get syntax and 'function
not found'
> errors. Clearly Access is translating my query, but into what?
>
> I have turned ODBC logging on but it doesn't seem to log the query sent
to
> postgres.
>
> Thanks
>
> Fred
In postgresql.conf set:
log_statement = 'all'
This will log all statements sent to the server, assuming you have logging
turned on.
--
Adrian Klaver
aklaver@[EMAIL PROTECTED]
--
Sent via pgsql-odbc mailing list (pgsql-odbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc
