From: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Clarify "allow_system_table_mods" |
Date: | 2016-04-25 16:30:07 |
Message-ID: | CANu8Fiy0P-i-0EAbugvZwiobNCg2uM=B7=y_d48W-Ttqec5fgQ@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I need clarification on allow_system_table_mods parameter
Per the documentation:
*Allows modification of the structure of system tables.* This is used by
initdb. This parameter can only be set at server start.
However, attempting to modify pg_class to add another column fails with
"STATUS_ACCESS_VIOLATION" as below.
So either only certain system catalogs may be changed, or only certain
types of structure changes are allowed.
eg: add indexes, triggers
Windows 10
PostgreSQL 9.2.15, compiled by Visual C++ build 1600, 32-bit
Current user is postgres
allow_system_table_mods = on
ALTER TABLE pg_catalog.pg_class ADD COLUMN relcreated timestamp DEFAULT
current_timestamp;
Fails with:
2016-04-25 12:08:00 EDT STATEMENT: ALTER TABLE pg_catalog.pgclass ADD
COLUMN relcreated timestamp DEFAULT current_timestamp;
2016-04-25 12:08:14 EDT LOG: server process (PID 7760) was terminated by
exception 0xC0000005
2016-04-25 12:08:14 EDT DETAIL: Failed process was running: ALTER TABLE
pg_catalog.pg_class ADD COLUMN relcreated timestamp DEFAULT
current_timestamp;
2016-04-25 12:08:14 EDT HINT: See C include file "ntstatus.h" for a
description of the hexadecimal value.
2016-04-25 12:08:14 EDT LOG: terminating any other active server processes
From ntstatus.h
*#define STATUS_ACCESS_VIOLATION ((NTSTATUS)0xC0000005L) //
winnt*
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
From | Date | Subject | |
---|---|---|---|
Next Message | Begin Daniel | 2016-04-25 17:10:39 | Re: Calculating Minkowski distance between two rows |
Previous Message | Tom Lane | 2016-04-25 15:08:47 | Re: Intemittendly get "server process (PID 5884) exited with exit code 3" |