Re: [HACKERS] src/tools/msvc usage instructions

On Tue, 3 Oct 2006, Magnus Hagander wrote: > No fix yet :-( Haven't had the time to dig into it properly, but I think > we can now safely say it's not a local issue in Joachims build env :-) > > If you just run a dumpbin command (the same way) manually with a ">foo", > does it redirect it properly

Re: [HACKERS] src/tools/msvc usage instructions

> > Delete the DEF file and run the gendef command manually (see the > > project file for commandline, IIRC there are no parameters, > but just > > to be sure). I'm wondering if you're seeing the samre problem as > > Joachim Wieland (off-list conversation) where the output from > > dumpbin.exe

Re: [HACKERS] src/tools/msvc usage instructions

On Tue, 3 Oct 2006, Magnus Hagander wrote: > > > Looks like the gendef script is failing. Check the contents of > > > release\postgres\postgres.def - it should have thousands of > > symbols, > > > but I'm willing to bet it's empty... > > > > It contains one word: "EXPORTS". I assume this means it

Re: [HACKERS] src/tools/msvc usage instructions

> > Looks like the gendef script is failing. Check the contents of > > release\postgres\postgres.def - it should have thousands of > symbols, > > but I'm willing to bet it's empty... > > It contains one word: "EXPORTS". I assume this means it is > empty. What should I do about it? Is there

Re: [HACKERS] src/tools/msvc usage instructions

On Tue, 3 Oct 2006, Magnus Hagander wrote: > Looks like the gendef script is failing. Check the contents of > release\postgres\postgres.def - it should have thousands of symbols, but > I'm willing to bet it's empty... It contains one word: "EXPORTS". I assume this means it is empty. What should

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

> > > > > Without having studied it closely, it might also > highlight a bug > > > > on > > > > > failure of the second clause -- if the _setmode > fails, shouldn't > > > > > _close be called instead of CloseHandle, and -1 returned? > > > > > (CloseHandle would still be called on failure of the

Re: [HACKERS] src/tools/msvc usage instructions

> > Jeremy Drake <[EMAIL PROTECTED]> writes: > > > The errors I got on this file were: > > > 1>bootparse.tab.c(1065) : error C2449: found '{' at file scope > > > 1>(missing function header?) > > > > I looked at this. Line 1065 is the left brace starting > yyparse(). On > > my Fedora Core 5 box

Re: [HACKERS] src/tools/msvc usage instructions

Looks like the gendef script is failing. Check the contents of release\postgres\postgres.def - it should have thousands of symbols, but I'm willing to bet it's empty... //Magnus > -Original Message- > From: Jeremy Drake [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 03, 2006 1:28 AM

Re: [HACKERS] Another idea for dealing with cmin/cmax

Greg Stark <[EMAIL PROTECTED]> wrote: > The plan Gavin Sherry and I were discussing at the Code Sprint was to store a > single "most common xmin" xmin in the per-page special area. Then have a bit > on each tuple indicating that the xmin isn't present in the tuple and instead > to use the xmin fr

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

Bruce Momjian wrote: > Magnus Hagander wrote: > > > >> Now, I still twist my head around the lines: > > > >> if ((fd = _open_osfhandle((long) h, fileFlags & O_APPEND)) < 0 > > > >> || > > > >> (fileFlags & (O_TEXT | O_BINARY) && (_setmode(fd, fileFlags & > > > (O_TEXT > > > >> | O_BINARY)) < 0))) >

Re: [HACKERS] Patch: Tie stats options to autovacuum in

Jim Nasby <[EMAIL PROTECTED]> writes: > On Oct 2, 2006, at 9:17 PM, Bruce Momjian wrote: >> Jim Nasby wrote: >>> Hrm... how about if the options are incompatible on HUP we refuse to >>> pick up any new settings and complain loudly? >> >> We don't read postgresql.conf as a test and then set values.

Re: [HACKERS] Patch: Tie stats options to autovacuum in

