Re: Question/problem with create view and restore a backup with such a view

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Franz(dot)Rasper(at)izb(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Question/problem with create view and restore a backup with such a view
Date: 2005-10-16 03:50:36
Message-ID: 4565.1129434636@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Franz(dot)Rasper(at)izb(dot)de writes:
> Postgres 7.2.1 (Debian woody)

This bug has been fixed since 7.2.2 ...

2002-06-15 14:38 tgl

* src/backend/utils/adt/ruleutils.c (REL7_2_STABLE): Back-patch 7.3
fix to fully parenthesize UNION/EXCEPT/INTERSECT queries in
ruleutils output. The previous partial parenthesization was a hack
to get around grammar restrictions that have since been fixed; and
as Sam O'Connor pointed out, there were cases where it didn't work.

The 7.2 branch is no longer supported at all, but if you insist on using
it you should at least be running the latest point-release, 7.2.8.
Reasons why can be found on this and following pages:
http://developer.postgresql.org/docs/postgres/release-7-2-8.html

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Travers 2005-10-16 04:20:41 Re: [GENERAL] Oracle buys Innobase
Previous Message Neil Conway 2005-10-16 01:29:39 Re: Equivalent queries and the planner