On 02/23/2017 06:08 AM, Ertan Küçükoğlu wrote:
-----Original Message-----
From: pgsql-general-owner@xxxxxxxxxxxxxx
[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Adrian Klaver
Sent: Thursday, February 23, 2017 3:55 PM
To: Ertan Küçükoğlu <ertan.kucukoglu@xxxxxxxxxxx>;
pgsql-general@xxxxxxxxxxxxxx
Subject: Re: Latest PostgreSQL on Raspbian Jessie
Hi,
Sorry about not indenting. Have to use Outlook as e-mail app.
I cannot show any work at the moment, I am just researching right now,
before I start actual job. I have a single form making connection to local
PostgreSQL and remote one. Local seems to be OK in all respects. Remote is a
problem.
Below you can see some psql output.
postgres@raspberrypi:~$ psql -d test -U postgres -p 5432 -h 192.168.1.105
Password for user postgres:
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
psql (9.4.10, server 9.6.1)
WARNING: psql major version 9.4, server major version 9.6.
Some psql features might not work.
Type "help" for help.
test=# select count(*) from sale;
DEBUG: StartTransactionCommand
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
DEBUG: CommitTransactionCommand
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR,
xid/subid/cid: 0/1/0, nestlvl: 1, children:
count
--------
176588
(1 row)
test=#
Btw, I am surprised that psql can make a connection *and* runs a query just
fine.
Yeah with the caveat:
"Some psql features might not work."
The older version of psql does not 'know' about new features in 9.6.
My main problem with my application is to run a query. Connection seems to
be OK. Trying to run a query and my application simply freeze.
So the issue is with the Postgres library that Lazarus/FreePascal is using.
What would that library be?
PgAdmin3 gives lots of error messages some objects missing, assertion
failures, etc. After all these messages PgAdmin3 seems to establish a
connection to PostgreSQL 9.6 database on Windows OS. However, PgAdmin3
cannot run a query, too. When I try to do a select, PgAdmin3 freeze. Waiting
only kills my application, or PgAdmin3. No log messages that I can find of.
Not all that surprising as pgAdmin3 is no longer supported:
https://www.pgadmin.org/download/source.php
As you found out, I don't think the last version of pgAdmin3 is
compatible with 9.6.
Thanks.
-Ertan
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
