Re: [pgsql-hackers-win32] [HACKERS] snprintf causes regression tests

2005-03-15 Thread Bruce Momjian
I have applied a modified version of your patch, attached. initdb will not work without %*s support, so I had to add that. Please look over my work. I don't think i handle %*1$ but I am not even sure what that means or if our translators would ever use such a thing. You can probably test that

Re: [HACKERS] PHP stuff

2005-03-15 Thread Christopher Kings-Lynne
Uh, but that's what the BSD license allows --- relicensing as any other license, including commercial. The point remains that Chris, by himself, does not hold the copyright on the PG docs and therefore cannot assign it to anyone. ISTM the PHP guys are essentially saying that they will only take stu

Re: [HACKERS] PQexecParams

2005-03-15 Thread Christopher Kings-Lynne
Will PQexecParams automatically escape bytea data as it goes in, or must one run it through PQescapeBytea first? Neither. The data does not need escaping (assuming you pass it as a parameter, of course.) Even binary data? ie. You could upload a binary string straight into PQexecParams with no o

Re: [HACKERS] contrib/pg_buffercache

2005-03-15 Thread Mark Kirkwood
Andrew Dunstan wrote: ... is apparently broken for Windows and Cygwin. See for example http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=loris&dt=2005-03-16%2001:55:33 cheers hmmm - never tried to compile it on win32! I am getting http 502 from the above url, so I will have a go at building on win

Re: [HACKERS] invalidating cached plans

2005-03-15 Thread Tom Lane
Greg Stark <[EMAIL PROTECTED]> writes: > That makes me wonder. What happens if I prepare a query, then use SET SESSION > AUTHORIZATION to change my user. Then try to execute the query? Permissions checks are applied at executor startup, not by the planner, so it should Work Correctly in my view of

[HACKERS] Real-Time Vacuum Possibility

2005-03-15 Thread Rod Taylor
This is a much discussed topic, which always boils down to grabbing indexes from disk. At the moment we have bgwriter periodically flushing parts of the dirty buffers to disk on a periodic basis. Would it be possible to have the bgwriter take a look at the pages it has, and see if it can do any va

[HACKERS] contrib/pg_buffercache

2005-03-15 Thread Andrew Dunstan
... is apparently broken for Windows and Cygwin. See for example http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=loris&dt=2005-03-16%2001:55:33 cheers andrew ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appr

Re: [HACKERS] [pgsql-hackers-win32] UNICODE/UTF-8 on win32

2005-03-15 Thread Bruce Momjian
Tatsuo Ishii wrote: > I do understand the problem, but don't undertstand the decision you > guys made. The fact that UPPER/LOWER and some other functions does not > work in win32 is surely a problem for some languages, but not a > problem for otheres. For example, Japanese (and probably Chinese and

Re: [HACKERS] CVS head broken on win32?

2005-03-15 Thread Neil Conway
Tom Lane wrote: Um. Shouldn't that whole file be #ifndef EXEC_BACKEND? Woops, sorry about that. We can't make the file #ifndef EXEC_BACKEND since fork_process() is used by the Unix implementation of internal_forkexec(), but #ifndef WIN32 should work. I've applied the attached patch to HEAD. -Ne

Re: [HACKERS] change palloc to malloc

2005-03-15 Thread Bruce Momjian
Nguyen Hai wrote: > Hi, > > Is it possible to convert palloc back to malloc? > If so, what should I do to make the change? You can, but palloc is automatically freed at the end of a query, while malloc has to be freed in the code. Why do you want to make the switch? -- Bruce Momjian

[HACKERS] change palloc to malloc

2005-03-15 Thread Nguyen Hai
Hi, Is it possible to convert palloc back to malloc? If so, what should I do to make the change? Many Thanks, Hai __ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/

Re: [HACKERS] CVS head broken on win32?

2005-03-15 Thread Tom Lane
Thomas Hallgren <[EMAIL PROTECTED]> writes: > I'm trying to compile CVS HEAD on Win32. > postmaster/SUBSYS.o(.text+0x9d7):fork_process.c: undefined reference to > `fork' Um. Shouldn't that whole file be #ifndef EXEC_BACKEND? regards, tom lane ---

[HACKERS] CVS head broken on win32?

2005-03-15 Thread Thomas Hallgren
I'm trying to compile CVS HEAD on Win32. ./configure --enable-integer-datetimes make ... It ends with: postmaster/SUBSYS.o(.text+0x9d7):fork_process.c: undefined reference to `fork' gcc --version and uname -a gcc.exe (GCC) 3.4.1 (mingw special) MINGW32_NT-5.1 THHALHOME3 1.0.11(0.46/3/2) 2004-03-3

Re: [HACKERS] signed short fd

2005-03-15 Thread Bruce Momjian
Mark Woodward wrote: > >> > I actually met him _briefly_ at Linuxworld in Boston. He just said > >> > "hi", then disappeared. :-) > >> > >> Bruce, I did want to meet you to a greater extent, but you we surrounded > >> by people and looked quite busy. > > > > Yea, I was just teasing. It was a ver

Re: [HACKERS] type unknown - how important is it?

2005-03-15 Thread Russell Smith
On Wed, 16 Mar 2005 05:17 am, Dave Cramer wrote: > Shachar, > > I think with type oid 705 (unknown) it's safe to treat it as text. > Certainly better than punting. > > On another note are you aware of any issues with transactions? > Specifically with using the dated autocommit mode ? > > Dave

Re: [HACKERS] type unknown - how important is it?

