Re: [PATCHES] Patch to be verbose about being unable to read ~/.pgpasss...

2003-06-23 Thread Tom Lane
used to be that way). Returning a failed connection should not be something the app can't deal with --- if it is, that app has got problems anyway. But insisting that we can print on stderr may well be something it cannot overcome. regards, tom lane

Re: [PATCHES] Patch to be verbose about being unable to read ~/.pgpasss...

2003-06-23 Thread Tom Lane
go through (directly or indirectly). Comments? regards, tom lane ---(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

Re: [PATCHES] Consistent timestamp input

2003-06-23 Thread Tom Lane
(US style) assume DD before MM, and then reject if out of range, rather than allowing the range to determine which is which. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [PATCHES] Patch to be verbose about being unable to read ~/.pgpasss...

2003-06-23 Thread Tom Lane
them up in a window; sending to stderr is likely to mean sending to /dev/null, or at best a logfile that the user will never look at. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PATCHES] src/bin/psql/input.c

2003-06-25 Thread Tom Lane
(with a note about why). regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PATCHES] Runtime.SGML diff ... please expedite!

2003-06-25 Thread Tom Lane
for that ASAP.) regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PATCHES] [NOVICE] connectby() minor bug in errormessage

2003-06-25 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Attached is a patch for the issue reported above by Nabil. Please apply. Applied (with correct spelling ...) regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists

Re: [PATCHES] Runtime.SGML diff ... please expedite!

2003-06-25 Thread Tom Lane
, or is it just a Source Developer Option? It's gone. You might want to crosscheck the docs against the CVS-tip version of guc.c ... regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [PATCHES] Interval Patch

2003-06-25 Thread Tom Lane
it's a definitional change rather than a true bug. regards, tom lane ---(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

Re: [PATCHES] Runtime.SGML diff ... please expedite!

2003-06-25 Thread Tom Lane
that). Yeah, the correct fix is to document it under Developer Options as LOG_BTREE_BUILD_STATS. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] [HACKERS] allowed user/db variables

2003-06-25 Thread Tom Lane
with US (NonEuropean) conventions This reminds me, someone (Barry?) was griping that SHOW DATESTYLE doesn't produce a value that SET DATESTYLE will take. Did we agree that it was OK to change the output to look like ISO, US etc? regards, tom lane

Re: [PATCHES] [HACKERS] allowed user/db variables

2003-06-25 Thread Tom Lane
). regards, tom lane ---(end of broadcast)--- TIP 3: 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

Re: [PATCHES] [HACKERS] Missing array support

2003-06-29 Thread Tom Lane
... regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PATCHES] polymorphic arguments and return type for PL/pgSQL

2003-06-30 Thread Tom Lane
. Then it would be practical to recover the memory associated with an obsoleted cache entry. But we've lived without this so far, so I guess it's not causing many people problems. regards, tom lane ---(end of broadcast)--- TIP 5: Have

Re: [PATCHES] Typo in backend/libpq/be-secure.c

2003-07-01 Thread Tom Lane
? Applied. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] fix for plpgsql polymorphism

2003-07-02 Thread Tom Lane
. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] fix for plpgsql polymorphism

2003-07-03 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Tom Lane wrote: I'm not excited about picking a notation for the long term on the grounds that it takes the least code to implement today. I knew you wouldn't be ;-) I admit I have not got a clearly-better solution in my hip pocket, but $0 is just

[PATCHES] Proof-of-concept for initdb-time shared_buffers selection

2003-07-04 Thread Tom Lane
be the set of tested values? I have it as buffers: first to work of 1000 900 800 700 600 500 400 300 200 100 50 connections: first to work of 100 50 40 30 20 10 but we could certainly argue for different rules. regards, tom lane *** src/backend/port/sysv_shmem.c.orig

Re: [PATCHES] Autoconf test for incompatible version of flex

2003-07-05 Thread Tom Lane
it. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PATCHES] Autoconf test for incompatible version of flex

2003-07-05 Thread Tom Lane
it a minor version bump has to violate a truth-in-advertising law or two. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] Another POC initdb patch

2003-07-06 Thread Tom Lane
to cope with this. I disagree with the concept of expecting someone to supply useful values at install time anyway, since a newbie is the *least* likely to have any idea what to say at that time. Heck, the experts can hardly agree on what to use ... regards, tom lane

Re: [PATCHES] Proof-of-concept for initdb-time shared_buffers selection

