| From: | ryan <ryan(at)bel(dot)bc(dot)ca> | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Stored Procedure warnings | 
| Date: | 2000-07-12 00:29:07 | 
| Message-ID: | 396BBBD3.21C0F966@bel.bc.ca | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
Hi,
I tried to create a stored procedure:
be=# CREATE FUNCTION freeip ( int4 ) RETURNS inet AS '
be'# (SELECT ip FROM allips WHERE net = $1)
be'#   EXCEPT
be'#  (SELECT ipaddr FROM ips WHERE ipaddr << 
be'#    (SELECT net FROM nets WHERE netid = $1))
be'# order by ip'
be-# LANGUAGE 'sql';
NOTICE:  _outNode: don't know how to print type 703 
NOTICE:  _outNode: don't know how to print type 703 
NOTICE:  _outNode: don't know how to print type 703 
NOTICE:  _outNode: don't know how to print type 703 
CREATE
Then every call to freeip() generates those _outNode warning
messages...  
Now, this is with postgresql 7.0.2... I have another box with
postgresql, but it is the debian package of such, and this works
perfectly on it.. I have another machine running stampede (ick) and I
compiled postgresql and now it gives me this warning...
Is there something im missing here?
Thanks,
-ryan
--
Ryan Rawson
System Administrator
Binary Environments Ltd.
ryan(at)bel(dot)bc(dot)ca
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew McMillan | 2000-07-12 00:48:49 | Re: [GENERAL] Slashdot discussion | 
| Previous Message | Peter Eisentraut | 2000-07-12 00:23:23 | Re: pg_backup symlink? |