Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-15 Thread Bruce Momjian
Matthias Schmidt wrote: > Hi Tom, > > after beeing offline because of a chrashed box, I able to mail again. > I would like to volunteer for the uptime() function. Is that OK? Sure. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 3

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-15 Thread Matthias Schmidt
Hi Tom, after beeing offline because of a chrashed box, I able to mail again. I would like to volunteer for the uptime() function. Is that OK? cheers, Matthias Am 13.12.2004 um 03:31 schrieb Bruce Momjian: Matthias Schmidt wrote: Am 07.12.2004 um 19:24 schrieb Tom Lane: Matthias Schmidt <[EMAIL PR

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-12 Thread Bruce Momjian
Matthias Schmidt wrote: > > Am 07.12.2004 um 19:24 schrieb Tom Lane: > > > Matthias Schmidt <[EMAIL PROTECTED]> writes: > >> By the way: Do you have an idea about a small or > >> medium sized task from the TODO-List for a newbee, which gets me up to > >> speed?(!Win32) > > > > A lot of the tasks

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-11 Thread Peter Eisentraut
Alvaro Herrera wrote: > I had thought that maybe we shouldn't track dependencies on the first > superuser, on the assumption that it cannot be dropped. I'm not sure > if this is entirely true however. Well, there are certainly nontrivial provisions for recovering installations where it has been

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-11 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > I have been working on the patch and it seems now it works as I > originally intended it to: dropping users or tablespaces is disallowed > unless they own or contain no object. ACL's are not tracked; I'm still > unsure if they should be. If we fail to

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-11 Thread Alvaro Herrera
On Mon, Dec 06, 2004 at 05:27:32PM -0500, Tom Lane wrote: Hi, > So if Alvaro's thing works out, the shared-sequence problem becomes moot. > Probably that's a good reason not to spend time on it just yet. I'm still alive, and I've been following this thread. Sorry for not giving an update. I ha

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-10 Thread Tom Lane
Matthias Schmidt <[EMAIL PROTECTED]> writes: > By the way: Do you have an idea about a small or > medium sized task from the TODO-List for a newbee, which gets me up to > speed?(!Win32) A lot of the tasks listed under DATA TYPES are fairly self-contained problems ... but what draws your interest?

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-10 Thread Matthias Schmidt
Am 07.12.2004 um 19:24 schrieb Tom Lane: Matthias Schmidt <[EMAIL PROTECTED]> writes: By the way: Do you have an idea about a small or medium sized task from the TODO-List for a newbee, which gets me up to speed?(!Win32) A lot of the tasks listed under DATA TYPES are fairly self-contained problems

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-10 Thread Matthias Schmidt
Am 06.12.2004 um 23:27 schrieb Tom Lane: schmidtm <[EMAIL PROTECTED]> writes: 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? No, that's not quite the di

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-06 Thread Tom Lane
schmidtm <[EMAIL PROTECTED]> writes: > 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? No, that's not quite the direction of the problem. The real

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-06 Thread schmidtm
Hi Tom + *, Am 03.12.2004 um 23:58 schrieb Tom Lane: schmidtm <[EMAIL PROTECTED]> 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 f

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-04 Thread Riccardo G. Facchini
--- Tom Lane <[EMAIL PROTECTED]> wrote: > schmidtm <[EMAIL PROTECTED]> 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

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Bruce Momjian
Kris Jurka wrote: > > > On Fri, 3 Dec 2004, Bruce Momjian wrote: > > > > What about Alvaro's shared dependencies work: > > > > > > http://archives.postgresql.org/pgsql-hackers/2004-10/msg00963.php > > > > That is for allowing comments on global tables like pg_shadow and > > pg_database. I don

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Kris Jurka
On Fri, 3 Dec 2004, Bruce Momjian wrote: > > What about Alvaro's shared dependencies work: > > > > http://archives.postgresql.org/pgsql-hackers/2004-10/msg00963.php > > That is for allowing comments on global tables like pg_shadow and > pg_database. I don't think it relates to finding if some

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Bruce Momjian
Kris Jurka wrote: > > > On Fri, 3 Dec 2004, Tom Lane wrote: > > > > 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 conn

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-03 Thread Tom Lane
Kris Jurka <[EMAIL PROTECTED]> writes: > On Fri, 3 Dec 2004, Tom Lane wrote: >> 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. > What about

Re: [HACKERS] somebody working on: Prevent default re-use of sysids

2004-12-03 Thread Kris Jurka
On Fri, 3 Dec 2004, Tom Lane wrote: > > 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 t

Re: [HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-03 Thread Tom Lane
schmidtm <[EMAIL PROTECTED]> 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 pret

[HACKERS] somebody working on: Prevent default re-use of sysids for dropped users and groups?

2004-12-03 Thread schmidtm
Hi *, is somebody working on these two issues on the TODO-List? 1) Prevent default re-use of sysids for dropped users and groups Currently, if a user is removed while he still owns objects, a new user given might be given their user id and inherit the previous users objects. 2) Prevent dropp