Re: [PATCHES] new aggregate functions v1

2004-05-18 Thread Bruce Momjian
... ] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life

Re: [PATCHES] new aggregate functions v3

2004-05-18 Thread Bruce Momjian
)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

[PATCHES] Fix for Win32 linking

2004-05-18 Thread Bruce Momjian
Win32 can't have the same function coming from two library object files, so we make is_absolute_path() a macro so libpq doesn't use path.o. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

Re: [PATCHES] new aggregate functions v1

2004-05-19 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I will try to apply it within the next 48 hours. This patch seems to still be under active discussion. Would you refrain from giving the impression that it's going to be applied as-is? He submitted a new version based on Neil's

Re: [PATCHES] [COMMITTERS] pgsql-server/src backend/main/main.c backend/p ...

2004-05-19 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: [EMAIL PROTECTED] (Bruce Momjian) writes: Remove elog() calls from find_my_exec; do fprintf(stderr) instead. Isn't that a seriously bad idea? Yes, it probably is bad, but I am not sure how frequently

Re: [PATCHES] [COMMITTERS] pgsql-server/src backend/main/main.c backend/p ...

2004-05-19 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: so it has to be earlier. I can put it much earlier in both postgres and postmaster, but by having it in main.c, I have it in only one place. It doesn't do any palloc or anything fancy, because of course it is also used by client

Re: [PATCHES] [COMMITTERS] pgsql-server/src backend/main/main.c backend/p

2004-05-19 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: And tested? I didn't say that I thought elog would work in main.c. In fact I'm pretty certain it won't. Compiles/regression tests pass. You need to test the cases that will produce elog output. This is why

Re: [PATCHES] [COMMITTERS] pgsql-server/src backend/main/main.c backend/p

2004-05-19 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: OK, I moved the find_my_exec calls to the locations you mentioned in both postgres.c and postmaster.c and remove it from main.c. I tested the elog and it worked. You omitted get_pkglib_path() from the postmaster case

Re: [PATCHES] [HACKERS] pg_dump end comment

2004-05-19 Thread Bruce Momjian
of the files. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: src/bin/pg_dump

Re: [PATCHES] [PORTS] Building PgSQL 7.4.2 on SGI Irix 6.19

2004-05-19 Thread Bruce Momjian
unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square

Re: [PATCHES] [COMMITTERS] pgsql-server/src backend/main/main.c b ackend/p

2004-05-19 Thread Bruce Momjian
Claudio Natoli wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Also, in the non-exec case it seems unnecessary and possibly unsafe to repeat this computation in a backend. Thanks. It originally was as below and I forgot about

Re: [PATCHES] [COMMITTERS] pgsql-server/src backend/main/main.c b ackend/p

2004-05-19 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Claudio Natoli wrote: There's also the possibility of adding it to read/write_backend_variables, just as we add other variables for fork/exec that we want the backends to inherit. In the exec case, the executable name is actually

Re: [PATCHES] Add error-checking to timestamp_recv

