Re: a couple of minor itches: RI Trigger Names, and

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

In response to

Browse pgsql-hackers by date

  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