Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: seiliki@xxxxxxxxxxxxx
Subject: Re: How to keep the last row of a data set?
From: Thomas Markus <t.markus@xxxxxxxxxxxxx>
Date: Thu, 13 Dec 2012 16:14:25 +0100
Cc: pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <20121213133234.56113F4816C@m5.so-net.net.tw>
Organization: proventis GmbH
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/17.0 Thunderbird/17.0

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



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to keep the last row of a data set?
  - From: seiliki

References:
- How to keep the last row of a data set?
  - From: seiliki

Prev by Date: Re: JDBC to load UTF8@psql to latin1@mysql
Next by Date: initdb error
Previous by thread: How to keep the last row of a data set?
Next by thread: Re: How to keep the last row of a data set?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux