|
Home > Archive > PostgreSQL Discussion > December 2005 > how to add a new column to system table
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
how to add a new column to system table
|
|
|
| I wanted to add a new column to system table(pg_database),b
ut failed at last. Who know how to do this and can you tell me ? | |
| Bruce Momjian 2005-12-29, 11:23 am |
| xiapw wrote:
> I wanted to add a new column to system table(pg_database),b
ut failed
> at last. Who know how to do this and can you tell me ?
It is pretty complicated. I would pick an existing column in the table
and find all references to that in the backend, then adjust other values
to match. Actually adding a column to a system table is quite complex
and you might be better off creating a new table that refernces
pg_database and linking to it.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
| |
| Qingqing Zhou 2005-12-29, 1:23 pm |
|
""xiapw"" <xiapw@lreis.ac.cn> wrote in message
news:000e01c60c57$52
c5f170$4503a8c0@stin
g...
>I wanted to add a new column to system table(pg_database),b
ut failed at
>last. Who know how to do this and can you tell me ?
A recent change to pg_database (adding a new column) happened on
--
Sun Jul 31 17:19:21 2005 UTC (4 months, 4 weeks ago) by tgl
Log Message:
-----------
Add per-user and per-database connection limit options.
This patch also includes preliminary update of pg_dumpall for roles.
Petr Jelinek, with review by Bruce Momjian and Tom Lane.
--
Try to find out related changes on pgsql.committers.
Regards,
Qingqing
|
|
|
|
|