Re: ip of the user doing an insert

From: Randolf Richardson <rr(at)8x(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: ip of the user doing an insert
Date: 2003-11-29 21:10:20
Message-ID: Xns944283F2C1232rr8xca@200.46.204.72
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[sNip]
>> If this isn't a feature now, hopefully it will be in the future, but I
>> assume it will have to return the address as a string since IPv4 and
>> IPv6 are formatted differently.
>
> Why not use the inet type, which can support both formats?

I probably should have rambled on a little bit there -- in summary I
was thinking of facilitating other protocols as well, such as IPX/SPX, and
who-knows-what-else gets invented in the future.

At least if a generic string type is used instead, then no assumptions
are being made which require research (and Tom already pointed out that local
Unix connections will probably be an issue with the "inet" type), thus less
work is required now to support whatever comes along in the future (or that
has been missed in this conversation).

--
Randolf Richardson - rr(at)8x(dot)ca
Vancouver, British Columbia, Canada

Please do not eMail me directly when responding
to my postings in the newsgroups.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Randolf Richardson 2003-11-29 21:14:34 Re: PostgreSQL, MySQL, etc., was Re: PostgreSQL is much
Previous Message Tom Lane 2003-11-29 20:46:26 Re: ip of the user doing an insert