[EMAIL PROTECTED] writes:
> The problem is that the oid column has no "unique" constraint ...
unless you add one, viz:
create unique index mytable_oids on mytable (oid);
which is de rigueur for any table you intend to rely on OID as an
identifier for. The index is needed not only to ens
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
> Is there something in Postgres that corresponds to the rowid
> pseudocolumn in Oracle, which represents the unique address of the
> row of data in the table? If so, how would you access that
> in a query?
> ...
> so what do you have to do to cre
Please remember:
- OIDs are NOT unique
- CTIDs are unique but not constant
- SERIALs are unique and forever
On Wed, Nov 26, 2003 at 10:39:43AM -0600, James Thompson wrote:
>
> I think oid is what you want.
>
> select oid,* from table;
>
> Take Care,
> James
>
> On Wed, 26 Nov 2003, Barbara Li
