Column pgl.transaction does not exist in 8.3 beta 4

From: Shelby Cain <alyandon(at)yahoo(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Column pgl.transaction does not exist in 8.3 beta 4
Date: 2007-12-07 18:06:42
Message-ID: 230605.75028.qm@web55408.mail.re4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just upgraded from 8.2.5 to 8.3b4 on Windows and after reimporting my database I noticed the following messages are showing up sporadically in the server logs:

2007-12-07 11:56:17 CST ERROR: column pgl.transaction does not exist at character 171
2007-12-07 11:56:17 CST STATEMENT: SELECT (SELECT datname FROM pg_database WHERE oid = pgl.database) AS dbname, pgl.relation::regclass AS class, pg_get_userbyid(pg_stat_get_backend_userid(svrid)) as user, pgl.transaction, pg_stat_get_backend_pid(svrid) AS pid, pgl.mode, pgl.granted, pg_stat_get_backend_activity(svrid) AS current_query, pg_stat_get_backend_activity_start(svrid) AS query_start FROM pg_stat_get_backend_idset() svrid, pg_locks pgl WHERE pgl.pid = pg_stat_get_backend_pid(svrid) ORDER BY pid;

Looks like it should be referencing pgl.transactionid instead? Anyone have any idea as to what is generating this statement?

Regards,

Shelby Cain

____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2007-12-07 18:14:46 Re: pg_dump
Previous Message Erik Jones 2007-12-07 18:01:47 Re: Re-partitioning huge schema