From: Mihail Nasedkin <m.nasedkin.perm@mail.ru>
To: pgsql-sql@postgresql.org
Subject: Re: OID's
Date: Fri, 21 Jan 2005 11:17:34 +0500
Message-ID: <8411982406.20050121111734@mail.ru> (raw)
In-Reply-To: <20050120164830.GB41081@winnie.fuhr.org>
References: <3628044953.20050120154558@mail.ru>
<20050120164830.GB41081@winnie.fuhr.org>
Hello, Michael.
Thank you for answer January, 20 2005, 21:48:30:
MF> On Thu, Jan 20, 2005 at 03:45:58PM +0500, Mihail Nasedkin wrote:
>> How (where) I can get all OID's of the PostgeSQL
>> installation?
>> In other words where OID's is stored? Is it stored in special table?
MF> See the "System Columns" section in the "Data Definition" chapter
MF> of the PostgreSQL documentation. Tables that store objects with
MF> OIDs should have an oid column; you could query pg_attribute to
MF> find out what tables those are.
I have already read about "System Columns" of the PostgreSQL documentation.
In the table "pg_catalog.pg_attribute" column "attrelid" contain
only "system OID's" but not OID's from records of the user tables.
But I would like to use OID's of all records of the all my tables.
^^^ ^^^
I try to use rules on INSERT action of my tables to store last insert
oid, but at the moment of the INSERT row into table OID value
inaccessible (unknown).
>> I would like use some SQL queries with the all OID's.
MF> To what end? Are you aware that PostgreSQL allows tables to be
MF> created without OIDs?
Yes, of course, but in my case I create tables with OID and then want use
OID of all records of the all tables as one column in some query.
I think what system of OID's is very useful for application!
MF> What problem are you trying to solve?
For example, I want to fetching all rows of the several tables in one
query by means of LEFT JOIN, but not use UNION operator.
--
Mihail Nasedkin mailto:m.nasedkin.perm@mail.ru
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: m.nasedkin.perm@mail.ru
Subject: Re: OID's
In-Reply-To: <8411982406.20050121111734@mail.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox