Scrach itch #2. I just figured out how to change the ownership of a
sequence:
alter table <sequence> owner to <owner>.
Amazing how easy it is to figure out once you have posted the question
to the mailing list :)
thanks,
- Ryan
On Mon, 2002-05-06 at 11:52, Ryan Bradetich wrote:
.. snip ...
> Itch #2: Alter ownership on a sequence, etc.
>
> Alter table provides the functionality to change the ownership of a
> table, but ownership on other structures like sequences, etc can not
> be changed without dropping and recreating as the new owner. Would
> there be any interest if I worked on a patch to do this too?
>
>
>
> Thanks again for all the hard work and a great database!
>
> - Ryan Bradetich
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>