Re: limit table to one row

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Brandon Metcalf <brandon(at)geronimoalloys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: limit table to one row
Date: 2009-06-06 18:07:42
Message-ID: 12466.1244311662@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
> On Thu, Jun 4, 2009 at 4:13 PM, Brandon
> Metcalf<brandon(at)geronimoalloys(dot)com> wrote:
>> Is there a way when creating a table to limit it to one row? That is,
>> without using a stored procedure?

> you can also do it with a trigger.

If you're willing to use a trigger, just insert the one allowed row
and then install a trigger that throws error for any insert or delete
attempt ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2009-06-06 18:12:04 Re: limit table to one row
Previous Message Merlin Moncure 2009-06-06 18:00:27 Re: limit table to one row