On Oct 2, 2006, at 9:17 PM, Bruce Momjian wrote: Jim Nasby wrote: On Oct 2, 2006, at 8:41 PM, Bruce Momjian wrote: David E. Wheeler wrote: On Sep 28, 2006, at 16:39, Jim C. Nasby wrote: +1. I was just at a client today that had run into this problem. Actually, I'm in favor of refusing to st

Re: [HACKERS] timestamptz alias

On Oct 2, 2006, at 6:22 PM, AgentM wrote: On Oct 2, 2006, at 18:15 , Markus Schaber wrote: I'm happy that the rather verbose "timestamp with time zone" has the much nicer alias "timestamptz", however it seems that this alias is not documented, neither at http://developer.postgresql.org/pgdocs

Re: [HACKERS] NULL and plpgsql rows

On Oct 2, 2006, at 6:28 PM, Tom Lane wrote: "Jim C. Nasby" <[EMAIL PROTECTED]> writes: However, the test right above that means that we'll fail if the user tries something like "row_variable := NULL;": The patch you seem to have in mind would allow row_variable := int_variable; to succ

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

Magnus Hagander wrote: > > >> Now, I still twist my head around the lines: > > >> if ((fd = _open_osfhandle((long) h, fileFlags & O_APPEND)) < 0 > > >> || > > >> (fileFlags & (O_TEXT | O_BINARY) && (_setmode(fd, fileFlags & > > (O_TEXT > > >> | O_BINARY)) < 0))) > > > > > Without having studied it

Re: [HACKERS] Patch: Tie stats options to autovacuum in

Jim Nasby wrote: > On Oct 2, 2006, at 8:41 PM, Bruce Momjian wrote: > > David E. Wheeler wrote: > >> On Sep 28, 2006, at 16:39, Jim C. Nasby wrote: > >> > >>> +1. I was just at a client today that had run into this problem. > >>> > >>> Actually, I'm in favor of refusing to start if autovac is on bu

Re: [HACKERS] Patch: Tie stats options to autovacuum in

On Oct 2, 2006, at 8:41 PM, Bruce Momjian wrote: David E. Wheeler wrote: On Sep 28, 2006, at 16:39, Jim C. Nasby wrote: +1. I was just at a client today that had run into this problem. Actually, I'm in favor of refusing to start if autovac is on but the proper stats settings aren't. I'd rathe

Re: [HACKERS] TM modificator don't work? to_char

Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> It works if you have NLS translations for "Thursday", "September", > >> etc ... which none of the backend .po files do yet. > > > But they will when we have the po files updated for this release, I > > suppose. >

Re: [HACKERS] TM modificator don't work? to_char

Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> It works if you have NLS translations for "Thursday", "September", >> etc ... which none of the backend .po files do yet. > But they will when we have the po files updated for this release, I > suppose. We should probably list transla

Re: [HACKERS] TM modificator don't work? to_char

On Mon, 2 Oct 2006, Bruce Momjian wrote: Can someone confirm this features works or fails? As I see from the original commit: http://groups.google.com/group/pgsql.committers/browse_frm/thread/4ba64c906fca7211/0e3b4d495ec7ecf8?lnk=gst&q=to_char&rnum=8#0e3b4d495ec7ecf8 http://developer.postgre

Re: [HACKERS] TM modificator don't work? to_char

Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Can someone confirm this features works or fails? > > It works if you have NLS translations for "Thursday", "September", > etc ... which none of the backend .po files do yet. But they will when we have the po files updated for this r

Re: [HACKERS] Patch: Tie stats options to autovacuum in

David E. Wheeler wrote: > On Sep 28, 2006, at 16:39, Jim C. Nasby wrote: > > > +1. I was just at a client today that had run into this problem. > > > > Actually, I'm in favor of refusing to start if autovac is on but the > > proper stats settings aren't. I'd rather that then people ending up > >

Re: [HACKERS] TM modificator don't work? to_char

