This is a discussion on BUG #3656: cannot truncate table in PGSQL from Java within the pgsql Bugs forums, part of the PostgreSQL category; --> The following bug has been logged online: Bug reference: 3656 Logged by: Eli Email address: eli.milanova@gmail.com PostgreSQL version: 8.0.1 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |