Single Row Table?

Поиск
Список
Период
Сортировка
От Yateen Joshi
Тема Single Row Table?
Дата
Msg-id FF851C7EEB75954F9BCFB5CA117AB1EC0104F251@delta.nulinkinc.com
обсуждение исходный текст
Ответы Re: Single Row Table?  (Bruno Wolff III <bruno@wolff.to>)
Re: Single Row Table?  (Tim Penhey <tim@penhey.net>)
Список pgsql-general

Hi,

 

I have got a table which is supposed to contain only one row. It does not have any primary keys defined.

So, essentially, when a new insert happens in that table, I would like it (the insert) to fail if there is already a row existing in that table.

How can I do that? Can I add any constraints? Or do I need to write a separate trigger for the same?

 

Thanks and regards,

 

Yateen V. Joshi

 

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

Предыдущее
От: "Doug Bloebaum"
Дата:
Сообщение: Equivalent to Oracle's inline CURSOR in a SELECT clause?
Следующее
От: Bruno Baguette
Дата:
Сообщение: Primary key inheritance problem