BUG #3656: cannot truncate table in PGSQL from Java - Mailing list pgsql-bugs

From Eli
Subject BUG #3656: cannot truncate table in PGSQL from Java
Date
Msg-id 200710050800.l9580V4E009130@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      3656
Logged by:          Eli
Email address:      eli.milanova@gmail.com
PostgreSQL version: 8.0.1
Operating system:   Windows
Description:        cannot truncate table in PGSQL from Java
Details:

Hi!
I'm trying to make "truncate table [tableName]" from Java but it doesn't
work. I'm dropping all foreign keys for the database from system catalog
"pg_constraint", I'm disabling triggers and dropping rules and after all
these I'm trying to truncate my table but there's the following mistake:
"INFO: Error while deleting information from t_accounts
ERROR: cannot truncate a table referenced in a foreign key constraint".
If anyone has an idea... please share it :)

pgsql-bugs by date:

Previous
From: "Radim Kolar"
Date:
Subject: BUG #3655: Inconsistent handling of usernames
Next
From: tomas@tuxteam.de
Date:
Subject: Re: BUG #3654: Inconsistent handling of usernames