Hi,

> I have a table named REGOPER_PART with 18,000 records. When trying to

create

> a foreign key that DID NOT exist, I get:
>
> This operation is not defined for system tables.
> unsuccessful metadata update.
> STORE RDB$RELATION_CONSTRAINTS failed.
> attempt to store duplicate value (visible to active transactions) in

unique

> index "RDB$INDEX_12".

Without the proper metadata and statements, it's hard to say -
probably someone else who knows the engine knows what index
that is :)

You're sure you didn't name the constraint to some existing constraint?

> When trying to check Indexes for this table using IBConsole, I get:
> SQL ERROR CODE -204
> Ambiguous field name between table RDB$INDICES and table

RDB$INDEX_SEGMENTS

> RDB$INDEX_NAME
>
> I gbaked and restored it, and the problem is still there.
>
> whats wrong?

IBConsole is no longer compatible with Firebird. You really should
try one of the other tools available.

Download a copy of Firebird Workbench (shareware) at www.upscene.com
or give a free tool a try - see www.ibphoenix.com section "contributed
downloads" for a list.

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."