Re: copying databases w/ indexes

Yuji Shinozaki <ys2n@virginia.edu> writes:
> See my other reply, but the problem was that I had a foreign key
> constraint between an integer and varchar. (The column was a varchar and
> the foreign key was an integer field).  Seems to me postgres shouldn't
> have allowed me to do this at all, but I guess it did a slow automatic
> type conversion.  So, reindexing was deathly slow.

There was some talk recently of spitting out a NOTICE when the
referenced columns aren't the same type as the referencing columns.
It's not done yet, but it's starting to seem like a good idea.

            regards, tom lane