Re: How to keep the last row of a data set?

From: Thomas Markus <t(dot)markus(at)proventis(dot)net>
To: seiliki(at)so-net(dot)net(dot)tw
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How to keep the last row of a data set?
Date: 2012-12-13 15:14:25
Message-ID: 50C9F0D1.8020905@proventis.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

create an after delete trigger with

IF (SELECT 1 FROM t1 limit 1) is null THEN
RAISE EXCEPTION 'Must keep at least 1 row';
....

hth
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Noel 2012-12-13 15:38:51 initdb error
Previous Message Emi Lu 2012-12-13 14:06:42 Re: JDBC to load UTF8@psql to latin1@mysql