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

Re: regarding oid(object id)

From: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
To: siva kiran balijepalli <b(dot)sivakiran(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: regarding oid(object id)
Date: 2011-03-10 09:57:34
Message-ID: 3061F750-3CA3-476D-99FF-0B02999A5747@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Mar 10, 2011, at 12:31 PM, siva kiran balijepalli wrote:

> 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

For old/Existing Table without OID, you can't get OID.

> note: even though i have changed the
> default_with_oids = on in postgreconf file,i am not getting the oid's.
>  
Setting Above parameter will make sure that new tables will get created with OIDs.
i.e you don't have to mention WITH OID in CREATE TABLE Syntax.


Thanks & Regards,
Vibhor Kumar
EnterpriseDB Corporation
The Enterprise PostgreSQL Company
vibhor(dot)kumar(at)enterprisedb(dot)com
Blog:http://vibhork.blogspot.com


In response to

pgsql-novice by date

Next:From: Vibhor KumarDate: 2011-03-10 09:59:30
Subject: Re: difference between functions and stored procedure
Previous:From: Chetan SuttrawayDate: 2011-03-10 09:47:29
Subject: Re: regarding oid(object id)

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