| From: | "Eli" <eli(dot)milanova(at)gmail(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #3656: cannot truncate table in PGSQL from Java |
| Date: | 2007-10-05 08:00:31 |
| Message-ID: | 200710050800.l9580V4E009130@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 3656
Logged by: Eli
Email address: eli(dot)milanova(at)gmail(dot)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 :)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | tomas | 2007-10-05 09:59:52 | Re: BUG #3654: Inconsistent handling of usernames |
| Previous Message | Radim Kolar | 2007-10-04 23:37:10 | BUG #3655: Inconsistent handling of usernames |