Re: WIP Patch for GROUPING SETS phase 1 - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: WIP Patch for GROUPING SETS phase 1
Date
Msg-id 20140822142942.GK6343@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: WIP Patch for GROUPING SETS phase 1  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: WIP Patch for GROUPING SETS phase 1
List pgsql-hackers
Andrew Gierth wrote:

> (This of course means that if someone has a cube() function call in
> a group by clause of a view, then upgrading will change the meaning
> of the view and possibly fail to create it; there seems to be no fix
> for this, not even using the latest pg_dump, since pg_dump relies on
> the old server's ruleutils)

This sucks.  Can we tweak pg_dump to check for presence of the cube
extension, and if found refuse to dump unless a minor version older than
some hardcoded version (known to have fixed ruleutils) is used?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: After switching primary server while using replication slot.
Next
From: Alvaro Herrera
Date:
Subject: Re: Proposal to add a QNX 6.5 port to PostgreSQL