pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedsysid
4+ messages / 4 participants
[nested] [flat]
* sysid
@ 2005-11-23 14:26 A. R. Van Hook <hook@lake-lotawana.mo.us>
2005-11-23 15:45 ` Re: sysid Alvaro Herrera <alvherre@commandprompt.com>
2005-11-23 15:52 ` Re: sysid Jaime Casanova <systemguards@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: A. R. Van Hook @ 2005-11-23 14:26 UTC (permalink / raw)
To: pgsql-sql
It seems that in 8.1.0 we can no longer set the SYSID when adding users
and groups.
i.e
template1=# create role hooker sysid 1345;
NOTICE: SYSID can no longer be specified
I have lots of code that depends on the actual group and user number.
Is there a way to set the user and group number?
thanks
--
Arthur R. Van Hook
Mayor
The City of Lake Lotawana
hook@lake-lotawana.mo.us
hook@lota.us
avanhook3@comcast.net
(816) 578-4704 - Home
(816) 578-4215 - City
(816) 564-0769 - Cell
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: sysid
2005-11-23 14:26 sysid A. R. Van Hook <hook@lake-lotawana.mo.us>
@ 2005-11-23 15:45 ` Alvaro Herrera <alvherre@commandprompt.com>
2005-11-26 03:22 ` Re: sysid Vivek Khera <vivek@khera.org>
1 sibling, 1 reply; 4+ messages in thread
From: Alvaro Herrera @ 2005-11-23 15:45 UTC (permalink / raw)
To: A. R. Van Hook <hook@lake-lotawana.mo.us>; +Cc: pgsql-sql
A. R. Van Hook wrote:
> It seems that in 8.1.0 we can no longer set the SYSID when adding users
> and groups.
> i.e
> template1=# create role hooker sysid 1345;
> NOTICE: SYSID can no longer be specified
>
> I have lots of code that depends on the actual group and user number.
> Is there a way to set the user and group number?
No -- fix the code. Just curious, how can user code depend on the
SYSIDs? I don't see a way.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: sysid
2005-11-23 14:26 sysid A. R. Van Hook <hook@lake-lotawana.mo.us>
2005-11-23 15:45 ` Re: sysid Alvaro Herrera <alvherre@commandprompt.com>
@ 2005-11-26 03:22 ` Vivek Khera <vivek@khera.org>
0 siblings, 0 replies; 4+ messages in thread
From: Vivek Khera @ 2005-11-26 03:22 UTC (permalink / raw)
To: pgsql-sql
On Nov 23, 2005, at 10:45 AM, Alvaro Herrera wrote:
> A. R. Van Hook wrote:
>> It seems that in 8.1.0 we can no longer set the SYSID when adding
>> users
>> and groups.
>> i.e
>> template1=# create role hooker sysid 1345;
>> NOTICE: SYSID can no longer be specified
>>
>> I have lots of code that depends on the actual group and user number.
>> Is there a way to set the user and group number?
>
> No -- fix the code. Just curious, how can user code depend on the
> SYSIDs? I don't see a way.
>
If 8.1 doesn't allow you to remove a user who still has rights
granted, then this should be no problem. however, in older versions
you can delete users and leave dangling rights with no way to revoke
them unless you create a user with that specific ID and then revoke
the rights, and re-delete the user.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: sysid
2005-11-23 14:26 sysid A. R. Van Hook <hook@lake-lotawana.mo.us>
@ 2005-11-23 15:52 ` Jaime Casanova <systemguards@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Jaime Casanova @ 2005-11-23 15:52 UTC (permalink / raw)
To: A. R. Van Hook <hook@lake-lotawana.mo.us>; +Cc: pgsql-sql
On 11/23/05, A. R. Van Hook <hook@lake-lotawana.mo.us> wrote:
> It seems that in 8.1.0 we can no longer set the SYSID when adding users
> and groups.
> i.e
> template1=# create role hooker sysid 1345;
> NOTICE: SYSID can no longer be specified
>
> I have lots of code that depends on the actual group and user number.
> Is there a way to set the user and group number?
>
> thanks
>
use versions < 8.1
> --
> Arthur R. Van Hook
> Mayor
> The City of Lake Lotawana
>
> hook@lake-lotawana.mo.us
> hook@lota.us
> avanhook3@comcast.net
> (816) 578-4704 - Home
> (816) 578-4215 - City
> (816) 564-0769 - Cell
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-11-26 03:22 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-23 14:26 sysid A. R. Van Hook <hook@lake-lotawana.mo.us>
2005-11-23 15:45 ` Alvaro Herrera <alvherre@commandprompt.com>
2005-11-26 03:22 ` Vivek Khera <vivek@khera.org>
2005-11-23 15:52 ` Jaime Casanova <systemguards@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox