Another OPERATOR bug??

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Pgsql-Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Another OPERATOR bug??
Date: 2000-12-20 08:55:00
Message-ID: NEBBIOAJBMEENKACLNPCMELICCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In our test environment, we performed the following set of commands (given
that the in/out functions already exist):

CREATE TYPE testtype (
internallength = 4,
input = test_in,
output = test_out
);

CREATE FUNCTION test_function(testtype, testtype)
RETURNS bool
AS '/usr/local/pgsql/types/bitset.so'
LANGUAGE 'c';

CREATE OPERATOR ^^^ (
leftarg = testtype,
rightarg = testtype,
procedure = test_function
);

DROP TYPE testtype;

Here, we've just dropped the testttype that the operator ^^^ uses. This
does not cause the operator to be deleted, it simply reverts its left and
right args to 'NONE'.

So, we're left with an operator with two NONE arguments (and returns NONE),
so we now try to drop this operator:

DROP OPERATOR ^^^ (NONE, NONE);

This fails with:

ERROR: parser: parse error at or near "NONE"

DROP OPERATOR ^^^ (none, none);

Also fails.

How do we go about dropping the now invalid operator???

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Mount 2000-12-20 11:42:49 Status of JDBC Interface
Previous Message Tatsuo Ishii 2000-12-20 08:37:44 sequence numbering on mails