From: | Alessio Bragadini <alessio(at)albourne(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | A problem with new pg_dump |
Date: | 2001-05-07 10:19:48 |
Message-ID: | 3AF676C4.C8E1FD08@albourne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I've tried the pg_dump bundled in the new 7.1.1 release. I wanted to
test its feature of dumping a 7.0.X database.
Let's say I have database A running 7.1.1, B running 7.0.2. Both servers
have the same database 'test', 'myview' is a view defined on both of
them. I want to dump data only, being a VIEW I expect zero rows.
From host A:
pg_dump -da -t myview test OK
pg_dump -h B -a -t myview test OK
pg_dump -h B -da -t myview test An INSERT for each row
This last behaviour is obviously wrong because you cannot re-INSERT into
the VIEW (no rules are defined).
From host B:
pg_dump -da -t myview test OK
Seems that there is a problem dumping 'INSERT-style' from a 7.0.X
database.
Running PostgreSQL 7.1.1 on alphaev67-dec-osf4.0f, compiled by cc -std
--
Alessio F. Bragadini alessio(at)albourne(dot)com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925
From | Date | Subject | |
---|---|---|---|
Next Message | Tatsuo Ishii | 2001-05-07 12:29:23 | Re: v7.1.1 Branched, Packaged and Released ... |
Previous Message | Zeugswetter Andreas SB | 2001-05-07 10:10:03 | AW: Re: New Linux xfs/reiser file systems |