I am using phppgadmin 3.5.2 connecting to a Postgres 8.0.1 on amd64. I am receiving this error when trying to drop a database : "ERROR: cannot drop the currently open database". However, a DROP command on this database in an sql window works just fine. The bug seems to be fixed in CVS version. See http://sourceforge.net/forum/forum.php?thread_id=1243412&forum_id=115884 . Reproducible: Always Steps to Reproduce: 1. Connect on phppgadmin with a valid user that can create a database 2. Create a database 3. try to delete this database Actual Results: Shows the error message "ERROR: cannot drop the currently open database" and the database is not deleted. Expected Results: The database should be deleted without any error. Portage 2.0.51.19 (default-linux/amd64/2004.3, gcc-3.4.3-20050110, glibc-2.3.4.20050125-r1, 2.6.10-gentoo-r7 x86_64) ================================================================= System uname: 2.6.10-gentoo-r7 x86_64 AMD Athlon(tm) 64 Processor 3500+ Gentoo Base System version 1.6.10 Python: dev-lang/python-2.3.5 [2.3.5 (#1, Mar 6 2005, 21:57:37)] distcc 2.18.3 x86_64-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled] dev-lang/python: 2.3.5 sys-devel/autoconf: 2.59-r6, 2.13 sys-devel/automake: 1.7.9-r1, 1.8.5-r3, 1.5, 1.4_p6, 1.6.3, 1.9.5 sys-devel/binutils: 2.15.92.0.2-r7 sys-devel/libtool: 1.5.14 virtual/os-headers: 2.6.8.1-r4 ACCEPT_KEYWORDS="amd64 ~amd64" AUTOCLEAN="yes" CFLAGS="-Os -march=athlon64 -mtune=athlon64 -pipe -fomit-frame-pointer" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3/share/config /usr/lib/X11/xkb /usr/share/config /var/qmail/control" CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d" CXXFLAGS="-Os -march=athlon64 -mtune=athlon64 -pipe -fomit-frame-pointer" DISTDIR="/usr/portage/distfiles" FEATURES="autoaddcvs autoconfig ccache distlocks sandbox" GENTOO_MIRRORS="ftp://ftp.wh2.tu-dresden.de/pub/mirrors/gentoo ftp://194.117.143.71/mirrors/gentoo ftp://mir.zyrianes.net/gentoo/ ftp://194.117.143.70/mirrors/gentoo ftp://194.117.143.69/mirrors/gentoo" MAKEOPTS="-j2" PKGDIR="/usr/portage/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="amd64 3ds X acpi acpi4linux aim alsa apache2 apm artswrappersuid artworkextra avi bash-completion berkdb bitmap-fonts blender-game bootsplash bzip2 bzlib calendar cdb cdio cdparanoia cdrom cgi chroot crypt css cups curl dba devmap dhcp dio divx4linux dvd dvdr dvdread emacs emul-linux encode ethereal faad fbcon ffmpeg font-server fortran ftp gd gdbm gif gimp gimpprint gkrellm glut gmail gpm gtk gtk2 hal hardened hardenedphp iconv icq imap inifile innodb jabber java javadoc javascript jbig jp2 jpeg latex libcaca libclamav libedit libwww lzw lzw-tiff maildir mbox md5sum memlimit mhash mime mimencode mjpeg mp3 mpeg mpeg2 mpeg4 mplayer mpm-leader mpm-peruser mpm-prefork mpm-threadpool mpm-worker msn multi-tty multilib mysql ncurses network nls nptl nvidia ogg opengl openssh oscar oss pam pam-mysql pam_chroot pam_console pam_timestamp pdf pdfkit pear-db perl php pic pie png posix postgres python qemu-fast quotas remote rpc rtc samba session simplexml snmp sockets softmmu spamassassin spell spl ssl stream symlink tcltk tcpd tidy tiff tokenizer transcode truetype truetype-fonts type1-fonts unicode usb userlocales utf8 vchroot vda vhosts virus-scan vorbis xchatdccserver xchattext xinetd xml2 xmlrpc xosd xpm xrandr xsl xslt xv xvid yahoo zlib linguas_fr" Unset: ASFLAGS, CBUILD, CTARGET, LANG, LC_ALL, LDFLAGS, PORTDIR_OVERLAY
Created attachment 55029 [details, diff] this patch must be applied to the file all_db.php in the directory of phppgadmin. The patch should be modified to be applied by portage.
See my patch I've just sent :) Please test and merge this to the portage tree.
This bug is fixed upstream in 3.5.3, please bump.
3.5.3 in cvs now
Works fine here. This bug should be closed and other ebuilds removed when 3.5.3 is marked stable (3.5.1 has the same bug).
3.5.4 stable in portage, closing.