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: (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group