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.
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
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
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 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
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 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
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
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
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 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
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
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
>
15 matches
Mail list logo