2004-05-19 Thread Bruce Momjian
. :) Thanks, Stephen [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us

Re: [PATCHES] pgkill for windows

2004-05-19 Thread Bruce Momjian
; done ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard

Re: [PATCHES] [HACKERS] Configuration patch

2004-05-19 Thread Bruce Momjian
in the meantime. [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED

Re: [PATCHES] pg_ctl patch to integrate apache's rotatelogs

2004-05-19 Thread Bruce Momjian
+YaC0LIVF/jNCk+QnmA= =Rsjl -END PGP SIGNATURE- [ End of raw data] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup

Re: [PATCHES] Add error-checking to timestamp_recv

2004-05-20 Thread Bruce Momjian
Stephen Frost wrote: -- Start of PGP signed section. * Bruce Momjian ([EMAIL PROTECTED]) wrote: Would you show an example of the invalid value this is trying to avoid? Well, the way I discovered the problem was by sending a timestamp in double format when the server was expecting one

Re: [PATCHES] Add error-checking to timestamp_recv

2004-05-20 Thread Bruce Momjian
Stephen Frost wrote: -- Start of PGP signed section. * Bruce Momjian ([EMAIL PROTECTED]) wrote: Stephen Frost wrote: I'll see about writing up a proper test case/schema. Looks like I'm probably most of the way there at this point, really. ;) I wasn't aware you could throw binary

Re: [PATCHES] Add error-checking to timestamp_recv

2004-05-20 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I wasn't aware you could throw binary values into the timestamp fields like that. I thought you needed to use a C string for the value. This facility was added in 7.4 as part of the wire-protocol overhaul. It's nothing directly

Re: [PATCHES] [HACKERS] Configuration patch

2004-05-20 Thread Bruce Momjian
. [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED

Re: [PATCHES] Disabling triggers / constraints

2004-05-20 Thread Bruce Momjian
to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] [HACKERS] pg_autovacuum fixes

2004-05-23 Thread Bruce Momjian
-issue. A query could fail for thousands of reasons, and doing a core dump is never a solution. Yes, these are the only two known issues. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

Re: [PATCHES] add build utilities in default install

2004-05-24 Thread Bruce Momjian
for extensions, sometimes later. I've something working that needs some finalization and tests. Good, I was wondering were we were on this. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13

[PATCHES] Relocatable locale

2004-05-24 Thread Bruce Momjian
up the exec path and stuff, and it seemed too complicated. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square

Re: [PATCHES] Relocatable locale

2004-05-24 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I have two questions. First, setlocale() seemed to be inconsistently set inside and outside of ENABLE_NLS. I assume the proper location is inside. Please do *not* go adding setlocale calls that were not there before. You

Re: [PATCHES] Relocatable locale

2004-05-24 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: OK, patch applied. Turns out it was only added for the backend (postgres). Hm? Isn't that code going to be executed in postmaster, bootstrap, checkpoint processes, etc etc? I don't really believe that path.c has any business

Re: [PATCHES] Relocatable locale

2004-05-24 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Well, as coded now, it will behave the same. No it won't: as you have it, the postmaster and everything else that goes through main.c will execute a setlocale call, which was not there before for very good reasons. I don't understand

Re: [PATCHES] Relocatable locale

2004-05-24 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: But I added code to path.c to skip that if the app is postgres. Why doesn't that work? That will work fine ... for a standalone backend. Not so fine for postmaster or bootstrap or other cases that go through main.c. But they all

Re: [PATCHES] [HACKERS] pg_ctl.c

2004-05-25 Thread Bruce Momjian
Andrew Dunstan wrote: Bruce Momjian wrote: I am almost finished Andrew's version of pg_ctl.c. Here is the current version I am using. Bruce, Thanks for advancing this. I think this is probably fairly close for Unix - the main thing missing is a more determined effort

[PATCHES] pg_ctl.c

2004-05-25 Thread Bruce Momjian
the change soon. This removes our last shell script! -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania

Re: [PATCHES] contrib/dbmirror typo fix

2004-05-25 Thread Bruce Momjian
... ] ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [PATCHES] pg_ctl.c

2004-05-26 Thread Bruce Momjian
OK, here is a new version with lots of fixes. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania

Re: [PATCHES] new aggregate functions v4

2004-05-26 Thread Bruce Momjian
: pg_strcasecmp However the aggregate part works fine. Have a nice day, -- Fabien Coelho - [EMAIL PROTECTED] Content-Description: [ Attachment, skipping... ] ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce Momjian

Re: [PATCHES] Bug in CVS pg_dump against 7.0.x

2004-05-26 Thread Bruce Momjian
previously and it was accepted :) Chris Bruce Momjian wrote: Uh, not sure anyone would even see a 7.0.X release if we made it, and I question how many are using varying[]. Your patch is now in the archives, and we can point folks to it if they ask

Re: [PATCHES] Bug in CVS pg_dump against 7.0.x

2004-05-26 Thread Bruce Momjian
and it was accepted :) Chris Bruce Momjian wrote: Uh, not sure anyone would even see a 7.0.X release if we made it, and I question how many are using varying[]. Your patch is now in the archives, and we can point folks to it if they ask

Re: [PATCHES] More network functions...

