Re: UUID's as primary keys

From: Thomas Hallgren <thomas(at)tada(dot)se>
To: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Psql_General <pgsql-general(at)postgresql(dot)org>
Subject: Re: UUID's as primary keys
Date: 2006-06-28 11:56:47
Message-ID: 44A26E7F.7050001@tada.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Martijn van Oosterhout wrote:
> On Wed, Jun 28, 2006 at 12:03:40PM +0200, Thomas Hallgren wrote:
>
>> OK. I thought you always had a type descriptor handy when reading the
>> binary representation. I've noticed that the typmod is expected in some
>> receive functions (bpcharrecv and numeric_recv for instance). Are you
>> saying that there are times when you don't use that?
>>
>
> The input functions get it, the output functions (bpcharout,
> bpcharsend, etc) don't. Which makes it kind of hard to print a raw
> value if you don't know how long it's going to be. They used to, but
> that was removed some time back. It's a security issue IIRC, since any
> user could call raw_out(field, 2048) and get whatever was in the 2K of
> data after that field.
>
>
A user that is trusted with installing a C-function in the backend is
free to scan the process memory anyway so in what way did that increase
the security? IMHO, the only relevant security in that context is to
have trusted people install trusted modules. I'm surprised that
something like that made you remove significant functionality.

Regards,
Thomas Hallgren

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message surabhi.ahuja 2006-06-28 12:50:07 error while installing the 8.1.4 rpms on my m/c
Previous Message zhicheng wang 2006-06-28 11:06:23 invalid primary checkpoint record

Browse pgsql-hackers by date

  From Date Subject
Next Message Tzahi Fadida 2006-06-28 12:25:57 Help with casting and comparing.
Previous Message Martijn van Oosterhout 2006-06-28 10:53:10 Re: UUID's as primary keys