[pgadmin-support] pgadmin4 on windows 10 64 bits

2016-10-13 Thread Alejandra Pazos Freire
I installed the pgadmin4 on windows 10 to connect a server 9.6 on Linux
RHEL.
When the pgadmin starts. it doesn't display the screens, only some text...
like this:

[image: Imágenes integradas 1]

In other notebook with windows 10 (but 32 bits), the startup was
succesfully...
Any idea about the problem ?

TIA, Alejandra.



*   Lic. Alejandra Pazos Freire*

*Esp. en Gestión de Tecnología e Innovación*
 ITM Argentina
 Gestión de Tecnología Informática
 www.itm-ar.com.ar
TE: 15-3100-6500


[pgadmin-support] pgr_createTopology creates bad topology

2016-10-13 Thread Ferjo
Hi,

I want to calculate the shortest way between two points using pgr_dijkstra
function. When I excecute that function, it doesn't show anything. Only when
two points are just in front of each other, pgr_dijkstra shows the way it is
between them. Just in this last case, pgr_dijkstra works fine. But when the
calculation is more complex, pgr_dijkstra does nothing.

I made a lot of tries and I am sure that pgr_createTopology doesn't work as
it should. Maybe my table needs more fields to get its topology done well,
but I don´t know what.

An explanation about what fields are needed for pgr_createTopology would be
helpful too.

I attach two screenshots: how it built the table's topology and its fields
composition.

Thank you very much!

 

 



--
View this message in context: 
http://postgresql.nabble.com/pgr-createTopology-creates-bad-topology-tp5925751.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


[pgadmin-support] pgr_createTopology creates bad topology

2016-10-13 Thread Ferjo
Hi,

I want to calculate the shortest way between two points using pgr_dijkstra
function. When I excecute that function, it doesn't show anything. Only when
two points are just in front of each other, pgr_dijkstra shows the way it is
between them. Just in this last case, pgr_dijkstra works fine. But when the
calculation is more complex, pgr_dijkstra does nothing.

I made a lot of tries and I am sure that pgr_createTopology doesn't work as
it should. Maybe my table needs more fields to get its topology done well,
but I don´t know what.

An explanation about what fields are needed for pgr_createTopology would be
helpful too.

I attach two screenshots: how it built the table's topology and its fields
composition.

Thank you very much!

 

 




--
View this message in context: 
http://postgresql.nabble.com/pgr-createTopology-creates-bad-topology-tp5925750.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support


[pgadmin-support] server status in pgadmin ERROR: path must be in or below the current directory CONTEXT: SQL function pg_file_length statement 1

2016-10-13 Thread bramcote . road
Hi folks,

When I try to open server status in pgadmin 1.18 I get the following error messages:

 

An error has occurred  ERROR: path must be in or below the current directory

CONTEXT: SQL function pg_file_length statement 1

 

An error has occurred   column not found in pgset:filename

 


An error has occurred   column not found in pgset:filetime


 

An error has occurred   column not found in pgset:len

 


An error has occurred  ERROR: could not stat file "": no such file or directory

CONTEXT: SQL function pg_file_length statement 1

 
and then the last 2 ad nasuseum,

I checked the .conf files for non-existent paths but didn't find anything.

 

Any tips what filepath needs fixing?

Many thanks, Brian





[pgadmin-support] SQL window bracket control

2016-10-13 Thread Oscar
When rewriting or error searching a poorly written SQL statement it's very
helpful to get the corresponding left or right bracket. I miss this feature
in the PGAdmin 4 query tool and I hope it will show up in a coming release.

Best regards
Oscar



--
View this message in context: 
http://postgresql.nabble.com/SQL-window-bracket-control-tp5925672.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.


-- 
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support