Re: table sequence

From: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: table sequence
Date: 2003-03-21 12:13:03
Message-ID: Pine.LNX.4.44.0303211741360.2317-100000@Bhuvan.bksys.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> Hello, I've changed the owner of a table in a database from the super-user
> to a normal user using the command ALTER TABLE table OWNER TO user;
> This changed the owner of the table but not the sequence associated with it.
> What is the command to do this. I have trawled through numerous forums and
> pages for the solution but could not find one. I am running postgresql 7.2
> on Solaris 8.

One among the way is,

1. Check the current value of that sequence
2. Drop that sequence as super user
3. Create the SAME sequence as non-super user with start value as previous
current value.

regards,
bhuvaneswaran

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message HK 2003-03-21 13:06:01 Initialising bit values inside stored procedure.
Previous Message Chr. Rossmanith 2003-03-21 12:06:45 age / timestamp