| From: | Reinhard Mueller <reinhard(dot)mueller(at)bytewise(dot)at> |
|---|---|
| To: | Neil Tiffin <ntiffin(at)earthlink(dot)net> |
| Cc: | Hannu Krosing <hannu(at)tm(dot)ee>, Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, gnue-geas(at)lists(dot)gnue(dot)org |
| Subject: | Re: [gnue-geas] Re: Proposal: OID wraparound: summary and proposal |
| Date: | 2001-08-11 20:54:55 |
| Message-ID: | 3B759B9F.8040509@bytewise.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Neil Tiffin wrote:
> I have not even considered multiple database servers running different
> database, which is our design goal. In this case we would like to have
> a slimmed down (and blazingly fast) PostgreSQL server in which we manage
> the uid in our middleware. This is because the uid must be unique
> accross all servers and database vendors. (I don't claim to be a
> database guru, so if we are all wet here please feel free to help
> correct our misunderstandings.)
I am not 100% sure, but I would believe that the
oid/uid/whatever_we_call_it only has to be unique within the table.
At least as long as you don't exchange data between different databases.
As soon as you transfer data from db a to db b, it's good to have an
object id that is unique in the world.
--
Reinhard Mueller
GNU Enterprise project
http://www.gnue.org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-08-11 20:59:49 | Re: [PATCHES] Select parser at runtime |
| Previous Message | Justin Clift | 2001-08-11 20:48:53 | Re: CREATE LANGUAGE |