On Wed, Aug 10, 2011 at 02:47:25PM -0400, Geoffrey Myers wrote:
> Is max connections in any table in the database I can access?
edbstore=> \d pg_catalog.pg_settings;
View "pg_catalog.pg_settings"
Column | Type | Modifiers
------------+---------+-----------
name | text |
setting | text |
unit | text |
category | text |
short_desc | text |
extra_desc | text |
context | text |
vartype | text |
source | text |
min_val | text |
max_val | text |
enumvals | text[] |
boot_val | text |
reset_val | text |
sourcefile | text |
sourceline | integer |
View definition:
SELECT a.name, a.setting, a.unit, a.category, a.short_desc, a.extra_desc, a.context, a.vartype, a.source, a.min_val,
a.max_val,a.enumvals, a.boot_val, a.reset_val, a.sourcefile, a.sourceline
FROM pg_show_all_settings() a(name, setting, unit, category, short_desc, extra_desc, context, vartype, source,
min_val,max_val, enumvals, boot_val, reset_val, sourcefile, sourceline);
Rules:
pg_settings_n AS
ON UPDATE TO pg_settings DO INSTEAD NOTHING
pg_settings_u AS
ON UPDATE TO pg_settings
WHERE new.name = old.name DO SELECT set_config(old.name, new.setting, false) AS set_config
