Re: Column pgl.transaction does not exist in 8.3 beta 4

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Shelby Cain <alyandon(at)yahoo(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Column pgl.transaction does not exist in 8.3 beta 4
Date: 2007-12-08 01:21:08
Message-ID: 704.1197076868@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> 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

> Looks like it should be referencing pgl.transactionid instead?

Most likely you want pg_locks.virtualtransaction, instead --- that's
the closest match to the old behavior of pg_locks.transaction.

> Anyone have any idea as to what is generating this statement?

Nope.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-12-08 02:38:00 Re: record-based log shipping
Previous Message Tom Lane 2007-12-08 01:11:42 Re: Array index not used for query on first element?