Home > mailing lists

regarding oid(object id) - Mailing list pgsql-novice

From	siva kiran balijepalli
Subject	regarding oid(object id)
Date	March 10, 2011 06:08:34
Msg-id	AANLkTi=Xr49mwAZXZWTrCOwtFz10VKkw6rFSv=fPS0s7@mail.gmail.com Whole thread Raw
Responses	Re: regarding oid(object id) (Chetan Suttraway <chetan.suttraway@enterprisedb.com>) Re: regarding oid(object id) (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
List	pgsql-novice

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

From: Jaime Casanova
Date: 10 March 2011, 04:51:02
Subject: Re: Cannot install pgAgent on Windows

From: siva kiran balijepalli
Date: 10 March 2011, 08:15:46
Subject: difference between functions and stored procedure