On 19.5.2017 16:24, rich...@xentu.com wrote:
On 2017-05-19 15:13, Michal Kozusznik wrote:
It means you don't have to switch into pgAdmin4 just because you are
using recent version of database.
pgAdmin3 v1.22.2 supports pg9.6 (at least it doesn't throw exceptions
for common tas
It means you don't have to switch into pgAdmin4 just because you are
using recent version of database.
pgAdmin3 v1.22.2 supports pg9.6 (at least it doesn't throw exceptions
for common tasks)
MK
On 19.5.2017 15:45, rich...@xentu.com wrote:
On 2017-05-19 14:20, Adam Brusselback wrote:
I serious
On 19.5.2017 14:38, Tomek wrote:
You must understand one thing - first You stop developing v3, than release
feature stripped v4, than demand to report issue/feature request You already
know it is missing...
Maybe this news for You but people used this software for more than 10 years -
they got
On 26.10.2016 17:38, Dave Page wrote:
Server based deployments, where multiple users manage servers from one
or more instances of pgAdmin.
After reading your recent responses to various posts I think I'm
starting to understand that the issue lays in the main role pgAdmin4 is
designed for.
It
things are more secure at server side than client side...
IMHO...
2016-10-26 13:00 GMT-02:00 Michal Kozusznik
mailto:kozusznik.mic...@ifortuna.cz>>:
On 26.10.2016 16:15, Dave Page wrote:
Or a misunderstanding on your part on the goals of the project and
reasons fo
On 26.10.2016 16:15, Dave Page wrote:
Or a misunderstanding on your part on the goals of the project and
reasons for them.
So just list the reasons, please.
IMO there is no single reason to work with files stored on the server.
It could be even considered non-safe in some scenarios. It's enou
On 26.10.2016 10:58, Dave Page wrote:
I wouldn't be so sure about that :-/. There are various problems with
using native file dialogues - firstly, they won't work at all in
server mode where you actually need to browse the filesystem on the
server, not the client.
(...)
So, I can't see us using
You are right regarding best practices but I cannot agree with your "do
not translate well"
Since postgresql officially allows mixed case names for objects,
applications have to support it.
Michal
On 20.10.2016 16:34, Melvin Davidson wrote:
*Mark,*
*
*
*Please DO NOT use CamelCase names (or U
On 6.9.2016 11:51, Dave Page wrote:
On Tue, Sep 6, 2016 at 10:47 AM, Attila Soki wrote:
Hi,
i testing pgadmin4 (rc1) and noticed that the query tool is significantly
slower than the query tool in pgadmin3.
i am not sure if this occurs only on my computer or only under os x (10.10.5)
or is th
I'm not sure images can be attached to the email, I'll try. In case if
doesn't work, you can see the image at: http://i.imgur.com/oPYHaAw.png
Please note, the first column on the picture is masked intentionally.
There are following issues depicted on the screenshot
1. Width of columns depends
On 10.6.2016 17:45, Dave Page wrote:
BTW Installer (under Win7) suggests inappropriate path while changing
installation path to another location than default. In my case, after
selecting D:\_programs, installer did suggest:
D:\_programs\v1
That's arguably intentional - we want to ensure you c
The first question:
Is there any way to import db connections from pgadmin3? I have dosens...
BTW Installer (under Win7) suggests inappropriate path while changing
installation path to another location than default. In my case, after
selecting D:\_programs, installer did suggest:
D:\_programs
Thank you. I'm going to test it.
Please note, download link on https://www.pgadmin.org/download/ page
points to pgadmin3/release/ subtree.
pgadmin4 is located under pgadmin3/pgadmin4/ which might be confusing
with regards
MK
On 10.6.2016 16:48, Dave Page wrote:
I'm pleased to announce that th
pgAdmin provides some basic functionality around autosuggestion and
autocompletion but as you noticed, it's not as perfect as expected.
I don't think pgAdmin is going to be improved in this area. I suggest to
check other solutions. Personally I can recommend SQL Assistant we use
in our company (
On 23.9.2015 10:47, Dave Page wrote:
Hi
On Tue, Sep 22, 2015 at 9:30 PM, Ken Winter wrote:
I need to migrate my pgAdmin to a new (Windows 7) computer. My pgAdmin
setup on my old (also Win 7) computer includes a couple dozen servers. I'm
hoping that I can somehow copy these to the new compute
Hello
I found, that in case of functions which returns TABLE structure,
function arguments are proceeded by IN keyword.
I believe it's because of similarity between 2 methods returning recordset:
- TABLE structure
and
- OUT arguments with conjunction of SETOF
Also please note, that arguments of
When I change trigger condition, it does nothing
How to reproduce
1. CLick RMB on some trigger, select properties
2. Select tab definition
3. Into "Where" field enter enything
4. Select tab SQL
5 SQL preview is empty
I noticed it while trying to remove existing condition, so it doesn't
work fo
Hello
There are 2 issues
1. While setting up new connection, if I put wrong password, connection
window will be re-openned with *default server group* (Servers), even if
I selected another one before connection attempt. Probably issue is
valid for other errors during the first connection attem
Hello
There is a small issue with OK button on server connection window while
creating new connection.
If first attempt of connection get failed (ie wrong password), edit
connection properties window will reappear, with [OK] button inactive.
(Not)Funny is, that changing password doesn't make t
Hello
Long standing issue which I often have face it.
When connected to a server, all server connection property fields are
locked.
I would understand they are locked for writing. But why these are even
locked for selecting text (copying into clipboard)?
I have a lot servers defined, and somet
After executing INSERT command, new OID, value: 2490917958, has been
assigned to the new row, but pgAdmin reported:
Query returned successfully: one row with OID -1804049338 inserted, 22
ms execution time.
Looks like signed/unsigned bug
with regards
<>
--
Sent via pgadmin-support mailing li
We are using SQL Assistant for a lot of tasks like code formatting,
Autocomplete, code searching etc. Really powerful tool.
Unfortunately pgAdmin developers has been rejected my request to make
CTRL-space hotkey optional in pgAdmin. Allegedly because of amount of
work needed to do it (lol).
I w
Try SQL Assistant software.
Really powerful tool, which can hook onto various applications adding
missing features (like text formatting, on-the-fly code checking,
searching through whole db structure for given text and much more.
Regarding formatting, it is configurable: you may create your own
A can confirm.
A lot of unwanted behaviour in case of broken connection (including
pgadmin crash).
As far as I remember it has been reported multiple times, and answered
that it is not possible to fix it due to ammount of work needed.
I still cannot understand how is it possible in case of off
On 21.8.2013 15:18, Dave Page wrote:
So the value is shown correctly in the query tool when you create the
function, but when the SQL is reverse engineered again, it gets changed?
Something is changed during storing function definition to db. You may
open existing, properly looking function
Everybody here is volunteering their time. Whilst we
try to respond to every bug report, unfortunately some
will get missed or ignored because noone has the time to
look at them. If you need guaranteed
Guys, what is the reason of reporting
bugs, while you don't even answer?
I reported quite important issue 4 month ago without any single
response. Is it already fixed? Or will remain in further builds?
On 18.4.2013 10:44, Michal Kozusznik
On 18.5.2013 15:26, Dave Page wrote:
As we have so few of these buttons and they're there primarily to
support a working practice that we discourage anyway, I'd like to
simply remove them so we can avoid the fragile and messy code changes
needed to make them work reliably.
I propose to do this
Intresting thing. I never thought it is so loose.
On the other side, I would never use double for currency calculations.
It provides instability to results due to floating point precision.
However due to this:
/Thescaleof anumericis the count of decimal digits in the fractional
part, to the r
Hello
Changing line ends cause replacing function delimiter tag ($BODY$ or
even $$) to single quote character.
How to reproduce:
Scenario 1
1. Make sure Line Ends are set to MAC (Query window, Edit > Line
Ends > MAC)
2. Open some function in Editor (RMB >
When content of SQLpane is very wide, using of vertical scroll-bar
doesn't move page to the right end.
In most cases it is caused by large number of long-named arguments which
are listed in single line.
To get view of end of the line, I need to move cursor to the last
character of such long li
Hello
When using table data view, and try to copy fragment of field value
using CTRL+c, whole value is copied instead of selected fragment.
How to reproduce:
1. RMB on some table
2. Select View Data / View Last 100 rows (or something else)
3. data view window will open
4. choose some single fie
That's basically what the patch I posted does. The problem is that the
base class doesn't have any knowledge of what controls are on an
instantiated dialogue, or how to test if they've been changed from
whatever the default is (for new objects) or from whatever pgObject
derived object exists for
OK. Thanx for deeper explanation. Looks like I missed a point twice :)
If you have a simple way to make it work, I'd love
to see a proposed patch because at the moment, I don't see a way to do
it that wouldn't take at least a few days of work.
Don't know architecture of pgadmin, but if reques
On 6.2.2013 18:19, Dave Page wrote:
It won't be fixed in 1.16.2 I doubt, as it's a change in behaviour
that's been established for over 10 years with no previous complaints
that I can recall.
I don't want to be rude, but maybe no one has used this feature due bugs
appearing from time to time.
I had a function almost finished, written in function editor.
Then I accidentally hit ESC making editor closed without any warning.
Terrific :(
I would like to see a confirmation which protect against such loses.
with regards.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgr
bject tab of backup window, object tree is scrolled down to the
bottom so I cannot see schema intended to be backuped
MK
30. 7. 2012 v 21:50, "Guillaume Lelarge" :
On Mon, 2012-07-30 at 13:54 +0200, Michal Kozusznik wrote:
There are a few things annoying me daily while working with ba
On 17.1.2013 16:54, Dave Page wrote:
It's not a case of voting I'm afraid. It's finding someone with the
time and desire to implement the feature.
When team working on pgAdmin will get rid of all bugs (hope it is not
infinity collection) then they may start on improving the product.
I know pg
I think the feature you are looking for is obtained using right click
over table and selecting "View data... filtered rows".
It's live and editable.
Yes it is. But is not comfy enough for daily work
It is implemented very well in MySQL software (Query Browser and
Workbench). You can edit res
Once superuser privilage is set, it's impossible to unset it in Role
Priperties.
Attempt of unchecking particulat checkbox results with requester popup:
"Deleting a superuser might... blabla. Are you sure?"
But doesn't matter I chose Yes or No, superadmin is not deselected.
Found in pgAdmin 1.1
When creating new foreign key, there is "references" combo-box in
Columns tab.
Can anyone say the rule used to sort the combo-box content? Because
I'm embarrassed. See picture.
I would like to see sorted items by schema and then by object name.
with re
On 29.11.2012 13:50, Dave Page wrote:
I never use it myself. But out of interest, how exactly to SQL
Assistant give you any kind of usable auto complete for column names
after SELECT if you've got a database that's anything other than
trivially sized? For example, the database I'm currently work
On 29.11.2012 13:04, Dave Page wrote:
On Thu, Nov 29, 2012 at 3:02 PM, Kozusznik Michal
wrote:
that's why i'm not asking for developing hotkeys settings support, but to add
single checkbox is setings to disable this feature at all. It should be quick
and easy.
But what is different between y
On 28.11.2012 17:22, Dave Page wrote:
Why would you want to disable it? If you don't want to use it, just
don't press Ctrl+Space or Ctrl+Tab if that's enabled.
Because I am got used those shortcuts and want to use same in SQL
Asistant (btw set by default too)
with regards
MK
--
Sent via pgad
Hello
Is it any option to disable auto-completion feature? If not, could it be
added?
We bought SQL Assistant which provides better functionality of this
feature, unfortunately sometimes both solutions colide each other.
BTW in pgAdmin manual is stated:
/You can optionally enable the Tab key
Check if Apply button is active just after opening function properties.
If true - it is known issues. It's not related to setting an option but
to apply changes while window is not initialized with correct state
(button should be disabled just after opening properties window)
BTW I'm curious w
Hello
Have you considered to split triggers into branches?
I can imagine:
* triggers
o insert
+ before
+ after
o update
+ before
+ after
o before
+ before
+ after
Triggers which are set for multiple events would appear in all
It's about copy&paste feature. If I copy DDL from pgadmin and paste to
another program (for example notpad) result is differ depending on from
which place I copied the source.
How to reproduce:
Windows7 64bit
Attempt 1
- select a table or function or whatever else in Object browser
- select DD
button is active just after opening edit function
window, pressing this button causes pgAdmin crash after.
(v1.16.0, W7 64bit)
On 19.9.2012 16:54, Michal Kozusznik wrote:
So, looks like we have 2 different issues, because I can also confirm
that sometimes Apply and OK buttons are active and
So, looks like we have 2 different issues, because I can also confirm
that sometimes Apply and OK buttons are active and sometimes not.
Basically, always after starting pgAdmin, buttons works as expected -
are inactive after opening a function. But after some time, buttons
start to be available
Tested with:
pgAdmin v1.16.0
posttgresql 8.4
Windows 7 64bit
How to reproduce
1. find a function in object tree
2. RMB on function, then select Properties
3. Select Code tab
4. Hit Apply button
5. put cursor somewhere into function body to enter any letter
PgAdmin will crash.
--
Sent via pgad
There are a few things annoying me daily while working with backup feature.
I believe improvements listed below would help a lot:
1. backup settings should be remembered by program for next use.
Currently each time I want to do backup I need to set even such basic
things as character set or form
already stored (valid also for
suggestion #1)
B)
Only one query history exists - same for all defined servers. I would
like to see separate history for each server.
I found useless to use queries from db on another one while both
databases may be significantly different
with regards
Michal
Actually I do have 2 releases. After I noticed that problem in 14.2
For windows version this bug appeared in 14.3 for postgresql versions
lower than 9.
14.2 works fine.
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.p
Edit Data is not able to reconnect after connection lost.
Trying to refresh data first time I get error message "server closed the
connection..."
After closing error pop-up and hitting refresh button again - nothing
happens.
I would like this grit to be able to reconnect.
with rega
Issue found in pgAdmin 1.14.2, Windows 7
How to reproduce:
1. create some text file and save it without suffix - make sure OS
doesn't hide suffixes making you think that there is no suffix in a filename
2. Open query editor window
3. Select File / Open...
4. Enter star character (*) into filena
issue appears while using function editor (available in properties window).
If I hit Apply button and the db returns error, button remains inactive.
To reactivate I have to write/remove some single character.
Found in v1.14.2
with regards
--
Sent via pgadmin-support mailing list (pgadmin-supp
hi!
Currently we can export data which are result of query executed in query
window.
But didn't find possibility of export from data view of a table.
Is it possible to add this feature?
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscripti
Dne 17.7.2012 20:52, Guillaume Lelarge napsal(a):
On Tue, 2012-07-17 at 10:59 -0500, Michael Shapiro wrote:
No, it doesn't.
For example, I want to see if a given string is used within a function.
I want to be able to see all the uses of a function: in other functions, in
select stmts in views,
I meant a colleague working with Linux
Dne 3.7.2012 16:22, Michal Kozusznik napsal(a):
Please, don't start discussion about windows against linux stability.
I'm working on W7 and I really don't remember if it crashed even once.
I have a collogue who sit next to me, and he also
Please, don't start discussion about windows against linux stability.
I'm working on W7 and I really don't remember if it crashed even once.
I have a collogue who sit next to me, and he also reports pgadmin crash
often.
We suspect that pgadmin has problems with manage disconnections.
Dne 3.7.20
pgAdmin crashes from time to time when connection is lost. For example
when using notebook, with pgAdmin, you often change networks, hibernate,
suspend, using direct connection or VPN etc
Such changes break connections to databases. I found that closing
pgAdmin is quicker solution than reconnect
Ahh I'm stupid.
1.14.2 is OK - just checked.
Sorry for making mess.
Dne 20.6.2012 11:09, Michal Kozusznik napsal(a):
I suggest to use 1.14.0.
Any newer version has another bug valid for postgresql 8.4: missing
default values of function arguments) which may be dangerous if you
work with
I suggest to use 1.14.0.
Any newer version has another bug valid for postgresql 8.4: missing
default values of function arguments) which may be dangerous if you work
with this feature.
with regards
Thanks. I'll use 1.14.2 until the next release.
Yes, I should know it. thank you.
There are a few sentences about pg_dump syntax compatibility from
postgresql documentation:
Because pg_dump is used to transfer data to newer versions of
PostgreSQL, the output of pg_dump can be expected to load into
PostgreSQL server versions newer than pg_
While performing db dump (from postgresql 8.4), pgAdmin stores CREATE
LANGUAGE in following way:
CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
This syntax is not compatible with postgresql 8.4
OR REPLACE has been added in v9.0
Reference
http://www.postgresql.org/docs/8.4/static/sql-createlang
What database server version? I just tested here with 9.0 and 1.14.3,
and I don't see the triggers, either with or without Show System
Objects enabled.
I reported it happens with postgresql 8.4
Now I checked v9.0.2 and indeed RI constraints are hidden.
So looks that this issue is related only t
Thanx for the answer
To make test, I de-installed v1.14.0 and v1.16.0-beta. Restarted system
and installed v1.14.3
Unfortunately without success. RI Constraint triggers appear in object
browser, SQL pane and even in table create script.
See picture at: http://img440.imageshack.us/img440/1986/pg
Hello
We have found this issue while working with postgresql 8.4
pgAdmin run under Windows7 64bit. Confirmed by all guys working with
pgAdmin 1.14.3 on Win7 (others are working with older ver of pgAdmin)
Dne 8.6.2012 11:49, Ashesh Vashi napsal(a):
Hi Michal,
Can you please tell us, on which
Hello guys.
I want to report serious bug in pgAdmin 1.14.3.
SQL pane, as well as create script for functions shows no defaults for
function arguments. Doesn't matter if it is DEFAULT NULL nor some other
datatype
On the other hand function properties window shows defaults as expected.
v1.14.0 s
ck to 14.0 just to manage this. Now
I tried v1.16 and I see that those triggers still exists. Of course
"Show system objects in the treeeview" is unchecked.
So again: how to hide thise triggers from treeview
with regards.
Michal Kozusznik
--
Sent via pgadmin-support mailing list (
71 matches
Mail list logo
