From: | "Riccardo G(dot) Facchini" <abief_ag_-postgresql(at)yahoo(dot)com> |
---|---|
To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: somebody working on: Prevent default re-use of sysids for dropped users and groups? |
Date: | 2004-12-04 09:52:19 |
Message-ID: | 20041204095219.4372.qmail@web13912.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> schmidtm <schmidtm(at)mock-software(dot)de> writes:
> > is somebody working on these two issues on the TODO-List?
>
> > 1) Prevent default re-use of sysids for dropped users and groups
>
> I don't know of anyone actively working on it, but if you check the
> archives you'll find that the preferred solution approach is pretty
> well
> hashed out --- it boils down to creating a shared sequence object and
> using that, rather than a MAX(sysid) query, to select default sysids.
> The painful part of this is just that bootstrap mode doesn't
> currently
> have any support for creating sequences. I don't think fixing that
> will
> be hugely hard, but it might be a bit tedious.
>
> > 2) Prevent dropping user that still owns objects, or auto-drop the
> > objects
>
> No one has any idea how to do this reasonably --- the problem is you
> have no visibility into databases other than the one you're connected
> to, so you can't tell what the user owns in other databases.
>
> regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
Maybe mine is an impossible suggestion, or maybe is just plain
stupid... but would be possible to create a "supershema" os sorts,
shared by all databases?
basically, a schema that is stored by default on all the databases,
with a backend process that takes care of the replication.
I insist, mine is just a wild suggestion, or just downright stupid...
regards,
Riccardo
From | Date | Subject | |
---|---|---|---|
Next Message | Kurt Roeckx | 2004-12-04 11:50:56 | Re: Buildfarm coverage (was Re: OK, ready for RC1 or Beta6) |
Previous Message | Joe Conway | 2004-12-04 05:33:09 | rc1 fedora core rpms |