Bruce Momjian <[EMAIL PROTECTED]> writes: > Can someone confirm this features works or fails? It works if you have NLS translations for "Thursday", "September", etc ... which none of the backend .po files do yet. regards, tom lane ---(end of broadc

Re: [HACKERS] Darwin stuff is getting deprecated

My guess is that we are going to have to live with the warnings for 8.2 and save this issue for 8.3. --- Tom Lane wrote: > With the latest Apple developers' tools, I get some warnings that > weren't there before: > > dynloa

Re: [HACKERS] TM modificator don't work? to_char

Can someone confirm this features works or fails? --- Pavel Stehule wrote: > Hello, > > I try 8.2 features. I tested to_char from doc, but without success. > > postgres=# select to_char(now(), 'TMDay, DD TMMonth '); >

Re: [HACKERS] Faster StrNCpy

Tom, FWIW, Tom Daly did some SpecJAppserver runs on the latest snapshot and didn't show any reduction in text parsing overhead. Unfortunately, he's gone on vacation now so I can't get details. I'm going to try to set up some tests using TPCE to see if it's affected. --Josh

Re: [HACKERS] Faster StrNCpy

Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > > You'll notice that it iterates once per char. Between that and the > > strlen() call in Tom's version, not sure which is the lesser evil. > > Yeah, I was wondering that too. My code would require two scans of the > source string (o

Re: [HACKERS] Sane error messages for SSL retry cases

Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Is this a TODO? I don't see how it is a new problem, meaning it > > probably is for 8.3. > > It's definitely not a new problem, but we hadn't recognized it before, > so it qualifies as a new bug. The question at hand was whether any

Re: [HACKERS] Sane error messages for SSL retry cases

Bruce Momjian <[EMAIL PROTECTED]> writes: > Is this a TODO? I don't see how it is a new problem, meaning it > probably is for 8.3. It's definitely not a new problem, but we hadn't recognized it before, so it qualifies as a new bug. The question at hand was whether anyone was excited enough about

Re: [HACKERS] src/tools/msvc usage instructions

I now get things to compile, but now I get linker errors on any dll which needs to access symbols from postgres.exe via postgres.lib. For example: 1>-- Build started: Project: autoinc, Configuration: Release Win32 -- 1>Generate DEF file 1>Not re-generating AUTOINC.DEF, file already exists

Re: [HACKERS] src/tools/msvc usage instructions

On Mon, 2 Oct 2006, Jeremy Drake wrote: In the bison 2.2 generated code, the #if check is #if (defined __STDC__ || defined __C99__FUNC__ \ || defined __cplusplus || defined _MSC_VER) which looks like they figured out that they needed to check for MicroSoft C explicitly. I have no idea why

Re: [HACKERS] Faster StrNCpy

Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > A wholesale replacement of strncpy() calls is probably worth doing -- > > replacing them with strlcpy() if the source string is NUL-terminated, > > and I suppose memcpy() otherwise. > > What I'd like to do immediately is put in strlcpy(

Re: [HACKERS] Sane error messages for SSL retry cases

Is this a TODO? I don't see how it is a new problem, meaning it probably is for 8.3. --- Tom Lane wrote: > As per a recent discussion in pgsql-admin, > http://archives.postgresql.org/pgsql-admin/2006-09/msg00297.php > libpq

Re: [HACKERS] horo(r)logy test fail on solaris (again and

Thanks for the analysis. I have removed mention of the -fast option from the Solaris FAQ. --- Kenneth Marshall wrote: > On Wed, Sep 27, 2006 at 04:09:18PM +0200, Zdenek Kotala wrote: > > Tom Lane napsal(a): > > >Zdenek Ko

Re: [HACKERS] Ready for pgindent?

Bruce Momjian <[EMAIL PROTECTED]> writes: > Are people ready for me to run pgindent? I don't see a reason to hold off. There aren't any more pending patches we intend to apply before 8.2 ... regards, tom lane ---(end of broadcast)-

Re: [PATCHES] [HACKERS] Incrementally Updated Backup

Documentation patch applied. Thanks. Your documentation changes can be viewed in five minutes using links on the developer's page, http://www.postgresql.org/developer/testing. --- Simon Riggs wrote: > > > On Tue, 2006-09

Re: [HACKERS] Broken link in PG docs

I added the citeseer URL as an SGML comment. Neil is trying to contact the author. --- Tom Lane wrote: > Neil Conway <[EMAIL PROTECTED]> writes: > > I agree the link should be fixed, but I can't see another canonical > > lo

Re: [HACKERS] NULL and plpgsql rows

"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > However, the test right above that means that we'll fail if the user > tries something like "row_variable := NULL;": The patch you seem to have in mind would allow row_variable := int_variable; to succeed if the int_variable chanced to contain N

Re: [HACKERS] timestamptz alias

On Oct 2, 2006, at 18:15 , Markus Schaber wrote: Hi, I'm happy that the rather verbose "timestamp with time zone" has the much nicer alias "timestamptz", however it seems that this alias is not documented, neither at http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html nor

Re: [HACKERS] src/tools/msvc usage instructions

On Mon, 2 Oct 2006, Tom Lane wrote: > Jeremy Drake <[EMAIL PROTECTED]> writes: > > The errors I got on this file were: > > 1>bootparse.tab.c(1065) : error C2449: found '{' at file scope (missing > > function header?) > > I looked at this. Line 1065 is the left brace starting yyparse(). On > my

[HACKERS] timestamptz alias

Hi, I'm happy that the rather verbose "timestamp with time zone" has the much nicer alias "timestamptz", however it seems that this alias is not documented, neither at http://developer.postgresql.org/pgdocs/postgres/datatype-datetime.html nor at http://www.postgresql.org/docs/8.1/interactive/datat

Re: [HACKERS] initdb ignores invalid locale names

Is this a TODO item? --- Greg Sabino Mullane wrote: [ There is text before PGP section. ] > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > > > When initdb is given an invalid (possibly mistyped) locale name, it jus

[HACKERS] NULL and plpgsql rows

I'm looking at how NULLs are handled in relation to plpgsql row types. Looking at exec_assign_value, it appears that we're supposed to be able to handle setting a row variable to NULL: if (*isNull) { /* If source is null, just assign nulls to the

Re: [HACKERS] on-disk bitmap indexes

Radovan Jablonov wrote: > Hello, > > I carefully check all mail threads of Re: > > On-disk bitmap index patch > http://secure.linuxports.com/pgsql-hackers/2006-07/msg01514.php > > I am testing 8.2 postgresql features and wonder i

[HACKERS] on-disk bitmap indexes

Hello,   I carefully check all mail threads of Re: On-disk bitmap index patch http://secure.linuxports.com/pgsql-hackers/2006-07/msg01514.php   I am testing 8.2 postgresql features and wonder if on-disk bitmap indexes are included in beta version. It could be great to test their perfor

Re: [HACKERS] Faster StrNCpy

Tom, Yes, the clients are using the V3 protocol and prepared statements. David From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Mon 10/2/2006 2:09 PM To: Strong, David Cc: pgsql-hackers@postgresql.org Subject: Re: [HACKERS] Faster StrNCpy "Strong, David" <[E

Re: [HACKERS] Faster StrNCpy

"Strong, David" <[EMAIL PROTECTED]> writes: > Obviously, different copy mechanisms suit different data sizes. So, I > added a little debug to the strlcpy () function that was added to > Postgres the other day. I ran a test against Postgres for ~15 minutes > that used 2 client backends and the BG wr

Re: [HACKERS] Faster StrNCpy

I did a couple more tests using x86 architectures. On a rather old Pentium-4 machine running Fedora 5 (gcc 4.1.1, glibc-2.4-11): $ gcc -O3 -std=c99 -DSTRING='"This is a very long sentence that is expected to be very slow."' -DN="(1024*1024)" -o x x.c y.c strlcpy.c NONE:786305 us MEMCPY

Re: [PATCHES] [HACKERS] Incrementally Updated Backup

Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches It will be applied as soon as one of the PostgreSQL committers reviews and approves it. --- Si

Re: [HACKERS] Faster StrNCpy

On Mon, 2 Oct 2006, Tom Lane wrote: "Sergey E. Koposov" <[EMAIL PROTECTED]> writes: Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to be quite different: What libc are you using exactly? Can you try it with the unrolled strlcpy I posted? glibc 2.3.5 , gcc 3.4.4 my

[HACKERS] Ready for beta2?

Are we ready to think about a beta2? Seems beta1 was quiet. -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 9: In ver

[HACKERS] Ready for pgindent?

Are people ready for me to run pgindent? -- Bruce Momjian [EMAIL PROTECTED] EnterpriseDBhttp://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)--- TIP 5: don't forget to increase y

Re: [HACKERS] Faster StrNCpy

"Sergey E. Koposov" <[EMAIL PROTECTED]> writes: > Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to > be quite different: What libc are you using exactly? Can you try it with the unrolled strlcpy I posted? In glibc-2.4.90, there seem to be out-of-line assembly code implem

Re: [HACKERS] Faster StrNCpy

Mark, Tom, Just the test on IA64 (Itanium2, 1.6Ghz, 8Gb memory). The results seem to be quite different: [EMAIL PROTECTED]:~/test$ gcc -O3 -std=c99 -DSTRING='"This is a very long sentence that is expected to be very slow."' -DN="(1024*1024)" -o x x.c y.c strlcpy.c ; ./x NONE:825671 us M

Re: [HACKERS] Faster StrNCpy

Thanks for the results on your machines Dave, Luke, and Tom. Interesting. On Mon, Oct 02, 2006 at 02:30:11PM -0400, Tom Lane wrote: > It appears that these results are a bit platform-dependent; on my x86_64 > (Xeon) Fedora 5 box, I get *nod* > Anyway, I looked at glibc's strncpy and determined t

Re: [HACKERS] Faster StrNCpy

Mark, On 9/29/06 2:59 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Here are results over 64 Mbytes of memory, to ensure that every call is > a cache miss: On my Mac OSX intel laptop (Core Duo, 2.16 GHz, 2GB RAM, gcc 4.01): Luke-Lonergans-Computer:~/strNcpy-perf-test lukelonergan$ gcc -O

Re: [HACKERS] Faster StrNCpy

[EMAIL PROTECTED] writes: > Here is the cache hit case including your strlen+memcpy as 'LENCPY': > $ gcc -O3 -std=c99 -DSTRING='"This is a very long sentence that is expected > to be very slow."' -DN=1 -o x x.c y.c strlcpy.c ; ./x > NONE:696157 us > MEMCPY: 825118 us > STRNCPY:79

[HACKERS] undescribe

unsubscribe  pgsql-hackers 

Re: [HACKERS] [BUGS] Update using sub-select table in schema

I wrote: > The comments for refnameRangeTblEntry indicate that at one time we > thought we saw support for our approach in the spec: Here is the discussion thread that settled on our current behavior: http://archives.postgresql.org/pgsql-hackers/2002-03/msg00403.php It looks like we followed Oracl

Re: [HACKERS] [BUGS] Update using sub-select table in schema

Simon Riggs <[EMAIL PROTECTED]> writes: > On Mon, 2006-10-02 at 11:38 -0400, Tom Lane wrote: >> Postgres treats "FROM temp.a" the same as "FROM temp.a AS a", > [Which AFAICS doesn't follow SQL:2003, since a reference to temp.a > should not be allowed following its redefinition as a.] I'm sorry, I

Re: [HACKERS] [BUGS] Update using sub-select table in schema

On Mon, 2006-10-02 at 11:38 -0400, Tom Lane wrote: > Chris Dunlop <[EMAIL PROTECTED]> writes: > > I'm not sure if this is a bug or if it's displaying my ignorance > > of this corner of SQL... > > > update a set name = ( > > select name > > from temp.a > > where temp.a.id = a.id > > ) > > Po

Re: [HACKERS] Select for update with outer join broken?

Josh Berkus writes: > Oh, no, what should happen is that the outer join portion of the query > doesn't > get locked, rather than a fatal exception. That behavior is expected by the > J2EE certification, so it's at least somewhat industry-standard. Really? Please cite chapter and verse. And

Re: [HACKERS] Select for update with outer join broken?

Tom, > Josh, you don't know what you're talking about. The backend's > capabilities for this have not moved an inch since 8.1 (transient bugs > in its error checking do not represent an advance in capability), Hmmm ... was this an unapplied patch? We certainly had it working on the benchmark m

Re: [HACKERS] Faster StrNCpy

Mark, Thanks for attaching the C code for your test. I ran a few tests on a 3Ghz Intel Xeon Paxville (dual core) system. I hope the formatting of this table survives: Method Size N=1024*1024 N=1 MEMCPY 63 6964927 us 582494 us MEMCPY 32 7102497 us 582467 us MEMCPY

Re: [HACKERS] [BUGS] Update using sub-select table in schema

Chris Dunlop <[EMAIL PROTECTED]> writes: > I'm not sure if this is a bug or if it's displaying my ignorance > of this corner of SQL... > update a set name = ( > select name > from temp.a > where temp.a.id = a.id > ) Postgres treats "FROM temp.a" the same as "FROM temp.a AS a", and then the

Re: [HACKERS] Another idea for dealing with cmin/cmax

Greg Stark <[EMAIL PROTECTED]> writes: > The plan Gavin Sherry and I were discussing at the Code Sprint was to store a > single "most common xmin" xmin in the per-page special area. Then have a bit > on each tuple indicating that the xmin isn't present in the tuple and instead > to use the xmin fro

Re: [HACKERS] src/tools/msvc usage instructions

Jeremy Drake <[EMAIL PROTECTED]> writes: > The errors I got on this file were: > 1>bootparse.tab.c(1065) : error C2449: found '{' at file scope (missing > function header?) I looked at this. Line 1065 is the left brace starting yyparse(). On my Fedora Core 5 box with Bison 2.1 installed, the st

Re: [HACKERS] In which module does query rewriting takes place

Tom Lane wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: Shaunak Godbole wrote: We are trying to introduce access control. This sounds like a pretty ugly hack. Perhaps more to the point, it's already been done: http://veil.projects.postgresql.org/ Ah

Re: [HACKERS] Another idea for dealing with cmin/cmax

Tom Lane <[EMAIL PROTECTED]> writes: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > ... place a limit on the number of transactions that can be live in a table > > at once. > > Urk, well maybe, but ... > > > you could shrink all the visibility info to 1 byte if you > > wanted to. > > ... 256

Re: [HACKERS] src/tools/msvc usage instructions

"Magnus Hagander" <[EMAIL PROTECTED]> writes: >> Certainly not --- we work with both of those (I have 1.875 on one >> of my devel machines and 2.1 on two others). > Well, it *does* break with 2.1 on win32-native. Could be something > simple, could be that it's just generating msvc-incompatible cod

Re: [HACKERS] In which module does query rewriting takes place

Andrew Dunstan <[EMAIL PROTECTED]> writes: > Shaunak Godbole wrote: >> We are trying to introduce access control. > This sounds like a pretty ugly hack. Perhaps more to the point, it's already been done: http://veil.projects.postgresql.org/ regards, tom lane

Re: [HACKERS] In which module does query rewriting takes place

Shaunak Godbole wrote: Hi, We are trying to introduce access control. For this we have to rewrite the input query by replacing each relation by its corresponding authorized view. This sounds like a pretty ugly hack. There are already extensive access controls available in postgres. What is

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

"Magnus Hagander" <[EMAIL PROTECTED]> writes: >> I agree that this code is both wrong and unreadable (although in >> practice the _setmode will probably never fail, which is why our >> attention hasn't been drawn to it). Is someone going to submit a >> patch? I'm hesitant to change the code mysel

[HACKERS] In which module does query rewriting takes place

Hi,We are trying to introduce access control. For this we have to rewrite the input query by replacing each relation by its corresponding authorized view. Which part of the code should we modify for this. Till now we have thought of the following: 1. We take as input the parse tree generated by the

Re: [HACKERS] Replication hooks discussion

On Friday 29 September 2006 20:02, Andrew Sullivan wrote: > At the beginning of the month, in > , > I said that I'd be willing to try to do any sort of co-ordination, > document writing, &c. for a project that might define common ba

Re: [HACKERS] [PATCHES] Bad bug in fopen() wrapper code

> >> Now, I still twist my head around the lines: > >> if ((fd = _open_osfhandle((long) h, fileFlags & O_APPEND)) < 0 > >> || > >> (fileFlags & (O_TEXT | O_BINARY) && (_setmode(fd, fileFlags & > (O_TEXT > >> | O_BINARY)) < 0))) > > > Without having studied it closely, it might also highlight a bug

Re: [HACKERS] Another idea for dealing with cmin/cmax

Ühel kenal päeval, E, 2006-10-02 kell 01:30, kirjutas Tom Lane: > "Jim C. Nasby" <[EMAIL PROTECTED]> writes: > > ... place a limit on the number of transactions that can be live in a table > > at once. > > Urk, well maybe, but ... > > > you could shrink all the visibility info to 1 byte if you >

Re: [HACKERS] Please build --with-ldap for Win32 beta1 binaries

> Can we have the beta1 binaries for Win32 with --with-ldap? > > On Windows, the LDAP library is part of the OS, so we won't incur > any undesirable dependencies. Oops, that's an oversight, it's supposed to be there. --with-ldap will be enabled in beta2. Sorry 'bout that. //Magnus

[HACKERS] Please build --with-ldap for Win32 beta1 binaries

Can we have the beta1 binaries for Win32 with --with-ldap? On Windows, the LDAP library is part of the OS, so we won't incur any undesirable dependencies. Yours, Laurenz Albe ---(end of broadcast)--- TIP 4: Have you searched our list archives?

Re: [HACKERS] src/tools/msvc usage instructions

> > Oh, I just got the email from Magnus which says do not use v2.1, > but > > 1.875, so I guess that's what I did wrong. Oops! > > Certainly not --- we work with both of those (I have 1.875 on one > of my devel machines and 2.1 on two others). In fact, your diff > says you have > 2.1 on the fai

Re: [HACKERS] [PATCHES] Generic Monitoring Framework with DTrace patch

Robert, I'm working on the new version of the Solaris FAQ and I mentioned this in this document. I'm going to sent patch asap. Zdenek Robert Treat napsal(a): On Monday 24 July 2006 17:00, Robert Lor wrote: Excellent! I'll submit a doc patch shortly. Regards, -Robert Peter Eisentra

Re: [HACKERS] src/tools/msvc usage instructions

Jeremy Drake <[EMAIL PROTECTED]> writes: > Oh, I just got the email from Magnus which says do not use v2.1, but > 1.875, so I guess that's what I did wrong. Oops! Certainly not --- we work with both of those (I have 1.875 on one of my devel machines and 2.1 on two others). In fact, your diff say

Re: [HACKERS] src/tools/msvc usage instructions

On Mon, 2 Oct 2006, Hiroshi Saito wrote: > Hi. > > I think that it has forgotten for VS2005-express to add path of SDK by myself. > http://www.winpg.jp/~saito/VS2005/VS2005_Include.png > http://www.winpg.jp/~saito/VS2005/VS2005_Library.png > Do I mistake your meaning? I have the platform sdk dire

Re: [HACKERS] src/tools/msvc usage instructions

Hi. I think that it has forgotten for VS2005-express to add path of SDK by myself. http://www.winpg.jp/~saito/VS2005/VS2005_Include.png http://www.winpg.jp/~saito/VS2005/VS2005_Library.png Do I mistake your meaning? Regards, Hiroshi Saito I switched to short paths in the INCLUDE env var, but it

Re: [HACKERS] src/tools/msvc usage instructions

> > > If you do "build solution" it should build all project sin the > > > correct order - there are dependency references set between them > > > that should take care of this automatically. > > > > If I do build solution it tells me "Project not selected to > build for > > this solution config