Re: [PATCHES] [HACKERS] Timezone List
Assuming we can sneak this in even though it's feature-freeze, want me to look for it? Yeah, please take a look --- seeing the size of the code will probably help us decide if it's too late for 8.2 or not. Here goes. Tested only on win32 so far, but works there. No docs yet either - need to know if it goes in first ;) It only returns the name, but if you want more funky stuff you can do things like select name,current_timestamp at time zone name from pg_timezone_names //Magnus pg_timezone_names.diff Description: pg_timezone_names.diff ---(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: [PATCHES] [HACKERS] Timezone List
Assuming we can sneak this in even though it's feature-freeze, want me to look for it? Yeah, please take a look --- seeing the size of the code will probably help us decide if it's too late for 8.2 or not. Here goes. Tested only on win32 so far, but works there. No docs yet either - need to know if it goes in first ;) It only returns the name, but if you want more funky stuff you can do things like select name,current_timestamp at time zone name from pg_timezone_names Oh, and it's going to need an update to expected/rules.out, not included in the patch, as well. //Magnus ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[PATCHES] Template0 age is increasing speedily.
Hi!.. I noticed that the age of template0 is increasing very rapidly..Can you please let me know how we can control this and what causes such problems. We also noticed that the database slow downs heavily at a particular time..Can you suggest any tools which will help in diagnosing the root cause behiond the data load. Regards, Nimesh.
Re: [PATCHES] [HACKERS] Fix linking of OpenLDAP libraries
Tom Lane wrote: I have realized that my modifications in configure.in and src/interfaces/libpq/Makefile to link libpq against OpenLDAP are buggy. Here is a proposed patch to fix it. [...] # The backend doesn't need everything that's in LIBS, however ! LIBS := $(filter-out -lz -lreadline -ledit -ltermcap -lncurses -lcurses -lldap_r $(PTHREAD_LIBS), $(LIBS)) This seems pretty risky. What if PTHREAD_LIBS contains -L switches? They'd get removed even if needed for other libraries. It would probably be safer not to put LDAP into LIBS at all, but invent two new macros for configure to set, say LDAP_LIBS and LDAP_LIBS_R, and add these to the link lines in the backend and libpq respectively. Here is a new patch that replaces the previous one; it adds two macros LDAP_LIBS_FE and LDAP_LIBS_BE for frontend and backend, respectively. I did not only add them to the Makefile for interfaces/libpq, but also everywhere something is linked against libpq in case somebody links static. I don't know if that's necessary, or if static builds are supported - if not, the changes to those Makefiles should perhaps not be applied. Tested on Linux, AIX and Windows. Yours, Laurenz Albe ldaplink2.patch Description: ldaplink2.patch ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [HACKERS] [PATCHES] Backend SSL configuration enhancement
On Tue, Sep 05, 2006 at 10:17:15AM +0400, Victor Wagner wrote: It's a pity that it's to late for patch to get into 8.2. It means that during all 8.2 lifecycle we'll have to maintain this patch separately. Hmm? After 8.2 releases, if it's ready, it will go straight into CVS at which point it'll be in the next release. Have a nice day, -- Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/ From each according to his ability. To each according to his ability to litigate. signature.asc Description: Digital signature
[PATCHES] related problem of path by msvc
Hi Bruce-san, and Magnus-san. I have one problem, after this is arranged. Please take into consideration. Regards, Hiroshi Saito --- src/tools/msvc/build.bat.orig Fri Sep 8 11:49:32 2006 +++ src/tools/msvc/build.batFri Sep 8 11:50:37 2006 @@ -4,7 +4,7 @@ perl mkvcbuild.pl if errorlevel 1 goto :eof -if exist ..\vcbuild if exist ..\src cd .. +if exist ..\..\..\src\tools\msvc if exist ..\..\..\src cd ..\..\.. if %1 == msbuild pgsql.sln if not %1 == vcbuild %1.vcproj --- src/tools/msvc/mkvcbuild.pl.origFri Sep 8 11:49:45 2006 +++ src/tools/msvc/mkvcbuild.pl Fri Sep 8 11:52:36 2006 @@ -5,12 +5,12 @@ use Project; use Solution; -chdir('..') if (-d '..\vcbuild' -d '..\src'); -die 'Must run from root directory or vcbuild directory' unless (-d 'vcbuild' -d 'src'); -die 'Could not find config.pl' unless (-f 'vcbuild/config.pl'); +chdir('..\..\..') if (-d '..\..\..\src\tools\msvc' -d '..\..\..\src'); +die 'Must run from root directory or vcbuild directory' unless (-d 'src/tools/msvc' -d 'src'); +die 'Could not find config.pl' unless (-f 'src/tools/msvc/config.pl'); our $config; -require 'vcbuild/config.pl'; +require 'src/tools/msvc/config.pl'; my $solution = new Solution($config); ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [PATCHES] related problem of path by msvc
Uga...short.. Sorry this is new patch. - Original Message - From: Hiroshi Saito [EMAIL PROTECTED] To: pgsql-patches@postgresql.org Sent: Friday, September 08, 2006 12:02 PM Subject: [PATCHES] related problem of path by msvc Hi Bruce-san, and Magnus-san. I have one problem, after this is arranged. Please take into consideration. Regards, Hiroshi Saito ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings --- src/tools/msvc/build.bat.orig Fri Sep 8 11:49:32 2006 +++ src/tools/msvc/build.batFri Sep 8 11:50:37 2006 @@ -4,7 +4,7 @@ perl mkvcbuild.pl if errorlevel 1 goto :eof -if exist ..\vcbuild if exist ..\src cd .. +if exist ..\..\..\src\tools\msvc if exist ..\..\..\src cd ..\..\.. if %1 == msbuild pgsql.sln if not %1 == vcbuild %1.vcproj --- src/tools/msvc/mkvcbuild.pl.origFri Sep 8 11:49:45 2006 +++ src/tools/msvc/mkvcbuild.pl Fri Sep 8 11:52:36 2006 @@ -5,12 +5,12 @@ use Project; use Solution; -chdir('..') if (-d '..\vcbuild' -d '..\src'); -die 'Must run from root directory or vcbuild directory' unless (-d 'vcbuild' -d 'src'); -die 'Could not find config.pl' unless (-f 'vcbuild/config.pl'); +chdir('..\..\..') if (-d '..\..\..\src\tools\msvc' -d '..\..\..\src'); +die 'Must run from root directory or vcbuild directory' unless (-d 'src/tools/msvc' -d 'src'); +die 'Could not find config.pl' unless (-f 'src/tools/msvc/config.pl'); our $config; -require 'vcbuild/config.pl'; +require 'src/tools/msvc/config.pl'; my $solution = new Solution($config); --- src/tools/msvc/Project.pm.orig Fri Sep 8 12:13:23 2006 +++ src/tools/msvc/Project.pm Fri Sep 8 12:14:51 2006 @@ -286,13 +286,13 @@ my $of = $f; $of =~ s/\.y$/.c/; $of =~ s{^src\\pl\\plpgsql\\src\\gram.c$}{src\\pl\\plpgsql\\src\\pl_gram.c}; - print F 'FileConfiguration Name=Debug|Win32Tool Name=VCCustomBuildTool Description=Running bison on ' . $f . ' CommandLine=vcbuild\pgbison.bat ' . $f . ' AdditionalDependencies= Outputs=' . $of . ' //FileConfiguration/File' . \n; + print F 'FileConfiguration Name=Debug|Win32Tool Name=VCCustomBuildTool Description=Running bison on ' . $f . ' CommandLine=src\tools\msvc\pgbison.bat ' . $f . ' AdditionalDependencies= Outputs=' . $of . ' //FileConfiguration/File' . \n; } elsif ($f =~ /\.l$/) { my $of = $f; $of =~ s/\.l$/.c/; $of =~ s{^src\\pl\\plpgsql\\src\\scan.c$}{src\\pl\\plpgsql\\src\\pl_scan.c}; - print F FileConfiguration Name=\Debug|Win32\Tool Name=\VCCustomBuildTool\ Description=\Running flex on $f\ CommandLine=\vcbuild\\pgflex.bat $f\ AdditionalDependencies=\\ Outputs=\$of\ //FileConfiguration/File\n; + print F FileConfiguration Name=\Debug|Win32\Tool Name=\VCCustomBuildTool\ Description=\Running flex on $f\ CommandLine=\src\tools\msvc\\pgflex.bat $f\ AdditionalDependencies=\\ Outputs=\$of\ //FileConfiguration/File\n; } elsif (defined($uniquefiles{$file})) { # File already exists, so fake a new name @@ -362,7 +362,7 @@ print $f \tTool Name=\VCLibrarianTool\ OutputFile=\.\\Debug\\$self-{name}\\$self-{name}.lib\ IgnoreDefaultLibraryNames=\libc\ /\n; print $f \tTool Name=\VCResourceCompilerTool\ AdditionalIncludeDirectories=\src\\include\ /\n; if ($self-{builddef}) { - print $f \tTool Name=\VCPreLinkEventTool\ Description=\Generate DEF file\ CommandLine=\perl vcbuild\\gendef.pl debug\\$self-{name}\ /\n; + print $f \tTool Name=\VCPreLinkEventTool\ Description=\Generate DEF file\ CommandLine=\perl src\tools\msvc\\gendef.pl debug\\$self-{name}\ /\n; } print $f EOF; /Configuration --- src/tools/msvc/Solution.pm.orig Fri Sep 8 12:15:06 2006 +++ src/tools/msvc/Solution.pm Fri Sep 8 12:15:30 2006 @@ -21,8 +21,8 @@ # Special case - if config.pl has changed, always return 1 sub IsNewer { my ($newfile, $oldfile) = @_; - if ($oldfile ne 'vcbuild\config.pl') { - return 1 if IsNewer($newfile, 'vcbuild\config.pl'); + if ($oldfile ne 'src\tools\msvc\config.pl') { + return 1 if IsNewer($newfile, 'src\tools\msvc\config.pl'); } return 1 if (!(-e $newfile)); my @nstat = stat($newfile); ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: [PATCHES] BUG #2600: dblink compile with SSL missing libraries
[EMAIL PROTECTED] (Tom Lane) writes: Chris Browne [EMAIL PROTECTED] writes: I still need the following, on AIX: -SHLIB_LINK = $(libpq) +SHLIB_LINK = $(libpq) $(LIBS) No you don't --- see recent warthog complaint. We have to filter LIBS down to just the minimum. I'm at a loss, then. - If LIBS is being filtered to the minimum, then shouldn't it be appropriate to add it in here? - There isn't any variable other than LIBS that *does* get bound to include -lssl and -lcrypto - Do we need to add an additional LIBSSL, spattered widely through makefiles, which sometimes gets linked in? - Or do we need some custom DBLINKLIBS, defined in configure, that is only used for dblink? -- (reverse (concatenate 'string moc.enworbbc @ enworbbc)) http://www3.sympatico.ca/cbbrowne/languages.html QT adds to a Linux distribution a level of licencing complexity that nullifies one of the major virtues of Linux: no licencing complexity. -- [EMAIL PROTECTED] ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [PATCHES] BUG #2600: dblink compile with SSL missing libraries
Chris Browne [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Tom Lane) writes: No you don't --- see recent warthog complaint. We have to filter LIBS down to just the minimum. I'm at a loss, then. - If LIBS is being filtered to the minimum, then shouldn't it be appropriate to add it in here? No, LIBS isn't filtered at all. See my recent commit to sslinfo's Makefile --- I blew it just like this, you should learn from my mistake. regards, tom lane ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [PATCHES] related problem of path by msvc
Ah...I am sorry in spam mail.:-( It is this surely.. Sorry..all Hiroshi Saito Uga...short.. Sorry this is new patch. --- src/tools/msvc/build.bat.orig Fri Sep 8 11:49:32 2006 +++ src/tools/msvc/build.batFri Sep 8 11:50:37 2006 @@ -4,7 +4,7 @@ perl mkvcbuild.pl if errorlevel 1 goto :eof -if exist ..\vcbuild if exist ..\src cd .. +if exist ..\..\..\src\tools\msvc if exist ..\..\..\src cd ..\..\.. if %1 == msbuild pgsql.sln if not %1 == vcbuild %1.vcproj --- src/tools/msvc/mkvcbuild.pl.origFri Sep 8 11:49:45 2006 +++ src/tools/msvc/mkvcbuild.pl Fri Sep 8 11:52:36 2006 @@ -5,12 +5,12 @@ use Project; use Solution; -chdir('..') if (-d '..\vcbuild' -d '..\src'); -die 'Must run from root directory or vcbuild directory' unless (-d 'vcbuild' -d 'src'); -die 'Could not find config.pl' unless (-f 'vcbuild/config.pl'); +chdir('..\..\..') if (-d '..\..\..\src\tools\msvc' -d '..\..\..\src'); +die 'Must run from root directory or vcbuild directory' unless (-d 'src/tools/msvc' -d 'src'); +die 'Could not find config.pl' unless (-f 'src/tools/msvc/config.pl'); our $config; -require 'vcbuild/config.pl'; +require 'src/tools/msvc/config.pl'; my $solution = new Solution($config); --- src/tools/msvc/Project.pm.orig Fri Sep 8 12:13:23 2006 +++ src/tools/msvc/Project.pm Fri Sep 8 13:14:34 2006 @@ -286,13 +286,13 @@ my $of = $f; $of =~ s/\.y$/.c/; $of =~ s{^src\\pl\\plpgsql\\src\\gram.c$}{src\\pl\\plpgsql\\src\\pl_gram.c}; - print F 'FileConfiguration Name=Debug|Win32Tool Name=VCCustomBuildTool Description=Running bison on ' . $f . ' CommandLine=vcbuild\pgbison.bat ' . $f . ' AdditionalDependencies= Outputs=' . $of . ' //FileConfiguration/File' . \n; + print F 'FileConfiguration Name=Debug|Win32Tool Name=VCCustomBuildTool Description=Running bison on ' . $f . ' CommandLine=src\tools\msvc\pgbison.bat ' . $f . ' AdditionalDependencies= Outputs=' . $of . ' //FileConfiguration/File' . \n; } elsif ($f =~ /\.l$/) { my $of = $f; $of =~ s/\.l$/.c/; $of =~ s{^src\\pl\\plpgsql\\src\\scan.c$}{src\\pl\\plpgsql\\src\\pl_scan.c}; - print F FileConfiguration Name=\Debug|Win32\Tool Name=\VCCustomBuildTool\ Description=\Running flex on $f\ CommandLine=\vcbuild\\pgflex.bat $f\ AdditionalDependencies=\\ Outputs=\$of\ //FileConfiguration/File\n; + print F FileConfiguration Name=\Debug|Win32\Tool Name=\VCCustomBuildTool\ Description=\Running flex on $f\ CommandLine=\src\\tools\\msvc\\pgflex.bat $f\ AdditionalDependencies=\\ Outputs=\$of\ //FileConfiguration/File\n; } elsif (defined($uniquefiles{$file})) { # File already exists, so fake a new name @@ -362,7 +362,7 @@ print $f \tTool Name=\VCLibrarianTool\ OutputFile=\.\\Debug\\$self-{name}\\$self-{name}.lib\ IgnoreDefaultLibraryNames=\libc\ /\n; print $f \tTool Name=\VCResourceCompilerTool\ AdditionalIncludeDirectories=\src\\include\ /\n; if ($self-{builddef}) { - print $f \tTool Name=\VCPreLinkEventTool\ Description=\Generate DEF file\ CommandLine=\perl vcbuild\\gendef.pl debug\\$self-{name}\ /\n; + print $f \tTool Name=\VCPreLinkEventTool\ Description=\Generate DEF file\ CommandLine=\perl src\\tools\\msvc\\gendef.pl debug\\$self-{name}\ /\n; } print $f EOF; /Configuration --- src/tools/msvc/Solution.pm.orig Fri Sep 8 12:15:06 2006 +++ src/tools/msvc/Solution.pm Fri Sep 8 12:15:30 2006 @@ -21,8 +21,8 @@ # Special case - if config.pl has changed, always return 1 sub IsNewer { my ($newfile, $oldfile) = @_; - if ($oldfile ne 'vcbuild\config.pl') { - return 1 if IsNewer($newfile, 'vcbuild\config.pl'); + if ($oldfile ne 'src\tools\msvc\config.pl') { + return 1 if IsNewer($newfile, 'src\tools\msvc\config.pl'); } return 1 if (!(-e $newfile)); my @nstat = stat($newfile); ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
Re: [PATCHES] BUG #2600: dblink compile with SSL missing libraries
[EMAIL PROTECTED] (Tom Lane) writes: Chris Browne [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Tom Lane) writes: No you don't --- see recent warthog complaint. We have to filter LIBS down to just the minimum. I'm at a loss, then. - If LIBS is being filtered to the minimum, then shouldn't it be appropriate to add it in here? No, LIBS isn't filtered at all. See my recent commit to sslinfo's Makefile --- I blew it just like this, you should learn from my mistake. OK, the very same change as your recent change to contrib/sslinfo/Makefile works out fine for contrib/dblink/Makefile. That allows a buildfarm run to go through perfectly. I suspect that both Makefiles also need to filter in -lgettext or something similar; see bug #2608, which shows off much the same problem surrounding NLS support. (I'm happy to see that someone's running xlC on AIX 5.3, by the way... I should be getting a copy Real Soon Now, but it may not be soon enough to be helpful :-( ) -- output = reverse(ofni.secnanifxunil @ enworbbc) http://linuxdatabases.info/info/multiplexor.html If God meant us to be vegetarians why'd He make cows out of meat? -- seen on a bumper sticker ---(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
Re: [PATCHES] [HACKERS] Template0 age is increasing speedily.
On 9/7/06, Nimesh Satam [EMAIL PROTECTED] wrote: We also noticed that the database slow downs heavily at a particular time..Can you suggest any tools which will help in diagnosing the root cause behiond the data load. possible checkpoint? poorly formulated query? it could be any number of things. use standard tools to diagnose the problem, including: unix tools: top, vmstat, etc postgresql query logging, including min_statement_duration explain analyze ---(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