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 form:
>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..
--strk;
On Fri, Aug 13, 2004 at 10:05:09PM +1000, Philip Warner wrote:
> 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 dumpfile
>
> and it will only restore the items corresponding to lines in listfile.
>
>
>
>
>
> ----------------------------------------------------------------
> Philip Warner | __---_____
> Albatross Consulting Pty. Ltd. |----/ - \
> (A.B.N. 75 008 659 498) | /(@) ______---_
> Tel: (+61) 0500 83 82 81 | _________ \
> Fax: (+61) 03 5330 3172 | ___________ |
> Http://www.rhyme.com.au | / \|
> | --________--
> PGP key available upon request, | /
> and from pgp.mit.edu:11371 |/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
