From: | schmidtm <schmidtm(at)mock-software(dot)de> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | 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-06 20:00:49 |
Message-ID: | 8653CA1C-47C1-11D9-A772-000393AA75A0@mock-software.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi Tom + *,
Am 03.12.2004 um 23:58 schrieb Tom Lane:
> 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.
Do I get that right: the only reason to do
max(sysid) or a user-supplied ID in CreateUser() (commands/user.c) is
that
we don't have the ability to get sequences over the *.BKI/initdb
mechanism?
If that is true and you think it's possible and worth to have sequences
in the bootstrap,
I volunteer to do this.
>
>> 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.
I think it's much better to leave this to somebody with far more
understanding of the subject.
>
> regards, tom lane
>
>
cheers,
Matthias
----------------------------------------------------------------------
Matthias Schmidt
Viehtriftstr. 49
67346 Speyer
Tel.: +49 6232 4867
Fax.: +49 6232 640089
From | Date | Subject | |
---|---|---|---|
Next Message | alex | 2004-12-06 20:02:45 | Re: DBD::PgSPI 0.02 |
Previous Message | Andrew Dunstan | 2004-12-06 19:56:19 | Re: DBD::PgSPI 0.02 |