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:
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
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
--
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
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
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
->
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
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
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
--
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
$$
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
7;s just a thought - Thanks again for creating such a great product.
Kieran
#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
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
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
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
u wait long enough, although I have just got used to opening a
query window and using alter table
Cheers
Kieran
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
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
/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
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
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
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
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
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
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
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:
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
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
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
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
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
32 matches
Mail list logo