Postgres Pro
Downloads
Home   >   mailing lists

Re: Single Row Table? - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Single Row Table?
Date
Msg-id ch2nep$3rj$1@sea.gmane.org
Whole thread Raw
In response to Re: Single Row Table?  (Mike Nolan <nolan@gw.tssi.com>)
Responses Re: Single Row Table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Single Row Table?  (Mike Nolan <nolan@gw.tssi.com>)
List pgsql-general
Tree view 
Mike Nolan wrote on 31.08.2004 21:46:

>>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...
>
>
> Why not just revoke the delete privilege?


That was one of my first guesses as well, but then I'm not sure if you can
revoke DELETE and INSERT privilege from the owner of the table...

Thomas

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Change config of running PGSQL
Next
From: Tom Lane
Date:
Subject: Re: zombie primary key lurches out of database to devour the brains of the unwary