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$ (view raw, whole thread or download thread mbox)
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...


In response to


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-2017 The PostgreSQL Global Development Group