Re: pg primary key bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: Richard_D_Levine(at)raytheon(dot)com, Michael Glaesemann <grzm(at)myrealbox(dot)com>, pgsql-sql(at)postgresql(dot)org, pgsql-sql-owner(at)postgresql(dot)org
Subject: Re: pg primary key bug?
Date: 2005-02-17 17:26:29
Message-ID: 8125.1108661189@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

pginfo <pginfo(at)t1(dot)unisoftbg(dot)com> writes:
> 01=# select * from a_constants_str where constname='DOCPLAID' ;
> constname | fid | constvalue
> -----------+-----+------------
> DOCPLAID | 0 | SOF_19738
> DOCPLAID | 0 | SOF_19738
> (2 rows)

Could we see the system columns on these rows?

select oid,xmin,cmin,xmax,cmax,ctid,* from a_constants_str where ...

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message pginfo 2005-02-17 17:34:59 Re: pg primary key bug?
Previous Message Ray Madigan 2005-02-17 16:59:14 LOOP?