2004-05-26 Thread Bruce Momjian
analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] Cancel/Kill backend functions

2004-05-26 Thread Bruce Momjian
... ] ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road

Re: [PATCHES] Relocatable locale

2004-05-26 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian wrote: I have two questions. First, setlocale() seemed to be inconsistently set inside and outside of ENABLE_NLS. I assume the proper location is inside. No, in case of doubt it's outside. OK, moved. New code is: void

Re: [PATCHES] Relocatable locale

2004-05-26 Thread Bruce Momjian
Andrew Dunstan wrote: Bruce Momjian wrote: Peter Eisentraut wrote: Andrew Dunstan wrote: I'm confused. Can you explain the problem more clearly, please? Do we need to distinguish known apps with a known (relative) message location, from unknown libpq clients

Re: [PATCHES] Relocatable locale

2004-05-26 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian wrote: I am wondering if we should use environment variables, and have our apps use putenv() to set it to the proper relative path. The problem isn't our applications, it's someone else's applications. Are you saying that from now on, setting

Re: [PATCHES] Relocatable locale

2004-05-27 Thread Bruce Momjian
Peter Eisentraut wrote: Am Donnerstag, 27. Mai 2004 14:41 schrieb Bruce Momjian: As for how to do it - on Windows you *can* get the path of the DLL that is executing your code, using GetModuleFileName(). Hardly cross-platform, but can be done. That sounds pretty reasonable to me

Re: [PATCHES] Relocatable locale

2004-05-27 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I will make a Win32-specific patch. Do we want an evironment variable for Unix? No, we do not. This entire thread has consisted of everyone but you objecting loudly to that idea. They didn't sound very loud to me. Why not have

Re: [PATCHES] [HACKERS] Configuration patch

2004-05-27 Thread Bruce Momjian
a little bit more sane in the meantime. [ Attachment, skipping... ] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http

Re: [PATCHES] Link errors on win32

2004-05-28 Thread Bruce Momjian
for me. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end

Re: [PATCHES] thread safety testing fix

2004-05-28 Thread Bruce Momjian
this going to break platforms that only want 5 X's ? My BSD/OS doesn't specify a specific number of X's, but it does use an example with six, so six should be fine. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your

Re: [PATCHES] mingw configure failure detection

2004-05-28 Thread Bruce Momjian
OK, fixed. --- Andrew Dunstan wrote: Bruce Momjian wrote: Andrew Dunstan wrote: following up our conversation last night, I have tested the following with autoconf 2.57 and it apparently does the right thing

Re: [PATCHES] Libpq ssl fix

2004-05-28 Thread Bruce Momjian
You will find Anreas's two patches in the patch queue. Are there more changes than that? --- Manfred Spraul wrote: Bruce Momjian wrote: - patch for thread_test.c needed posted some hours ago. Applied

Re: [PATCHES] [HACKERS] New pg_ctl has retrogressed in error messages

2004-05-31 Thread Bruce Momjian
failed to signal postmaster process 15273: No such process OK, new output is: $ aspg pg_ctl stop stop signal failed (PID: 3603): No such process I also changed all the pid variables to use pid_t. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL

Re: [PATCHES] [HACKERS] New pg_ctl has retrogressed in error messages

2004-05-31 Thread Bruce Momjian
negative values are an issue. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ? pg_ctl Index

Re: [PATCHES] Fully enabling NLS in pg_ctl

2004-05-31 Thread Bruce Momjian
YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] [HACKERS] Configuration patch

2004-06-02 Thread Bruce Momjian
. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 Index: doc/src/sgml/runtime.sgml

Re: [PATCHES] Small change in link order

2004-06-02 Thread Bruce Momjian
)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [PATCHES] Cancel/Kill backend functions

2004-06-02 Thread Bruce Momjian
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: den 26 maj 2004 20:50 To: Magnus Hagander Cc: Neil Conway; [EMAIL PROTECTED] Subject: Re: [PATCHES] Cancel/Kill backend functions Magnus, would you please resumbit this as a context diff

Re: [PATCHES] Small doc patch for area() function...

