On Sun, Dec 15, 2024 at 2:20 PM Tom Lane wrote:
> Isaac Morland writes:
> > On Sun, 15 Dec 2024 at 12:29, Tom Lane wrote:
> >> What I'd suggest as an improvement that could be implemented
> >> immediately is to wrap the checks in a user-defined function
> >> like "is_system_schema(nspname name)
On Sun, 15 Dec 2024 at 14:20, Tom Lane wrote:
> Isaac Morland writes:
> > On Sun, 15 Dec 2024 at 12:29, Tom Lane wrote:
> >> What I'd suggest as an improvement that could be implemented
> >> immediately is to wrap the checks in a user-defined function
> >> like "is_system_schema(nspname name)".
Isaac Morland writes:
> On Sun, 15 Dec 2024 at 12:29, Tom Lane wrote:
>> What I'd suggest as an improvement that could be implemented
>> immediately is to wrap the checks in a user-defined function
>> like "is_system_schema(nspname name)".
> Would it make sense to make the parameter be of type r
On Sun, Dec 15, 2024 at 12:29 PM Tom Lane wrote:
> Pavel Stehule writes:
> > ne 15. 12. 2024 v 17:59 odesílatel Ron Johnson
> > napsal:
> >> A new boolean column named "indissystem" that's true only for system
> >> relations would make *many* maintenance queries cleaner, since they'd
> >> look
Hi All,
Postgres 15.2
We have Patroni cluster with one master and two replicas. The master is
publisher (logical replication) to some subscriptions running on other
clusters. When we have a failover, the master becomes replica and one of the
replicas assume the role of master. In such a cas
On Sun, 15 Dec 2024 at 12:29, Tom Lane wrote:
> What I'd suggest as an improvement that could be implemented
> immediately is to wrap the checks in a user-defined function
> like "is_system_schema(nspname name)".
>
Would it make sense to make the parameter be of type regnamespace?
Pavel Stehule writes:
> ne 15. 12. 2024 v 17:59 odesílatel Ron Johnson
> napsal:
>> A new boolean column named "indissystem" that's true only for system
>> relations would make *many* maintenance queries cleaner, since they'd
>> look like:
>> select ...
> oid of all system objects is less then 0
Hi
ne 15. 12. 2024 v 17:59 odesílatel Ron Johnson
napsal:
> https://www.postgresql.org/docs/current/catalog-pg-namespace.html
>
> Currently, when I want to query all "userland" tables, I write something
> like:
> select ...
> from pg_class cl, pg_namespace nsp
> where cl.relnamespace = nsp.oid
>
https://www.postgresql.org/docs/current/catalog-pg-namespace.html
Currently, when I want to query all "userland" tables, I write something
like:
select ...
from pg_class cl, pg_namespace nsp
where cl.relnamespace = nsp.oid
and nsp.nspname not like 'pg_%
and nsp.nspname != 'information_schema';
