Stack Overflow
Stack Overflow

Questions tagged [php-pgsql]

This is for questions related to getting the PostgreSQL client libraries and PHP extensions working with PHP

89 questions
0
votes
0 answers

docker add pdo_pgsql without docker-php-ext

I have an issue with my Dockerfile, I want to add pdo_pgsql in my docker but when I add it (as you can see below commented) routes in my project doesnt work, I have a 404 for every routes, without the pdo_pgsql part everything works fine. Here is…
Kenyuki
  • 65
  • 1
  • 7
0
votes
0 answers

php postgres misinterpretation

The php code is bellow. $cc='create table mydataI(net) as VALUES (-20.12::double precision)'; $db->query($cc) or die('


pos02:'.$db->lasterror.'
'.nl2br($cc)); The error is as follows: pos02:ERROR: 42601: syntax error at or near…
George Kourtis
  • 2,381
  • 3
  • 18
  • 28
0
votes
0 answers

On centOS is Impossible to access to phpPgAdmin due to pgsql not found

CWP Pro version 7 PHP 7.4 PHP built with modules pdo_pgsql and pgsql PostgreSQL version 9.2.24 PostgreSQL started from the CWP, the database created and user linked. but trying to access to link https://93.188.164.66:2031/phpPgAdmin/ (from CWP menu)…
SWeC
  • 165
  • 2
  • 15
0
votes
0 answers

PHP : How to change OCI(oracle) upload file to postgresql?

I need help regarding migrating my OCI upload file to postgresql file. I've tried multiple ways from Youtube. I am new to pgsql and really in a pinch right now. Need help. Thank you!. Here is the code: $file = basename($_SERVER['PHP_SELF']); //get…
Syahmie
  • 9
  • 1
0
votes
0 answers

Dolibarr Projects Module: DB_ERROR_42803

Long story Short: I launched an EC2 instance on AWS to run Dolibarr v13, running PostgreSQL 12.4 on RDS, and Dolibarr itself on Ubuntu 20.04 LTS. All DIY, not Bitnami’s AMI. Once I started setting up modules on the web app's console, I got…
AMusketeer
  • 1
  • 1
0
votes
0 answers

PHP Fatal error: Call to undefined function pg_pconnect()

I'm running CentOS and have Apache, PHP and php-pgsql installed. Running my PHP script with: php my-script.php Works. But when calling it via Apache I'm getting the error in the httpd log: PHP Fatal error: Call to undefined function…
Alfred Balle
  • 1,135
  • 4
  • 16
  • 32
0
votes
0 answers

Different postgrese behavior in similar databases

I use PHP 7.1 with Pgsql 9.2.24. Have two similar copy of project (production and development) and two similar databases with the same data on it. But queries work differently in GROUP BY case. I tried to check all the sql settings with SHOW ALL…
Valik Tralik
  • 69
  • 1
  • 12
0
votes
1 answer

How to get as much inputs as line displayed in html?

I want to open a pop up window with a form that contains inputs when I click a button. I don't have problem to do that, the particularity is I want as much inputs (in the form of the pop up) as cells of a row from my orginal window. Basically I have…
LyessD
  • 201
  • 1
  • 3
  • 13
0
votes
1 answer

How to set a button at the beginning of each line of my table?

I try to have a button at the beginning of each line. I will use this button to open a line on a pop up windows. I know it is not hard to do but somehow I am struggling to place the button at the beginning of a line. To give you the context of my…
LyessD
  • 201
  • 1
  • 3
  • 13
0
votes
0 answers

How to add the pdo_pgsql extension to php7.1 on MacOs Sierra

I'm running macOS Sierra (10.12.6) and php7.1 and for way to long I have been trying to figure out how to read a php file that contains the PDO::FETCH_ASSOC. I'm getting an error which I (think) is related to not having php configured correctly with…
agh
  • 107
  • 1
  • 12
0
votes
1 answer

How to resolve "could not write block of temporary file: No space left on device" in postgresql?

I have local database in postgres. In which single table contains data of "74980435". When I have tried to execute SELECT query it is throwing this error: "could not write block 657567 of temporary file: No space left on device". I am trying to…
Jimesh Gajera
  • 612
  • 1
  • 11
  • 32
0
votes
1 answer

How to send HTTP request with PHP to connect PostgreSQL db using Jaxon?

I'm trying to connect to a PostgreSQL database when I click on a button and display a message to notify success or fail connection. It's my first time doing such operation in web interface and using Jaxon (PHP lib to do AJAX, fork of…
LyessD
  • 201
  • 1
  • 3
  • 13
0
votes
1 answer

phppgAdmin has more than 1 Error - also Error Loading servers.php

I am trying to learn PostgreSQL and so installed it and phppgAdmin on my laptop. I went to localhost/phppgadmin, logged in and I get all these errors on the front page: I tried going troubleshooting on Google, but unfortunately there are not enough…
user9581798
0
votes
1 answer

How to uninstall php-pgsql on AWS EC2

I got a problem when uninstall php-pgsql. it can't be remove. [root@ip-172-31-31-52 /]# yum list php-pgsql\* Loaded plugins: priorities, update-motd, upgrade-helper Available Packages php-pgsql.x86_64 5.3.29-1.8.amzn1 …
Intan Iryanti
  • 5
  • 5
0
votes
1 answer

Db connection not being closed

I've just opened submitted a bug relating to postgres database connections not been closed/cleaned by the garbage collector in any php 7.X version for the below scenario, I was hoping if someone could provide some insight on why such a behavior &…
Akash
  • 4,956
  • 11
  • 42
  • 70
1 2 3
4
5 6