2003-07-06 Thread Tom Lane
this unless you want to make it interactive, which would certainly make the RPM guys really unhappy. I'd rather see such considerations pushed off to a separate tool, some kind of configuration wizard perhaps. regards, tom lane ---(end of broadcast

Re: [PATCHES] fix for new SUSET GUC variables

2003-07-14 Thread Tom Lane
been there, it would not have saved him from this error, since I doubt it would have occurred to him to look for such a comment. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [PATCHES] [HACKERS] allowed user/db variables

2003-07-20 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: No, it's a DONE. I just tried this with CVS: test= show datestyle; DateStyle --- ISO with US (NonEuropean) conventions (1 row) Uh, when

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-20 Thread Tom Lane
Kenji Sugita [EMAIL PROTECTED] writes: This small patch eliminates relations in information_schema from oid2name listing. Seems like it'd be a good idea to eliminate views and composite types as well. regards, tom lane ---(end of broadcast

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-21 Thread Tom Lane
it *ought* to be doing is suppressing views, since those don't have disk files --- they are only cluttering the listing with irrelevant data. If we put that in, there'd be no need to special-case information_schema. regards, tom lane ---(end of broadcast

Re: [PATCHES] PATCH: Memory leaks on start-up

2003-07-22 Thread Tom Lane
that it was originally told to unlink, regardless of what happens to those globals. If you are intent on spending code to free stuff just before the postmaster exits, a better fix would be for UnlinkLockFile to free its string argument after using it. regards, tom lane

Re: [PATCHES] PATCH: Memory leaks on start-up

2003-07-22 Thread Tom Lane
the change as a matter of future-proofing that routine against such use. But on the argument of preventing resource leakage today, this is just a waste of code space. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9

Re: [PATCHES] Czech NLS

2003-07-23 Thread Tom Lane
that. There will doubtless be some further tweaking, as Peter says. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] UPDATED Patch for adding DATACUBE operator

2003-07-25 Thread Tom Lane
, and I'm not having any luck finding that message in the archives right now. Sumit, did you keep a copy? regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [PATCHES] Datetime patch

2003-07-25 Thread Tom Lane
there are no other paths for parsing a date spec in the main date/time code? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] UPDATED Patch for adding DATACUBE operator

2003-07-25 Thread Tom Lane
Kris Jurka [EMAIL PROTECTED] writes: On Fri, 25 Jul 2003, Tom Lane wrote: I'm not having any luck finding that message in the archives right now. Sumit, did you keep a copy? http://groups.google.com/groups?hl=enlr=ie=UTF-8selm=28882.1057162309%40sss.pgh.pa.us Thanks, but that actually

Re: [PATCHES] Datetime patch

2003-07-25 Thread Tom Lane
we can get away with deciding that common date formats aren't common. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] Eliminate information_schema from oid2name listing

2003-07-27 Thread Tom Lane
, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PATCHES] ruleutils with pretty-print option

2003-07-27 Thread Tom Lane
function. regards, tom lane ---(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

Re: [PATCHES] ruleutils with pretty-print option

2003-07-27 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom, how do I pass PG_FUNCTION_ARGS to another function, while adding a new parameter? I wouldn't. Do the PG_GETARGS in the wrapper, and have the called function take a normal C parameter list. regards, tom lane

Re: [PATCHES] [HACKERS] allowed user/db variables

2003-07-28 Thread Tom Lane
and application. The comment wouldn't have prevented the error, because patch(1) can't read comments. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] [HACKERS] allowed user/db variables

2003-07-28 Thread Tom Lane
adding one. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] pgsql-7.3.3: Build process not SMP clean

2003-07-29 Thread Tom Lane
Andreas Haumer [EMAIL PROTECTED] writes: But genbki.sh is not SMP safe: it uses a temporary file TMPFILE=$TMPDIR/genbkitmp.c Good catch. Applied for 7.4 --- thanks! regards, tom lane ---(end of broadcast)--- TIP 7: don't

Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

2003-07-30 Thread Tom Lane
for preventing specific users from altering data: that's what GRANT/REVOKE are for. I don't think anyone would have bothered with START TRANSACTION READ ONLY if it weren't required by the SQL spec. regards, tom lane ---(end of broadcast

Re: [PATCHES] array expression NULL fix [was: [HACKERS] odd behavior/possible bug]

2003-07-30 Thread Tom Lane
. regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PATCHES] [PATCH] Re: [pgsql-advocacy] Why READ ONLY transactions?

2003-07-30 Thread Tom Lane
a bool column to pg_shadow, and I'll be happy. regards, tom lane ---(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

