Skip site navigation (1) Skip section navigation (2)

Re: Single Row Table?

From: Mike Nolan <nolan(at)gw(dot)tssi(dot)com>
To: jeff_eckermann(at)yahoo(dot)com (Jeff Eckermann)
Cc: smarlowe(at)qwest(dot)net (Scott Marlowe),bruno(at)wolff(dot)to (Bruno Wolff III),yjoshi(at)starentnetworks(dot)com (Yateen Joshi),pgsql-general(at)postgresql(dot)org
Subject: Re: Single Row Table?
Date: 2004-08-31 15:47:46
Message-ID: 200408311547.i7VFlkxK012921@gw.tssi.com (view raw or flat)
Thread:
Lists: pgsql-general
> ISTM most natural to do this with a rule, e.g.:
> 
> CREATE RULE my_insert_rule AS ON INSERT TO my_table DO
> INSTEAD NOTHING;
> 
> Which will cause all inserts to be silently dropped. 

This strikes me as bad programming practice.  Errors should be reported, 
not silently ignored.  If the application is doing an insert when it doesn't
need to, then the application is flawed as well.
--
Mike Nolan

In response to

pgsql-general by date

Next:From: Elie NacacheDate: 2004-08-31 15:54:07
Subject: Re: Hebrew support -- please help !
Previous:From: Doug McNaughtDate: 2004-08-31 15:38:35
Subject: Re: Change config of running PGSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group