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

Re: Single Row Table?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Single Row Table?
Date: 2004-08-31 20:35:37
Message-ID: ch2nep$3rj$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-general
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


In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-31 20:41:40
Subject: Re: zombie primary key lurches out of database to devour the brains of the unwary
Previous:From: Doug McNaughtDate: 2004-08-31 20:24:01
Subject: Re: Change config of running PGSQL

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