Source code test data folder don't have CSV files. How to get the CSV file.

trying to understand the source code test part. https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/copy.sql;h=d72d226f341f42c69ffcb773c4faf53d9e586894;hb=072132f04e55c1c3b0f1a582318da78de7334379 First I can just ignore all the abs_srcdir, abs_builddir. Since I can t

Re: function currtid2() in SQL and ESQL/C to get the new CTID of a row

El día Wednesday, June 01, 2022 a las 09:46:17AM -0400, Tom Lane escribió: > ... > > > Is this function currtid2() not meant to be used in ESQL/C? Or did we > > something wrong in ESQL/C? > > This is not about currtid2, this is a fundamental misunderstanding > of how ECPG works. You can only in

Re: How to use 32 bit ODBC driver

On 6/20/22 22:51, Aditya Bhardwaj wrote: Hi, For Postgres, I'd like to utilize a 32-bit ODBC driver. I attempted to download it, but it does not appear in the 32-bit ODBC Data Source. Please assist me in locating or downloading the PostgresSql 32Bit OBDC driver. You will need to provide mor

Re: How to use 32 bit ODBC driver

hi. you didn't mention, after downloading did you install it? On Tue, 21 Jun 2022, 9:11 pm Aditya Bhardwaj wrote: > Hi, > > For Postgres, I'd like to utilize a 32-bit ODBC driver. I attempted to > download it, but it does not appear in the 32-bit ODBC Data Source. Please > assist me in locating

RE: Postgresql error : PANIC: could not locate a valid checkpoint record

Could you please provide some insights in the below query. We are in need of this as it this issue is seen at some of our customer's site. Thanks, Prabhakar Internal Use - Confidential From: Mahendrakar, Prabhakar - Dell Team Sent: Monday, June 20, 2022 4:22 PM To: Mateusz Henicz Cc: pgsql-gen

How to use 32 bit ODBC driver

Hi, For Postgres, I'd like to utilize a 32-bit ODBC driver. I attempted to download it, but it does not appear in the 32-bit ODBC Data Source. Please assist me in locating or downloading the PostgresSql 32Bit OBDC driver. Regards, Aditya Bhardwaj Disclaimer: The content of this email is confiden

Re: accessing postgres from c++

a db connector that will fit everyone? i think that's timely. i have tried, once, libpqxx but i think it forces me to use the source. couldn't find a binary that will just install and use like how python works, i.e., "pip install psycopg2". On Tue, 21 Jun 2022, 3:57 pm Matthias Apitz wrote: >

Re: Postgresql error : PANIC: could not locate a valid checkpoint record

Could you also answer on questions asked by Laurenz Albe a few emails back? That could shed some light into your issue. We would know if the upgrade was performed properly and possibly point where the issue can be. Also, are you able to reproduce the issue? I.e. try restoring the database to state

Reminder: Call for Papers for PostgreSQL Conference Europe 2022 is closing soon!

PostgreSQL Conference Europe 2022 takes place in Berlin, Germany, on October 25-28. The Call for Papers is closing soon! We are accepting proposals for talks in English. Each session will last 45 minutes, and may be on any topic related to PostgreSQL. The submission deadline is June 27th. S

Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

Le 21/06/2022 à 10:28, Jagmohan Kaintura a écrit : Hi Gilles, I was going though this earlier today but didn't compiled it as I read it may not be able to capture the errors if we have below type of statement and most of our statements are of INSERT .. SELECT statements only. The form |INSE

Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

Hi Gilles, I was going though this earlier today but didn't compiled it as I read it may not be able to capture the errors if we have below type of statement and most of our statements are of INSERT .. SELECT statements only. The form INSERT INTO SELECT ... will not have the same behavior than i

Re: accessing postgres from c++

We are developing a huge Library Management System with some 400 tables and which is/was running on many UNIX derivates (SINIX, HP-UX, AIX, SunOS, Linux) and all kind of databases one can imagine (INFORMIX, Oracle, Sybase and now PostgreSQL). The system is written in C, C++ and Perl and the C/C++

Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

Le 21/06/2022 à 09:08, Jagmohan Kaintura a écrit : Hi Team, We are working on a project where we are moving from Oracle to PostgreSQL and working on a migration tool which mostly have statements for inserting the records which are correct and logging the errors in error table using ORACLE inbu

INSERT ALL with DML ERROR Logging replacement in PostgreSQL

Hi Team, We are working on a project where we are moving from Oracle to PostgreSQL and working on a migration tool which mostly have statements for inserting the records which are correct and logging the errors in error table using ORACLE inbuilt statement for INSERT ALL with DML ERROR logging. As

Re: accessing postgres from c++

On Tue, Jun 21, 2022 at 7:59 AM Laurenz Albe wrote: > I am surprised that you choose to be fettered by the constraints of a generic > API like ODBC. > For me, that only makes sense if you want to be portable to different > databases. Ditto. > I would use ... C API of libpq, or, .. C++ boilerpl