Limiting Row Count In a Table??

Поиск
Список
Период
Сортировка
От Çağıl Şeker
Тема Limiting Row Count In a Table??
Дата
Msg-id 94327A2FE8C87C4C89A82DBE9E7B2B3F086870@beetle.biznet.com.tr
обсуждение исходный текст
Ответы Re: Limiting Row Count In a Table??  (Bruno Wolff III <bruno@wolff.to>)
Re: Limiting Row Count In a Table??  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

Is there a way in PG that allows limiting number of rows for a table.

If not maybe there is another way to achieve this:
I want my table to have only one row, if any other row is inserted or this one row is deleted it should give an error
andwon't let it go. 

How can this be done the right way?
Thanks...

Cagil Seker
-----------------
"Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The
Mentor'86(Hacker's Manifesto) 

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: The old "not using index" question
Следующее
От: Tom Lane
Дата:
Сообщение: Re: USAGE on schema allowed by default?