Re: FK fields order

2005-11-11 Thread Mamta Satoor
Hi,   The error message does sound misleading in this case. Can you enter a JIRA entry to track this issue?   Mamta  On 11/11/05, Veaceslav Chicu <[EMAIL PROTECTED]> wrote: create table acc.account(account_id integer not null,plan_id integer not null);create table acc.trans(plan_id integer not nul

FK fields order

2005-11-11 Thread Veaceslav Chicu
create table acc.account ( account_id integer not null, plan_id integer not null ); create table acc.trans ( plan_id integer not null, credit_id integer not null, ); alter table acc.account add constraint account_pk primary key (account_id, plan_id); alter table acc.trans add constraint trans_cred