Re: [pgadmin-support] SQL Editor fail
Le 05/12/2011 02:15 PM, Aleksey Chirkin a écrit :
> Hi! This is my first message in list, I hope that it will be helpful.
>
> I'm finding a bug in pgAdmin 1.14.0 Beta 1.
> To make sure that the problem is still there I'm pulled from latest git today.
>
> To reproduce it, enter in SQL Editor, write symbol "(" and then press
> enter for go to new line. It crashing pgAdmin.
>
> I'm testing it on MacOS 10.6.7.
>
Works on Linux at least. As Dave is able to reproduce it, I created a
ticket (http://code.pgadmin.org/trac/ticket/316) on this issue so that
we can work on it.
Thanks for your report.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Pgadmin3 and Postgres 9.0.4 observation
Hi, Le 05/13/2011 02:26 PM, r d a écrit : > [...] > since upgrading to postgresql 9.0.4 I have noticed that pgadmin3 (1.12.2 & > 1.12.3) > does not show the info for the columns: > > "last vacuum" > "last autovacuum" > "last analyze" > "last autoanalyze" > > in the table statistics view, for tables where I know for sure that > auto-vacuum and auto-analyze executed. > It does for me. What does psql tell you on these columns for these tables? or what does the query tool tell you if you launch this query? SELECT schemaname, relname FROM pg_stat_user_tables WHERE last_autovacuum IS NOT NULL OR last_autoanalyze IS NOT NULL; -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] SQL/MED Foreign Data Wrappers where is Handler?
Le 05/14/2011 01:17 AM, Paragon Corporation a écrit : > I'm using pgAdmin 1.14.0 beta 1 and was trying to create a Foreign Data > Wrapper entry. > > I see a Validator drop down, but no Handler drop down. Am I missing > something? > Ouch. You're completely right. We need to add support for it. Thanks a lot. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Ubuntu natty and SSL connections
Hi, Le 05/15/2011 11:35 PM, Andreas Neumann a écrit : > [...] > I am running into issues with Ubuntu Natty (64bit) and SSL connections. > I first tried the version 1.12.2 which comes as a binary with Ubuntu. > The Combobox to select SSL is greyed out. Then I compiled 1.12.3 from > source, but SSL is still greyed out. The openssl package is installed - > is there another library or package I am missing? > > pg_config reports that SSL should be supported: > > CONFIGURE = '--with-libxml' '--with-libxslt' '--with-openssl' > '--with-perl' '--with-python' > LIBS = -lpgport -lxslt -lxml2 -lssl -lcrypto -lz -lreadline -lcrypt -ldl -lm > > $LD_LIBRARY_PATH is also set to /usr/local/pgsql/lib > > Thank you if you have any additional idea what I could try, > It seems that configure thinks SSL support is missing. At the end of configure, you have some informations. You have a line which starts with "PostgreSQL SSL support". I bet it says no support. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Usability improvment ideas
Le 05/13/2011 06:03 PM, Dave Page a écrit : > On Thu, May 12, 2011 at 5:41 PM, Belbin, Peter > wrote: >> Just an observation. :) >> >> >> With the 1.14 stream of pgadmin3, I notice that the dialog for creation of >> columns moves the type to a different tab than the name, requiring much more >> work to create the columns. > > That does seem like a usability regression Guillaume. Can you look at > that please? Yeah, but it means we'll lose the consistency. I know it doesn't feel right, but if we allow the type to be on the first tab, we'll get lots of request for that kind of thing for $object. > The other one that's been bugging me is that the Service > field on the server dialog is now above the host/address field, which > also seems wrong. > Will look into it. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Usability improvment ideas
On Mon, May 16, 2011 at 8:52 AM, Guillaume Lelarge wrote: > Le 05/13/2011 06:03 PM, Dave Page a écrit : >> On Thu, May 12, 2011 at 5:41 PM, Belbin, Peter >> wrote: >>> Just an observation. :) >>> >>> >>> With the 1.14 stream of pgadmin3, I notice that the dialog for creation of >>> columns moves the type to a different tab than the name, requiring much >>> more work to create the columns. >> >> That does seem like a usability regression Guillaume. Can you look at >> that please? > > Yeah, but it means we'll lose the consistency. I know it doesn't feel > right, but if we allow the type to be on the first tab, we'll get lots > of request for that kind of thing for $object. I'm normally the first guy to bleat about consistency, but this really does feel like a big regression in usability to me - this is one of the few (the only?) dialog that people are likely to open over and over again when creating another object. We already know that is cumbersome (that's why there's a complete redesign of the table dialogue on the TODO) - this will make it worse. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
Re: [pgadmin-support] Ubuntu natty and SSL connections
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 That's the funny think: configure told me that OpenSSL support is present in PostgreSQL - still it is disabled. Here is the configure output: - checking build system type... x86_64-unknown-linux-gnu checking host system type... x86_64-unknown-linux-gnu checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... /bin/mkdir -p checking for gawk... gawk checking whether make sets $(MAKE)... yes checking how to create a ustar tar archive... gnutar checking for gcc... gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking for style of include used by make... GNU checking dependency style of gcc... gcc3 checking for g++... g++ checking whether we are using the GNU C++ compiler... yes checking whether g++ accepts -g... yes checking dependency style of g++... gcc3 checking for ranlib... ranlib checking whether to use precompiled headers... yes checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking arpa/inet.h usability... yes checking arpa/inet.h presence... yes checking for arpa/inet.h... yes checking netdb.h usability... yes checking netdb.h presence... yes checking for netdb.h... yes checking netinet/in.h usability... yes checking netinet/in.h presence... yes checking for netinet/in.h... yes checking for stdlib.h... (cached) yes checking for stdbool.h that conforms to C99... yes checking for _Bool... yes checking for an ANSI C-conforming const... yes checking for size_t... yes checking whether time.h and sys/time.h may both be included... yes checking for working strtod... yes checking for gethostbyname... yes checking for inet_ntoa... yes checking for memmove... yes checking for memset... yes checking for strchr... yes checking for SSL_library_init in -lssl... yes checking for krb5_sendauth in -lkrb5... yes checking for PQexec in -lpq... yes checking for PQconninfoParse in -lpq... yes checking for SSL_connect in -lpq... yes checking for krb5_free_principal in -lpq... yes checking libpq-fe.h usability... yes checking libpq-fe.h presence... yes checking for libpq-fe.h... yes checking PostgreSQL in /usr/local/pgsql... ok checking for PQgetOutResult in -lpq... no checking wxWidgets version... ok checking wxWidgets in /usr... ok checking libxml2 in /usr... ok checking libxml2 version... ok checking libxslt in /usr... ok configure: creating ./config.status config.status: creating Makefile config.status: creating branding/Makefile config.status: creating i18n/Makefile config.status: creating pgadmin/Makefile config.status: creating pkg/Makefile config.status: creating pkg/debian/Makefile config.status: creating pkg/mac/Makefile config.status: creating pkg/mandrake/Makefile config.status: creating pkg/redhat/Makefile config.status: creating pkg/slackware/Makefile config.status: creating pkg/src/Makefile config.status: creating pkg/suse/Makefile config.status: creating pkg/win32/Makefile config.status: creating xtra/Makefile config.status: creating xtra/pgscript/Makefile config.status: creating xtra/pgscript/lib/Makefile config.status: creating xtra/pgscript/bin/Makefile config.status: creating xtra/pgscript/test/Makefile config.status: creating xtra/wx-build/Makefile config.status: creating config.h config.status: config.h is unchanged config.status: executing depfiles commands PostgreSQL directory: /usr/local/pgsql PostgreSQL pg_config binary:/usr/local/pgsql/bin/pg_config PostgreSQL version: PostgreSQL 9.0.4 PostgreSQL PQconninfoParse support: Present PostgreSQL SSL support: Present wxWidgets directory:/usr wxWidgets wx-config binary: /usr/bin/wx-config wxWidgets version: wxWidgets 2.8.11 libxml2 directory: /usr libxml2 xml2-config binary: /usr/bin/xml2-config libxml2 version:libxml2 2.7.8 libxslt directory: /usr libxslt xslt-config binary: /usr/bin/xslt-config libxslt version:libxslt 1.1.26 Building a debug version of pgAdmin:No Statically linking pgAdmin:
