Laurent ROCHE wrote:
Hi,
I am puzzled why when I use pg_dump I get a script with INTEGER and SEQUENCE
and when you (i.e. PG Admin) use pg_dump you get a script with SERIAL ?
Do you pass extra undocumented options to pg_dump ?
What version of pg_dump do you use in PG Admin III 1.6.1 ?
(I have used 8.1 and 8.2 with the same results)
8.2 with 1.6.1, and no, there are no undocumented features I'm aware of.
Mind you, if you're thinking of the SQL it displays in the main window,
then that *is* generated by pgAdmin - it's the backup scripts that we
use pg_dump for. It often does thinks in different ways from what you
might expect to get round issues such as circular dependencies.
Regards, Dave.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
