Tony Caduto wrote:
Hi,
I did restore from a 8.0 dump.
[snip]
I am trying my tests on a new database with fresh language install now.
How can I get my restored databases to behave the same as a fresh one?
Run "createlang plpgsql mydb" before running your restore, and possibly
remove the bits that create them from the dump script, or they might
just fail benignly.
cheers
andrew
---------------------------(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
