Tom Lane schrieb am 11.04.2024 um 01:02:
> Jan Behrens writes:
>> While writing a PostgreSQL client library for Lua supporting
>> Pipelining (using PQsendQueryParams), I have been wondering if there
>> are any single SQL commands that return multiple result sets.
>
> Right now, I don't think so.
Jan Behrens writes:
> While writing a PostgreSQL client library for Lua supporting
> Pipelining (using PQsendQueryParams), I have been wondering if there
> are any single SQL commands that return multiple result sets.
Right now, I don't think so. I believe the current protocol design
intends to
On Wed, Apr 10, 2024 at 4:22 PM Jan Behrens wrote:
> Hello,
>
> While writing a PostgreSQL client library for Lua supporting
> Pipelining (using PQsendQueryParams), I have been wondering if there
> are any single SQL commands that return multiple result sets. It is
> indeed possible to create suc
On 4/10/24 1:31 PM, Tom Lane wrote:
Adrian Klaver writes:
On 4/10/24 12:38, Adnan Dautovic wrote:
By the way, the row count of pg_timezone_names is 385, but I do
not know how that compares to a more standard installation.
On my instance of Postgres 16.2, 1196.
You're probably using a b
Hello,
While writing a PostgreSQL client library for Lua supporting
Pipelining (using PQsendQueryParams), I have been wondering if there
are any single SQL commands that return multiple result sets. It is
indeed possible to create such a case by using the RULE system:
db=> CREATE VIEW magic AS SE
Andreas Wagner writes:
> I consider using two instances of the PG server on one node. The node
> has two processors and each processor has 64GB memory assigned to it.
> I'd like to
> * restrict instance one to processor 0 and its memory and
> * instance two to processor 1 and its memory
> using nu
Hello everyone,
I consider using two instances of the PG server on one node. The node
has two processors and each processor has 64GB memory assigned to it.
I'd like to
* restrict instance one to processor 0 and its memory and
* instance two to processor 1 and its memory
using numactl (or similar c
Adrian Klaver writes:
> On 4/10/24 12:38, Adnan Dautovic wrote:
>> By the way, the row count of pg_timezone_names is 385, but I do
>> not know how that compares to a more standard installation.
> On my instance of Postgres 16.2, 1196.
You're probably using a build with --with-system-tzdata point
Adnan Dautovic writes:
> On 05. Apr 2024, at 16:13, Tom Lane wrote:
>> Out of curiosity, does
>> SET timezone to 'GMT';
>> work?
> Yes, it yields:
>> SET
>>
>> Query returned successfully in 84 msec.
I expected that, because the name "GMT" is hard-wired in our code.
Doesn't help for postgres_f
On 4/10/24 12:38, Adnan Dautovic wrote:
Hi,
On 05. Apr 2024, at 16:13, Tom Lane wrote:
Adnan Dautovic writes:
By the way, the row count of pg_timezone_names is 385, but I do
not know how that compares to a more standard installation.
On my instance of Postgres 16.2, 1196.
Kind regards
Dear Adrian,
On 05. Apr 2024, at 17:05, Adrian Klaver wrote:
The below is cut down from the actual output as there should be at least:
Europe/Berlin CEST 02:00:00 t
present also?
Correct! That entry also exists. I only included the snippet
where I would have expected the "UTC" entry to be
Hi,
On 05. Apr 2024, at 16:13, Tom Lane wrote:
Adnan Dautovic writes:
SELECT * FROM pg_timezone_names ORDER BY name;
"name""abbrev" "utc_offset" "is_dst"
"Turkey" "+03" "03:00:00"false
"UCT" "UCT" "00:00:00"false
"Universal" "UTC" "00:00:00"false
"W-SU"
On Wed, Apr 10, 2024 at 8:40 AM Matthias Apitz wrote:
> Maybe later I did it accidently against the 15.1 server from the psql
> history.
Yes, as shown by the timestamps from your first post:
-rw--- 1 postgres postgres 124 Mar 28 11:35
> postgresql151/data/postgresql.auto.conf
>
This is al
On 4/10/24 03:11, John Bateson wrote:
Good morning,
The end of my working life was taken up with developing and supporting a
Scientific Research establishment near Warrington in the UK. I had a
small team of programmer who did an excellent job for me and with me.
The software was Ingres and
On Wed, Apr 10, 2024 at 12:11 PM John Bateson
wrote:
> *Using Postgres and PGAdmin -4*.
>
> [...]. This is getting towards 20 tables so far.
>
> [...] i.e. the traditional .EXE file I can put on a button on the screen
> on a Windows 11 based system.
>
John,
Are you aware of SQLite or DuckDB?
Un
On Wed, 2024-04-10 at 10:26 -0400, Tom Lane wrote:
> Ian Lawrence Barwick writes:
> > 2024年4月10日(水) 21:40 Matthias Apitz :
> > > Why it does not give an error because the shared lib isn't there?
>
> > ALTER SYSTEM is a way of modifying the PostgreSQL configuration file
> > via SQL; just as when y
Ian Lawrence Barwick writes:
> 2024年4月10日(水) 21:40 Matthias Apitz :
>> Why it does not give an error because the shared lib isn't there?
> ALTER SYSTEM is a way of modifying the PostgreSQL configuration file
> via SQL; just as when you modify it manually, changes are not applied
> until you actua
Hi,
To start I had to find out what MDBS IV is, since it caught my attention
and I ended up learning a few things about the history of databases ;-).
Regarding your concern:
First you must be clear that there are many alternatives to develop
graphical interfaces to work with Postgres.
So,
2024年4月10日(水) 21:40 Matthias Apitz :
>
> El día miércoles, abril 10, 2024 a las 09:08:56 +0900, Ian Lawrence Barwick
> escribió:
>
> > > # cat postgresql151/data/postgresql.auto.conf
> > > # Do not edit this file manually!
> > > # It will be overwritten by the ALTER SYSTEM command.
> > > shared_pr
El día miércoles, abril 10, 2024 a las 09:08:56 +0900, Ian Lawrence Barwick
escribió:
> > # cat postgresql151/data/postgresql.auto.conf
> > # Do not edit this file manually!
> > # It will be overwritten by the ALTER SYSTEM command.
> > shared_preload_libraries = 'pg_tde'
> >
> > How is this possi
Hi
2024年4月10日(水) 20:10 Matthias Apitz :
(...)
> End of March I started to investigate the TDE extension pg_tde within
> the 16.2 server. And only this software contains this extension:
>
> # find /usr/local/sisis-pap/pgsql** | grep pg_tde
> /usr/local/sisis-pap/pgsql-16.2/lib/pg_tde.so
> /usr/loca
Hello,
I've a Linux development / QA server were three different PostgreSQL
cluster are setup and the corresponding (self built) PostgreSQL
software:
The software is below corresponding directories (always the full tree):
# ls -ld /usr/local/sisis-pap/pgsql-*
drwxr-xr-x 7 bin bin 4096 Mar 21 1
Good morning,
The end of my working life was taken up with developing and supporting a
Scientific Research establishment near Warrington in the UK. I had a small team
of programmer who did an excellent job for me and with me.
The software was Ingres and the main program supporting user administra
23 matches
Mail list logo
