• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 729
  • Last Modified:

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

---------------------------
OK  
---------------------------
0
Skumar_CCSA
Asked:
Skumar_CCSA
  • 3
1 Solution
 
earth man2Commented:
DELETE FROM vdsauditmsg CASCADE;
0
 
Skumar_CCSAAuthor Commented:
Can you please share any screenshot if you have
0
 
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?
0
 
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....
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now