Skip site navigation (1) Skip section navigation (2)

regarding oid(object id)

From: siva kiran balijepalli <b(dot)sivakiran(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: regarding oid(object id)
Date: 2011-03-10 07:01:30
Message-ID: AANLkTi=Xr49mwAZXZWTrCOwtFz10VKkw6rFSv=fPS0s7@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi
i am novice postgr sql user.

I have created a table named customer in my data base.
also i have inserter some of the rows into my table.
when i try to execute this command to select object id's (oid) i am getting
following error.

select oid from customer;
error: column oid doesn't exist

note: even though i have changed the
default_with_oids = on in postgreconf file,i am not getting the oid's.

my postgre sql version is 8.4

but when i try to select oid's for already existed tables in pg_catalogue
the output is coming
for eg: select oid from pg_proc;

please reply

thanks & regards
sivakiran.B

Responses

pgsql-novice by date

Next:From: siva kiran balijepalliDate: 2011-03-10 09:15:34
Subject: difference between functions and stored procedure
Previous:From: Jaime CasanovaDate: 2011-03-10 05:50:32
Subject: Re: Cannot install pgAgent on Windows

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group