| 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: | Whole Thread | Raw Message | 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 |