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