postgres

postgres copied to clipboard

#53 - cancel query before close connection

2

https://github.com/amphp/postgres/issues/53

oleg1540

Closing connection during a long running query blocks the loop

1

If we have a long running query and try to close connection while it is executing, loop will be blocked. Script: ```php

oleg1540

fix(transaction): transaction is never released

4

Given the following example: ```php $config = Postgres\ConnectionConfig::fromString('host=127.0.0.1 port=32770 user=main password=main'); $link = Postgres\connect($config); $trans = $link->beginTransaction(); $trans->query('DROP TABLE IF EXISTS test_users'); $trans->query('CREATE TABLE IF NOT EXISTS test_users ( id...

azjezz

rfc: better transaction disposing mechanism

6

while working on #50, i noticed a weird behavior within the library. a query cannot be executed ( on the same connection ), unless all handles related to a specific...

azjezz

given the following code: ```php

azjezz

Amp\Loop\InvalidWatcherError : Cannot reference an invalid watcher identifier: 'e'

3

I try use PHPUnit with Postgres adapter. But I catch error. `amphp/postgres v1.4.3` Example code: ```php

PNixx

Cannot set connection to nonblocking mode

6

I see a same error on v1.3.3. I set a pool 10 connection and receive error after 1-2 minutes: ``` pg_connection_busy(): Cannot set connection to nonblocking mode, /project/vendor/amphp/postgres/src/PgSqlHandle.php:109 ``` When...

PNixx

Transactions won't work if \pg_get_result returns multiple results

9

Code to reproduce: ```php use Amp\Postgres; Amp\Loop::run(function () { $config = Postgres\ConnectionConfig::fromString('host=localhost user=postgres'); $pool = Postgres\pool($config); yield $pool->query('DROP TABLE IF EXISTS test'); yield $pool->query('DROP TABLE IF EXISTS test2'); /** @var...

roquie

Set default time zone for pool

1

Sql query: `SET TIMEZONE TO 'UTC'` not working, I receiving time in my local TZ `2021-03-22 14:57:49.834961+03`. But it work with connect `psql`: ``` # select now(); now ------------------------------- 2021-03-22...

PNixx

danog