Re: Constraint: string length must be 32 chars

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Constraint: string length must be 32 chars
Date: 2010-10-17 16:42:54
Message-ID: 4CBB278E.5020502@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Farber wrote:
> Hello, really good advices here! But -
>
> On Sun, Oct 17, 2010 at 2:37 AM, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>> I just read the "anonymously" part, so I take it you have ruled out
>> recording the given coordinate components directly, in multiple columns
>> presumably? Otherwise it seems you could then do a) a composite key and b)
>> queries directly against coordinate values.
>>
>
> what do you mean here? Do you suggest using line segments
> instead of points in my records or something else?
>
> Regards
> Alex
>
>

Sorry Alexander, I have to confess here and now that I'm not familiar
with GPS data. My presumption was that it was represented as something
like latitude, longitude (,alitutde?, others?), and that while those
would surely hash nicely with md5 I thought you would be loosing the
inherent information of the position.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Iliffe 2010-10-17 18:53:44 Re: Automated Database Backups
Previous Message Tom Lane 2010-10-17 14:33:38 Re: Constraint: string length must be 32 chars