Re: [HACKERS] Collation rules and multi-lingual databases

2003-08-23 Thread Stephan Szabo
On Fri, 22 Aug 2003, Stephan Szabo wrote: > On Fri, 22 Aug 2003, Tom Lane wrote: > > > Stephan Szabo <[EMAIL PROTECTED]> writes: > > > On 22 Aug 2003, Greg Stark wrote: > > >> If it's deemed a reasonable approach and nobody has any fatal flaws then I > > >> expect it would be useful to put in the

Re: [HACKERS] strerror_r and gethostbyname_r?

2003-08-23 Thread Larry Rosenman
--On Friday, August 22, 2003 21:23:57 -0500 Larry Rosenman <[EMAIL PROTECTED]> wrote: How can I --enable-thread-safety and JUST need the getpwuid_r function and not the strerror_r and gethostbyname_r function? UnixWare doesn't have strerror_r and gethostbyname_r, and we DONT NEED THEM! Please h

Re: [HACKERS] Collation rules and multi-lingual databases

2003-08-23 Thread Greg Stark
Stephan Szabo <[EMAIL PROTECTED]> writes: > Since most of that work is for an exceptional case, maybe it'd be safer > (although slower) to structure the function as Yeah I thought of that. But if making it a critical section is cheap then it's probably a better approach. The problem with restorin

Re: [HACKERS] Single-file DBs WAS: Need concrete "Why Postgres

2003-08-23 Thread Jeff
On Fri, 22 Aug 2003, Mike Mascari wrote: > In addition to Jan's points, using a single pre-allocated file also > reduces file descriptor consumption, although I don't know what the > costs are regarding maintaining the LRU of file descriptors, the price > of opens and closes, the price of having a

Re: [HACKERS] Single-file DBs WAS: Need concrete 'Why Postgres

2003-08-23 Thread Andrew Dunstan
Is anyone seriously suggesting that postgres should support either raw devices or use some sort of virtual file system? If not, this whole discussion is way off topic. And if they are my response would be that it would at best be a serious waste of time - there is far more important work to do. c

Re: [HACKERS] Collation rules and multi-lingual databases

2003-08-23 Thread Stephan Szabo
On 23 Aug 2003, Greg Stark wrote: > Stephan Szabo <[EMAIL PROTECTED]> writes: > > > Since most of that work is for an exceptional case, maybe it'd be safer > > (although slower) to structure the function as > > Yeah I thought of that. But if making it a critical section is cheap then it's > probab

Re: [HACKERS] Collation rules and multi-lingual databases

2003-08-23 Thread Joe Conway
Greg Stark wrote: Yeah I thought of that. But if making it a critical section is cheap then it's probably a better approach. The problem with restoring the locale for the palloc is that if the user is unlucky he might sort a table of thousands of strings that all trigger the exception case. What ab

[HACKERS] sequence generator for sysids

2003-08-23 Thread Andrew Dunstan
I was looking at a sequence generator for sysids. It appears to me that such an object would need to be global, and it looks like the only way to create global things is in the bootstrap code. But it doesn't look like the bootstrap code knows how to create a sequence object, so we'd have to tea

Re: [HACKERS] Collation rules and multi-lingual databases

2003-08-23 Thread Joe Conway
Joe Conway wrote: What about something like this? Oops! Forgot to restrore error handling. See below: Joe 8< #include #include #include "postgres.h" #include "fmgr.h" #include "tcop/tcopprot.h" #include "utils/builtins.h" #define GET_STR(textp) \ DatumGetCStri

Re: [HACKERS] Header files installed for contrib modules?

2003-08-23 Thread Peter Eisentraut
Robert Creager writes: > Just wondering if there is currently any mechanism in the contrib makefile > hierarchy for installing header files into an appropriate directory. There isn't, because until now there was no need for it. But there is no reason that it couldn't be added. -- Peter Eisentr

Re: [HACKERS] Collation rules and multi-lingual databases

2003-08-23 Thread Greg Stark
Joe Conway <[EMAIL PROTECTED]> writes: > > if (sigsetjmp(Warn_restart, 1) != 0) > > { > > memcpy(&Warn_restart, &save_restart, sizeof(Warn_restart)); > > newlocale = setlocale(LC_COLLATE, oldlocale); > > if (!newlocale) > > elog(PANIC, "setlocale failed to reset locale: %s",

[HACKERS] ambiguous sql states

2003-08-23 Thread Dave Cramer
I'm working on identifying various errors in ecpg using sql state and one which is particularly ambiguous is ERRCODE_UNDEFINED_OBJECT for a file which isn't found. This is returned in a number of places. Is it possible to get a set of file specific error codes? Dave -- Dave Cramer <[EMAIL PROTEC

Re: [HACKERS] Collation rules and multi-lingual databases

2003-08-23 Thread Joe Conway
Greg Stark wrote: Joe Conway <[EMAIL PROTECTED]> writes: if (sigsetjmp(Warn_restart, 1) != 0) { memcpy(&Warn_restart, &save_restart, sizeof(Warn_restart)); newlocale = setlocale(LC_COLLATE, oldlocale); if (!newlocale) elog(PANIC, "setlocale failed to reset locale: %s", localestr);

Re: [HACKERS] ambiguous sql states

2003-08-23 Thread Peter Eisentraut
Dave Cramer writes: > I'm working on identifying various errors in ecpg using sql state and > one which is particularly ambiguous is ERRCODE_UNDEFINED_OBJECT for a > file which isn't found. This is returned in a number of places. Is it > possible to get a set of file specific error codes? That er

Re: [HACKERS] ambiguous sql states

2003-08-23 Thread Dave Cramer
Specifically, if you try to open a file for copy, and it isn't there it will return int errcode_for_file_access(void) { case ENOENT:/* No such file or directory */ edata->sqlerrcode = ERRCODE_UNDEFINED_OBJECT; bre

Re: [HACKERS] Header files installed for contrib modules?

2003-08-23 Thread Robert Creager
On Sat, 23 Aug 2003 21:16:38 +0200 (CEST) Peter Eisentraut <[EMAIL PROTECTED]> said something like: > Robert Creager writes: > > > Just wondering if there is currently any mechanism in the contrib makefile > > hierarchy for installing header files into an appropriate directory. > > There isn't,

Re: [HACKERS] Header files installed for contrib modules?

2003-08-23 Thread Peter Eisentraut
Robert Creager writes: > So would one of you fine hackers be willing to add this feature? If not, I'll > have a go of it. There isn't any contrib module that would use it, so why bother? > Would this be best accomplished using a sub-directory which contains the header > files to install, or a m

[HACKERS] libpq with SSL on Win32

2003-08-23 Thread Dave Page
Hi all, Has anyone ever got libpq to compile with SSL support on Windows (natively, not Cygwin)? It looks like there is some work required in fe-secure.c - just wondering if anyone played with it before... Regards, Dave. ---(end of broadcast)---