From: | Luke Tudor - RSG <ltt(at)unixmail(dot)nerc-pml(dot)ac(dot)uk> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | Error Messages!? |
Date: | 2000-11-10 15:33:45 |
Message-ID: | 3A0C1559.6FD80D63@unixmail.npm.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Dear All,
I have recently started working on psql, I am experiencing an error, and
I am unable to find any documentation on Psql's error messages.
The problem is as follows;
If I say :
"DELETE FROM PERMISSION WHERE PERMISSIONNO = 1176;"
I should delete that permission :- I Know it exists.
However, I am recieving the error message;
"ERROR: check_foreign_key: invalid number of arguments 10 for 3
references"
The primary key for the table is PERMISSIONNO, there are no forien keys.
Below is an Entiry Relationship Diagram showing the relation from
permission to other tables.
[agreementpermission] -- < [permission] >--- [PermissionImageDate]
|
|
/|\
/|\
[Agreement]
[Imagedate]
In Permission, primary key is permissionno.
In agreementpermission, (link table) it has forien key permissionno & forein key agreementno.
Agreement has primary key agreement no.
Any Ideas, why the error message is occuring? I would love to hear from anyone who has any ideas.
I know I haven't explained this very well!
Best Regards
Luke Tudor.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-11-10 15:53:08 | Re: Error Messages!? |
Previous Message | webadmin | 2000-11-10 12:30:09 | geometric type: path |