Re: REASSIGN OWNED lacks support for FDWs

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: REASSIGN OWNED lacks support for FDWs
Date: 2012-02-21 22:14:26
Message-ID: 1329862262-sup-6225@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Excerpts from Alvaro Herrera's message of mar feb 21 15:54:03 -0300 2012:
> Excerpts from Tom Lane's message of lun feb 20 12:37:45 -0300 2012:
> > Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> > > On Wed, Feb 15, 2012 at 12:58 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > >> As per http://archives.postgresql.org/pgsql-general/2012-02/msg00304.php
> > >> there is no switch case in shdepReassignOwned for foreign data wrappers.

> I'm gonna take a stab at fixing this now (the simple way).

Here's the patch I have; last minute opinions. I intend to push a
backpatch to 9.1 and 9.0. 8.4 has the same problem, but since Heikki
punted in e356743f3ed45c36dcc4d0dbf6c1e8751b3d70b5, I'm not going to
bother either.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Attachment Content-Type Size
reassign-fdw.patch application/octet-stream 8.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gabriele Bartolini 2012-02-21 23:19:08 Re: [PATCH] Support for foreign keys with arrays
Previous Message Dimitri Fontaine 2012-02-21 21:44:04 Re: Displaying accumulated autovacuum cost