Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't Figure Out Where Rows Are Going - Mailing list pgsql-general

From Tom Lane
Subject Re: Can't Figure Out Where Rows Are Going
Date
Msg-id 15978.1147047773@sss.pgh.pa.us
Whole thread Raw
In response to Re: Can't Figure Out Where Rows Are Going  (HH <lists@lastonepicked.com>)
List pgsql-general
Tree view 
HH <lists@lastonepicked.com> writes:
> Would it be possible to create a constraint that makes rows of a certain
> table impossible to delete?

REVOKE DELETE ON foo FROM ...

This assumes you don't run your apps as database superuser of course.

            regards, tom lane

pgsql-general by date:

Previous
From: Geoffrey
Date:
Subject: Re: Using the REPLACE command to replace all vowels
Next
From: "Jean-Yves F. Barbier"
Date:
Subject: dumb but existential question