From: | "Scott Marlowe" <smarlowe(at)qwest(dot)net> |
---|---|
To: | "Bruno Wolff III" <bruno(at)wolff(dot)to> |
Cc: | "Yateen Joshi" <yjoshi(at)starentnetworks(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Single Row Table? |
Date: | 2004-08-29 21:38:45 |
Message-ID: | 1093815524.5493.31.camel@localhost.localdomain |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, 2004-08-29 at 15:30, Bruno Wolff III wrote:
> On Fri, Aug 27, 2004 at 13:32:07 +0530,
> Yateen Joshi <yjoshi(at)starentnetworks(dot)com> wrote:
> > 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?
>
> A simple way to force this is to add a primary key and a constraint
> that forces the primary key to be a particular value.
Is it reasonable / possible to add a check constraint something like
select count(*) from table <=1?
From | Date | Subject | |
---|---|---|---|
Next Message | Chris | 2004-08-29 21:42:37 | Re: malformed array literal in 8beta1 |
Previous Message | Chris | 2004-08-29 21:35:13 | malformed array literal in 8beta1 |