Thread: ALTER TABLE OWNER: handle toast
Hi all, The attached patch changes ALTER TABLE OWNER to also change the ownership of any toast tables that belong to the table that is being operated upon (as suggested by Tom Lane). Unless there are any problems, please apply for 7.3 Cheers, Neil -- Neil Conway <neilconway@rogers.com> PGP Key ID: DB3C29FC
Attachment
Your patch has been added to the PostgreSQL unapplied patches list at:
http://candle.pha.pa.us/cgi-bin/pgpatches
I will try to apply it within the next 48 hours.
---------------------------------------------------------------------------
Neil Conway wrote:
> Hi all,
>
> The attached patch changes ALTER TABLE OWNER to also change the
> ownership of any toast tables that belong to the table that is being
> operated upon (as suggested by Tom Lane).
>
> Unless there are any problems, please apply for 7.3
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilconway@rogers.com>
> PGP Key ID: DB3C29FC
[ Attachment, skipping... ]
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Patch applied. Thanks. --------------------------------------------------------------------------- Neil Conway wrote: > Hi all, > > The attached patch changes ALTER TABLE OWNER to also change the > ownership of any toast tables that belong to the table that is being > operated upon (as suggested by Tom Lane). > > Unless there are any problems, please apply for 7.3 > > Cheers, > > Neil > > -- > Neil Conway <neilconway@rogers.com> > PGP Key ID: DB3C29FC [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026