| From: | Rudi Starcevic <rudi(at)oasis(dot)net(dot)au> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Dropping Ref. Integrity |
| Date: | 2002-11-21 23:25:07 |
| Message-ID: | 3DDD6B53.1020408@oasis.net.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi,
I'm trying to drop some referential integrity on a table and am getting
this error:
PostgreSQL said: ERROR: zero-length delimited identifier
Your query: DROP TRIGGER "RI_ConstraintTrigger_6187534" ON "host_domain";
DROP TRIGGER "RI_ConstraintTrigger_6187538" ON "host_domain";
DROP TRIGGER "" ON "";
I created this using the 'references' statement.
I dropped the integrity using the PhpPgAdmin tool. There's a screen
where you can see the triggers on a database.
The 'update' trigger dropped ok but the 'on' trigger is giving the above
error.
Any idea's ?
TIA
Regards
Rudi.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Langille | 2002-11-22 06:18:25 | connectby questions |
| Previous Message | Manuel Sugawara | 2002-11-21 22:38:13 | Re: [SQL] psql on FreeBSD 4.7-RELEASE-p2 and greek (iso8859-7) chars |