Hi
I'm having the same problem. I did install the earlier RPMs but removed
them (and any mention I could find of pgAdmin4) before reinstalling.
Thanks
Kieran
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresq
Hi
Just been looking at the SQL editor in pgAdmin4. Issues I see at the
moment are:
My users spend a lot of their day editing scripts that are held on
the network.
It looks currently like you have to map each network drive to a
drive letter (in windows).
It takes 3-4 seconds fr
Hi
Just had a look at pgAdmin4. Looks very nice but I'm having some issues
with performance for the kind of use that our office will use it for.
If you take a table like this which we use quite a lot (we are a survey
business, nowadays I would have used jsonb)
CREATE TABLE a870m1
(
id int
not yet available to the
general public."? Should pgAdmin have suppressed these?
Thanks again
Kieran
Many thanks
On 01/02/2012 10:44, Guillaume Lelarge wrote:
> Hi,
>
> On Wed, 2012-02-01 at 10:28 +, Kieran McCusker wrote:
>> [...]
>> I've noticed the perf
Hi
I've noticed the performance of version 14.2 is very slow when clicking
on tables.
~3 seconds for V14.2.
Looking at the logs I see the following:-
SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname,
typns.nspname AS typnsp, lanname, proargnames,
pg_get_expr(proargdefaults, '
Hi
Thanks for the response. I take your point, but for ourselves where we
have ~6000 tables and almost 700 schemas speed is important. Our staff
have never looked (and never needed to) at the information in the
Statistics, Dependencies and Dependents tabs so the loss in performance
is not balanced
Hi
I've noticed the performance of version 14 is noticeably worse than
version 12 when clicking on tables.
~0.1 seconds for V12 comapared to ~0.5 seconds in V14.
Looking at the logs I see that the details for all the tabs are selected
by V14 but in V12 only the details for the current tab of
Hi
I think it was release 12 that changed the icon for the Query Tool.
Could I make the following observations all based on Windows running
Windows Classic Theme :-
1. The icon in the PgAdmin Toolbar has unattractive white pixels around
the edge of the magnifying glass
2. On the TaskBar th
Hi
Sorry if this has been raised before but I have just tried to restore a
table from one of my schemas.
The problem was that this table name is very common - It is used in many
schemas as each schema is the data for an individual client.
Restore has the three disabled checkboxes
Only data
Hi
Sorry if this has been raised before but the following function will not
be reverse engineered correctly - It will be changed into a setof return
which will break anything expecting organisation_id.
CREATE OR REPLACE FUNCTION public.t() RETURNS TABLE (organisation_id
integer) AS
$$
sele
Hi
There are a couple of things I would like in the messages tab of the
output panel. Our staff use a lot of functions where I report
information back to them using RAISE NOTICE|WARNING. The pane is
non-ideal for this workflow as :-
1.Context is reported - I can see this is useful for me
Hi
Sorry if this has been raised before but the following function will not
be reverse engineered correctly - The final default clause will be removed.
CREATE FUNCTION fn(a text, b integer DEFAULT NULL::integer, c integer
DEFAULT NULL::integer) returns text as $$
BEGIN
return 't';
END;
$$
Hi
I have been trying to use pgScript to do something I would normally do
by writing a function. It very nearly worked perfectly except I got
stuck with a problem where the script would run indefinitely and could
not be interrupted.
If you find the line "UNCOMMENTING THE LINE BELOW CAUSES TH
Hi
Could I raise a small performance issue with 1.10.
When I click on a table in the object browser in my big database (5004
views and tables, 260 schemas, 211,493 columns) there is a noticable lag
before the SQL pane refreshes. Enabling debugging show the following for
the first query
2009
Hi
Enabling logging revealed the following :-
2009-05-11 08:10:05 INFO : Setting logfile to:
C:\Users\mccuskk\Documents\pgadmin.log
2009-05-11 08:10:05 INFO : Setting loglevel to: &Debug (not
recommended for normal use)
2009-05-11 08:10:07 INFO : Displaying properties for Table events
2
Hi
This is also a long standing issue but one I have never got around to
reporting. With our database (5004 views and tables, 260 schemas,
211,493 columns) when you go :
Table -> Properties... -> Columns
and then click on Add pgAdmin hangs. I believe it does actually come
back if you wait l
Hi
Firstly, congratulations on beta 3. An issue I had with the time it took
to for the object browser to refresh has gone away (I was waiting for
the logging fix I raised to investigate myself), and the issue with tabs
in the query window has also been fixed. The performance of the
graphical
Hi again
I was going to look at the SQL that produces the view or table when you
click on it in the UI as it seems a little sluggish in our (admittedly
large 5000+ views and tables) database. Enabling logging I got the
following (at least for views and tables). The query (I've marked in
bold)
Hi
This is not really a beta 2 issue as it has existed for a while but I
thought I might as well raise it now.
In Server properties -> DB restriction there appears to a conflict
between the restriction in the UI and what the SQL actually wants. The
sql wants anything that can go in an IN cla
Hi
Just another couple of issues:
Tab is not working in SQL Editor (Windows) - Although you can block
indent with the tab key.
Graphical Query builder takes forever (10 minutes+) on our database
(5004 views and tables, 260 schemas)
Cheers
Kieran
Hi
I have been using beta 1 for a few days now. It's looking good but could
I mention the following items:
*Query tool Ctrl-E*
Selecting the Query tool opens with the contents of the SQL pane which
it didn't in 1.8.4. I think this behaviour is fine except when you go to
open the query file y
Hi
Sorry to bother you. I noticed this has been fixed in trunk. We use a
lot of functions for end user tasks and report issues to them using
raise NOTICE. They tend to lose these messages in general postgresql
messages and where we report a couple of things its harder for them to
read.
I wa
Hi
I know there is already a known issue in the GRD for columns with a
large amount of data but is it known that the same problem appears in
the query window?
I am using postgresql to capture email content (in a text field) and it
is impossible to use pgadmin to browse the table in either th
Sorry I sent the mail too soon!
There is an extra behaviour whereby if you cancel the dialog and then
try to close the window it prompts you to overwrite the recent file you
tried to open.
Many thanks
Kieran
---(end of broadcast)---
TIP 6: exp
Another report - I couldn't find an earlier report (although I only had
a quick look).
Do the following :-
1. Menu -> Tools -> Query tool
2. type any character
3. Menu -> File -> Recent file -> then choose any file in the list
pgadmin throws up a dialog saying:-
"The text in file has changed t
Hi
Could I just mention a couple of requests:-
1. The first is to do with the treeview. The use case is where my users
just connect to a single database (limited by datname). Here the
treeview shows :-
Servers (1)
-> Server
-> Databases (1)
-> Database
-
Another report - Sorry I haven't had time to check if it has already
been reported.
Create a new table without a primary key (I did it using the SQL pane.)
my example is:-
CREATE TABLE t
(
id integer,
t text
)
Do the following :-
1. Right click on the table in the properties pane and sel
This bug has been around a while, sorry its taken me so long to report it.
In the sql editor do the following :-
1. Open Find and replace
2. Check regular expressions
3. In Find what enter $
4. In Replace with enter anything
5. Click Replace All
pgadmin seems to go into a loop where pgadmin stop
Hi
Both these issues are also present in the 1.6 series :-
public schema prefix not added to any scripts
===
This exists in 1.6 as well, but if you have a login that is also the
name of a schema and you edit a public anything using CREATE script then
"public." is not a
Hi
I may be being dumb but I cannot see a way for creating a server
registration that leaves both the username and password blank until
connection time.
In our organisation we have client jobs separated into schemas and were
planning on a separate userid/login for each schema to allow staff
Hi
Trying to view a 7.3.4 database running on SUSE I get a MessageBox with
the message :-
"ERROR: Column reference "proname" is ambiguous"
The database works fine with PgAdmin 1.2.2
Got the following with debug logging enabled:-
2005-10-14 14:58:18 INFO : Displaying properties for Tables
31 matches
Mail list logo
