Funny works fine in my system. FireBird 1.5 Release 8.

At 09:27 AM 1/20/2004, you wrote:

>Hi,
>
>I am trying to execute the following SQL which has self-reference:
>
> create table ExampleTable (
> code integer not null primary key,
> name varchar(100) not null unique,
> parent integer,
>
> foreign key (parent) references ExampleTable(code)
> );
>
>And, this throws an error like:
>
>fmSQLEditor.Query:
>This operation is not defined for system tables.
>unsuccessful metadata update.
>object EXAMPLETABLE is in use .
>
>Is this a bug?
>THANKS!..
>
>
>
>
>
>Yahoo! Groups Links
>
>To visit your group on the web, go to:
> http://groups.yahoo.com/group/firebird-support/
>
>To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>Your use of Yahoo! Groups is subject to:
> http://docs.yahoo.com/info/terms/