Tim Penhey wrote on 30.08.2004 23:12:
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.
You could try:
id INT PRIMARY KEY NOT NULL DEFAULT(1) CHECK (id = 1),
I like that approach :)
But should you also prevent DELETE's from that table? Otherwise you could wind up with no rows at all. I guess that would have to be done using a rule...
Thomas
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match