Re: "no unpinned buffers available" ? why? (hstore and

From: Richard Huxton <dev(at)archonet(dot)com>
To: hubert depesz lubaczewski <depesz(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: "no unpinned buffers available" ? why? (hstore and
Date: 2007-01-03 17:19:29
Message-ID: 459BE5A1.2010808@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hubert depesz lubaczewski wrote:
> On 1/3/07, Richard Huxton <dev(at)archonet(dot)com> wrote:
>>
>> If you do that separately at the start of the process, (one query per
>> custom column in the old table) then it becomes straightforward.
>>
>
> no, because meaning of "col1" in advert_custom_fields is different for each
> record.
> for one record it's codename might be "email" for another record it
> might be
> "engine size".
And is that not what's stored in "v_category_custom_fields"? So you can
do the transformation and get (advert_id=1, codename='col1',
value='vvv') then use v_category_custom_fields to update the 'col1' part.

--
Richard Huxton
Archonet Ltd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Enrico 2007-01-03 17:27:09 Re: Index Scanning
Previous Message novnov 2007-01-03 17:10:54 Re: Generic timestamp function for updates where field