Re: My question about the transaction

2023-10-19 Thread David G. Johnston
On Thursday, October 19, 2023, Juan Rodrigo Alejandro Burgos Mella < rodrigoburgosme...@gmail.com> wrote: > By default, psql is configured with autocommit on. > Use another administrator, like phpadmin, and configure the > connection with autocommit off. > No. Please leave autocommit on and incor

Re: My question about the transaction

2023-10-19 Thread Juan Rodrigo Alejandro Burgos Mella
By default, psql is configured with autocommit on. Use another administrator, like phpadmin, and configure the connection with autocommit off. Atte JRBM El jue, 19 oct 2023 a las 11:49, Wen Yi () escribió: > Hi community, > I am learning the transaction of the postgresql, and I try to test using

Re: My question about the transaction

2023-10-19 Thread Adrian Klaver
On 10/19/23 04:36, Wen Yi wrote: Hi community, I am learning the transaction of the postgresql, and I try to test using these: ## terminal 1: postgres=# select * from t;  number   1 (1 row) postgres=# update t set number = 2; UPDATE 1 postgres=# select * from t;  number

Re: My question about the transaction

2023-10-19 Thread David G. Johnston
On Thursday, October 19, 2023, Wen Yi wrote: > Hi community, > I am learning the transaction of the postgresql, and I try to test using > these: > You failed to show how the two sessions interleave. Also, your first session doesn’t use multi-statement transactions. postgres=# insert into t val

My question about the transaction

2023-10-19 Thread Wen Yi
Hi community, I am learning the transaction of the postgresql, and I try to test using these: ## terminal 1: postgres=# select * from t;  number   1 (1 row) postgres=# update t set number = 2; UPDATE 1 postgres=# select * from t;  number   2 (1 row) postgre

Re: Driver Postgresql HP-Unix

2023-10-19 Thread Ron
On 10/18/23 13:45, Abelardo Erazo Lopez wrote: Hi, Everyone I have an Oracle database Oracle 19c and I need to access a PostgreSQL database 15.4  that resides on a different server. I see that one alternative is to use ODBC from Oracle. However, the server where the database resides is an HP

Re: Build fails on RHEL 8.8 about libxml2 version

2023-10-19 Thread Sebastien Flaesch
Answering to myself: Of course I must install the "*-devel" packages Seb From: Sebastien Flaesch Sent: Thursday, October 19, 2023 10:36 AM To: pgsql-general@lists.postgresql.org Subject: Build fails on RHEL 8.8 about libxml2 version EXTERNAL: Do not click link

Re: How can I accurately infer the output of a SELECT statement FROM a table with floating-point data type?

2023-10-19 Thread Tomek
Hi, May be you think about this ? SELECT REAL_COLUMN, *to_char(REAL_COLUMN,'9.9') 6_significant_numbers_format *FROM TEST; Regards Tomek czw., 19 paź 2023 o 05:47 毛毛 napisał(a): > Hi, > > Do we have a rule by follow which one can accurately info the output of a > SELECT statment FROM

Build fails on RHEL 8.8 about libxml2 version

2023-10-19 Thread Sebastien Flaesch
Hello, Trying to build PostgreSQL 15 and 16 on RHEL 8.8: [comp@havok postgresql-15.1]$ cat /etc/redhat-release Red Hat Enterprise Linux release 8.8 (Ootpa) [comp@havok postgresql-15.1]$ uname -a Linux havok.strasbourg.4js.com 4.18.0-477.27.1.el8_8.x86_64 #1 SMP Thu Aug 31 10:29:22 EDT 2023 x86_

Driver Postgresql HP-Unix

2023-10-19 Thread Abelardo Erazo Lopez
Hi, Everyone I have an Oracle database Oracle 19c and I need to access a PostgreSQL database 15.4 that resides on a different server. I see that one alternative is to use ODBC from Oracle. However, the server where the database resides is an HP-UX server and I understand that I need a PostgreS