Re: pg_dump PostgreSQL 8.4

What version of pg_dump and pgAdmin are you using?

In PostgreSQL version 8.3 it's reltriggers, in version 8.4 it's
relhastriggers. Just run the next query to see the difference:

SELECT * FROM pg_class;

Using pgAdmin 1.10, I don't have any problemes with 8.3 nor 8.4

Regards,
Frank

Op 9 jul 2009, om 10:24 heeft serafin g.segador het volgende geschreven:

> hi!.
>
> i am trying to migrate my database from 8.3.7 to 8.4 (both versions
> running on the same server windows 2003, hp ml350 quad core xeon)
> using pg_dump and restore using pgAdmin III R 1.10.0, this i was
> able to do. but i cannot seem to make a backup on 8.4. i keep
> getting the following error message:
>
> pg_dump: reading user-defined tables
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: column "reltriggers"
> does not exist
> LINE 1: ...oles WHERE oid = relowner) as rolname, relchecks,
> reltrigger...
> ^
> pg_dump: The command was: SELECT c.tableoid, c.oid, relname, relacl,
> relkind, relnamespace, (SELECT rolname FROM pg_catalog.pg_roles
> WHERE oid = relowner) as rolname, relchecks, reltriggers,
> relhasindex, relhasrules, relhasoids, d.refobjid as owning_tab,
> d.refobjsubid as owning_col, (SELECT spcname FROM pg_tablespace t
> WHERE t.oid = c.reltablespace) AS reltablespace,
> array_to_string(c.reloptions, ', ') as reloptions from pg_class c
> left join pg_depend d on (c.relkind = 'S' and d.classid = c.tableoid
> and d.objid = c.oid and d.objsubid = 0 and d.refclassid = c.tableoid
> and d.deptype = 'a') where relkind in ('r', 'S', 'v', 'c') order by
> c.oid
> pg_dump: *** aborted because of error
> Process returned exit code 1.
> is there any configuration setting i need to do. any help would be
> appreciated.
>
> regards
>
> raffy segador
> destiny cable inc
> ncr, philipines

Frank Heikens
frankheikens(at)mac(dot)com