Re: DELETE FROM pg_class

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Dawid Kuroczko <qnex42(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: DELETE FROM pg_class
Date: 2007-09-24 13:51:31
Message-ID: 1190641891.4181.179.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2007-09-24 at 14:44 +0200, Dawid Kuroczko wrote:

> Hello, I see that I can modify system tables even though I have
> not set allow_system_table_mods... Is this a feature or a bug?

allow_system_table_mods allows you to modify the structure, not just the
data, i.e. add additional columns to system tables.

Superusers have the capability to modify data in catalog tables and many
other things besides, normal users don't.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Simon Riggs 2007-09-24 13:53:14 Re: Transaction Steps!!
Previous Message Rodrigo De Le� 2007-09-24 13:21:49 Re: Transaction Steps!!