pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Marten Feldtmann <marten@feki.toppoint.de>
To: Chris Bitmead <chris@bitmead.com>
Cc: Hannu Krosing <hannu@tm.ee>
Cc: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Re: Thus spoke SQL3 (on OO)
Date: Mon, 22 May 2000 18:56:02 +0200 (CEST)
Message-ID: <200005221656.SAA02300@feki.toppoint.de> (raw)
In-Reply-To: <39291781.D9947450@bitmead.com>

> Hannu Krosing wrote:
> 
> It's not such a big deal really. When you do an OO model you don't need
> to think about your own primary key.
> 

 Hmm, I see here more and more postings, that do say, the OID (or the
result of a SEQUENCE) is usable for a key to identify an object stored
within a database.

 Though it's true, that SEQUENCE can be used to create unique
identifiers, the function is simply a hack - nothing more for greater
OO software systems and worse than software solutions, which provide
more power and lower traffic.

 The identification of an object has to be based on a unique key and
it does not matter of which type it is.

 The foreign key is of course not useful for the oo-model, but for the
programmer, which produces the object-relational wrapper this is VERY
urgent !

 And here again: if you use SEQUENCE for the OID you use a special
feature of the database ... and that is bad.

 Marten



 




view thread (23+ messages)  latest in thread

Message-ID: <200005221656.SAA02300@feki.toppoint.de>
Permalink:  ../200005221656.SAA02300@feki.toppoint.de/
Also on:    postgresql.org/message-id/200005221656.SAA02300@feki.toppoint.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: marten@feki.toppoint.de, chris@bitmead.com, hannu@tm.ee, chrisb@nimrod.itg.telstra.com.au
  Subject: Re: Thus spoke SQL3 (on OO)
  In-Reply-To: <200005221656.SAA02300@feki.toppoint.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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