pgadmin-org / pgadmin3 Goto Github PK
View Code? Open in Web Editor NEWArchive of the pgAdmin III project
Home Page: https://www.pgadmin.org/
License: Other
Archive of the pgAdmin III project
Home Page: https://www.pgadmin.org/
License: Other
Issue migrated from Redmine: https://redmine.postgresql.org/issues/319
Originally created by Anonymous at 2009-08-06 11:02:29 UTC.
Add the partition name to the proprties pane when viewing the partitions of a table on [[GreenPlum]]
Issue migrated from Redmine: https://redmine.postgresql.org/issues/317
Originally created by Anonymous at 2009-08-06 10:59:01 UTC.
Issues with control characters creeping in on Windows
Issue migrated from Redmine: https://redmine.postgresql.org/issues/2
Originally created by Magnus Hagander at 2009-04-24 13:34:55 UTC.
The code for parsing and generating connection parameters is duplicated in several places (both in "just pgadmin" and between pgadmin and the debugger).
I noticed this in the number of places I had to touch to do the sslverify/sslmode work.
This seems like a good candidate for refactoring to avoid making such mistakes again :-)
Issue migrated from Redmine: https://redmine.postgresql.org/issues/307
Originally created by Anonymous at 2009-08-06 10:24:10 UTC.
Just a little bug.
In the query tool screen, each time we switch from "Graphical Query
Builder" pane to "SQL Editor" pane a new item is added
to Menu Query : "Generate SQL from Graphical query builder model".
If we switch 10 times then 10 entries is added to menu.
Environment:
Windows XP pro sp3
[[PgAdmin]] 1.10.0
Issue migrated from Redmine: https://redmine.postgresql.org/issues/303
Originally created by Magnus Hagander at 2009-08-05 13:17:35 UTC.
Implement the ability to save the graphical explain output to a (PNG) file, instead of having to take a screenshot.
There is an original patch by Magnus in the archives for this that "almost worked", but Ashesh is working on this now combined with some other work.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/1
Originally created by Anonymous at 2009-03-31 07:39:46 UTC.
Some minor Greenplum specific stuff.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/302
Originally created by Dave Page at 2009-08-04 08:06:23 UTC.
On Mac OS X, data is retrieved from the clipboard as UTF16, which may include embedded nulls. This can cause the data to be truncated.
Fixed in wxWidgets for 3.x: http://trac.wxwidgets.org/ticket/10902
Thanks to Stephan Jaensch for tracking down the fix.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/338
Originally created by Anonymous at 2009-08-27 15:25:43 UTC.
i'm using pgadmin tunneling through ssh,
anyone knows if there is a way to connect directly
from pgadmin using tunneling without use a shell interface + ssh?
Issue migrated from Redmine: https://redmine.postgresql.org/issues/295
Originally created by Guillaume Lelarge at 2009-05-04 19:51:28 UTC.
Add a cursors list in the server status window
Issue migrated from Redmine: https://redmine.postgresql.org/issues/334
Originally created by Anonymous at 2009-08-18 21:21:39 UTC.
Almost all Windows applications remember the maximize state of their windows the next time they start up. I've noticed that this is not true for pgAdmin; by default it always starts up non-maximized. Changing the shortcut's properties to force maximization works for the main window, but new query windows are still non-maximized.
This is a minor issue, but saving the maximize state is a very widely-accepted convention. Windows users are accustomed to closing a maximized window by moving the mouse to the upper-right corner of the screen. A window, i.e. a new query window, that always starts up non-maximized can be irritating, because the usual gesture to close it ends up closing the application behind it instead.
Using version 1.10.0 (also present in 1.8.4) on Windows XP Pro SP3
Issue migrated from Redmine: https://redmine.postgresql.org/issues/333
Originally created by Anonymous at 2009-08-17 10:22:35 UTC.
If the Edit Grid is displaying a table/view, it should be able to refresh successfully if the table/view is recreated underneath it.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/310
Originally created by Dave Page at 2009-08-06 10:30:10 UTC.
Syntax error when viewing the dependencies of a sequence
Issue migrated from Redmine: https://redmine.postgresql.org/issues/332
Originally created by Anonymous at 2009-08-17 10:18:58 UTC.
When running a script option from a treeview node, we should refresh the node whenever the script is executed to try to keep the tree in sync. This will probably involve passing a pointer to the treeview node to frmQuery, and refreshing it when the query returns.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/321
Originally created by Anonymous at 2009-08-06 11:11:42 UTC.
After the changed grid editor, now in Kubuntu 9:04 - Jaunty, pgadmin3 on any table in the Data View when trying to copy contents of grid cell with Ctrl-C make core dump.
My svn build:
root @ vlD-home: / media/sda5/tmp/pgadmin3-svn #. / checkout.sh
Checked out revision 7984
root @ vlD-home: / media/sda5/tmp/pgadmin3-svn # cd pgadmin3
root @ vlD-home: / # media/sda5/tmp/pgadmin3-svn/pgadmin3 bash bootstrap
Aclocal checking ...
Checking automake ...
Stamping the version number ...
Configuring the build system ...
[[PostgreSQL]] directory: / media/sda5/postgresql-8.4/8.4
[[PostgreSQL]] pg_config binary: / media/sda5/postgresql-8.4/8.4/bin/pg_config
[[PostgreSQL]] version: [[PostgreSQL]] 8.4beta1
[[PostgreSQL]] SSL support: Present
wxWidgets directory: / usr
wxWidgets wx-config binary: / usr / bin / wx-config
wxWidgets version: wxWidgets 2.8.9
libxml2 directory: / usr
libxml2 xml2-config binary: / usr/bin/xml2-config
libxml2 version: libxml2 2.6.32
libxslt directory: / usr
XSLT libxslt-config binary: / usr / bin / XSLT-config
libxslt version: libxslt 1.1.24
Building a debug version of pgAdmin: Yes
Statically linking pgAdmin: No
Building a Mac OS X appbundle: No
pgAdmin configuration is now complete. You can now compile and
install pgAdmin using 'make, make install'.
root @ vlD-home: / tmp # / usr/local/pgadmin3/bin/pgadmin3
Segmentation fault (core dumped)
root @ vlD-home: / tmp # ls-l
total 14228
-RW ------- 1 root root 0 2009-07-26 22:49 atievntX.ER87Rl
-RW ------- 1 root root 23556096 2009-07-26 22:48 core
drwxr-XR-x 2 root root 4096 2009-07-26 22:38 hsperfdata_root
drwxr-XR-x 2 root root 4096 2009-07-26 22:38 jarfscacheroot
drwx ------ 3 root root 4096 2009-07-26 18:03 kde-root
drwx ------ 2 root root 4096 2009-07-26 22:41 ksocket-root
drwx ------ 2 root root 4096 2009-07-26 22:16 orbit-root
drwx ------ 2 root root 4096 2009-07-26 18:03 pulse-ZzsRwpC5iUza
drwxr-XR-x 2 root root 4096 2009-07-26 22:37 root-cnd67-caches-0
drwx ------ 2 root root 4096 2009-07-26 18:02 ssh-afihn12827
root @ vlD-home: / tmp # gdb / usr/local/pgadmin3/bin/pgadmin3 core
GNU gdb 6.8-debian
Copyright (C) 2008 Free Software Foundation, Inc..
License GPLv3 +: GNU GPL version 3 or later
http://gnu.org/licenses/gpl.html
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "i486-linux-gnu" ...
Warning: Can not read pathname for load map: Input / output error.
Reading symbols from / usr/lib/libkrb5.so.3...done.
Loaded symbols for / usr/lib/libkrb5.so.3
Reading symbols from / usr/lib/libwx_gtk2ud_stc-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_stc-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_ogl-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_ogl-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_richtext-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_richtext-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_aui-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_aui-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_xrc-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_xrc-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_qa-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_qa-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_html-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_html-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_adv-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_adv-2.8.so.0
Reading symbols from / usr/lib/libwx_gtk2ud_core-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_gtk2ud_core-2.8.so.0
Reading symbols from / usr/lib/libwx_baseud_xml-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_baseud_xml-2.8.so.0
Reading symbols from / usr/lib/libwx_baseud_net-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_baseud_net-2.8.so.0
Reading symbols from / usr/lib/libwx_baseud-2.8.so.0...done.
Loaded symbols for / usr/lib/libwx_baseud-2.8.so.0
Reading symbols from / usr/lib/libxml2.so.2...done.
Loaded symbols for / usr/lib/libxml2.so.2
Reading symbols from / usr/lib/libxslt.so.1...done.
Loaded symbols for / usr/lib/libxslt.so.1
Reading symbols from / usr/lib/libpq.so.5...done.
Loaded symbols for / usr/lib/libpq.so.5
Reading symbols from / usr / lib / libstdc + +. So.6 ... done.
Loaded symbols for / usr / lib / libstdc + +. So.6
Reading symbols from / lib/tls/i686/cmov/libm.so.6...done.
Loaded symbols for / lib/tls/i686/cmov/libm.so.6
Reading symbols from / lib/libgcc_s.so.1...done.
Loaded symbols for / lib/libgcc_s.so.1
Reading symbols from / lib/tls/i686/cmov/libpthread.so.0...done.
Loaded symbols for / lib/tls/i686/cmov/libpthread.so.0
Reading symbols from / lib/tls/i686/cmov/libc.so.6...done.
Loaded symbols for / lib/tls/i686/cmov/libc.so.6
Reading symbols from / usr/lib/libk5crypto.so.3...done.
Loaded symbols for / usr/lib/libk5crypto.so.3
Reading symbols from / lib/libcom_err.so.2...done.
Loaded symbols for / lib/libcom_err.so.2
Reading symbols from / usr/lib/libkrb5support.so.0...done.
Loaded symbols for / usr/lib/libkrb5support.so.0
Reading symbols from / lib/libkeyutils.so.1...done.
Loaded symbols for / lib/libkeyutils.so.1
Reading symbols from / lib/tls/i686/cmov/libresolv.so.2...done.
Loaded symbols for / lib/tls/i686/cmov/libresolv.so.2
Reading symbols from / lib/libz.so.1...done.
Loaded symbols for / lib/libz.so.1
Reading symbols from / lib/tls/i686/cmov/libdl.so.2...done.
Loaded symbols for / lib/tls/i686/cmov/libdl.so.2
Reading symbols from / usr/lib/libgtk-x11-2.0.so.0...done.
Loaded symbols for / usr/lib/libgtk-x11-2.0.so.0
Reading symbols from / usr/lib/libgdk-x11-2.0.so.0...done.
Loaded symbols for / usr/lib/libgdk-x11-2.0.so.0
Reading symbols from / usr/lib/libatk-1.0.so.0...done.
Loaded symbols for / usr/lib/libatk-1.0.so.0
Reading symbols from / usr/lib/libpangoft2-1.0.so.0...done.
Loaded symbols for / usr/lib/libpangoft2-1.0.so.0
Reading symbols from / usr/lib/libgdk_pixbuf-2.0.so.0...done.
Loaded symbols for / usr/lib/libgdk_pixbuf-2.0.so.0
Reading symbols from / usr/lib/libgio-2.0.so.0...done.
Loaded symbols for / usr/lib/libgio-2.0.so.0
Reading symbols from / usr/lib/libpango-1.0.so.0...done.
Loaded symbols for / usr/lib/libpango-1.0.so.0
Reading symbols from / usr/lib/libfreetype.so.6...done.
Loaded symbols for / usr/lib/libfreetype.so.6
Reading symbols from / usr/lib/libfontconfig.so.1...done.
Loaded symbols for / usr/lib/libfontconfig.so.1
Reading symbols from / usr/lib/libgobject-2.0.so.0...done.
Loaded symbols for / usr/lib/libgobject-2.0.so.0
Reading symbols from / usr/lib/libgmodule-2.0.so.0...done.
Loaded symbols for / usr/lib/libgmodule-2.0.so.0
Reading symbols from / usr/lib/libgthread-2.0.so.0...done.
Loaded symbols for / usr/lib/libgthread-2.0.so.0
Reading symbols from / lib/tls/i686/cmov/librt.so.1...done.
Loaded symbols for / lib/tls/i686/cmov/librt.so.1
Reading symbols from / usr/lib/libglib-2.0.so.0...done.
Loaded symbols for / usr/lib/libglib-2.0.so.0
Reading symbols from / usr/lib/libXinerama.so.1...done.
Loaded symbols for / usr/lib/libXinerama.so.1
Reading symbols from / usr/lib/libSM.so.6...done.
Loaded symbols for / usr/lib/libSM.so.6
Reading symbols from / usr/lib/libpng12.so.0...done.
Loaded symbols for / usr/lib/libpng12.so.0
Reading symbols from / usr/lib/libjpeg.so.62...done.
Loaded symbols for / usr/lib/libjpeg.so.62
Reading symbols from / usr/lib/libtiff.so.4...done.
Loaded symbols for / usr/lib/libtiff.so.4
Reading symbols from / usr/lib/libexpat.so.1...done.
Loaded symbols for / usr/lib/libexpat.so.1
Reading symbols from / lib/i686/cmov/libssl.so.0.9.8...done.
Loaded symbols for / lib/i686/cmov/libssl.so.0.9.8
Reading symbols from / lib/i686/cmov/libcrypto.so.0.9.8...done.
Loaded symbols for / lib/i686/cmov/libcrypto.so.0.9.8
Reading symbols from / usr/lib/libgssapi_krb5.so.2...done.
Loaded symbols for / usr/lib/libgssapi_krb5.so.2
Reading symbols from / lib/tls/i686/cmov/libcrypt.so.1...done.
Loaded symbols for / lib/tls/i686/cmov/libcrypt.so.1
Reading symbols from / usr/lib/libldap_r-2.4.so.2...done.
Loaded symbols for / usr/lib/libldap_r-2.4.so.2
Reading symbols from / lib/ld-linux.so.2...done.
Loaded symbols for / lib/ld-linux.so.2
Reading symbols from / usr/lib/libXext.so.6...done.
Loaded symbols for / usr/lib/libXext.so.6
Reading symbols from / usr/lib/libXrender.so.1...done.
Loaded symbols for / usr/lib/libXrender.so.1
Reading symbols from / usr/lib/libXi.so.6...done.
Loaded symbols for / usr/lib/libXi.so.6
Reading symbols from / usr/lib/libXrandr.so.2...done.
Loaded symbols for / usr/lib/libXrandr.so.2
Reading symbols from / usr/lib/libXcursor.so.1...done.
Loaded symbols for / usr/lib/libXcursor.so.1
Reading symbols from / usr/lib/libpangocairo-1.0.so.0...done.
Loaded symbols for / usr/lib/libpangocairo-1.0.so.0
Reading symbols from / usr/lib/libX11.so.6...done.
Loaded symbols for / usr/lib/libX11.so.6
Reading symbols from / usr/lib/libXcomposite.so.1...done.
Loaded symbols for / usr/lib/libXcomposite.so.1
Reading symbols from / usr/lib/libXdamage.so.1...done.
Loaded symbols for / usr/lib/libXdamage.so.1
Reading symbols from / usr/lib/libXfixes.so.3...done.
Loaded symbols for / usr/lib/libXfixes.so.3
Reading symbols from / usr/lib/libcairo.so.2...done.
Loaded symbols for / usr/lib/libcairo.so.2
Reading symbols from / lib/libpcre.so.3...done.
Loaded symbols for / lib/libpcre.so.3
Reading symbols from / lib/libselinux.so.1...done.
Loaded symbols for / lib/libselinux.so.1
Reading symbols from / usr/lib/libICE.so.6...done.
Loaded symbols for / usr/lib/libICE.so.6
Reading symbols from / lib/libuuid.so.1...done.
Loaded symbols for / lib/libuuid.so.1
Reading symbols from / usr/lib/liblber-2.4.so.2...done.
Loaded symbols for / usr/lib/liblber-2.4.so.2
Reading symbols from / usr/lib/libsasl2.so.2...done.
Loaded symbols for / usr/lib/libsasl2.so.2
Reading symbols from / usr/lib/libgnutls.so.26...done.
Loaded symbols for / usr/lib/libgnutls.so.26
Reading symbols from / usr/lib/libtasn1.so.3...done.
Loaded symbols for / usr/lib/libtasn1.so.3
Reading symbols from / lib/libgcrypt.so.11...done.
Loaded symbols for / lib/libgcrypt.so.11
Reading symbols from / usr/lib/libXau.so.6...done.
Loaded symbols for / usr/lib/libXau.so.6
Reading symbols from / usr/lib/libxcb.so.1...done.
Loaded symbols for / usr/lib/libxcb.so.1
Reading symbols from / usr/lib/libpixman-1.so.0...done.
Loaded symbols for / usr/lib/libpixman-1.so.0
Reading symbols from / usr/lib/libdirectfb-1.0.so.0...done.
Loaded symbols for / usr/lib/libdirectfb-1.0.so.0
Reading symbols from / usr/lib/libfusion-1.0.so.0...done.
Loaded symbols for / usr/lib/libfusion-1.0.so.0
Reading symbols from / usr/lib/libdirect-1.0.so.0...done.
Loaded symbols for / usr/lib/libdirect-1.0.so.0
Reading symbols from / usr/lib/libxcb-render-util.so.0...done.
Loaded symbols for / usr/lib/libxcb-render-util.so.0
Reading symbols from / usr/lib/libxcb-render.so.0...done.
Loaded symbols for / usr/lib/libxcb-render.so.0
Reading symbols from / lib/libgpg-error.so.0...done.
Loaded symbols for / lib/libgpg-error.so.0
Reading symbols from / usr/lib/libXdmcp.so.6...done.
Loaded symbols for / usr/lib/libXdmcp.so.6
Reading symbols from / usr/lib/gconv/UTF-32.so...done.
Loaded symbols for / usr/lib/gconv/UTF-32.so
Reading symbols from / lib/tls/i686/cmov/libnss_compat.so.2...done.
Loaded symbols for / lib/tls/i686/cmov/libnss_compat.so.2
Reading symbols from / lib/tls/i686/cmov/libnsl.so.1...done.
Loaded symbols for / lib/tls/i686/cmov/libnsl.so.1
Reading symbols from / lib/tls/i686/cmov/libnss_nis.so.2...done.
Loaded symbols for / lib/tls/i686/cmov/libnss_nis.so.2
Reading symbols from / lib/tls/i686/cmov/libnss_files.so.2...done.
Loaded symbols for / lib/tls/i686/cmov/libnss_files.so.2
Reading symbols from /
usr/lib/gtk-2.0/modules/libcanberra-gtk-module.so...done.
Loaded symbols for / usr/lib/gtk-2.0/modules/libcanberra-gtk-module.so
Reading symbols from / usr/lib/libcanberra-gtk.so.0...done.
Loaded symbols for / usr/lib/libcanberra-gtk.so.0
Reading symbols from / usr/lib/libcanberra.so.0...done.
Loaded symbols for / usr/lib/libcanberra.so.0
Reading symbols from / usr/lib/libvorbisfile.so.3...done.
Loaded symbols for / usr/lib/libvorbisfile.so.3
Reading symbols from / usr/lib/libvorbis.so.0...done.
Loaded symbols for / usr/lib/libvorbis.so.0
Reading symbols from / usr/lib/libogg.so.0...done.
Loaded symbols for / usr/lib/libogg.so.0
Reading symbols from / usr/lib/libtdb.so.1...done.
Loaded symbols for / usr/lib/libtdb.so.1
Reading symbols from / usr/lib/libltdl.so.7...done.
Loaded symbols for / usr/lib/libltdl.so.7
Reading symbols from / usr/lib/gtk-2.0/2.10.0/engines/libqtcurve.so...done.
Loaded symbols for / usr/lib/gtk-2.0/2.10.0/engines/libqtcurve.so
Reading symbols from /
usr/lib/pango/1.6.0/modules/pango-basic-fc.so...done.
Loaded symbols for / usr/lib/pango/1.6.0/modules/pango-basic-fc.so
Reading symbols from / usr/lib/libcanberra-0.11/libcanberra-alsa.so...done.
Loaded symbols for / usr/lib/libcanberra-0.11/libcanberra-alsa.so
Reading symbols from / usr/lib/libasound.so.2...done.
Loaded symbols for / usr/lib/libasound.so.2
Reading symbols from /
usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-xpm.so...done.
Loaded symbols for / usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-xpm.so
Reading symbols from /
usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-png.so...done.
Loaded symbols for / usr/lib/gtk-2.0/2.10.0/loaders/libpixbufloader-png.so
Core was generated by @/ usr/local/pgadmin3/bin/pgadmin3.
Program terminated with signal 11, Segmentation fault.
[New process 4252]
(gdb) BT
.. / src / generic / grid.cpp: 871
0xbfbc12f4) at. / FRM / frmEditGrid.cpp: 663
0xa64b6a8, func = 0x80782b8 _ZNK20wxGridCellTextEditor8GetValueEv@plt,
event = @ 0xbfbc12f4)
at .. / src / common / appbase.cpp: 322
0x87973c8, handler = 0xa64b6a8, event = @ 0xbfbc12f4) at .. / src /
common / event.cpp: 1231
h1. @ 0xbfbc12f4, self
0xa64b6a8) at .. / src / common / event.cpp: 906
@ 0xbfbc12f4) at .. / src / common / event.cpp: 1293
@ 0xbfbc12f4) at .. / src / common / event.cpp: 1300
0xa67c8b0) at .. / src / gtk / menu.cpp: 653
usr/lib/libgobject-2.0.so.0
usr/lib/libgobject-2.0.so.0
usr/lib/libgobject-2.0.so.0
usr/lib/libgtk-x11-2.0.so.0
usr/lib/libgtk-x11-2.0.so.0
usr/lib/libgtk-x11-2.0.so.0
usr/lib/libgobject-2.0.so.0
usr/lib/libgtk-x11-2.0.so.0
usr/lib/libglib-2.0.so.0
gtk / evtloop.cpp: 76
common / appcmn.cpp: 312
--- Type to continue, or q to quit ---
common / appcmn.cpp: 367
/ src / common / init.cpp: 460
.. / src / common / init.cpp: 472
./pgAdmin3.cpp: 113
(gdb)
Issue migrated from Redmine: https://redmine.postgresql.org/issues/337
Originally created by Guillaume Lelarge at 2009-08-24 13:16:29 UTC.
It's really too restrictive. I don't see what this requirement gives us. We should get rid of it.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/294
Originally created by Guillaume Lelarge at 2009-05-04 19:50:22 UTC.
Nowadays, it's impossible to change the schema with pgAdmin's UI. One needs to write the SQL statement to do it and refresh the treview to see it.
It would be great to have a schema combobox in each properties dialog.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/292
Originally created by Guillaume Lelarge at 2009-05-04 19:44:52 UTC.
Use case:
Having to administrate around 150 [[PostgreSQL]] servers. 150 registered servers will probably be a mess in the treeview. We don't have grouping functionality, folder-like to group servers by
<insert here everyone's idea> (geographical for example: one group for all Paris servers, another one for all servers in Marseilles, etc.).
Even better if it can dynamically create the node when needed, so that you can register servers directly under the "root" node. Then there won't be "an extra click" for those who just have 5-10 servers and don't need the grouping.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/301
Originally created by Anonymous at 2009-06-26 08:13:33 UTC.
We are users of your great tool pgAdmin since we started migrating
projects to [[PostgreSQl]]. But just two days ago we noticed a very nasty
bug in the otherwise very great little tool pgScript.
One of our developers needed to fire a lot of updates for a specific
range of values, so he wrote a neat little pgScript code to do it.
Essentially only a loop with some variables which are incremented and
passed to an UPDATE statement. But some days ago he also noticed a very
nasty behavior while running two pgScript in two different query windows
at the same time (he needed to run it against many diferent DBs). As he
had some PRINT outputs to monitor the advance of his script he noticed,
that one script got some absolutely wrong values for one of his
variables.
The I wrote a simplified version of the loop - even left out the SQL
code (!) - to look what happens. And as soon as I run them it TWO query
windows (but started from the same pgAdmin process!) I could notice the
weirdest behaviors one could expect. The most usual was early
termination of the loop - without error messages - but there were also
loops which then run much longer as their target value would have
suggested. In one case, we even got an "unhandled exception" which
completely nuked pgAdmin.
As soon as we did not run in TWO threads in ONE process, but instead run
the Query in two different processes (started pgAdmin twice and opened
one Query window in each), everything was fine. We could run the script
as often as we wanted (and the same time as the other was running) and
nothing went wrong. The script went just trough deterministically.
So, from this observations I would dare to say, that this looks like
some very basic "thread safety" precautions were omitted in the pgScript
code.
I would also say, that this is a dangerous BUG! Think about a similar
script like ours, which has to delete data from a specific range. Now,
what if it deletes more, because the LOOP runs longer?@
And you might also ask, why the hell we would run more than one similar
scripts at the same time? Well, if you need to do a maintenance task
(the same task) for many DBs or Servers, you might easily come up with
the idea to do it from many query windows.
Finally, I would - of course - share the simple script, which helps to
reproduce the odd behavior. With it, I hope, you can quickly pinpoint
the issue and fix it. Before that I would recommend to issue a warning
to users, to never run more then one pgScript rom the same process.
DECLARE @v_package;
DECLARE @v_purchaseidmin;
DECLARE @v_purchaseidmax;
DECLARE @v_to;
DECLARE @v_from;
DECLARE @v_i;
SET @v_package = 10;
SET @v_purchaseidmin = 0;
SET @v_purchaseidmax = 120000000;
SET @v_from = @v_purchaseidmin;
SET @v_to = (@v_purchaseidmin + @v_package);
SET @v_i = 1;
WHILE ( @v_from <= @v_purchaseidmax ) BEGIN
PRINT 'from: ' + CAST(@v_from AS STRING);
PRINT 'to: ' + CAST(@v_to AS STRING);
PRINT 'i: ' + CAST(@v_i AS STRING);
-- some SQL code could be executed here
SET @v_from = (@v_from + @v_package);
SET @v_to = (@v_to + @v_package);
SET @v_i = @v_i+1;
Issue migrated from Redmine: https://redmine.postgresql.org/issues/309
Originally created by Anonymous at 2009-08-06 10:29:14 UTC.
Some typos
Issue migrated from Redmine: https://redmine.postgresql.org/issues/328
Originally created by Anonymous at 2009-08-06 15:55:28 UTC.
The title is ok but the description field is empty.
For more informations, go to the [[RedHat]] BTS: https://bugzilla.redhat.com/show_bug.cgi?id=513039
Issue migrated from Redmine: https://redmine.postgresql.org/issues/339
Originally created by Anonymous at 2009-08-30 16:18:09 UTC.
Problem occur when I have more than one schema.
When I create domain for TEST_SCHEMA and set owner, pgadmin add the line:
ALTER DOMAIN "PT2" OWNER TO postgres; and I get error.
It Should be:
ALTER DOMAIN test_schema."PT2" OWNER TO postgres;
but schema name is not consider.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/299
Originally created by Guillaume Lelarge at 2009-05-04 19:57:24 UTC.
Display the locks in a logical tree rather than a list (in the server status window)
Issue migrated from Redmine: https://redmine.postgresql.org/issues/335
Originally created by Anonymous at 2009-08-19 07:53:36 UTC.
In the Create/Edit Dialog for columns, after have saved a long comment that changes the field to scrollbars, when re-open the Create/Edit Dialog for the column, the "Use Replication" label and field are pushed out of viewable area. The top portion of the words "Use Replication" are barely discernable.
My environment: Windows 2003 Server Native Japanese. Postgresql 8.4. [[PgAdmin]] III 1.10.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/323
Originally created by Anonymous at 2009-08-06 11:14:53 UTC.
It solves translation for object type names in reports.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/331
Originally created by Anonymous at 2009-08-10 20:44:46 UTC.
Is there any hope of fixing the problems that [[PgAdmin]] has when it loses a connection? In an SQL window, if the connection is lost, and I ask to rerun the query (more than once), [[PgAdmin]] crashes. In the main, it will close the browser.
Is there any way for it to try to reconnect before it reports problems. Often, it may be the fact that the server drops the connection (or a network issue) if there is no activity for a period of time, and a reconnect behind the scenes would be really helpful.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/306
Originally created by Anonymous at 2009-08-06 10:22:11 UTC.
This is a new error message. I have been using 1.10.0 (jun 29 2009, rev:
7942:7934M) for a number of weeks now, and I am just now seeing this error
message. It only occurs the first time I ask the see a function. After that
(even for other functions) it does not happen.
The server is Postgres 8.1.9, under Linux 3.2.3-58.
2009-07-20 08:14:09 STATUS : Retrieving Function details...
2009-07-20 08:14:09 STATUS : Retrieving Function details... (0.00 secs)
2009-07-20 08:14:09 QUERY : Scalar query (tgcdb.teragrid.org:5432): SHOW
shared_preload_libraries;
2009-07-20 08:14:09 ERROR : ERROR: unrecognized configuration parameter
"shared_preload_libraries"
Issue migrated from Redmine: https://redmine.postgresql.org/issues/324
Originally created by Anonymous at 2009-08-06 11:16:41 UTC.
patch to do sequence statistics description translateable.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/298
Originally created by Guillaume Lelarge at 2009-05-04 19:56:22 UTC.
Ability to select a running backend, and copy the query straight into a new query tool window
Issue migrated from Redmine: https://redmine.postgresql.org/issues/316
Originally created by Magnus Hagander at 2009-08-06 10:35:35 UTC.
Properly include the counter variable in the message when
deleting multiple rows, instead of getting a completely random
number (usually very large, from random memory location) in
the message
Issue migrated from Redmine: https://redmine.postgresql.org/issues/304
Originally created by Dave Page at 2009-08-06 10:15:51 UTC.
Error thrown when examining a Slony 2.x cluster.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/326
Originally created by Anonymous at 2009-08-06 13:42:16 UTC.
When adding a new server in pgadmin3 that has no IPv4 address, I get the error:
An error has occurred:
Could not resolve hostname db.deor
It also doesn't accept the literal IPv6 address, complaining it can't resolve it.
I guess it just needs some IPv6 resolver/socket code, as the [[PostgreSQL]] client/server stuff is all perfectly v6-aware.
This is version 1.8.4-3, from Jaunty.
Ubuntu BTS ticket: https://bugs.launchpad.net/ubuntu/+source/pgadmin3/+bug/374656
Issue migrated from Redmine: https://redmine.postgresql.org/issues/336
Originally created by Anonymous at 2009-08-21 07:49:55 UTC.
I am using [[PgAdmin]] 1.10.0 with Postgresql 8.3.7 on Windows XP Pro (SP3).
The problem I am facing deals with savepoint and rollback management in [[PgAdmin]]. I initiate a transaction, then I run different queries, create a savepoint :
BEGIN;
CREATE temp TABLE toto (id int);
INSERT INTO toto VALUES (1);
SAVEPOINT my_save;
Then, I execute a wrong query :
SELECT * FROM tot;
I get an error message :
ERROR: relation "toto" does not exist
********** Erreur **********
ERROR: relation "toto" does not exist
État SQL :42P01
But I can't rollback to my savepoint, because a complete rollback has already been executed by [[PgAdmin]] :
ROLLBACK TO my_save;
ERROR: ROLLBACK TO SAVEPOINT can only be used in transaction blocks
********** Erreur **********
ERROR: ROLLBACK TO SAVEPOINT can only be used in transaction blocks
État SQL :25P01
This problem seems to come from the fact that [[PgAdmin]] executes code in a single transaction statement... How is it possible to create different transaction statements within [[PgAdmin]], in order to use savepoints ?
Thanks in advance for your help.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/312
Originally created by Dave Page at 2009-08-06 10:31:44 UTC.
http://code.pgadmin.org/trac/changeset/7993/branches/REL-1_10_0_PATCHES
Issue migrated from Redmine: https://redmine.postgresql.org/issues/329
Originally created by Anonymous at 2009-08-07 15:10:42 UTC.
this is no bug, but a little bit annoying: I sometimes accidently hit
the tab "Graphical Query Builder" in the Query window. No big deal, I
just click on "SQL Editor" to get back, but then a dialog pops up: "No
SQL query was generated.".
Wouldn't it be possible to suppress that dialog?
Issue migrated from Redmine: https://redmine.postgresql.org/issues/318
Originally created by Anonymous at 2009-08-06 11:01:04 UTC.
Cache datatypes in dlgTable, so they don't have to be reloaded by dlgColumn, which may be used multiple times when creating a table [].
Issue migrated from Redmine: https://redmine.postgresql.org/issues/293
Originally created by Guillaume Lelarge at 2009-05-04 19:47:43 UTC.
From Heikki:
There's still a lot of troublesome constructs like “Cannot drop system %s”, where %s is replaced with “View”, “Sequence” etc. That doesn't work for many languages, including Finnish, where the following word needs to be inflected differently depending on the context.
and:
For messages like ”%d seconds”, ”%d rows”, the plural forms of the formatting functions/macros should be used, see http://www.gnu.org/software/gettext/manual/gettext.html#Plural-forms. Google suggests that wxWidgets has a wxPLURAL macro for plural forms, that works like the _() macro that's used for normal strings.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/305
Originally created by Anonymous at 2009-08-06 10:19:41 UTC.
Hello,
Here is my setup:
Steps to reproduce the bug:
Note: The same happens if I try to add a step and the "Step
Definition" dialog is closed.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/311
Originally created by Dave Page at 2009-08-06 10:30:54 UTC.
Bug in foreign key creation on Solaris
Issue migrated from Redmine: https://redmine.postgresql.org/issues/315
Originally created by Dave Page at 2009-08-06 10:34:42 UTC.
Include comments on procedures in the reverse engineered SQL
Issue migrated from Redmine: https://redmine.postgresql.org/issues/320
Originally created by Guillaume Lelarge at 2009-08-06 11:07:46 UTC.
Here are three patches for statistics on various objects:
I did a patch for each one because I'm not sure they will all be accepted right away. For the database one, I'm not sure that copying the [DisplayStatistics] function code is the better way to make it work. On the index one, should I also display statistics for primary key and unique constraints? it seems it would be a good idea. But it would meant that only these constraints would be displayed. CHECK constraints, for example, would be invisible. Comments?
Issue migrated from Redmine: https://redmine.postgresql.org/issues/296
Originally created by Guillaume Lelarge at 2009-05-04 19:53:31 UTC.
We need to create columns for each differents informations in the logfile (log_line_prefix is an hint to parse the log text).
Issue migrated from Redmine: https://redmine.postgresql.org/issues/325
Originally created by Anonymous at 2009-08-06 11:29:09 UTC.
When you try to restore some database from backup file pgadmin3 pops up [[FileSelection]] dialog from gtk. I can choose here between showing ".backup" or ".*" files.
The second filter howerver doesn't show all files. To show all files in this dialog there muste be "*" filter.
Right now you cannot open files named: "my-cool-backup", "something" "coolDatabase"... etc..
Complete Debian bug report on: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=451038
Issue migrated from Redmine: https://redmine.postgresql.org/issues/308
Originally created by Anonymous at 2009-08-06 10:27:56 UTC.
Hi, when I save a macro in the Macros management and click on OK raise an error:
"Failed to write to macros file" (where will be saved?)
However Macros works.
[[PgAdmin]] 1.10 running on Windows XP SP3
I hope this help!
Issue migrated from Redmine: https://redmine.postgresql.org/issues/327
Originally created by Anonymous at 2009-08-06 15:51:41 UTC.
See https://bugzilla.redhat.com/show_bug.cgi?id=516017 for more informations.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/330
Originally created by Anonymous at 2009-08-07 15:42:07 UTC.
I usually use hibernation instead of shut down - to carry on with work in the morning. The problem is that I can't carry on with work using pgAdmin - it says that connection is lost to server few times and goes to disconnected from server state. Then I have to connect again. All query windows loses connections as well. I have to connect them also.
My question is - do we really need to be connected to server all the time? Why not "connect when needed" strategy? Maybe theres an setting I don't know about? Is there a workaround?
Issue migrated from Redmine: https://redmine.postgresql.org/issues/322
Originally created by Anonymous at 2009-08-06 11:14:51 UTC.
It solves translation for object type names in dialog Grand Wizard.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/300
Originally created by Guillaume Lelarge at 2009-05-04 20:02:42 UTC.
The postgresql.conf editor is not really usable right now because parameters are sorted in a weird way. Adding the capacity to filter, order and group settings would be much more interesting for the user experience.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/297
Originally created by Guillaume Lelarge at 2009-05-04 19:55:42 UTC.
Say green for running OK, orange for running, but with the query time being past a configurable limit, blue for idle, and red when waiting for a lock etc.
Issue migrated from Redmine: https://redmine.postgresql.org/issues/313
Originally created by Dave Page at 2009-08-06 10:32:42 UTC.
Bug on debugger name resolution on 64 bit Solaris
Issue migrated from Redmine: https://redmine.postgresql.org/issues/314
Originally created by Anonymous at 2009-08-06 10:33:50 UTC.
Typos
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.