Re: [pgadmin-hackers] Be careful in postgresql.conf of 8.1.
Hiroshi Saito wrote: Hi Andreas. Although this is a comment, it is bad condition. postgresql.conf #data_directory = 'ConfigDir' # use data in another directory #hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file #ident_file = 'ConfigDir/pg_ident.conf # IDENT configuration file Ummm, This should be as follows. #ident_file = 'ConfigDir/pg_ident.conf' # IDENT configuration file It is conf-editor gets confused. What do you consider? pgsql needs fix. Regards, Andreas ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] Possible bug renaming roles
Dear Sirs: I looked in the pgAdmin web page for a place to report bugs, but I couldn't find it. So I send it to this list. If I'm wrong, please let me know. Bug description: - When you try to rename a role, you get an error. The underlying sql sentence seems to be wrong. PgAdmin is trying ALTER GROUP ROLE "AccTotBDProy" RENAME TO "BDProy_AccTot"; and then the user gets the error Expected results: - It seems pgAdmin should try ALTER ROLE "AccTotBDProy" RENAME TO "BDProy_AccTot"; and rename it I'm available to do whatever tryings are needed. Keep up the good work. Thanks for it all! ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] automake
Dave Page wrote: On 9/11/05 8:22 pm, "Andreas Pflug" <[EMAIL PROTECTED]> wrote: How to handle the [tar-ustar] option in configure.ac? I had to remove it in my setup. You probably need to upgrade to automake 1.9.6. When I was packaging 1.4 the other night, I suddenly realised that whoever added the slony docs ( :-p ), forgot to add them to makefile.am, so they weren't included in the tarball. Having added them to the makefile, I rebuilt the tarball only to get errors from tar about three of the slony docs having too-long filenames, and find that the tarball itself way 12MB instead of the normal 6!! The tar-ustar option makes tar work in a mode in which 255 character names are supported instead of the default 99. A one off upgrade to automake on the /older/ developer systems seemed far less pain than manually renaming the slony docs forever more. Did that, automake works now, but Makefile will have a missing separator in line 377. automake-1.9 will claim that *.m4 is created by aclocal-1.4, but aclocal-1.9 will have throw warnings and automake-1.9 will fail then. If 1.9 is needed, it should be called explicitely in bootstrap, no? Current status: can't build on linux. automake/aclocal are 1.9.6 Regards, Andreas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-hackers] automake
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 10 November 2005 09:39 > To: Dave Page > Cc: pgadmin-hackers > Subject: Re: automake > > Did that, automake works now, but Makefile will have a > missing separator > in line 377. > > automake-1.9 will claim that *.m4 is created by aclocal-1.4, but > aclocal-1.9 will have throw warnings and automake-1.9 will fail then. > If 1.9 is needed, it should be called explicitely in bootstrap, no? Eh? Do you have both installed in different locations or something? This works perfectly for me on Slack 10, FC4 and OSX Panther - Florian has been using it on Tiger as well I believe. Regards, Dave. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-hackers] Search/replace
Dave Page wrote: Problem is that in both cases I get a crash in wx code, when none of our functions are on the call stack, after the new dialogue has been created. If running in the VC++ debugger, it breaks telling me I've hit a user breakpoint inside wx's assert handling code (where there definitely aren't any breakpoints that I've inserted). It won't let me break properly from the assert dialogue. After lengthy investigation the answer is quite simple: wx is broken. The dialogs sample has the same problem. Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] automake
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 10 November 2005 09:39 To: Dave Page Cc: pgadmin-hackers Subject: Re: automake Did that, automake works now, but Makefile will have a missing separator in line 377. automake-1.9 will claim that *.m4 is created by aclocal-1.4, but aclocal-1.9 will have throw warnings and automake-1.9 will fail then. If 1.9 is needed, it should be called explicitely in bootstrap, no? Eh? Do you have both installed in different locations or something? No, /usr/bin. All versions are present, but ./bootstrap relies on aclocal/autoconf to point to the right versions. currently, aclocal-1.4 will run (without problem), but automake-1.9 will claim aclocal version and configure isn't created. aclocal-1.9 won't run, many errors. Regards, Andreas ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] SVN Commit by andreas: r4729 - in trunk/pgadmin3: . src/dlg src/include
Author: andreas
Date: 2005-11-10 11:12:40 + (Thu, 10 Nov 2005)
New Revision: 4729
Modified:
trunk/pgadmin3/CHANGELOG.txt
trunk/pgadmin3/src/dlg/dlgRole.cpp
trunk/pgadmin3/src/include/version.h
Log:
Fix role rename
Modified: trunk/pgadmin3/CHANGELOG.txt
===
--- trunk/pgadmin3/CHANGELOG.txt2005-11-09 22:58:27 UTC (rev 4728)
+++ trunk/pgadmin3/CHANGELOG.txt2005-11-10 11:12:40 UTC (rev 4729)
@@ -17,6 +17,7 @@
+2005-11-09 AP 1.4.1 Fix role rename (r: Antonio)
2005-11-09 AP database and schema display restriction
2005-11-09 AP overhaul of server config settings
2005-11-09 AP 1.4.1 fix procedure/triggerFunc collection list
Modified: trunk/pgadmin3/src/dlg/dlgRole.cpp
===
--- trunk/pgadmin3/src/dlg/dlgRole.cpp 2005-11-09 22:58:27 UTC (rev 4728)
+++ trunk/pgadmin3/src/dlg/dlgRole.cpp 2005-11-10 11:12:40 UTC (rev 4729)
@@ -447,7 +447,7 @@
{
// Edit Mode
-AppendNameChange(sql);
+AppendNameChange(sql, wxT("ROLE ") + role->GetQuotedFullIdentifier());
wxString options;
Modified: trunk/pgadmin3/src/include/version.h
===
--- trunk/pgadmin3/src/include/version.h2005-11-09 22:58:27 UTC (rev
4728)
+++ trunk/pgadmin3/src/include/version.h2005-11-10 11:12:40 UTC (rev
4729)
@@ -11,7 +11,7 @@
// Application Versions
-#define VERSION_STR wxT("1.5.0")
+#define VERSION_STR wxT("1.5 Devel")
#define VERSION_NUM 1,5,0,0
#define VERSION_PACKAGE 1.5.0
#define VERSION_SVN wxT("$Rev$")
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] Be careful in postgresql.conf of 8.1.
> > #ident_file = 'ConfigDir/pg_ident.conf' # IDENT configuration file > > > > It is conf-editor gets confused. What do you consider? > > pgsql needs fix. Ok, I will post. Regards, Hiroshi Saito ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-hackers] SVN Commit by andreas: r4730 - branches/REL-1_4_0_PATCHES/pgadmin3/src/dlg
Author: andreas
Date: 2005-11-10 11:14:32 + (Thu, 10 Nov 2005)
New Revision: 4730
Modified:
branches/REL-1_4_0_PATCHES/pgadmin3/src/dlg/dlgRole.cpp
Log:
Fix role rename
Modified: branches/REL-1_4_0_PATCHES/pgadmin3/src/dlg/dlgRole.cpp
===
--- branches/REL-1_4_0_PATCHES/pgadmin3/src/dlg/dlgRole.cpp 2005-11-10
11:12:40 UTC (rev 4729)
+++ branches/REL-1_4_0_PATCHES/pgadmin3/src/dlg/dlgRole.cpp 2005-11-10
11:14:32 UTC (rev 4730)
@@ -447,7 +447,7 @@
{
// Edit Mode
-AppendNameChange(sql);
+AppendNameChange(sql, wxT("ROLE ") + role->GetQuotedFullIdentifier());
wxString options;
---(end of broadcast)---
TIP 6: explain analyze is your friend
Re: [pgadmin-hackers] Search/replace
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 10 November 2005 11:06 > To: Dave Page > Cc: pgadmin-hackers > Subject: Re: Search/replace > > Dave Page wrote: > > > > Problem is that in both cases I get a crash in wx code, > when none of our > > functions are on the call stack, after the new dialogue has > been created. If > > running in the VC++ debugger, it breaks telling me I've hit a user > > breakpoint inside wx's assert handling code (where there > definitely aren't > > any breakpoints that I've inserted). It won't let me break > properly from the > > assert dialogue. > > After lengthy investigation the answer is quite simple: wx is broken. > The dialogs sample has the same problem. Oh, good to know it's not me for once!! Thanks for looking. It did strike me that the replace dialogue can do find as well - perhaps we should just remove the find one altogether? /D ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] Possible bug renaming roles
Antonio wrote: Dear Sirs: I looked in the pgAdmin web page for a place to report bugs, but I couldn't find it. So I send it to this list. If I'm wrong, please let me know. Bug description: - When you try to rename a role, you get an error. Fixed in svn for 1.4.1 and HEAD, thanks for reporting. Regards, Andreas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] Search/replace
Dave Page wrote: Oh, good to know it's not me for once!! Thanks for looking. It did strike me that the replace dialogue can do find as well - perhaps we should just remove the find one altogether? This is uncommon, we should provide separate dialogs. Regards, Andreas ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] Search/replace
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 10 November 2005 11:24 > To: Dave Page > Cc: pgadmin-hackers > Subject: Re: Search/replace > > Dave Page wrote: > > > > > Oh, good to know it's not me for once!! Thanks for looking. > > > > It did strike me that the replace dialogue can do find as > well - perhaps > > we should just remove the find one altogether? > > This is uncommon, we should provide separate dialogs. Yeah, guess you're right. I'll mail the wx guys (as soon as I get 5!). /D ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[pgadmin-hackers] SVN Commit by dpage: r4732 - trunk/pgadmin3
Author: dpage Date: 2005-11-10 13:59:17 + (Thu, 10 Nov 2005) New Revision: 4732 Modified: trunk/pgadmin3/bootstrap Log: Make sure we use aclocal/automake 1.9 per Andreas Modified: trunk/pgadmin3/bootstrap === --- trunk/pgadmin3/bootstrap2005-11-10 13:36:25 UTC (rev 4731) +++ trunk/pgadmin3/bootstrap2005-11-10 13:59:17 UTC (rev 4732) @@ -12,7 +12,7 @@ if ! ([ -x config ]); then mkdir config fi -aclocal && \ +aclocal-1.9 && \ autoheader && \ -automake --foreign --add-missing --copy && \ +automake-1.9 --foreign --add-missing --copy && \ autoconf ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
[pgadmin-hackers] win32 8.1 pgadmin dll issues
My dev box was running 8.1rc1 and I thought it was time to put 8.1 on it. I downloaded the 8.1 binaries-only dist off of postgresql.org (bt version), did a binary swap on my server and nothing ran...it turns out all the binaries like initdb.exe, postgres.exe have a dll dependency on various pgAdmin dlls like comerr32.dll and several others. pgAdmin was not installed on my server so nothing worked. I copied the .dlls from the pgAdmin folder on my workstation and postgres starts up. Normally I roll my own so this may or may not be an issue...but when did initdb.exe acquire a pgAdmin dependency? Merlin ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] [HACKERS] win32 8.1 pgadmin dll issues
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Merlin Moncure > Sent: 10 November 2005 14:56 > To: pgadmin-hackers@postgresql.org > Cc: pgsql-hackers@postgresql.org > Subject: [HACKERS] win32 8.1 pgadmin dll issues > > My dev box was running 8.1rc1 and I thought it was time to put 8.1 on > it. I downloaded the 8.1 binaries-only dist off of postgresql.org (bt > version), did a binary swap on my server and nothing ran...it > turns out > all the binaries like initdb.exe, postgres.exe have a dll > dependency on > various pgAdmin dlls like comerr32.dll and several others. > pgAdmin was > not installed on my server so nothing worked. I copied the .dlls from > the pgAdmin folder on my workstation and postgres starts up. > > Normally I roll my own so this may or may not be an > issue...but when did > initdb.exe acquire a pgAdmin dependency? It doesn't - they're all libpq dependencies, not pgAdmin ones (though pgAdmin does need them because it uses libpq of course). Commerr32 & brb5_32 are Kerberos. Libiconv-2.dll & libintl-2.dll are Gettext. Libeay32.dll and ssleay32.dll are Open SSL Regards, Dave. ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] [HACKERS] win32 8.1 pgadmin dll issues
> > My dev box was running 8.1rc1 and I thought it was time to put 8.1 on > > it. I downloaded the 8.1 binaries-only dist off of postgresql.org (bt > > version), did a binary swap on my server and nothing ran...it > > turns out > > all the binaries like initdb.exe, postgres.exe have a dll > > dependency on > > various pgAdmin dlls like comerr32.dll and several others. > > pgAdmin was > > not installed on my server so nothing worked. I copied the .dlls from > > the pgAdmin folder on my workstation and postgres starts up. > > > > Normally I roll my own so this may or may not be an > > issue...but when did > > initdb.exe acquire a pgAdmin dependency? > > It doesn't - they're all libpq dependencies, not pgAdmin ones (though > pgAdmin does need them because it uses libpq of course). hm that makes sense...however those dlls are not provided in the binary only installation but are required because it is compiled with ssl, etc. The bt page doesn't state if ssl is required or not. I just assumed pgAdmin because that was the only place I could find a copy of the libraries. Merlin ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [pgadmin-hackers] [HACKERS] win32 8.1 pgadmin dll issues
> My dev box was running 8.1rc1 and I thought it was time to > put 8.1 on it. I downloaded the 8.1 binaries-only dist off > of postgresql.org (bt version), did a binary swap on my > server and nothing ran...it turns out all the binaries like > initdb.exe, postgres.exe have a dll dependency on various > pgAdmin dlls like comerr32.dll and several others. pgAdmin > was not installed on my server so nothing worked. I copied > the .dlls from the pgAdmin folder on my workstation and > postgres starts up. Exactly what DLLs are those? comerr32.dll is a Kerberos DLL and not a pgAdmin DLL.. > Normally I roll my own so this may or may not be an > issue...but when did initdb.exe acquire a pgAdmin dependency? It really shouldn't. //Magnus ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] [HACKERS] win32 8.1 pgadmin dll issues
On Thu, Nov 10, 2005 at 04:24:46PM +0100, Magnus Hagander wrote: > > My dev box was running 8.1rc1 and I thought it was time to > > put 8.1 on it. I downloaded the 8.1 binaries-only dist off > > of postgresql.org (bt version), did a binary swap on my > > server and nothing ran...it turns out all the binaries like > > initdb.exe, postgres.exe have a dll dependency on various > > pgAdmin dlls like comerr32.dll and several others. pgAdmin > > was not installed on my server so nothing worked. I copied > > the .dlls from the pgAdmin folder on my workstation and > > postgres starts up. > > Exactly what DLLs are those? > comerr32.dll is a Kerberos DLL and not a pgAdmin DLL.. I wonder if this is an artifact of the "link everything into every binary even if we don't use it" procedure. Hence the postmaster can depend on readline even though it doesn't use it. With gcc we're proposing --as-needed to resolve this, but how would that work for a windows platform? Can you examine a binary to see what it depends on? Hope this helps, -- Martijn van Oosterhout http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them. pgptHwYUhOyrI.pgp Description: PGP signature
Re: [pgadmin-hackers] [HACKERS] win32 8.1 pgadmin dll issues
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Martijn van Oosterhout > Sent: 10 November 2005 15:42 > To: Magnus Hagander > Cc: Merlin Moncure; pgadmin-hackers@postgresql.org; > pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] win32 8.1 pgadmin dll issues > > On Thu, Nov 10, 2005 at 04:24:46PM +0100, Magnus Hagander wrote: > > > My dev box was running 8.1rc1 and I thought it was time to > > > put 8.1 on it. I downloaded the 8.1 binaries-only dist off > > > of postgresql.org (bt version), did a binary swap on my > > > server and nothing ran...it turns out all the binaries like > > > initdb.exe, postgres.exe have a dll dependency on various > > > pgAdmin dlls like comerr32.dll and several others. pgAdmin > > > was not installed on my server so nothing worked. I copied > > > the .dlls from the pgAdmin folder on my workstation and > > > postgres starts up. > > > > Exactly what DLLs are those? > > comerr32.dll is a Kerberos DLL and not a pgAdmin DLL.. > > I wonder if this is an artifact of the "link everything into every > binary even if we don't use it" procedure. Hence the postmaster can > depend on readline even though it doesn't use it. > > With gcc we're proposing --as-needed to resolve this, but how would > that work for a windows platform? Can you examine a binary to see what > it depends on? Those are the only dependencies, and are all intentional. Regards, Dave ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [pgadmin-hackers] automake
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 10 November 2005 11:04 > To: Dave Page > Cc: pgadmin-hackers > Subject: Re: automake > > Dave Page wrote: > > > > > > > >>-Original Message- > >>From: Andreas Pflug [mailto:[EMAIL PROTECTED] > >>Sent: 10 November 2005 09:39 > >>To: Dave Page > >>Cc: pgadmin-hackers > >>Subject: Re: automake > >> > >>Did that, automake works now, but Makefile will have a > >>missing separator > >>in line 377. > >> > >>automake-1.9 will claim that *.m4 is created by aclocal-1.4, but > >>aclocal-1.9 will have throw warnings and automake-1.9 will > fail then. > >>If 1.9 is needed, it should be called explicitely in bootstrap, no? > > > > > > Eh? Do you have both installed in different locations or something? > No, /usr/bin. > All versions are present, but ./bootstrap relies on > aclocal/autoconf to > point to the right versions. > > currently, aclocal-1.4 will run (without problem), but > automake-1.9 will > claim aclocal version and configure isn't created. aclocal-1.9 won't > run, many errors. Is this OK now (following an svn update)? Regards, Dave ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [pgadmin-hackers] automake
Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 10 November 2005 11:04 To: Dave Page Cc: pgadmin-hackers Subject: Re: automake Dave Page wrote: -Original Message- From: Andreas Pflug [mailto:[EMAIL PROTECTED] Sent: 10 November 2005 09:39 To: Dave Page Cc: pgadmin-hackers Subject: Re: automake Did that, automake works now, but Makefile will have a missing separator in line 377. automake-1.9 will claim that *.m4 is created by aclocal-1.4, but aclocal-1.9 will have throw warnings and automake-1.9 will fail then. If 1.9 is needed, it should be called explicitely in bootstrap, no? Eh? Do you have both installed in different locations or something? No, /usr/bin. All versions are present, but ./bootstrap relies on aclocal/autoconf to point to the right versions. currently, aclocal-1.4 will run (without problem), but automake-1.9 will claim aclocal version and configure isn't created. aclocal-1.9 won't run, many errors. Is this OK now (following an svn update)? I get quite some warnings from aclocal, but after rm -r config* ac*;svn update I'm workable again. Regards, Andreas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [pgadmin-hackers] automake
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 10 November 2005 16:47 > To: Dave Page > Cc: pgadmin-hackers > Subject: Re: [pgadmin-hackers] automake > > > Is this OK now (following an svn update)? > > I get quite some warnings from aclocal, but after rm -r > config* ac*;svn > update I'm workable again. Great. See, that was a lot less painful than renaming Slony docs every time we update :-) /D ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[pgadmin-hackers] server closed connection on a select query
Hi, I've installed a 8.1.0 PostgreSQL server on a SCO OpenServer 5.0.6. It seemed to work well with psql and such tools. I tried to connect to this server with pgAdmin3 and a query failed. I tried to find which part of the query was wrong and I have a strange result : SELECT 1 FROM pg_language WHERE lanispl IS TRUE; this one crashes the server. SELECT 1 FROM pg_language WHERE lanispl = true; works. It seemed to me that "IS TRUE" is the culprit so I tried something else SELECT lanispl IS TRUE FROM pg_language; and it works. If I create a table for testing purpose, I can add a where clause with "IS TRUE". This behavior happens on another server (SCO too) but not on any Linux that I tried. I've attached the patch I apply to be able to build PostgreSQL on SCO OpenServer. I'm not 100% sure it isn't faulty. Did something like this already happened to someone ? Do you know of any test I can do ? Regards. -- Guillaume. pg810.patch Description: Binary data ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
[pgadmin-hackers] Nightly Builds
Hi FYI, I do nightly builds of the PGADMIN3_PATCHES_1_4 (or however it is actually called ;-) ) branch, as well as of trunk. greetings, Florian Pflug smime.p7s Description: S/MIME Cryptographic Signature
Re: [pgadmin-hackers] [GENERAL] How to install Slony in windows
> Postgres 8.1 PgAdmin help in slony windows says: > > "In case you're installing a PostgreSQL 8.1 server on Win32, > the windows installer routine can do this for you if you > select the "Slony-I" > installation option. " > > How I can select Slony-I installation option ? > I havent seen such thing during 8.1 installation. That's most definitly a pgadmin documentation bug. Slony-I for win32 is not yet released, and definitly not included in the 8.1 installer. Sorry to dissapoint. //Magnus ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
