From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Freddy Villalba Arias <fvillalba(at)madrid(dot)bilbomatica(dot)es> |
Cc: | PostgreSQL JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: default_with_oid |
Date: | 2004-04-26 15:40:56 |
Message-ID: | 1082994056.13952.123.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
oid's are not necessary for the table, just create the table without
oid's
oids are used by the system tables to reference each other.
ie create table foo ( id int ) without oids;
Dave
On Mon, 2004-04-26 at 11:07, Freddy Villalba Arias wrote:
> Hello,
>
>
>
> I’ve noticed that whenever I create a table, the DBMS is adding an OID
> column without my consent. I’ve also read that this behaviour can be
> modified (disabled) by setting the default_with_oid (to false, I
> suppose).
>
>
>
> What is the OID column for? How (and where) can I find (and disable)
> the default_with_oid flag?
>
>
>
> Then, a less important question for pgAdmin3 users: is it possible to
> manage (select / insert / update / delete) the system’s tables with
> this tool?
>
>
>
> Regards,
>
> Freddy.
>
>
> !DSPAM:408d2aac66071710736892!
--
Dave Cramer
519 939 0336
ICQ # 14675561
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-04-26 15:44:34 | Re: default_with_oid |
Previous Message | Freddy Villalba Arias | 2004-04-26 15:07:56 | default_with_oid |