Thread: rserv and inet data type

rserv and inet data type

From
Rod Taylor
Date:
Below is a 7.2.4 example of the rserv log with inet data type. You will
notice that inet cast to text, and the log entry are differently (one
from unknown directly to text via a trigger, the other from inet cast to
text).

I see this hasn't been changed in the 7.4 version. Is there intent on
removing this package entirely in favour of eRServer?


build=#  select  _build2.ip::text, l.key, _build2.ip::text = l.key from
_RSERV_LOG_ l, build2 _build2 where l.reloid = 16734 and l.deleted = 0
and (l.logid >= 513);        ip         |       key       | ?column?
--------------------+-----------------+----------123.123.123.123/32 | 123.123.123.123 | f123.123.123.122/32 |
123.123.123.123| f123.123.123.123/32 | 123.123.123.122 | f123.123.123.122/32 | 123.123.123.122 | f 
(4 rows)


Re: rserv and inet data type

From
Bruce Momjian
Date:
Rod Taylor wrote:
- Start of PGP signed section.
> Below is a 7.2.4 example of the rserv log with inet data type. You will
> notice that inet cast to text, and the log entry are differently (one
> from unknown directly to text via a trigger, the other from inet cast to
> text).
> 
> I see this hasn't been changed in the 7.4 version. Is there intent on
> removing this package entirely in favour of eRServer?

Yes, I think so.

---------------------------------------------------------------------------


> 
> 
> build=#  select  _build2.ip::text, l.key, _build2.ip::text = l.key from
> _RSERV_LOG_ l, build2 _build2 where l.reloid = 16734 and l.deleted = 0
> and (l.logid >= 513);
>          ip         |       key       | ?column?
> --------------------+-----------------+----------
>  123.123.123.123/32 | 123.123.123.123 | f
>  123.123.123.122/32 | 123.123.123.123 | f
>  123.123.123.123/32 | 123.123.123.122 | f
>  123.123.123.122/32 | 123.123.123.122 | f
> (4 rows)
> 
-- End of PGP section, PGP failed!

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073