pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
System Attribute
2+ messages / 2 participants
[nested] [flat]

* System Attribute
@ 1999-12-14 00:14 Drew Whittle <drew@albatross.co.nz>
  1999-12-14 00:33 ` Re: [SQL] System Attribute Mathijs Brands <mathijs@ilse.nl>
  0 siblings, 1 reply; 2+ messages in thread

From: Drew Whittle @ 1999-12-14 00:14 UTC (permalink / raw)
  To: pgsql-sql@hub.org

We have an online order system that I am trying to convert to use postgres 
and I noticed a problem with the creation of the DB.

One of the tables has a field called 'oid', which is fine under lots of 
other DB's but postgres doesn't like it. I am in the process of renaming 
this field so things will work but I am curious what the error actually means:

ERROR:  create: system attribute named "oid"

Thanks,

Drew




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] System Attribute
  1999-12-14 00:14 System Attribute Drew Whittle <drew@albatross.co.nz>
@ 1999-12-14 00:33 ` Mathijs Brands <mathijs@ilse.nl>
  0 siblings, 0 replies; 2+ messages in thread

From: Mathijs Brands @ 1999-12-14 00:33 UTC (permalink / raw)
  To: Drew Whittle <drew@albatross.co.nz>; +Cc: pgsql-sql@hub.org

On Tue, Dec 14, 1999 at 01:14:14PM +1300, Drew Whittle allegedly wrote:
> We have an online order system that I am trying to convert to use postgres 
> and I noticed a problem with the creation of the DB.
> 
> One of the tables has a field called 'oid', which is fine under lots of 
> other DB's but postgres doesn't like it. I am in the process of renaming 
> this field so things will work but I am curious what the error actually means:
> 
> ERROR:  create: system attribute named "oid"
> 
> Thanks,
> 
> Drew

Every record in a table has a unique OID value. So if you were to insert the
same value twice, you would be able to keep them apart using the OID value.
Since PostgreSQL uses the oid field internally, you cannot use it.

I hope this helps.

Mathijs



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~1999-12-14 00:33 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-12-14 00:14 System Attribute Drew Whittle <drew@albatross.co.nz>
1999-12-14 00:33 ` Mathijs Brands <mathijs@ilse.nl>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox