From: | Ryan Bradetich <rbradetich(at)uswest(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: a couple of minor itches: RI Trigger Names, and |
Date: | 2002-05-06 23:01:06 |
Message-ID: | 1020726066.17204.3.camel@beavis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marc G. Fournier | 2002-05-06 23:20:09 | Re: Native Windows, Apache Portable Runtime |
Previous Message | Tom Lane | 2002-05-06 22:59:58 | Re: HEADS UP: Win32/OS2/BeOS native ports |