Re: insert on duplicate update?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: insert on duplicate update?
Дата
Msg-id 4371EB5D.5010706@archonet.com
обсуждение исходный текст
Ответ на insert on duplicate update?  ("Peter Filipov" <pfilipov@netissat.bg>)
Ответы Re: insert on duplicate update?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Peter Filipov wrote:
> hi,
> is there in postgres anything similar to:
> insert .... on duplicate update?
> here is the problem i need a solution for:
> I need to insert in pg_type a row which was previously selected from
> there  and
> with slight modifications, the problem is that when i try to insert the row
> there might be a row with the same 'typname' which is sort of primary key.
> The second problem is that when doing those operations i don't want to
> depend
> on the specific structure of the pg_type catalog.

Are you certain it will always be safe to do this?

How will you provide meaningful values for columns you don't know exist?

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: insert on duplicate update?
Следующее
От: "mad"
Дата:
Сообщение: resetting superuser password