> 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