calling 'has_a' on foreign key that is also a primary key causes intermittant error.

[prev] [thread] [next] [Date index for 2005/02/08]

Hi all, I have a problem, for which I have a workaround, but it's not 
optimal, so I'm asking you guys for ideas.

I have a database with two tables (amongst others....)

table gateways:
name         text    PRIMARY KEY,
customer_id  integer REFERENCES customer_details,
build_status char(2) NOT NULL.
type         text    REFERENCES gateway_types


table subscriber_gateways:
name             text PRIMARY KEY REFERENCES gateways,
mgcp_domain_name text UNIQUE

when I create the subscriber_gateways class, if I call has_a on the 
primary key, it causes intermittant faults when accessing the class 
later on, in that, while search and retrieve succeed, calling the 
mgcp_domain_name accessor produces the following error:

Can't bind a reference (FENS::BBV::gateways=HASH(0x64b6e4)) at 
/opt/perl5.8.6/lib/site_perl/5.8.6/DBIx/ContextualFetch.pm line 51.

I've gotten round it for now by not calling has_a on the foreign key, 
but I'm wondering if there's another way?

Chris