[PATCHES] Any unapplied patches out there?

2003-07-30 Thread Tom Lane
tip or a nightly snapshot tarball should be pretty-durn-close-to-the-beta. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] updateable cursors

2003-07-30 Thread Tom Lane
. I don't understand what the diffs in postgres.c are supposed to accomplish, but I can just about promise that they are misplaced too, since they won't affect queries executed via functions or SPI. regards, tom lane ---(end of broadcast

Re: [PATCHES] Check for failed memory allocations in libpq

2003-07-31 Thread Tom Lane
moves the core dump somewhere else, unless you find reasonable fallbacks for *all* its callers (including applications you don't have the source code for, but in any case including every one of the calls in libpq). regards, tom lane ---(end

Re: [Fwd: Re: [PATCHES] ruleutils with pretty-print option]

2003-07-31 Thread Tom Lane
.) More: if the tree structure for ops of equal precedence looks like a + (b + c), then it's a near certainty that the user wrote those parentheses. Why would you think that removing them is pretty-printing? regards, tom lane ---(end of broadcast

Re: [Fwd: Re: [PATCHES] ruleutils with pretty-print option]

2003-07-31 Thread Tom Lane
+ ((-1.0::float8) + 1.0e-20::float8); ?column? -- 0 (1 row) regards, tom lane ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [PATCHES] updateable cursors

2003-07-31 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: This has been saved for the 7.5 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 Saved for? It's not gonna be acceptable in its current form for 7.5, either. regards, tom lane ---(end

Re: [PATCHES] Autoconf test for incompatible version of flex

2003-07-31 Thread Tom Lane
[ followup to old message ] Greg Stark [EMAIL PROTECTED] writes: This patch adds an autoconf test to check for the new incompatible version of flex. Peter E. claims that CVS tip does work with flex 2.5.31 --- so we shouldn't need this patch anymore. regards, tom lane

Re: [PATCHES] Check for failed memory allocations in libpq

2003-07-31 Thread Tom Lane
; it will usually behave reasonably when it runs out of memory for a query result. If you'd like to pursue the matter, please pull down CVS tip and see what you can do with it. The patch as given would not be much use to us anyway because of the changes since 7.3... regards, tom lane

Re: [PATCHES] contrib regression test update

2003-07-31 Thread Tom Lane
the duplicated work ... regards, tom lane ---(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

Re: [PATCHES] [HACKERS] 7.4 COPY BINARY Format Change

2003-08-01 Thread Tom Lane
, and for integers on bigendian machines, but not for much else.) We are not going back to the pre-7.4 format. Sorry. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [PATCHES] [HACKERS] statement level trigger causes pltcl, plpython SIGSEGV

2003-08-04 Thread Tom Lane
changes to plpython. Please do. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PATCHES] [HACKERS] statement level trigger causes pltcl, plpython SIGSEGV

2003-08-04 Thread Tom Lane
. IMHO anyway. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [PATCHES] Patch for select() - poll() in libpq

2003-08-04 Thread Tom Lane
-patch this, since it creates portability hazards that we can't risk without a proper beta test cycle. Feel free to back-patch locally if it's in your way. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze

Re: [PATCHES] CVSROOT/modules: earthdistance...

2003-08-06 Thread Tom Lane
and putting earthdistance back with the rest, myself. But you'll have to convince Marc ;-) regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] [HACKERS] IS OF

2003-08-08 Thread Tom Lane
tuple should be said to be IS OF the tuple type of its parent). And what about domains --- should we say a domain type IS OF its base type? regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] logging enhancements, minor code cleanup

2003-08-11 Thread Tom Lane
assumption; the question was just about whether your code acts sanely if the assumption isn't true. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] CVSROOT/modules: earthdistance...

2003-08-12 Thread Tom Lane
, and thus not break anyone's checkout? regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] array concat, et al patch

2003-08-19 Thread Tom Lane
Joe Conway [EMAIL PROTECTED] writes: Here's a patch for the documentation updates. Please apply. Applied with one small change --- I thought the last example failed to make the point that the elements of an ARRAY[] construct could be dissimilar. regards, tom lane

Re: [PATCHES] gettext-related compile failure fix

2003-08-28 Thread Tom Lane
. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PATCHES] [BUGS] to_timestamp not stable if date string shorter than

