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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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