> Greg Stark <[EMAIL PROTECTED]> writes: >> Hmmm I think there's still something missing here. I was using pg_restore -r >> (actually I was using -L but the list was originally generated with -r) which >> seemed like a good idea at the time. Rereading it now it seems like it >> shouldn't change anything because it says "This option is the default":
Actually, your real problem is that the documentation of -r bears no relationship whatever to what the code really does :-( I have attempted to improve it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match