[pgadmin-support] PgAdmin4 not usable when installed from RPMs on Fedora linux

2016-11-29 Thread Kieran McCusker
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:

[pgadmin-support] SQL Editor in pgAdmin4

2016-08-02 Thread Kieran McCusker
it. They tend to be quite long. There doesn't appear to be a shortcut for executing the SQL (used to be F5) I appreciate this is still beta, but thought it worth mentioning these issues as they will cause problems for my users. Thanks Kieran

[pgadmin-support] pgAdmin4 performance

2016-08-02 Thread Kieran McCusker
then we are back to:- 9 seconds to view page 2 4 seconds to view any subsequent page It looks to me the problem lies in the smart column sizing algorithm being way too expensive in terms of time. Anyway as always thanks for all the effort you put in to produce these tools. Kieran --

[pgadmin-support] Copy and paste in Edit Data

2013-05-17 Thread Kieran
have just copied. You will get the whole contents of the field not what you just highlighted. My environment is Windows Vista pgAdmin 1.16.1 Many thanks, and it goes without saying thanks for a great tool! Kieran -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To

Re: [pgadmin-support] Performance of pgAdmin 14 Beta 2

2012-02-01 Thread Kieran McCusker
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

[pgadmin-support] Performance of pgAdmin 14 Beta 2

2012-02-01 Thread Kieran McCusker
FKey_cascade_del"(); -- Trigger: RI_ConstraintTrigger_34533277 on versions -- DROP TRIGGER "RI_ConstraintTrigger_34533277" ON versions; CREATE CONSTRAINT TRIGGER "RI_ConstraintTrigger_34533277" AFTER UPDATE ON versions FOR EACH ROW EXECUTE PROCEDURE "RI_FKe

Re: [pgadmin-support] Performance of pgAdmin 14 Beta 1

2011-06-02 Thread Kieran McCusker
-> Options (similar to the browser tab or maybe a general "simple mode" type idea). Many Thanks Kieran -- 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] Performance of pgAdmin 14 Beta 1

2011-05-17 Thread Kieran McCusker
t tab of the property pane are selected. As the additional tabs are used much less frequently by me and my users couldn't they be lazy loaded as they were in V12? Many thanks Kieran For reference the slow queries are the 4th, 5th and 6th in the log:- SELECT DISTINCT dep.deptype, d

[pgadmin-support] Search Icon does not play well in Windows

2010-10-20 Thread Kieran McCusker
the icon shows up with unattractive black pixels around the edge of the magnifying glass 3. The icon does not scale well when it appears in the left hand of a Window Title bar I know I'm being fussy, but I do think it does detract from the look of the product. Many thanks Kieran --

[pgadmin-support] Problem with restore

2010-04-20 Thread Kieran McCusker
wanted using the UI?) Shouldn't the schema be checked as well? Many thanks Kieran -- 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] Another problem with reverse engineering functions

2010-04-07 Thread Kieran McCusker
$$ select 27; $$ LANGUAGE 'sql'; In pgAdmin 10.2 it becomes :- CREATE OR REPLACE FUNCTION public.t() RETURNS SETOF integer AS $BODY$ select 27; $BODY$ LANGUAGE 'sql' VOLATILE COST 100 ROWS 1000; Many thanks Kieran -- Sent via pgadmin-support mailing list (pgadmin-su

[pgadmin-support] Feature request

2010-02-17 Thread Kieran McCusker
7;s just a thought - Thanks again for creating such a great product. Kieran

[pgadmin-support] Problems reverse engineering functions

2010-02-16 Thread Kieran McCusker
#x27;; END; $$ LANGUAGE 'plpgsql'; Many thanks Kieran -- 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] Problems using pgScript

2009-07-06 Thread Kieran McCusker
to another table? What would happen if the column data contained quotes? 2. Is it true that you can't put a column from a record into a sql command without first assigning it to a simple variable? This seems a little restrictive. Sorry about the length of the script by the way. Many

[pgadmin-support] Performance

2009-06-03 Thread Kieran McCusker
eve this is functionally equivalent, although we don't use inherited tables so I can't comment on what effect lots of inherited tables would have on the query. The database is 8.3.7 running on 64bit Fedora Any thoughts? Anyway keep up the good work, this release is already a big step up from 1.8! Kieran

[pgadmin-support] Slow opening of Table -> Properties... -> Columns

2009-05-11 Thread Kieran McCusker
ypnamespace AND relkind != 'c' UNION SELECT '_' || relname FROM pg_class WHERE relnamespace = typnamespace AND relkind != 'c') AND nsp.nspname NOT LIKE 'information_schema' ORDER BY CASE WHEN typtype='d' THEN 0 ELSE 1 END, (t.typelem>0)::bool, 1 The last query is where the time went - Running it in a query window it took 235 seconds. Let me know if I can provide anything else Cheers Kieran

