Обсуждение: postgres - oid question

Hi...

In looking over a few sites via google, I'm trying to figure out what has to
be added to the sql I have for creating TBLs that use OIDs. I'd rather have
the cmds added to the sql file, than the postgres conf file...

I can't find out what I have to add!

I understand that OIDs are depricated, but the app I'm dealing with has
them. I'm using v8.1 of postgres on Fedora 5.

Any pointers are appreciated.

thanks

-bruce
bedouglas@earthlink.net

Hi Oliver.

Thanks for the reply.

I was hoping that there was/is a single cmd that I could use at the
beginning of the sql file, that would allow all the tables that are created
to be created using the OID. Kind of a

use OID
 create tbl Foo1
 create tbl Foo2
 create tbl Foo3
 create tbl Foo4
 create tbl Foo5
stop OID
 create tbl Foo6
 create tbl Foo7

so that everything created between use/stop would be created using OID...

thanks

-bruce

-----Original Message-----
From: Oliver Elphick [mailto:olly@lfix.co.uk]
Sent: Thursday, May 24, 2007 11:19 AM
To: bedouglas@earthlink.net
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgres - oid question


On Thu, 2007-05-24 at 10:58 -0700, bruce wrote:
> Hi...
>
> In looking over a few sites via google, I'm trying to figure out what has
to
> be added to the sql I have for creating TBLs that use OIDs. I'd rather
have
> the cmds added to the sql file, than the postgres conf file...
>
> I can't find out what I have to add!
>
> I understand that OIDs are depricated, but the app I'm dealing with has
> them. I'm using v8.1 of postgres on Fedora 5.
>
> Any pointers are appreciated.

TO create one table with oids, use
   CREATE TABLE table_name (...) WITH OIDS;

To have all tables created with oids, set the config parameter
default_with_oids to true.  (It defaults to false from 8.1 onwards.)

Oliver Elphick

On Thu, 2007-05-24 at 10:58 -0700, bruce wrote:
> Hi...
>
> In looking over a few sites via google, I'm trying to figure out what has to
> be added to the sql I have for creating TBLs that use OIDs. I'd rather have
> the cmds added to the sql file, than the postgres conf file...
>
> I can't find out what I have to add!
>
> I understand that OIDs are depricated, but the app I'm dealing with has
> them. I'm using v8.1 of postgres on Fedora 5.
>
> Any pointers are appreciated.

TO create one table with oids, use
   CREATE TABLE table_name (...) WITH OIDS;

To have all tables created with oids, set the config parameter
default_with_oids to true.  (It defaults to false from 8.1 onwards.)

Oliver Elphick

On Thursday 24 May 2007 11:31, "bruce" <bedouglas@earthlink.net> wrote:
> Hi Oliver.
>
> Thanks for the reply.
>
> I was hoping that there was/is a single cmd that I could use at the
> beginning of the sql file, that would allow all the tables that are
> created to be created using the OID. Kind of a
>

set default_with_oids  = true;
create table ...
create table ...


--
`"Gun-wielding recluse gunned down by local police" isn't the epitaph
I want. I am hoping for "Witnesses reported the sound up to two hundred
kilometers away" or "Last body part finally located".' --- James Nicoll

On 24/05/2007 18:58, bruce wrote:

> In looking over a few sites via google, I'm trying to figure out what has to
> be added to the sql I have for creating TBLs that use OIDs. I'd rather have

Something like -

     create table (...) with oids;

- but check the docs (under CREATE TABLE) to be sure.

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------