that's ok, i found a working solution with 8.0.5 +pg-hier (8.0.1 wouldn't work + or -pg-hier), so i got things dumped, upgraded, and running. thank you to you and the guys on #postgresql very much for your assistance :)
davidOn 1/9/06, Tom Lane <[EMAIL PROTECTED]> wrote:
David Ford <[EMAIL PROTECT
David Ford <[EMAIL PROTECTED]> writes:
> i've tried with and without the hier patch and neither seems to work.
I was afraid of that: you've got some views created with the patch
installed and some with it not installed.
> i have a few options left to try but i might be reduced to stitching togeth
you are correct and we've gone down that road. i build my db with 8.0.1, and i've upgraded through to 8.0.5 as time went by and i never noticed an issue with it until i went to bump to 8.1 today.i've tried with and without the hier patch and neither seems to work. i have a few options left to try
David Ford <[EMAIL PROTECTED]> writes:
> i encountered this when trying to do a pg_dumpall in preparation for moving
> from 8.0 to 8.1.
Would it be too far off to guess that you're running Gentoo? This looks
like ye olde problem with that hierarchical-queries patch that they push
on people. Eith
i encountered this when trying to do a pg_dumpall in preparation for moving from 8.0 to 8.1.Jaymale ~ # pg_dump -U postgres -d administration > psql-dbs.jan2006.dumppg_dump: SQL command failedpg_dump: Error message from server: ERROR: unexpected right parenthesis
pg_dump: The command was: SELECT t
