On 1/9/24 09:38, Yi Sun wrote:
Hello,
We custom set variable
Added patroni.nodes_count = 2 in postgresql.conf
postgres=# show patroni.nodes_count;
patroni.nodes_count
-
2
(1 row)
postgres=# select current_setting('patroni.nodes_count');
current_setting
I have the following query:
SELECT *
FROM polygons
WHERE zoomlevel <= {zoom} AND st_intersects(way,{tileboundary})
For any given tile according to the openstreetmap tiles.
So zoomlevel is from 0..14 and the number of polygons in each level is roughly
exponential.
Postgres doc (https://www.postgre
Hi,
I have a table with bytea column and trying to load the data using copy
command. But Copy command is failing with "ERROR: invalid byte sequence
for encoding UTF8: 0x00. Why postgresql is failing to load when data
contains 0x00. How to resolve this error ? any workaround to load the data
with
On Tue, Jan 9, 2024 at 3:38 PM Yi Sun wrote:
>
> Hello,
>
>
>
> But can not select it from pg_settings, as we use pgwatch2 to monitor, to
> avoid pgwatch2 script change prefer to use pg_setting not current_setting()
> function, is it possible to get the custom variable from pg_setting please?
>
On Tue, 2024-01-09 at 17:48 +0530, Kiran K V wrote:
> I have a table with bytea column and trying to load the data using copy
> command.
> But Copy command is failing with
> "ERROR: invalid byte sequence for encoding UTF8: 0x00.
> Why postgresql is failing to load when data contains 0x00.
> How to
Laurenz Albe writes:
> On Tue, 2024-01-09 at 17:48 +0530, Kiran K V wrote:
>> I have a table with bytea column and trying to load the data using copy
>> command.
>> But Copy command is failing with
>> "ERROR: invalid byte sequence for encoding UTF8: 0x00.
>> Why postgresql is failing to load when
On 1/9/24 03:33, Innocent Ememe wrote:
Reply to list also.
Ccing list.
Hello
Thank you for your email, I’m getting the software from the official
PostgreSQL.org website. I used to download command to install, my issues
If you mean here:
https://www.enterprisedb.com/downloads/postgres-postg
