Re: sysid

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "A(dot) R(dot) Van Hook" <hook(at)lake-lotawana(dot)mo(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: sysid
Date: 2005-11-23 15:45:22
Message-ID: 20051123154522.GC26927@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • sysid at 2005-11-23 14:26:49 from A. R. Van Hook

Responses

  • Re: sysid at 2005-11-26 03:22:38 from Vivek Khera

Browse pgsql-sql by date

  From Date Subject
Next Message Jaime Casanova 2005-11-23 15:52:02 Re: sysid
Previous Message Wim Audenaert 2005-11-23 15:21:40 Drop functions