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/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 ...

• Aclocal-1.10
• Autoheader
  -1.10 + automake - foreign - add-missing - copy
• Autoconf
  root @ vlD-home: / media/sda5/tmp/pgadmin3-svn/pgadmin3 #. / configure -
  enable-debug - with-pgsql = / media/sda5/postgresql-8.4/8.4>
  configure-out.log 2 > & 1
  root @ vlD-home: / media/sda5/tmp/pgadmin3-svn/pgadmin3 # make>
  make-out.log 2> & 1
  root @ vlD-home: / media/sda5/tmp/pgadmin3-svn/pgadmin3 # make install>
  make-install-out.log 2> & 1
  root @ vlD-home: / # media/sda5/tmp/pgadmin3-svn/pgadmin3

pgadmin3 is configured with the following options:

[[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'.

Exec pgadmin3:

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]

0 0x00000000 in? ()

(gdb) BT

0 0x00000000 in? ()

1 0xb7b53d1f in wxGridCellTextEditor:: [[GetValue]] (this = 0xa6f5ef0) at

.. / src / generic / grid.cpp: 871

2 0x08201434 in frmEditGrid: [[OnCopy]] (this = 0xa64b6a8, ev = @

0xbfbc12f4) at. / FRM / frmEditGrid.cpp: 663

3 0xb75cfa81 in wxAppConsole: [[HandleEvent]] (this = 0x9e75798, handler =

0xa64b6a8, func = 0x80782b8 _ZNK20wxGridCellTextEditor8GetValueEv@plt,
event = @ 0xbfbc12f4)
at .. / src / common / appbase.cpp: 322

4 0xb768da6a in wxEvtHandler: [[ProcessEventIfMatches]] (entry = @

0x87973c8, handler = 0xa64b6a8, event = @ 0xbfbc12f4) at .. / src /
common / event.cpp: 1231

5 0xb768f1f4 in wxEventHashTable: [[HandleEvent]] (this = 0x8797240, event

h1. @ 0xbfbc12f4, self
0xa64b6a8) at .. / src / common / event.cpp: 906

6 0xb768f346 in wxEvtHandler: [[ProcessEvent]] (this = 0xa64b6a8, event =

@ 0xbfbc12f4) at .. / src / common / event.cpp: 1293

7 0xb768f2cc in wxEvtHandler: [[ProcessEvent]] (this = 0xa64b8c4, event =

@ 0xbfbc12f4) at .. / src / common / event.cpp: 1300

8 0xb7911e85 in gtk_menu_clicked_callback (widget = 0xa642748, menu =

0xa67c8b0) at .. / src / gtk / menu.cpp: 653

9 0xb6ad23a4 in g_cclosure_marshal_VOID+VOID () from /

usr/lib/libgobject-2.0.so.0

10 0xb6ac4c7b in g_closure_invoke () from / usr/lib/libgobject-2.0.so.0

11 0xb6adae57 in? () From / usr/lib/libgobject-2.0.so.0

12 0xb6adc4b9 in g_signal_emit_valist () from /

usr/lib/libgobject-2.0.so.0

13 0xb6adc936 in g_signal_emit () from / usr/lib/libgobject-2.0.so.0

14 0xb6f90edf in? () From / usr/lib/libgtk-x11-2.0.so.0

15 0xb6ac4c7b in g_closure_invoke () from / usr/lib/libgobject-2.0.so.0

16 0xb6adae57 in? () From / usr/lib/libgobject-2.0.so.0

17 0xb6adc34f in g_signal_emit_valist () from /

usr/lib/libgobject-2.0.so.0

18 0xb6adc936 in g_signal_emit () from / usr/lib/libgobject-2.0.so.0

19 0xb6d95e49 in gtk_accel_group_activate () from /

usr/lib/libgtk-x11-2.0.so.0

20 0xb6d95f4d in gtk_accel_groups_activate () from /

usr/lib/libgtk-x11-2.0.so.0

21 0xb6fa13f7 in gtk_window_activate_key () from /

usr/lib/libgtk-x11-2.0.so.0

22 0xb6fa147c in? () From / usr/lib/libgtk-x11-2.0.so.0

23 0xb6e6f526 in? () From / usr/lib/libgtk-x11-2.0.so.0

24 0xb6ac33d9 in? () From / usr/lib/libgobject-2.0.so.0

25 0xb6ac4c7b in g_closure_invoke () from / usr/lib/libgobject-2.0.so.0

26 0xb6adaaff in? () From / usr/lib/libgobject-2.0.so.0

27 0xb6adc34f in g_signal_emit_valist () from /

usr/lib/libgobject-2.0.so.0

28 0xb6adc936 in g_signal_emit () from / usr/lib/libgobject-2.0.so.0

29 0xb6f8a2ae in? () From / usr/lib/libgtk-x11-2.0.so.0

30 0xb6e68041 in gtk_propagate_event () from /

usr/lib/libgtk-x11-2.0.so.0

31 0xb6e69327 in gtk_main_do_event () from / usr/lib/libgtk-x11-2.0.so.0

32 0xb6cf634a in? () From / usr/lib/libgdk-x11-2.0.so.0

33 0xb6a26b88 in g_main_context_dispatch () from /

usr/lib/libglib-2.0.so.0

34 0xb6a2a0eb in? () From / usr/lib/libglib-2.0.so.0

35 0xb6a2a5ba in g_main_loop_run () from / usr/lib/libglib-2.0.so.0

36 0xb6e697d9 in gtk_main () from / usr/lib/libgtk-x11-2.0.so.0

37 0xb788d41b in wxEventLoop:: Run (this = 0x9f52a48) at .. / src /

gtk / evtloop.cpp: 76

38 0xb7931b3c in wxAppBase:: [[MainLoop]] (this = 0x9e75798) at .. / src /

common / appcmn.cpp: 312
--- Type to continue, or q to quit ---

39 0xb7931891 in wxAppBase: [[OnRun]] (this = 0x8789668) at .. / src /

common / appcmn.cpp: 367

40 0xb76177ca in wxEntry (argc = @ 0xb77106cc, argv = 0x9e63e30) at ..

/ src / common / init.cpp: 460

41 0xb7617887 in wxEntry (argc = @ 0xbfbc20a0, argv = 0xbfbc2124) at

.. / src / common / init.cpp: 472

42 0x08092172 in main (argc =- 971495937, argv = 0x3068086d) at

./pgAdmin3.cpp: 113
(gdb)

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/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/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/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/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/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/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.

Here is the Script, start it from two query windows (from one process)
at the same time, and you should easily see what I mean:

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;

END

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/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/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/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/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/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/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/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/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/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/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/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/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/305
Originally created by Anonymous at 2009-08-06 10:19:41 UTC.

Hello,

Here is my setup:

• [[WinXPSP]]3
• [[PostgreSQL]] 8.4.0: postgresql-8.4.0-1-windows.exe
• pgAgent: pgAgent-3.0.0-win32.zip
  I have copied the exe and dll to the pg8.4 binary directory.
• pgAgent.sql was executed in database postgres
• pgAgent service is installed

Steps to reproduce the bug:

1. Select "New job" from the "Jobs" tree element context menu.
   (NOTE: The elipses are missing in the command text)
2. Enter a name for the job and close the dialog with OK.
3. Select command "Properties" from the context menu of the newly
   created job.
4. Activate the schedules tab and press "Add".
5. Close the schedule dialog using "Cancel".
6. BOOOOOMMMM r1

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/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/320
Originally created by Guillaume Lelarge at 2009-08-06 11:07:46 UTC.

Here are three patches for statistics on various objects:

• database: we had statistics on the Databases node but we didn't have them on each individual database node.
• indexes: we had statistics on each individual index node but we didn't have them on the Indexes node of each table.
• functions: we didn't have them at all, but it is now needed on 8.4.

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/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/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/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/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/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/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/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/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/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/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/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/314
Originally created by Anonymous at 2009-08-06 10:33:50 UTC.

Typos

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/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/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/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/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/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/309
Originally created by Anonymous at 2009-08-06 10:29:14 UTC.

Some typos

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/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/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/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.