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

BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)

From: "David Blewett" <david(at)dawninglight(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)
Date: 2009-05-20 12:48:34
Message-ID: 200905201248.n4KCmYRG018135@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4817
Logged by:          David Blewett
Email address:      david(at)dawninglight(dot)net
PostgreSQL version: 8.4beta2
Operating system:   Gentoo Linux
Description:        Dump of 8.3 hstore not restorable to 8.4 (RECHECK)
Details: 

In testing the beta to see if my planner issues might be resolved, I ran
into a situation where the 8.4 pg_dump created a dump for the hstore contrib
module which would not restore against 8.4.

Here is the problem SQL:
--
-- Name: gin_hstore_ops; Type: OPERATOR CLASS; Schema: public; Owner:
postgres
--

CREATE OPERATOR CLASS gin_hstore_ops
    DEFAULT FOR TYPE hstore USING gin AS
    STORAGE text ,
    OPERATOR 7 @>(hstore,hstore) RECHECK ,
    OPERATOR 9 ?(hstore,text) ,
    FUNCTION 1 bttextcmp(text,text) ,
    FUNCTION 2 gin_extract_hstore(internal,internal) ,
    FUNCTION 3 gin_extract_hstore_query(internal,internal,smallint) ,
    FUNCTION 4 gin_consistent_hstore(internal,smallint,internal);

--
-- Name: gist_hstore_ops; Type: OPERATOR CLASS; Schema: public; Owner:
postgres
--

CREATE OPERATOR CLASS gist_hstore_ops
    DEFAULT FOR TYPE hstore USING gist AS
    STORAGE ghstore ,
    OPERATOR 7 @>(hstore,hstore) RECHECK ,
    OPERATOR 9 ?(hstore,text) RECHECK ,
    OPERATOR 13 @(hstore,hstore) RECHECK ,
    FUNCTION 1 ghstore_consistent(internal,internal,integer) ,
    FUNCTION 2 ghstore_union(internal,internal) ,
    FUNCTION 3 ghstore_compress(internal) ,
    FUNCTION 4 ghstore_decompress(internal) ,
    FUNCTION 5 ghstore_penalty(internal,internal,internal) ,
    FUNCTION 6 ghstore_picksplit(internal,internal) ,
    FUNCTION 7 ghstore_same(internal,internal,internal);

This generates the following errors:
ERROR:  RECHECK is no longer supported at character 131
ERROR:  RECHECK is no longer supported at character 136

I worked around this by installing the 8.4 version of hstore and ignoring
those particular errors. However, why would pg_dump generate syntax that
isn't supported any longer?

David Blewett

Responses

pgsql-bugs by date

Next:From: David BlewettDate: 2009-05-20 13:17:10
Subject: Re: BUG #4817: Dump of 8.3 hstore not restorable to 8.4 (RECHECK)
Previous:From: hubert depesz lubaczewskiDate: 2009-05-20 12:01:08
Subject: Re: BUG #4816: NOT IN clause, doesn't work

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