Hello, dump problems again.
I'm working on a dump ToC parser for spatial database restore
(postgis).
I've noticed that pg_dump-7.3 and pg_dump-7.4 list CAST entries
in different ways. Still 'Dump Version' is the same (1.7-0).
What does 'Dump Version' refer to then ? Are these ToC output
changes
At 08:09 PM 13/08/2004, strk wrote:
What does 'Dump Version' refer to then ? Are these ToC output
changes encoded somehow ?
The file format version of pg_dump; the actual contents depend on pg_dump
version, and the source database since pg_dump asks the source (as much as
possible) to present
On Fri, Aug 13, 2004 at 08:42:44PM +1000, Philip Warner wrote:
At 08:09 PM 13/08/2004, strk wrote:
What does 'Dump Version' refer to then ? Are these ToC output
changes encoded somehow ?
The file format version of pg_dump; the actual contents depend on pg_dump
version, and the source
At 08:53 PM 13/08/2004, strk wrote:
Commenting out lines from the dump corresponding to objects that
will be defined by another script.
I may have misunderstood, but try:
pg_restore -l dumpfile listfile
then delete lines from listfile that you do not want, and do:
pg_restore -L listfile
Philip, I'm trying to make the process you describe automatic.
A script reads objects definitoin from an .sql file
and automatically deletes linkes from 'listfile' corresponding
to objects already found in the given .sql file.
As for my problem (detecting CASTS) I had to support
lines in the
At 10:30 PM 13/08/2004, strk wrote:
From PG73:
552; 2663984 CAST bytea (public.wkb)
From PG74:
547; 1915318 CAST CAST (public.wkb AS bytea)
Since these two dumps have same file format version I asked..
The file format (unfortunately for you) does not define the format of the
On Fri, Aug 13, 2004 at 11:12:50PM +1000, Philip Warner wrote:
At 10:30 PM 13/08/2004, strk wrote:
From PG73:
552; 2663984 CAST bytea (public.wkb)
From PG74:
547; 1915318 CAST CAST (public.wkb AS bytea)
Since these two dumps have same file format version I asked..
The
