Skip site navigation (1) Skip section navigation (2)

Re: WITH SYSID feature dropped

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Donald Fraser" <postgres(at)kiwi-fraser(dot)net>
Cc: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: WITH SYSID feature dropped
Date: 2005-12-20 15:57:04
Message-ID: 29845.1135094224@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
"Donald Fraser" <postgres(at)kiwi-fraser(dot)net> writes:
> 1) Was there a good reason for dropping this feature?

Users/groups are identified by OIDs now, not by sysids.

The original motivation for allowing manual assignment of userids was to
allow recovery if a user was dropped while still owning objects --- you
could recreate the user with the same sysid and then the objects' owner
fields would match up.  8.1 now does reference counting and prevents you
from dropping users who still own anything, so AFAICS that use-case is
gone.  Do you have another one?

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Jonathan ParkinDate: 2005-12-20 16:21:53
Subject: PostgreSQL 7.4.10 hanging on delete
Previous:From: Tom LaneDate: 2005-12-20 15:35:13
Subject: Re: PG8.1 - Config file check

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group