um...Your soln is possible. But if the user created an unique index using constraint name <table_name>_<column_name>_key5, it will not be able to distinguish it from other auto index.
On Tue, Jun 10, 2008 at 12:58 PM, Alex Hunsaker <badalex@gmail.com> wrote:
On Mon, Jun 9, 2008 at 10:17 PM, Tommy Cheng <csckcac@gmail.com> wrote: > you are right. I double checked. So, is there any way to turn off auto index > creation for the parent? (the best is changing postgresql database setting) > I am using postgres (PostgreSQL) 8.1.9 on CentOS 5 x86_64 >
Again, there is no auto index creation for foriegn keys. However if you declared the column unique or its the pkey (ala unique) (As Scott said) then there will an index.
My guess, use the name of the index to try to distinguish. Auto generated ones will always be in the form: pkey: <table_name>_pkey(num) unique: <table_name>_<column_name>_key(num)