[pgadmin-support] Another issue

2009-05-08 Thread Kieran McCusker
u wait long enough, although I have just got used to opening a query window and using alter table Cheers Kieran

[pgadmin-support] Beta 3

2009-05-08 Thread Kieran McCusker
ect. 4. The Links in pgAdmin III help do not all work I noticed this looking at Connect to Server where at least the pg_namespace link does not work Anyway many thanks again for a great piece of software! Kieran

[pgadmin-support] Beta 2 logging

2009-04-01 Thread Kieran McCusker
bold) appears to be cut off mid-sentence Cheers Kieran *2009-04-01 15:44:28 STATUS : Retrieving View details... 2009-04-01 15:44:28 QUERY : Set query (kwest:5432): SELECT att.*, def.*, pg_catalog.pg_get_expr(def.adbin, def.adrelid) AS defval, CASE WHEN att.attndims > 0 THEN 1 ELSE

[pgadmin-support] Beta 2 issues

2009-03-31 Thread Kieran McCusker
/datname IN (some list)/ 2. let PgAdmin connect 3. clear the invalid DB restriction (get the note about server settings...) 4. Disconnect 5. Server properties -> DB restriction put in correct restriction e.g. 'test_db' Cheers Kieran

[pgadmin-support] Beta 2 issues

2009-03-26 Thread Kieran McCusker
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

[pgadmin-support] Issues with v1.10 beta 1

2009-03-25 Thread Kieran McCusker
lts of the last query to be sent to the output pane? I also wondered about F5 giving a clearer message if pgScript was detected? Many thanks for a great product. Kieran

[pgadmin-support] No New line before NOTICE in messages pane

2009-01-29 Thread Kieran McCusker
was wondering if a new release is due soon, or if it was possible to backport just that fix to v1.8.4? We can of course live with it. Many thanks again for a brilliant tool. Kieran -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription

[pgadmin-support] Text column with large amounts of data

2008-01-04 Thread Kieran McCusker
king aloud, thanks for a great piece of software. Kieran ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[pgadmin-support] Bug in Query tool (tested on Beta 5)

2007-10-05 Thread Kieran McCusker
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

[pgadmin-support] Bug in Query tool (tested on Beta 5)

2007-10-05 Thread Kieran McCusker
text in file has changed to you want to save changes?" Clicking Yes overwrites the contents of the file you were trying to open. Tested under Windows (Vista). Many thanks Kieran ---(end of broadcast)--- TIP 3: Have you checked our exte

[pgadmin-support] Feature request in pgadmin (tested on Beta 5)

2007-09-28 Thread Kieran McCusker
to the same database cluster to allow connection by different users (standard user, superuser etc.). It also discourages me from using individual user ids for my users (always bad!). Many thanks Kieran ---(end of broadcast)--- TIP 7:

[pgadmin-support] Bug in pgadmin table properties (tested on Beta 5)

2007-09-28 Thread Kieran McCusker
e and select properties 2. Click the constraints tab 3. Click add with Primary Key in the combo 4. Click the columns tab 5. Select the first column and click Add 6. Click Ok pgadmin seems to go into a loop where pgadmin stops responding. Tested under Windows (Vista). Many thanks K

[pgadmin-support] Bug in pgadmin (tested on Beta 5)

2007-09-17 Thread Kieran McCusker
stops responding. Tested under Windows (Vista). As a feature request is it possible to make search and replace work in a selection? Many thanks Kieran ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[pgadmin-support] public schema not prefixed / copy + paste adds newline

2007-07-19 Thread Kieran McCusker
a newline === If you double click on a text field in the grid and do ctrl-c then paste the result into another text field you get a newline on the end. My users do this all the time and I am constantly writing triggers to prevent this from happening. Many thanks for great produ

[pgadmin-support] Does New Server Registration Support entering both username and password?

2006-12-15 Thread Kieran McCusker
to work on a job without fear of trashing another job and without involving the sysadmin with endlessly adjusting privileges for the analysts. Is this possible? - Could I add it to the wish list if it is not? Many Thanks Kieran ---(end of broadcast

[pgadmin-support] Problem with 7.3 database viewing tables (ERROR: Column reference "proname" is ambiguous)

2005-10-14 Thread Kieran McCusker
l LEFT OUTER JOIN pg_description des ON des.objoid=rel.oid AND des.objsubid=0 LEFT OUTER JOIN pg_constraint c ON c.conrelid=rel.oid AND c.contype='p' WHERE relkind IN ('r','s','t') AND relnamespace = 2200::oid ORDER BY relname 2005-10-14 14