2004-06-02 Thread Bruce Momjian
) == -- Sean Chittenden ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [PATCHES] Relocatable locale

2004-06-02 Thread Bruce Momjian
it is already set. This will allow our applications to emit proper locale messages that are generated in libpq. --- Bruce Momjian wrote: Andrew Dunstan wrote: Bruce Momjian wrote: Peter Eisentraut wrote

Re: [PATCHES] Compiling libpq with VisualC

2004-06-02 Thread Bruce Momjian
Bruce Momjian wrote: I noticed that SYSCONFDIR will also be an issue for relocatable installs just like localedir. I will address them in the same way either as an environment variable or libpq function call to set the location. Fixed. fe-connect.c: - pg_config_paths.h isn't

Re: [PATCHES] Libpq ssl fix

2004-06-02 Thread Bruce Momjian
: 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 -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610

Re: [PATCHES] fix for pg_regress.sh on mingw

2004-06-02 Thread Bruce Momjian
unset postmaster_pid fi ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Bruce Momjian| http://candle.pha.pa.us

Re: [PATCHES] [HACKERS] Configuration patch

2004-06-03 Thread Bruce Momjian
up the new -D/PGDATA functionality. I was wondering myself how someone would configure this. Do we need to add an initdb capability? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

Re: [PATCHES] small fix in FAQ

2004-06-03 Thread Bruce Momjian
Euler Taveira de Oliveira wrote: Hi, This is a small fix in FAQ. It just clean up some old comments and change an old -not-working piece of code. Please apply it in HEAD and 7.4 branch. Thanks. Patch applied to HEAD. We don't normally backpatch stuff like this to 7.4.X. -- Bruce

Re: [PATCHES] [HACKERS] pg_dump --comment?

2004-06-03 Thread Bruce Momjian
-- -- -- PostgreSQL database dump complete -- Completed on 2004-06-04 01:01:36 EDT -- -- -- PostgreSQL database cluster dump complete -- Completed on 2004-06-04 01:01:36 EDT -- -- Bruce Momjian| http

Re: [PATCHES] [HACKERS] pg_dump --comment?

2004-06-04 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: The following patch adds start/stop times for pg_dump and pg_dumpall What happens in a pg_dump -Fc / pg_restore scenario? Uh, do those markers not appear in that dump type? I thought they did. I just tried pg_restore -v and while I

Re: [PATCHES] Compiling libpq with VisualC

2004-06-04 Thread Bruce Momjian
Patch applied. I didn't realize that file was for win32 _client_ compiles, and I didn't realize it had no pg_config_paths.h. --- Andreas Pflug wrote: Bruce Momjian wrote: Andreas Pflug wrote: Bruce Momjian wrote

Re: [PATCHES] [HACKERS] pg_dump --comment?

2004-06-04 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: What happens in a pg_dump -Fc / pg_restore scenario? So, in non-ascii format, I need to dump a comment record and read it back on restore? Yuck. Anyone want to tackle that? Yes. Hacking the output routines

Re: [PATCHES] Tablespaces

2004-06-05 Thread Bruce Momjian
and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] pgxs: build infrastructure for extensions v1

2004-06-07 Thread Bruce Momjian
to [EMAIL PROTECTED] -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

Re: [PATCHES] [HACKERS] CVS tip problems

2004-06-07 Thread Bruce Momjian
This patch fixes strerror_r() by checking the return type from configure. --- Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: The code we have appears to assume that the result will always be placed in the user

Re: [PATCHES] [HACKERS] CVS tip problems

2004-06-07 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: ! #ifdef STRERROR_R_INT ! /* SUSv3 version */ ! if (strerror_r(errnum, strerrbuf, buflen) == 0) ! return strerrbuf; ! else ! return NULL; ! #else This code will dump core if strerror_r ever fails

Re: [PATCHES] [HACKERS] CVS tip problems

2004-06-07 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I assume all the callers have to check for NULL, Eh? *None* of the callers of pqStrerror check for NULL, and I don't think they should have to. We surely do not check for null return from plain strerror() anyplace. Oh, I see

Re: [PATCHES] Relocatable locale