2003-09-03 Thread Tom Lane
of the changes didn't apply cleanly, and seemed unrelated anyway. This fixes the immediate complaint, but if there's some reason to apply the rest to 7.3.*, would you submit an additional patch against that branch? regards, tom lane ---(end of broadcast

Re: [PATCHES] [BUGS] to_timestamp not stable if date string shorter than

2003-09-03 Thread Tom Lane
Karel Zak [EMAIL PROTECTED] writes: Hmm.. but the patch fix another small bug which I found today. Okay. Please send a patch against 7.3 tip and I'll throw it in. regards, tom lane ---(end of broadcast)--- TIP 2

Re: [PATCHES] 7.3: [BUGS] to_timestamp not stable if date string shorter than

2003-09-03 Thread Tom Lane
Karel Zak [EMAIL PROTECTED] writes: Hmm.. but the patch fix another small bug which I found today. Okay. Please send a patch against 7.3 tip and I'll throw it in. The patch for REL7_3_4 is attached. Applied, thanks. regards, tom lane

Re: [PATCHES] [BUGS] PgSQL74b2: initdb fails (max_connections)

2003-09-03 Thread Tom Lane
Janko Richter [EMAIL PROTECTED] writes: On FreeBSD 5.1 using PgSQL 7.4b2 initdb failed with: Yeah, it's broken on any system with shmmax too small for the defaults :-(. My fault. This patch solves the problem: It's fixed in a different way in CVS tip. regards, tom

Re: [PATCHES] Warning for missing createlang

2003-09-04 Thread Tom Lane
misspellings of language names. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [PATCHES] minor documentation improvements

2003-09-05 Thread Tom Lane
you intending the variable definitions to be upper case and all the references lower case? It's not real clear what the intended style is, and I have to say that I thought Neil was heading in the intended direction also. regards, tom lane ---(end

Re: [PATCHES] minor documentation improvements

2003-09-05 Thread Tom Lane
in the main description in runtime.sgml, which are all upper case. That is a bit inconsistent, but I think it's OK, because here they sort of serve as section titles.) Okay, that seems reasonable. Ignore my prior message --- I hadn't come across this one yet. regards, tom lane

Re: [PATCHES] IPV4 addresses on IPV6 machines in pg_hba.conf

2003-09-05 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Would you like me to conditionally add the IPv6 line to pg_hba.conf from initdb now? I was going to tackle that tomorrow, but if you wanna do it, go for it. regards, tom lane ---(end of broadcast

Re: [PATCHES] MinGW patch

2003-09-06 Thread Tom Lane
. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] MinGW patch

2003-09-06 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: but top_srcdir isn't defined at this point. Perhaps $srcdir? Peter would probably know what to use. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [PATCHES] MinGW patch

2003-09-07 Thread Tom Lane
HAVE_SYS_SOCKET_H, etc. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [PATCHES] mcxt.c

2003-09-07 Thread Tom Lane
to do this, what is it? regards, tom lane ---(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

Re: [PATCHES] Unixware 713 probs

2003-09-07 Thread Tom Lane
fixed that yesterday. The s_addr name collision is unfortunate, but easily worked around; fix committed as suggested by Larry. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [PATCHES] Minor lmgr code cleanup

2003-09-07 Thread Tom Lane
? regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PATCHES] Minor lmgr code cleanup

2003-09-07 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: This has been saved for the 7.5 release: http:/momjian.postgresql.org/cgi-bin/pgpatches2 BTW, that page still calls itself PostgreSQL Items For 7.4. regards, tom lane ---(end of broadcast

Re: [PATCHES] ISO 8601 Time Intervals of the format with time-unit deignators

2003-09-07 Thread Tom Lane
months''P1Y6M' '3 hours 25 minutes 42 seconds' 'PT3H25M42S' Er, don't we support that already? I know I saw code to support something much like that syntax last time I looked into the datetime routines. regards, tom lane ---(end

Re: [PATCHES] ISO 8601 Time Intervals of the format with time-unit deignators

2003-09-08 Thread Tom Lane
to make sense, it's likely a bug rather than anything we want to preserve. In particular, given the knowledge that it doesn't meet the ISO spec, I'd judge that the existing code for the ISO shorthand was a work-in-progress. regards, tom lane ---(end

Re: [PATCHES] ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

2003-09-08 Thread Tom Lane
. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] ISO 8601 'Time Intervals' of the 'format with time-unit deignators'

2003-09-08 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: Yes, but by the same token iso8601 isn't specific enough either. Several of the other input formats we support have at least as good a claim on that name. The only input formats we support are along the lines of @ 1 year 2 mons 3

Re: [PATCHES] message not following the guidelines

2003-09-11 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: This message seems to be breaking the message guidelines. Wups, that seems to have slipped by me. (There were a *lot* of elogs :-() Fixed, thanks for the pointer. regards, tom lane ---(end of broadcast

Re: [PATCHES] Reorganization of spinlock defines

2003-09-11 Thread Tom Lane
the decision discussed on -hackers and not buried in -patches. regards, tom lane ---(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

Re: [PATCHES] Reorganization of spinlock defines

2003-09-11 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: On Thu, 11 Sep 2003, Tom Lane wrote: Well, as long as you're prepared to reduce the list of known supported platforms to zero as of 7.4beta3, and issue a fresh call for port reports. I didn't think we had done that yet ... had we? called for port

Re: [PATCHES] tsearch pfree error

2003-09-13 Thread Tom Lane
assumed Oleg and Teodor would take care of it. But they haven't yet, so I applied what I could. regards, tom lane ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [PATCHES] NLS changes

2003-09-14 Thread Tom Lane
probably have a better feel for this than I do, but I just wanted to point out that there was *some* thought behind doing it this way. I'm fine with changing it if other translators agree it's better. regards, tom lane ---(end of broadcast

Re: [PATCHES] NLS changes

2003-09-14 Thread Tom Lane
, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] [HACKERS] New array functions

2003-09-14 Thread Tom Lane
stuff seemed completely obsolete, but intagg isn't. regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] [GENERAL] backend crashing despite tsearch2 patch

2003-09-17 Thread Tom Lane
the above is unhelpful by any measure. regards, tom lane ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PATCHES] Align large shared memory allocations

2003-09-20 Thread Tom Lane
in pg_config_manual.h, then #define BUFFERALIGN(LEN) to parallel the other TYPEALIGN macros in c.h, and finally use that in the ShmemAlloc code. regards, tom lane ---(end of broadcast)--- TIP 9: the planner will ignore your desire

Re: [PATCHES] contrib mode - pgenv

2003-09-21 Thread Tom Lane
types. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

Re: [PATCHES] Align large shared memory allocations

2003-09-21 Thread Tom Lane
Manfred Spraul [EMAIL PROTECTED] writes: Tom Lane wrote: This patch is missing a demonstration that it's actually worth anything. What kind of performance gain do you get? 7.4cvs on a 1.13 GHz Intel Celeron mobile, 384 MB RAM, Severn RedHat Linux 2.4 beta, postmaster -N 30 -B 64, data

Re: [PATCHES] fix log_min_duration_statement logic error

2003-09-22 Thread Tom Lane
because log_duration is set, we don't need to print it again if the duration of the query exceeded log_min_duration_statement), but I haven't changed it. I think there should be just one duration: nnn log entry, printed if either condition holds. regards, tom lane

Re: [PATCHES] bug in vacuumlo?

2003-09-23 Thread Tom Lane
. Sigh. regards, tom lane ---(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

Re: [PATCHES] bug in vacuumlo?

2003-09-23 Thread Tom Lane
. But vacuumlo shouldn't depend on it.) I've applied a patch. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [PATCHES] correct NUL vs. NULL usage

2003-09-24 Thread Tom Lane
other names for the null character. In short, I think most of this patch is just pedantry. Could you trim it down to just the places where there's actually risk of confusion? (I do agree that upper case NULL is not appropriate as a name for the character.) regards, tom lane

Re: [PATCHES] tablefunc functions in postgresql

2003-10-01 Thread Tom Lane
. regards, tom lane ---(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

Re: [PATCHES] pg_dump --table=* dumps nothing?

2003-10-02 Thread Tom Lane
. regards, tom lane ---(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

Re: [PATCHES] fix log_min_duration_statement logic error

2003-10-04 Thread Tom Lane
than moving information around depending on which combination of switches happens to have caused the log entries to be generated. Am willing to fix the code to make this happen. regards, tom lane ---(end of broadcast)--- TIP 1

Re: [PATCHES] fix log_min_duration_statement logic error

2003-10-04 Thread Tom Lane
Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: I would prefer to see the log entries look like LOG: query: select * from pg_class; LOG: duration: nn.nnn msec The problem with two lines is that another log message could get between them. That was true already with log_statement

Re: [PATCHES] fix log_min_duration_statement logic error

2003-10-05 Thread Tom Lane
lines together, then we have got lots bigger problems to fix than log_duration. I'm not convinced it's an appropriate goal at all, though. regards, tom lane ---(end of broadcast)--- TIP 7: don't forget to increase your free

  1   2   3   4   5   6   7   8   9   10   >