operator '~~' for types 'inet' and '"unknown"'

From: Shaun Jurrens <shaun(dot)jurrens(at)skoleetaten(dot)oslo(dot)no>
To: pgsql-novice(at)postgresql(dot)org
Subject: operator '~~' for types 'inet' and '"unknown"'
Date: 2003-04-07 14:06:36
Message-ID: 20030407140636.GC78744@nevada.skoleetaten.oslo.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I seem to have a problem that I haven't found an obvious answer to or a
reference to in the mailing lists or on google. Using dumps on a little
network database that I've made, I've run into problems with select's like:

select * from ske_net_allocs where ip_net like '139.165.19%';

These work on 7.2.3 on freebsd but not with

PostgreSQL 7.3.2 on i386-portbld-freebsd4.7.

I get the following error:

ERROR: Unable to identify an operator '~~' for types 'inet' and '"unknown"'
You will have to retype this query using an explicit cast

This may be a real bonehead question, but I'm unfortunately too ignorant to
answer it yet. I've tried using dumps from the 7.2.3 box using both
pg_dump and pg_dump -o. Thanks in advance for any hints/clue bats.

I'd appreciate a CC, because I read the list via the archives. Thanks.

--
Med vennlig hilsen/Sincerely,

Shaun D. Jurrens
Drift og Sikkerhetskonsulent
IKT-Avdeling
Oslo Skoleetaten
Tel: +47 2208 7394
Mobil: +47 9820 8826

gpg key fingerprint: 007A B6BD 8B1B BAB9 C583 2D19 3A7F 4A3E F83E 84AE

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Antti Haapala 2003-04-07 15:01:33 Re: calling C++ functions from PostgreSQL
Previous Message Alessandro Galasso 2003-04-07 10:10:26 Basic info