PostgreSQL SQL

Author

sysid

A. R. Van Hook

2005-11-23, 11:25 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jaime Casanova

2005-11-23, 11:25 am

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 ;)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Alvaro Herrera

2005-11-23, 11:25 am

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Vivek Khera

2005-11-26, 3:23 am

On Nov 23, 2005, at 10:45 AM, Alvaro Herrera wrote:

> A. R. Van Hook wrote:
>
> 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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links