Re: Feature request - Edit data and tables without a primary key

Поиск
Список
Период
Сортировка
От Thom Brown
Тема Re: Feature request - Edit data and tables without a primary key
Дата
Msg-id CAA-aLv7gHLGAU4A7Hd6=R0sPkG1+6unBqdmZGWBP-1=7m7xSKA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Feature request - Edit data and tables without a primary key  (Guillaume Lelarge <guillaume@lelarge.info>)
Ответы Re: Feature request - Edit data and tables without a primary key  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgadmin-support
On 14 July 2012 13:57, Guillaume Lelarge <guillaume@lelarge.info> wrote:
> On Thu, 2012-07-12 at 12:31 +0100, Thom Brown wrote:
>> Use of the CTID system column would work.
>
> I don't see how that could work. CTIDs obviously are unique, but anyone,
> updating a line will get another CTID for this line. If you try to
> update it afterwards, in the best case, it errors out because there is
> no line at this CTID. In the worst case, you update a completely
> different line.

Why can't you just use "RETURNING ctid" at the end of the statement to
get the new one and update the grid with that value?
-- 
Thom


В списке pgadmin-support по дате отправления:

Предыдущее
От: Guillaume Lelarge
Дата:
Сообщение: Re: pgScript error when relation name contains ")" symbol
Следующее
От: Dave Page
Дата:
Сообщение: Re: Feature request - Edit data and tables without a primary key