Renaming Tables.

Dear All,

I've been renaming some of my tables with alter table. These tables were
created with a primary key so an implicit unique index is created on the
primary key field.

When I rename the table, the <old_table_name>_pkey is not renamed but the
key still appears to function normally (e.g. I can't insert two entries
with the same primary key).

Are they any instances (other than 'human' ones such as lack of clarity in
table names) where this might be a problem or can I safely ingnore the
discrepancy.

Cheers,

S.

+-------------------------+--------------------------------------+
| Stuart Rison | Ludwig Institute for Cancer Research |
+-------------------------+ University College London |
| Tel. (0171) 878 4041 | 91 Riding House Street |
| Fax. (0171) 878 4040 | London, W1P 8BT, UNITED KINGDOM. |
+-------------------------+--------------------------------------+
| stuart(at)NOJUNK_ludwig(dot)ucl(dot)ac(dot)uk [Remove NOJUNK_ for it to work] |
+----------------------------------------------------------------+