| 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: | Whole Thread | Raw Message | 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 |