2005-03-15 Thread Dave Cramer
Shachar, I think with type oid 705 (unknown) it's safe to treat it as text. Certainly better than punting. On another note are you aware of any issues with transactions? Specifically with using the dated autocommit mode ? Dave Shachar Shemesh wrote: Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED

[HACKERS] Kerberos code overwrites it's own error message

2005-03-15 Thread Magnus Hagander
interfaces/libpq/fe-auth, line 621-622: <> if (pg_krb5_sendauth(PQerrormsg, conn->sock, hostname) != STATUS_OK) { snprintf(PQerrormsg, PQERRORMSG_LENGTH, libpq_gettext("K

Re: [HACKERS] invalidating cached plans

2005-03-15 Thread Greg Stark
Tom Lane <[EMAIL PROTECTED]> writes: > Neil Conway <[EMAIL PROTECTED]> writes: > > (BTW, another thing to consider is how the rewriter will effect a plan's > > dependencies: I think we should probably invalidate a plan when a > > modification is made to a view or rule that affected the plan. >

Re: [HACKERS] type unknown - how important is it?

2005-03-15 Thread Shachar Shemesh
Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: I just had a customer complain about this. My understanding is that unkown is a constant which has not been typed yet. Is it possible for it to be a binary type, if so how ? I would think it should only ever be a string? You can read

Re: [HACKERS] PQexecParams

2005-03-15 Thread Alvaro Herrera
On Tue, Mar 15, 2005 at 02:02:58PM +0800, Christopher Kings-Lynne wrote: > Will PQexecParams automatically escape bytea data as it goes in, or must > one run it through PQescapeBytea first? Neither. The data does not need escaping (assuming you pass it as a parameter, of course.) -- Alvaro Her

Re: [HACKERS] PHP stuff

2005-03-15 Thread Tom Lane
Bruce Momjian writes: > Bruno Wolff III wrote: >> Just because the licenses are compatible, doesn't necessarily mean you >> can safely sign over the copyrights for documentation that you don't hold. >> If PHP holds the copyright they can relicense the documentation later under >> a license that ma

Re: [HACKERS] type unknown - how important is it?

2005-03-15 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > I just had a customer complain about this. My understanding is that > unkown is a constant which has not been typed yet. Is it possible for it > to be a binary type, if so how ? > I would think it should only ever be a string? You can read "unknown" as "

Re: [HACKERS] signed short fd

2005-03-15 Thread Mark Woodward
> Mark Woodward wrote: >> > Christopher Kings-Lynne wrote: >> >> > I really don't intend to do that, and it does seem to happen a lot. >> I >> >> am >> >> > the first to admit I lack tact, but often times I view the >> decisions >> >> made >> >> > as rather arbitrary and lacking a larger perspectiv

Re: [HACKERS] PHP stuff

2005-03-15 Thread Bruce Momjian
Bruno Wolff III wrote: > On Tue, Mar 15, 2005 at 08:34:14 -0500, > Bruce Momjian wrote: > > > > Uh, but that's what the BSD license allows --- relicensing as any other > > license, including commercial. > > If that were true, than why not have the code public domain? Ismn't there > credit info

Re: [HACKERS] PHP stuff

2005-03-15 Thread Bruno Wolff III
On Tue, Mar 15, 2005 at 08:34:14 -0500, Bruce Momjian wrote: > > Uh, but that's what the BSD license allows --- relicensing as any other > license, including commercial. If that were true, than why not have the code public domain? Ismn't there credit information that is supposed to be kept? -

Re: [HACKERS] PHP stuff

2005-03-15 Thread Bruce Momjian
Bruno Wolff III wrote: > On Tue, Mar 15, 2005 at 06:08:48 -0500, > Mark Woodward <[EMAIL PROTECTED]> wrote: > > > I'm currently adding support for the v3 protocol in PHP pgsql extension. > > > I'm wondering if anyone minds if I lift documentation wholesale from > > > the PostgreSQL docs for the

Re: [HACKERS] PHP stuff

2005-03-15 Thread Bruno Wolff III
On Tue, Mar 15, 2005 at 06:08:48 -0500, Mark Woodward <[EMAIL PROTECTED]> wrote: > > I'm currently adding support for the v3 protocol in PHP pgsql extension. > > I'm wondering if anyone minds if I lift documentation wholesale from > > the PostgreSQL docs for the PHP docs for these functions. F

Re: [HACKERS] PHP stuff

2005-03-15 Thread Marc G. Fournier
On Tue, 15 Mar 2005, Christopher Kings-Lynne wrote: I'm currently adding support for the v3 protocol in PHP pgsql extension. I'm wondering if anyone minds if I lift documentation wholesale from the PostgreSQL docs for the PHP docs for these functions. For instance, the fieldcodes allowed for PQ

Re: [HACKERS] type unknown - how important is it?

2005-03-15 Thread Dave Cramer
Shachar, I just had a customer complain about this. My understanding is that unkown is a constant which has not been typed yet. Is it possible for it to be a binary type, if so how ? I would think it should only ever be a string? his particular case is select 'picture.jpg' as icon1, 'picture2.jp

Re: [HACKERS] PHP stuff

2005-03-15 Thread Mark Woodward
> I'm currently adding support for the v3 protocol in PHP pgsql extension. > I'm wondering if anyone minds if I lift documentation wholesale from > the PostgreSQL docs for the PHP docs for these functions. For instance, > the fieldcodes allowed for PQresultErrorField, docs on > PQtransactionStat