On Fri, 2025-04-18 at 05:49 +, sivapostg...@yahoo.com wrote:
> We use PowerBuilder along with PostgreSQL.
>
> PostgreSQL 15.7 (Ubuntu 15.7-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled
> by gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit
>
> Suddenly, one system starts throwing an error while
Adrian Klaver to Anton Shepelev:
> The below does not look like a Postgres message to me.
>
> > You need to install postgresql-server-dev-NN for
> > building a server-side extension or libpq-dev for
> > building a client-side application.
Yet that is what we get for `pg_config --version' on the
a
Daniel Gustafsson:
> Also, is this by any chance a managed instance like Amazon
> RDS or Azure, or is it a local database under your
> control?
It is a normal installation on a Linux machine, and my
company has full root access to it over SSH. Because of
strict security measures, however, only a
Hello,
We use PowerBuilder along with PostgreSQL.
PostgreSQL 15.7 (Ubuntu 15.7-1.pgdg24.04+1) on x86_64-pc-linux-gnu, compiled by
gcc (Ubuntu 13.2.0-23ubuntu4) 13.2.0, 64-bit
Suddenly, one system starts throwing an error while updating a record from
PowerBuilder. The same update statement (wind
On 4/17/25 14:23, Anton Shepelev wrote:
Adrian Klaver to Anton Shepelev:
db=# show shared_preload_libraries;
shared_preload_libraries
---
online_analyze, plantuner
Are you running PostgresPro?
Both those modules are associated with it:
https://postg
On 4/17/25 07:05, Anton Shepelev wrote:
Tom Lane to Anton Shepelev:
I have a Postgres sever with the 'track_counts' setting
stuck in 'off'. [...]
I am fairly certain that there is nothing in core Postgres
that would do that. PGC_S_OVERRIDE is used to lock down
the values of certain variable
On 4/17/25 07:23, Tom Lane wrote:
Anton Shepelev writes:
What extensions do you have installed?
Nothing much:
db=# show shared_preload_libraries;
shared_preload_libraries
---
online_analyze, plantuner
Never heard of either of those, but just from th
Anton Shepelev writes:
>> What extensions do you have installed?
> Nothing much:
> db=# show shared_preload_libraries;
>shared_preload_libraries
> ---
>online_analyze, plantuner
Never heard of either of those, but just from the names, they sound
like they mig
Laurenz Albe writes:
> On Thu, 2025-04-17 at 05:17 +, 王 博 wrote:
>> 1. In PostgreSQL 15 and later:
>> The following SQL causes a syntax error unless a space is added after the
>> `?`:
>> SELECT * FROM table WHERE a = ?AND b = 123;
>> → Adding a space (`? AND`) resolves the issue.
Tom Lane to Anton Shepelev:
> > I have a Postgres sever with the 'track_counts' setting
> > stuck in 'off'. [...]
>
> I am fairly certain that there is nothing in core Postgres
> that would do that. PGC_S_OVERRIDE is used to lock down
> the values of certain variables that shouldn't be allowed
>
On Thu, 2025-04-17 at 05:17 +, 王 博 wrote:
> We have encountered unexpected SQL parsing errors during application upgrades
> from
> PostgreSQL 14 to 15 and 16, related to the use of JDBC-style parameter
> placeholders (`?`) in our legacy applications.
>
> Specifically:
>
> 1. In PostgreSQL
On Thu, Apr 17, 2025 at 5:13 AM Anton Shepelev wrote:
> Daniel Gustafsson:
>
> > Also, is this by any chance a managed instance like Amazon
> > RDS or Azure, or is it a local database under your
> > control?
>
> It is a normal installation on a Linux machine, and my
> company has full root access
On Thu, Apr 17, 2025 at 11:13 AM 王 博 wrote:
> Hello PostgreSQL Community,
> We have encountered unexpected SQL parsing errors during application upgrades
> from PostgreSQL 14 to 15 and 16, related to the use of JDBC-style parameter
> placeholders (`?`) in our legacy applications.
AFAIK, Postgre
Hello PostgreSQL Community,
We have encountered unexpected SQL parsing errors during application upgrades
from PostgreSQL 14 to 15 and 16, related to the use of JDBC-style parameter
placeholders (`?`) in our legacy applications.
Specifically:
1. In PostgreSQL 15 and later:
The following SQL
Adrian Klaver:
> Anton Shepelev:
>
> > have a Postgres sever with the 'track_counts'
> > setting stuck in 'off'.
> > [...]
> > name| track_counts
> > setting | on
> > source | override
>
> This shows a setting of 'on' not the 'off' you mention in
> the first paragraph.
I beg pardon. Having n
15 matches
Mail list logo
