rserv and inet data type
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 | 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)
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, Pennsylvania 19073