Access query as executed by postgres

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 r=
un the same query at the pgsql command prompt I get syntax and 'function no=
t 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


--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Access query as executed by postgres

-------------- Original message ----------------------
From: "Fred Parkinson"
> 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@comcast.net



--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

Re: Access query as executed by postgres

On Wed, Jun 11, 2008 at 11:37 AM, Fred Parkinson wrote:
> I have turned ODBC logging on but it doesn't seem to log the query sent to postgres.

Here is what I like to do:

log_destination = 'stderr'
redirect_stderr = on

log_statement = 'all'


--
Regards,
Richard Broersma Jr.

Visit the Los Angles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc