Stephan,
Thanks for your reply.
No I don't have indexes on the *_id fields in bus_pc_idc. Now that you
point it out it make perfect sense why this query would
take a while and give the impression it's hanging - it's all those seq
scans.
Thank you kindly, I really appreicate it.
Regards
Rudi.
> Hello,
>
> I have two 4 table with referential constraint's that are hanging when I
> try to delete from them.
>
> I have a,
> users table, ( 3 rows )
> suburbs table ( 16000 rows ),
> regions table ( 54 rows )and
> a bus_pc_idc table ( business type ) ( 3 rows )
>
> Here is my integr
Hello,
I have two 4 table with referential constraint's that are hanging when I
try to delete from them.
I have a,
users table, ( 3 rows )
suburbs table ( 16000 rows ),
regions table ( 54 rows )and
a bus_pc_idc table ( business type ) ( 3 rows )
Here is my integrity rules:
create ta