2004-06-08 Thread Bruce Momjian
Peter Eisentraut wrote: Bruce Momjian wrote: With no one coming up with a better idea, this applied patch adds PGETC (for pg_service.conf) and PGLOCALE (for locale dir) environment variable processing to libpq. Considering that in other places these locations are referred

Re: [PATCHES] Stylistic changes in bufmgr.c

2004-06-08 Thread Bruce Momjian
; } } } ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [PATCHES] vacuum.c refactoring

2004-06-08 Thread Bruce Momjian
Patch applied. Thanks. --- Manfred Koizar wrote: . rename variables . cur_buffer - dst_buffer . ToPage - dst_page . cur_page - dst_vacpage . move variable declarations into block where variable

[PATCHES] Regression test for COPY CSV format

2004-06-09 Thread Bruce Momjian
I have added some regression tests for COPY CSV format. I had promised Andrew I would do this because he did pg_ctl in C. :-) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13

Re: [PATCHES] Tablespaces

2004-06-09 Thread Bruce Momjian
will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [PATCHES] [HACKERS] dynamic_library_path on Win32

2004-06-09 Thread Bruce Momjian
Hallgren Bruce Momjian [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I can do it but will be a few days until I get to it. -- - Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: You've

Re: [PATCHES] Fully enabling NLS in pg_ctl

2004-06-09 Thread Bruce Momjian
command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown

Re: [PATCHES] FAQ translation to pt_BR

2004-06-09 Thread Bruce Momjian
FAQ? http://www.postgresql.org/docs/faqs/FAQ.html -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown

Re: [PATCHES] fix schema ownership for database owner on first connection

2004-06-09 Thread Bruce Momjian
, skipping... ] ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359

Re: [PATCHES] [HACKERS] serverlog function (log_destination file)

2004-06-09 Thread Bruce Momjian
*LogFileName(void); +extern void LogFileOpen(void); +extern void LogFileClose(void); #endif /* ELOG_H */ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http

Re: [PATCHES] [HACKERS] serverlog function (log_destination file)

2004-06-09 Thread Bruce Momjian
/* ELOG_H */ ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard

Re: [PATCHES] Nested transactions

2004-06-09 Thread Bruce Momjian
. - Bruce Momjian for useful ideas. IMHO this patch should be reviewed and applied to achieve wide testing as soon as possible before feature freeze. More changes can be applied later as available/needed. (The patch is already huge and contains several important changes that need careful

Re: [PATCHES] Turkish translation of FAQ (fwd)

2004-06-09 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: I cannot see this in the CVS. Could someone please apply it? I'd like it to be in 7.3.6 :( I was away last week and I think 7.4.X and 7.3.X are already packaged. Applied to HEAD and 7.4.X. 7.3.6 is already wrapped, but 7.4.2

Re: [PATCHES] Fully enabling NLS in pg_ctl

2004-06-10 Thread Bruce Momjian
Peter says he has your patches and will have them in 7.4.3. --- Serguei Mokhov wrote: - Original Message - From: Bruce Momjian [EMAIL PROTECTED] Sent: June 09, 2004 10:59 PM OK, I added the nls and po

Re: [PATCHES] Fully enabling NLS in pg_ctl

2004-06-10 Thread Bruce Momjian
Serguei A. Mokhov wrote: On Thu, 10 Jun 2004, Bruce Momjian wrote: Date: Thu, 10 Jun 2004 09:25:14 -0400 (EDT) Peter says he has your patches and will have them in 7.4.3. Cool. Thanks. Will more translation patches be accepted on Friday and during the weekend before 7.4.3 release? I

Re: [PATCHES] [HACKERS] serverlog function (log_destination file)

2004-06-10 Thread Bruce Momjian
Andreas Pflug wrote: Sorry I didn't get back on this earlier, yesterday morning my internet access was literally struck by lightning, I'm running temporary hardware now. Bruce Momjian wrote: Looks good to me. The only issue I saw was that the default file name mentioned

Re: [PATCHES] [HACKERS] serverlog function (log_destination file)

2004-06-10 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Actually, my idea of sending a message to stderr saying we are using a pre-configured file is so folks aren't surprised by the fact they can't see any stderr anymore. Hm? I thought we'd just established that the patch wasn't going

[PATCHES] pg_ctl using START with paths needing quotes

2004-06-10 Thread Bruce Momjian
START with the batch name: START /B C:\PG_CTL_323223.BAT then unlink the batch file. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your

Re: [PATCHES] delayed planning of unnamed statements

2004-06-10 Thread Bruce Momjian
Applied by Tom. Thanks. --- Oliver Jowett wrote: Per discussion on -hackers (http://archives.postgresql.org/pgsql-hackers/2004-05/msg00990.php), here is a first cut at delaying query planning for unnamed statements

Re: [PATCHES] Compiling libpq with VisualC

2004-06-10 Thread Bruce Momjian
pthread_self(); void pthread_setspecific(pthread_key_t, void*); void* pthread_getspecific(pthread_key_t); void pthread_mutex_init(pthread_mutex_t *, void *attr); void pthread_mutex_lock(pthread_mutex_t*); // blocking void pthread_mutex_unlock(pthread_mutex_t*); #endif -- Bruce

Re: [PATCHES] pgpipe error reporting

2004-06-10 Thread Bruce Momjian
yet) /Magnus pipe_errmsg.patch Content-Description: pipe_errmsg.patch [ Attachment, skipping... ] ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] -- Bruce Momjian

