On Sat, Jun 6, 2009 at 2:07 PM, Tom Lane<tgl@sss.pgh.pa.us> wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
>> On Thu, Jun 4, 2009 at 4:13 PM, Brandon
>> Metcalf<brandon@geronimoalloys.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 ...
what if you need to delete then insert? :-)
merlin