Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL

2021-12-23 Thread Pavel Stehule
> > Thank you very much indeed for this careful reply, Pavel—and for the links > to the threads on the Hackers list. A great deal is now clarified for me. > You said “I am not native speaker, and my English is very poor”. You’re > far, far, too modest. I am a native English speaker. And I often see

Re: Packages, inner subprograms, and parameterizable anonymous blocks for PL/pgSQL

2021-12-23 Thread Bryn Llewellyn
> pavel.steh...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> Yes, I did read your “schema variables” post on your site “Pavel Stehule’s >> blog — Some notes about PostgreSQL”. It gives me a very good idea about what >> you have in mind. >> >> But as I’ve come to understand the term “Fu

Re: storing zipped SQLite inside PG ?

2021-12-23 Thread Дмитрий Иванов
Or, if you want to extend this theme, you can use a PostgreSQL-based "SQLite file player" with PostgreSQL + Python[sqlite3] extension.This way you can provide direct access to SQLite files without duplicating data in PostgreSQL cluster tables. PS: It may seem that this will reduce performance. When

Re: How to confirm the pg_hba.conf service is correctly working

2021-12-23 Thread Vijaykumar Jain
On Thu, 23 Dec 2021 at 15:45, shing dong wrote: > I have tested this feature , only had >> > > host VJ VJ_USER 10.10.10.1/32 md5 > > in the pg_hba.conf file > I may be a bit off , but can you try a couple of things, other than a fresh install, incase you have time to debug more. is it

Re: How to confirm the pg_hba.conf service is correctly working

2021-12-23 Thread Imre Samu
> Have checked select * from pg_hba_file_rules results are consistent with pg_hba.conf > any ip and user still can login in db Any proxy? port/ip - forwarding running in the background? in the next time check the "client_addr". - SELECT usename, client_addr FROM pg_stat_activity where client_ad

Re: How to confirm the pg_hba.conf service is correctly working

2021-12-23 Thread shing dong
> > Your original post stated that you only had > host VJ VJ_USER 10.10.10.1/32 md5 > in the pg_hba.conf file. > However the result of the select is considerably more ? DEAR I have tested this feature , only had host VJ VJ_USER 10.10.10.1/32 md5 in the pg_hba.conf file Have ch