Postgres 9.0.4
I installed from the visual linux installer
Redhat 6 newest updates
I keep getting the following message when logging into the command psql:
psql (9.0.4)
Type "help" for help.
Segmentation fault (core dumped)
It then kicks me out. I uninstalled the application completely even d
PostgreSQL 9.2.2
pgAdmin 1.16.1
pgAdmin > Tools > Server Status
When viewing the Server Status window I notice that my queries look like this:
SELECT * FROM tablex WHERE id=$1
How can I display the full query without the $1?
Example of what I would like to see:
SELECT * FROM tablex where id=75
PostgreSQL 9.2.2
Is there a configuration parameter in PostgreSQL that will allow a full query
to be displayed in the log file?
What I see:
UPDATE abc.table set def=$1 WHERE id=$2
What I want to see:
UPDATE abc.table set def='hi bob' WHERE id=12
Thanks,
Lance Campbell
Software Architect
Web Se
ql.org] On Behalf Of Campbell, Lance
Sent: Tuesday, January 08, 2013 9:46 AM
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] How to display full query in logs
PostgreSQL 9.2.2
Is there a configuration parameter in PostgreSQL that will allow a full query
to be displayed in the lo
pgAdmin 3 1.18.1
PostgreSQL 9.2
I am having issues with a query getting "stuck" while doing updates. So I went
to Server Status in pgAdmin. I found the query was highlighted in dark orange.
When a query appears to get hung up and won't finish what steps should I take
to figure out what is hap
pgAdmin 1.18.1
Windows
Normally in the left hand navigation when I click on a table I see in the right
hand window the SQL to create the table and the indexes associated with it.
When I click on a materialized view I only see the SQL to create the view. I
don't see the indexes. Is there somet
I am using PG Admin 4 version 1.2 on Windows 7. I found a couple of issues:
1) I did a fresh install and PGAdmin 4 version 1.2 wants to store
everything in 4 V1. I think you have an issue with the installation software.
The short cut it creates says pgAdmin 4v1 . In program files direct
Peter,
Have you heard of any solution to this problem. I have found pgAdmin 4 v1.3 is
completely unusable on Windows 7 64 bit. I have found that pgAdmin 4 v1.1 is
stable. I am currently using that version. Do you think they are not testing
at all on Windows 7 64 bit? There website says it i
application hung.
I have never ever had any issue with pgAdmin 3. I don't have any of these
issues with pgAdmin4 v1.1 .
Lance
-Original Message-
From: Dave Page [mailto:dp...@pgadmin.org]
Sent: Thursday, March 23, 2017 9:22 AM
To: Campbell, Lance
Cc: Peter Johnson ; pgadmin-su
h a 9.4 backend running on Linux.
On 23/03/17 11:12, Campbell, Lance wrote:
Peter,
Have you heard of any solution to this problem. I have found pgAdmin 4 v1.3 is
completely unusable on Windows 7 64 bit. I have found that pgAdmin 4 v1.1 is
stable. I am currently using that version. Do you thi
can now backup my PostgreSQL 9.6 database with pgAdmin 3.
Thanks for your help.
Lance
From: Melvin Davidson [mailto:melvin6...@yahoo.com]
Sent: Thursday, March 23, 2017 2:06 PM
To: Campbell, Lance
Subject: Re: [pgadmin-support] pgAdmin 4 v1.3 fails to load
>pg_dump: server version: 9.
For pgAdmin 4 I have a request. Could you give us an option in setup such that
when any screen list fields in a table we can request that they be in a
particular order? I think most people find one of these orders best:
1) Fields listed as they are in a table. (default)
2) Fields l
I have a Windows 7 64 desktop. I just installed pgadmin 4-1.4 . I am very
impressed. I was having a lot of issues with the prior releases of 4-1.2 and
4-1.3. These issues have disappeared. You did a great job getting the
installation issues addressed. Thanks for the hard work.
Lance Campb
In pgadmin 4 in the left hand navigation you can select the "Columns" label
under any table listed in order to get a list of all columns within a table.
A fantast enhancements would be to add to the "File >> Preferences" the ability
to do either option #1 or #2 listed below:
1) A question
being returned from your below code.
You would think they would have a function already in PostgreSQL to do that.
Thanks,
Lance
From: Melvin Davidson [mailto:melvin6...@yahoo.com]
Sent: Wednesday, April 19, 2017 9:18 AM
To: Campbell, Lance ; pgadmin-support@postgresql.org
Subject: Re: [pgadmin
pgAdmin 4 v1.4
In pgAdmin 3 there was a way to view your database logs. I am not seeing that
in pgAdmin 4. It might be there but I am missing it. As a side note in case
this helps, I am connecting to a PostgreSQL 9.6.2 database at AWS. Using AWS
is new for me. I might be missing a step and
16 matches
Mail list logo
