Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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: reassign-fdw.patch
Description: application/octet-stream (8.2 KB)

In response to

Responses

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group