VASCO, PostgreSQL, IDENTIKEY, PostgreSQL Logs delete

i installed identikey server.
DB size is more now..
trying to delete the unwanted logs..
when i try to delete i get error msg.
please help how to solve this.

pgAdmin III
An error has occurred:

ERROR:  update or delete on table "vdsauditmsg" violates foreign key constraint "vdsauditmsgfield0" on table "vdsauditmsgfield"
DETAIL:  Key (vdstimestamp,vdsamid)=(2014-01-27 08:02:21.186,0D08804C8762AC61E4170195E73E985C) is still referenced from table "vdsauditmsgfield".

Who is Participating?
earth man2Connect With a Mentor Commented:
Skumar_CCSAAuthor Commented:
Can you please share any screenshot if you have
Skumar_CCSAAuthor Commented:
I tried this option it did not work....
If we delete the foreign key from the properties then it works, but I am not able to add the key back....

When I select the root folder and see the script, I see the constraint Restriction for both update and delete.

How I do I change the option...can you help?
Skumar_CCSAAuthor Commented:
Thanks ....
Your point helped to to me navigate and find the issue...I remove the foreign key..after that i was able to delete it....
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.