Re: How to efficiently duplicate a whole schema?

"scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> On Wed, 6 Aug 2003, Tom Lane wrote:
>> One obvious question is whether you have your foreign keys set up
>> efficiently in the first place. As a rule, the referenced and
>> referencing columns should have identical datatypes and both should
>> be indexed. (PG will often let you create foreign key constraints
>> that don't meet these rules ... but performance will suffer.)

> Is this one of those things that should spit out a NOTICE when it happens?
> I.e. when a table is created with a references and uses a different type
> than the parent, would it be a good idea to issue a "NOTICE: parent and
> child fields are not of the same type"

I could see doing that for unequal data types, but I'm not sure if it's
reasonable to do it for lack of index. Usually you won't have created
the referencing column's index yet when you create the FK constraint,
so any warning would just be noise. (The referenced column's index *is*
checked for, since we require it to be unique.)

regards, tom lane