FW: About OIDs - Mailing list pgsql-general

They are invisible unless you ask to see them:

C:\CONNX32\CONNXSTORE\BIN>psql -h localhost connxdatasync
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

connxdatasync=# select * from  pg_amop limit 1;
 amopid | amopclaid | amopopr | amopstrategy
--------+-----------+---------+--------------
    402 |       422 |     493 |            1
(1 row)

connxdatasync=# select Oid, * from   pg_amop limit  1;
  oid  | amopid | amopclaid | amopopr | amopstrategy
-------+--------+-----------+---------+--------------
 16698 |    402 |       422 |     493 |            1
(1 row)

connxdatasync=#

-----Original Message-----
From: Flower Sun [mailto:sun_2002_flower@yahoo.com]
Sent: Thursday, March 27, 2003 1:44 PM
To: Alvaro Herrera
Cc: Pgsql Group
Subject: Re: [GENERAL] About OIDs


Hi, Alvaro,
Thank you for your reply. Well, if you view the system defination from
PgAdminII 1.4.12, you will see the following one example which shows
that no OIDs. I am not sure whether PgadminII is right or you are right
on this topic.

-- Table: pg_amop

CREATE TABLE pg_amop (
amopclaid oid,
amopstrategy int2,
amopreqcheck bool,
amopopr oid,
CONSTRAINT pg_amop_opc_opr_index UNIQUE (amopclaid, amopopr),
CONSTRAINT pg_amop_opc_strategy_index UNIQUE (amopclaid, amopstrategy)
) WITHOUT OIDS;