Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 20EE5476023 for ; Thu, 21 Nov 2002 18:26:00 -0500 (EST) Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by postgresql.org (Postfix) with ESMTP id 87C88475FDE for ; Thu, 21 Nov 2002 18:25:58 -0500 (EST) Received: from oasis.net.au (guardian [210.8.139.5]) by water.oasis.net.au (8.9.3/100.1) with ESMTP id KAA28640 for ; Fri, 22 Nov 2002 10:02:29 +1000 X-Authentication-Warning: water.oasis.net.au: Host guardian [210.8.139.5] claimed to be oasis.net.au Message-ID: <3DDD6B53.1020408@oasis.net.au> Date: Fri, 22 Nov 2002 09:25:07 +1000 From: Rudi Starcevic User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.1) Gecko/20020826 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Dropping Ref. Integrity Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/339 X-Sequence-Number: 10481 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.