From: | Matthew Hixson <hixson(at)poindextrose(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Postgres 8.0b3 doesn't log queries correctly |
Date: | 2004-09-28 23:32:03 |
Message-ID: | 9A676E02-11A6-11D9-BF0E-000A95D05926@poindextrose.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
In my logs I'm getting queries like this:
SELECT t0_userprofile.user_profile_id FROM user_profiles t0_userprofile
WHERE (t0_userprofile.user_id = $1)
Where $1 was actually something like 'BSHO-XITLLH-LTDHF7-V3-ETFQ'. In
a query where there are several parameters they appear as $1, $2, $3,
... $n.
In Postgres 7.x the same query would have been logged as
SELECT t0_userprofile.user_profile_id FROM user_profiles t0_userprofile
WHERE (t0_userprofile.user_id = 'BSHO-XITLLH-LTDHF7-V3-ETFQ')
Is there a way to return to the 7.x behavior or is this a bug in the
8.x series?
I'm not on the pgsql-bugs list so if you'd like more info be sure to
reply directly.
Thanks,
-M@
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksey Fedorchenko | 2004-09-29 08:13:02 | Re: BUG #1266: Improper unique constraint / MVCCactivitieswithin |
Previous Message | Patrick Clery | 2004-09-28 22:03:45 | Disk space is consumed by UPDATE query |