Re: Bug in pg_dump

From: Marko Tiikkaja <marko(dot)tiikkaja(at)cs(dot)helsinki(dot)fi>
To: Joel Jacobson <joel(at)gluefinance(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Bug in pg_dump
Date: 2011-01-13 11:02:07
Message-ID: 4D2EDBAF.80800@cs.helsinki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2011-01-13 11:31 AM +0200, Joel Jacobson wrote:
> The example from Tom Lane below results in a database which is not
> possible to correctly dump using pg_dump.
>
> The view v1 strangely becomes a table in the dump output?!

> CREATE RULE "_RETURN" AS ON SELECT TO v1 DO INSTEAD SELECT v2.f1, v2.f2 FROM v2;

This statement turns the table into a view.

Regards,
Marko Tiikkaja

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2011-01-13 11:06:08 Re: pg_primary_conninfo
Previous Message Robert Haas 2011-01-13 10:59:47 Re: libpq documentation cleanups (repost 3)