[HACKERS] Escaping in C-language functions

2002-03-29 Thread Andreas Scherbaum
Hello, i have a C-language function and need to escape some strings returned from SPI_getvalue to insert into another query string. Is there a proper way to do the escaping or should i use my own functions for that? Or i'm totally wrong and there's a better way to get the values from a row and i

[HACKERS] Posix AIO in new Red Hat Linux

2002-03-29 Thread Justin Clift
Hi everyone, I just read the annoucement of the public beta for Red Hat Linux's new server-oriented edition (code named Pensacola) : https://listman.redhat.com/pipermail/redhat-watch-list/2002-February/000466.html One of the things this mentions being included/tuned in its kernel is : POSIX

Re: [HACKERS] timeout implementation issues

2002-03-29 Thread Bruce Momjian
Tom Lane wrote: > Jessica Perry Hekman <[EMAIL PROTECTED]> writes: > > [snip] > > My proposal, then, is that the Java driver should submit the > > transaction request; wait for the timeout; if it goes off, submit a > > cancel request; and then throw a SQLException. We would not handle > > this in

Re: [HACKERS] timeout implementation issues

2002-03-29 Thread Tom Lane
Jessica Perry Hekman <[EMAIL PROTECTED]> writes: > [snip] > My proposal, then, is that the Java driver should submit the > transaction request; wait for the timeout; if it goes off, submit a > cancel request; and then throw a SQLException. We would not handle > this in the backend at all. > Bruce

Re: [HACKERS] Ok, I lied about it working... TCP_NODELAY?

2002-03-29 Thread Peter Eisentraut
Rod Taylor writes: > Is anonymous cvs on a time delay? Yes. I believe it's one hour. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister Yo

Re: [HACKERS] Ok, I lied about it working... TCP_NODELAY?

2002-03-29 Thread Rod Taylor
Is anonymous cvs on a time delay? I keep getting 1.172 of configure.in from HEAD. Should be 173 -- Rod Taylor Your eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. You cannot imagin

Re: [HACKERS] Ok, I lied about it working... TCP_NODELAY?

2002-03-29 Thread Peter Eisentraut
Rod Taylor writes: > Configure worked, compile failed :) > > gcc -pipe -O2 -Wall -Wmissing-prototypes -Wmissing-declarations > -I../../../src/include -c -o pqcomm.o pqcomm.c > pqcomm.c: In function `StreamConnection': > pqcomm.c:395: `TCP_NODELAY' undeclared (first use in this function) > pqcom

[HACKERS] Ok, I lied about it working... TCP_NODELAY?

2002-03-29 Thread Rod Taylor
Configure worked, compile failed :) gcc -pipe -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../src/include -c -o pqcomm.o pqcomm.c pqcomm.c: In function `StreamConnection': pqcomm.c:395: `TCP_NODELAY' undeclared (first use in this function) pqcomm.c:395: (Each undeclared identif

Re: [HACKERS] Configure issues - FreeBSD 4.5-RELEASE

2002-03-29 Thread Rod Taylor
It appears to work now -- as stated. -- Rod Taylor Your eyes are weary from staring at the CRT. You feel sleepy. Notice how restful it is to watch the cursor blink. Close your eyes. The opinions stated above are yours. You cannot imagine why you ever felt otherwise. - Original Message -

Re: [HACKERS] Configure issues - FreeBSD 4.5-RELEASE

2002-03-29 Thread Peter Eisentraut
I wrote: > > Configure fails checking for types of arguements to accept(). > > Fix committed. Try again please. OK, it needed two more fixes, but I just ran it on FreeBSD and now it works. I promise. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)-

Re: [HACKERS] Configure issues - FreeBSD 4.5-RELEASE

2002-03-29 Thread Peter Eisentraut
Rod Taylor writes: > Configure fails checking for types of arguements to accept(). Fix committed. Try again please. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgre

[HACKERS] Configure issues - FreeBSD 4.5-RELEASE

2002-03-29 Thread Rod Taylor
Configure fails checking for types of arguements to accept(). Full log at: http://www.zort.ca/temp/config.log checking sys/ipc.h presence... yes configure: WARNING: sys/ipc.h: present but cannot be compiled configure: WARNING: sys/ipc.h: check for missing prerequisite headers? configure: WARNIN

[HACKERS] timeout implementation issues

2002-03-29 Thread Jessica Perry Hekman
I have been talking with Bruce Momjian about implementing query timeouts in the JDBC driver. As things stand, you can call setQueryTimeout() or getQueryTimeout(), but a slow query will never actually timeout, even if a timeout is set. The result of a timeout should be a SQLException. Bruce feels

[HACKERS] administrivia = no

2002-03-29 Thread Marc G. Fournier
there, let's see if that doens't hurt things too much ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Autoconf upgraded

2002-03-29 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > It's done. It seems a tad broken. ... checking string usability... yes checking string presence... yes checking for string... yes checking for class string in ... no configure: error: neither nor seem to define the C++ class 'string' $ Not havin

Re: [HACKERS] pg_dump 2GB limit?

2002-03-29 Thread Jan Wieck
Christopher Kings-Lynne wrote: > > > File size limit exceeded (core dumped) > > > > > > We suspect pg_dump. Is this true? Why would there be this limit in > > > pg_dump? Is it scheduled to be fixed? > > Try piping the output of pg_dump through bzip2 before writing it to disk. > Or else, I think

[HACKERS] Autoconf upgraded

2002-03-29 Thread Peter Eisentraut
It's done. Note some behavioral changes: * The cache file config.cache is now off by default. If you still want it, run './configure -C'. * Specifying --host now means you are cross compiling. So don't do it. Use --build if you really have to. Which you don't. * Running 'autoconf' is now ve

Re: [HACKERS] Bug or feature in 7.3?

2002-03-29 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: > Why field 'bar' has modifier 'not null'? Oh ... last parameter of TypeCreate should be false not 'f' ... two places in define.c. Bug introduced in DOMAIN patch evidently. I have a ton of other changes I'm about to commit in that area, will fix this one

Re: [HACKERS] Bug or feature in 7.3?

2002-03-29 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: > Why field 'bar' has modifier 'not null'? Hmm ... looks like CREATE TYPE is leaving typnotnull set TRUE for user- created types; all the types created on-the-fly in the regression tests have the same problem. A bug, I agree. Don't see where the error i

Re: [HACKERS] Mailing List Question

2002-03-29 Thread Thomas Lockhart
... > Let me disable the administrative stuff being blocked and we'll see if it > makes much of a difference in the way of 'false traffic' ... Great! Thanks Marc. - Thomas Uh, just to confirm: you are removing administrative blocks, and also removing any scanning of messages f

[HACKERS] Bug or feature in 7.3?

2002-03-29 Thread Teodor Sigaev
Hello. Some example: compile and install contrib/tsearch module and now: wow=# create table foo (bar txtidx); CREATE wow=# \d foo Table "foo" Column | Type | Modifiers ++--- bar| txtidx | not null Why field 'bar' has modifier 'not null'? -- Teodor S