VASCO, PostgreSQL, IDENTIKEY, PostgreSQL Logs delete

Skumar_CCSA
Skumar_CCSA used Ask the Experts™
on
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".

---------------------------
OK  
---------------------------
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
DELETE FROM vdsauditmsg CASCADE;

Author

Commented:
Can you please share any screenshot if you have

Author

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?

Author

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....

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial