-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ali Gökçen
Sent: Sunday, July 09, 2006 2:04 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: FK confusion

>Pardon,
>it was my sunday laziness... references on "Cust"(ID).
>
>...
>
> CREATE UNIQUE INDEX "IDX_Cust_13" ON "Cust" (ID);
>
>
>Did you commited this create index command and was it ok?

Yes. I was hoping it would be some sort of transaction-related
thing, but the index is there, and marked unique, according to
FlameRobin and from my grubbing around in RDB$INDICES with isql:


SQL> select rdb$index_name, rdb$unique_flag from rdb$indices
where upper(rdb$index_name) = 'IDX_CUST_13';

RDB$INDEX_NAME RDB$UNIQUE_FLAG
=============================== ===============

IDX_Cust_13 1

SQL>