Обсуждение: Query the catalog

Поиск
Список
Период
Сортировка

Query the catalog

От
"Ottó Havasvölgyi"
Дата:
Hi,

How can I query the following information from the catalog:
 - max number of index columns;
 - max number of function arguments;

As far as I know these are compile-time constants, default is 32.

Thanks,
Otto

Fwd: Query the catalog

От
"Sibte Abbas"
Дата:


---------- Forwarded message ----------
From: Sibte Abbas <sibtay@gmail.com>
Date: Aug 31, 2007 8:32 AM
Subject: Re: [GENERAL] Query the catalog
To: Ottó Havasvölgyi <havasvolgyi.otto@gmail.com>

On 8/31/07, Ottó Havasvölgyi <havasvolgyi.otto@gmail.com> wrote:
Hi,

How can I query the following information from the catalog:

You can find guc variables for both of these compile time constants:
 

- max number of index columns;

show  max_index_keys;

- max number of function arguments;

show max_function_args;
 

As far as I know these are compile-time constants, default is 32.

Thanks,
Otto


regards,
-- Sibte