Re: [PATCHES] [pgsql-hackers-win32] [HACKERS] select like...not using index

2004-06-10 Thread Bruce Momjian
of broadcast)--- TIP 7: don't forget to increase your free space map settings -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can

Re: [PATCHES] CR fix for create_help.pl

2004-06-10 Thread Bruce Momjian
)--- TIP 8: explain analyze is your friend -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073

[PATCHES] Fix for Win32 START

2004-06-11 Thread Bruce Momjian
After digging, I found START can accept a quoted executable name if you put a title of before it. I have remove the batch file hack and documented this requirement. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001

Re: [PATCHES] pg_ctl using START with paths needing quotes

2004-06-11 Thread Bruce Momjian
be preceded by '@' to suppress echoing . the whole command, including redirections should go inside the .bat file, so that pg_ctl just issues 'start /b foo.bat' There are still things to clean up in pg_ctl, e.g. its handling of relative paths to the data dir. Hack removed. -- Bruce Momjian

Re: [PATCHES] Compiling libpq with VisualC

2004-06-11 Thread Bruce Momjian
pthread_mutex_init() should be called only once, and we have to guarantee that. If the Windows implentation allows it to be called multiple times, just create a function to be called only by Win32 that does that and leave the Unix safe. -- Bruce Momjian| http

Re: [PATCHES] path.c char[strlen(xxx)] not portable

2004-06-11 Thread Bruce Momjian
[MAXPGPATH + strlen(PGLOCALEDIR=)]; use sizeof instead. Please apply to current Andreas Content-Description: path.c.locale.patch [ Attachment, skipping... ] ---(end of broadcast)--- TIP 8: explain analyze is your friend -- Bruce

Re: [PATCHES] pg_ctl using START with paths needing quotes

2004-06-11 Thread Bruce Momjian
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Bruce Momjian wrote: This applied patch changes the way pg_ctl starts on Win32. Using START, it is not possible to quote the executable name, who's directory might have spaces: This is a really ugly hack (I take the blame

Re: [PATCHES] [HACKERS] serverlog function (log_destination file)

2004-06-11 Thread Bruce Momjian
silly in this connection.) My vote is not to apply until and unless something that can rotate the logfile is demonstrated ... Agreed. Lets see where it goes. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your

Re: [PATCHES] Fix for erroneous warning on Shutdown

2004-06-11 Thread Bruce Momjian
an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive

Re: [PATCHES] Compiling libpq with VisualC

2004-06-11 Thread Bruce Momjian
Can you put that in the new pthread file that needs to be added for Win32? --- Manfred Spraul wrote: Andreas Pflug wrote: Bruce Momjian wrote: Agreed. My pthread book says pthread_mutex_init() should be called

<    2   3   4   5   6   7   8   9   10   11   >