Questions tagged [psqlodbc]

Open Database Connectivity middleware for PostgreSQL

Open Database Connectivity middleware for PostgreSQL

33 questions
0
votes
1 answer

SSIS package deployment error, with psql-ODBC driver

I have created an SSIS package to transfer data from MySQL to PostgreSQL, and it is working fine on my local system. However, when I try to deploy the package to a SQL Server and schedule a job, it fails to establish a connection with the PostgreSQL…
0
votes
0 answers

PostgreSQL ODBC - EnableBulkLoad parameter

Please, help, Does "EnableBulkLoad" parameter (maybe under a different name) exist for ODBC PostgreSQL driver? Watched ODBC driver(version 11.0) from https://www.postgresql.org/ftp/odbc/versions/src/ and can't find in docs about this…
HelOs
  • 21
  • 3
0
votes
0 answers

how to connect to postgres from sqalchemy without exposing sensitive information like password, port and host

I'm making a Flask application that is using sqlalchemy as a layer between the application and a postgres database. Currently I'm using a 'config.py' file that fetches the sensible connection info from system variables. But my IT admin says it's not…
user123442
  • 29
  • 6
0
votes
0 answers

How to disable AutoCommit in Postgresql ODBC

I'm trying to connect oracle to postgreSQL via db link. Is there any option to disable AutoCommit in Postgresql ODBC? odbc.ini looks like [PG] Description = PG Driver = /usr/lib64/psqlodbc.so ServerName = xxxxx Username = authenticator Password =…
0
votes
1 answer

How to limit update to single row

Command update invoice set unpaid = unpaid - 123 where regexp_replace(invocienumber, '-.*', '', 'g') ='12345' returning * updates all invoices whose number start with 12345. How to fix this so than only one invoice is updated and get back…
Andrus
  • 26,339
  • 60
  • 204
  • 378
0
votes
0 answers

DBLink From AIX Oracle To Postgresql

Is it possible to create a DBLink from Oracle 11G which is running on AIX 7.1 to PostgreSQL? I couldn't find postgresql-odbc for AIX. Oracle 11G - AIX 7.1 PostgreSQL 9.3.5 - Linux Thanks for advance.
0
votes
1 answer

How to fix duplicate key value violates unique constraint error in Postges 9+

Sometimes strange duplicate key error duplicate key value violates unique constraint "session_pkey" Key (workplace)=(WIN-N9BSKUNKBC8 ) already exists. Occurs in script: delete from session where workplace='WIN-N9BSKUNKBC8' ; INSERT INTO session…
Andrus
  • 26,339
  • 60
  • 204
  • 378
0
votes
1 answer

Authentication : Password passed part of connection string parameters is not considered with PostgresSql 13.1

recently we have upgraded our postgres db to version 13.1. after that we are facing strange behaviour with Connection Strings with PostgresSql 12.3 below command used to connect successfully to DB with out prompting for password **postgres=#…
0
votes
0 answers

Performance issues using psqlodbc in Excel/PowerQuery

Already asked the question here but it was falsely marked as closed. I use psqlODBC and PowerQuery to load data from a PostgreSQL (12.4) to Microsoft Excel. Recently I am having performance issues I cannot explain. Some of the functions take…
Andi
  • 124
  • 2
  • 12
0
votes
1 answer

How to optimize the execution time for this query

I have the following query: SELECT "factures"."id" FROM "factures" WHERE ( "factures"."id" NOT IN (SELECT DISTINCT( "echeances"."facture_id" ) FROM "echeances" WHERE …
Yassine
  • 193
  • 1
  • 11
0
votes
0 answers

PSQL just closes after asking for my account password

During the PSQL.exe launch I am asked for my account password. After providing the password the tool just closes with no error message or indication of what went wrong. My account has full admin privileges and regardless of if I run the tool with…
0
votes
1 answer

How to check is connection encrypted

Using old Postgres server PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit Server has symlinks server.crt and server.key in data directory /var/lib/postgresql/9.1./main and ssl=true in…
Andrus
  • 26,339
  • 60
  • 204
  • 378
0
votes
0 answers

ODBC connection pooling is not working in C# for PostGreSQL using psqlODBC driver

I have my application working on psql ODBC driver, connecting my .net code to the postgreSQL server and the connection string is as follows:
0
votes
1 answer

How to fix buffer overrun in psqlodbc driver

Visual FoxPro application calls Postgres psqlodbc driver 9.3.0400 Both are 32 bit application running in Windows 7 x64 This call causes Buffer Ovverrun exception in psqlodbc35w.dll with stack trace below. How to fix the issue ? psqlodbc is open…
Andrus
  • 26,339
  • 60
  • 204
  • 378
0
votes
2 answers

Query for PSQL determine no.of patients in system current time

select room_id,count (distinct(patient_id)) as patient_id from patient_flow where time='CURRENT_TIME'; I need the number of patients ids with corresponding room_ids at the current time. id | patient_id | room_id | …
Pari Venthan
  • 59
  • 1
  • 1
  • 8