Re: [HACKERS] WIP patch: Collation support

2008-09-23 Thread Martijn van Oosterhout
peope add more is the goal. I'm sure once the catalog exists the existing ICU-for-Postgres patch will be adjusted to use it. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank

Re: [HACKERS] WIP patch: Collation support

2008-09-23 Thread Martijn van Oosterhout
On Tue, Sep 23, 2008 at 01:32:38PM +0300, Heikki Linnakangas wrote: Martijn van Oosterhout wrote: You're assuming collations are denumerable. They're not. There is no way to find the list of available collations/locales. You may be able to guess a few but certainly not all of them. locale

Re: [HACKERS] WIP patch: Collation support

2008-09-19 Thread Martijn van Oosterhout
, Firebird added support for ICU more than three years ago. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital

Re: [HACKERS] WIP patch: Collation support

2008-09-19 Thread Martijn van Oosterhout
it as it was because it takes care of a useful subset of the features people want in a way that is compatable for the future. Whereas the stripped down version, I'm not sure it gets us anywhere. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] WIP patch: Collation support

2008-09-10 Thread Martijn van Oosterhout
, and then use that as a template for a database with UTF-8 encoding, the text data will be incorrectly encoded. We should probably fix that too. I'd say forbid more than one encoding in a cluster, but that's just my opinion :) Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http

Re: [HACKERS] WIP patch: Collation support

2008-09-10 Thread Martijn van Oosterhout
. But that put us back where we started: every database having the same collation. We're trying to move away from that. Just reindex everything and be done with it. That's easier said than done, unfortunately. I don't see an alternative. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED

Re: [HACKERS] Base64 decode/encode performance

2008-09-10 Thread Martijn van Oosterhout
much for performance. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] [PATCHES] to_date() validation

2008-09-09 Thread Martijn van Oosterhout
to provide too few characters, as long as it's not the last field? Other than that it looks like a good patch. Have a ncie day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn

Re: [HACKERS] Need more reviewers!

2008-09-05 Thread Martijn van Oosterhout
and later a newer version is posted with just changes. The commitfest page points to the latter, losing former in the archive somewhere. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] Question regarding the database page layout.

2008-09-02 Thread Martijn van Oosterhout
degradation. Other architechtures will simply throw exceptions, that's the smoke test. Also, what's the performance cost? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank

Re: [HACKERS] Window functions patch v04 for the September commit fest

2008-09-02 Thread Martijn van Oosterhout
optimization is the root of all evil. (Knuth, Donald.) make it work, then make it better. Getting a partial implementation that works out now is far better than waiting until its perfect. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] WIP patch: Collation support

2008-09-02 Thread Martijn van Oosterhout
make this work. While it's true POSIX locales don't handle this, other collation libraries do and we should support them if the user wants. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while

Re: [HACKERS] WIP patch: Collation support

2008-09-02 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] WIP patch: Collation support

2008-09-02 Thread Martijn van Oosterhout
On Tue, Sep 02, 2008 at 05:42:13PM +0100, Gregory Stark wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: On Tue, Sep 02, 2008 at 04:46:16PM +0300, Peter Eisentraut wrote: While it's true POSIX locales don't handle this, other collation libraries do and we should support them

Re: [HACKERS] Mysterious Bus Error with get_fn_expr_argtype()

2008-09-02 Thread Martijn van Oosterhout
a text representation of the type easily then. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Our CLUSTER implementation is pessimal

2008-09-01 Thread Martijn van Oosterhout
probably worse :) Isn't there some compromise. Like say scanning the index to collect a few thousand records and then sort them the way a bitmap index scan does. Should be much more efficient that what we have now. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org

Re: [HACKERS] IN, BETWEEN, spec compliance, and odd operator names

2008-08-25 Thread Martijn van Oosterhout
optimisation or the ORDER BY clause. Essentially anywhere where currently there are assumptions about the real operator name is required. And then the optimiser can fill in the actual operator by which time it should be clear what it is. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http

Re: [HACKERS] IN, BETWEEN, spec compliance, and odd operator names

2008-08-25 Thread Martijn van Oosterhout
On Mon, Aug 25, 2008 at 10:43:30AM -0400, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: ISTM the problem is that there's no easy way to refer to operators found in a default opclass, so perhaps we could invent a construct: A OPERATOR(btree,2) B Huh? I don't

Re: [HACKERS] What in the world is happening on spoonbill?

2008-08-24 Thread Martijn van Oosterhout
, and is widely supported. I'm not sure if any text browsers support CSS, so if implemented that way, for them the tooltips simply won't appear. Once you decide on exactly how you want text browsrs to be able to see it then the solution becomes obvious. Have a nice day, -- Martijn van Oosterhout [EMAIL

Re: [HACKERS] proposal sql: labeled function params

2008-08-24 Thread Martijn van Oosterhout
that python manages named and labelled params in a single calling syntax fairly straightforward. http://docs.python.org/tut/node6.html#SECTION00672 Have a ncie day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap

Re: [HACKERS] Proposal: new border setting in psql

2008-08-22 Thread Martijn van Oosterhout
it's almost plain text. In fact, a ReST document source can easily be read raw. I presume by ReST you mean this: http://docutils.sourceforge.net/rst.html Just guessing though. It's not referenced in wikipedia under that acronym. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED

Re: [HACKERS] modifying views

2008-08-15 Thread Martijn van Oosterhout
is to have logical position != physical position, so I don't see how bugs could survive very long. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] [WIP] patch - Collation at database level

2008-08-02 Thread Martijn van Oosterhout
will be explained in details so stay tuned. Good luck! Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Fixing the representation of ORDER BY/GROUP BY/DISTINCT

2008-08-01 Thread Martijn van Oosterhout
to a primary key is equivalent to a GROUP BY involving all the rest of the fields. Now, I don't think anyone has proposed a way to support that, but I wanted to check we arn't making it harder to do with these changes... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http

Re: [HACKERS] Do we really want to migrate plproxy and citext into PG core distribution?

2008-07-28 Thread Martijn van Oosterhout
, expressions and columns do. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] WITH RECUSIVE patches 0723

2008-07-28 Thread Martijn van Oosterhout
want materialization. Since the problem is using the result of a WITH clause more than once, would it be sufficient to simply detect that case and bail? You don't want materialisation is most cases, there's just a few where it is needed. Have a nice day, -- Martijn van Oosterhout [EMAIL

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-24 Thread Martijn van Oosterhout
with any characters... Which is basically the approach glibc/ICU takes. I think the standard is kind of pathetic to say that strcoll can set errno but have no value to indicate error. I wonder how many platforms actually use that feature. Have a nice day, -- Martijn van Oosterhout [EMAIL

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-22 Thread Martijn van Oosterhout
handle any characters that can be produced by encoding. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital

Re: [HACKERS] Fwd: Proposal - UUID data type

2008-07-14 Thread Martijn van Oosterhout
why there are standards. You are ofcourse free to propose it to them, but the question is if they'd listen... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-12 Thread Martijn van Oosterhout
a locale for any pair of (locale code,encoding), whether the result is meaningful is another question. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn

Re: [HACKERS] [WIP] collation support revisited (phase 1)

2008-07-11 Thread Martijn van Oosterhout
been accepted as a Google Summer of Code project. Why bother with pg_charset? I don't think I've seen anyone even asking for multiple charsets in a single DB and certainly no actual use case. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up

Re: [HACKERS] [WIP] patch - Collation at database level

2008-07-09 Thread Martijn van Oosterhout
day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Summary of some postgres portability issues

2008-07-09 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Summary of some postgres portability issues

2008-07-09 Thread Martijn van Oosterhout
On Wed, Jul 09, 2008 at 03:03:48PM -0400, Ken Camann wrote: On Wed, Jul 9, 2008 at 3:35 AM, Martijn van Oosterhout [EMAIL PROTECTED] wrote: Just clarifying for myself: you are mostly listing theoretical problems here, not actual I ran it and got regression failures problems, right

Re: [HACKERS] PATCH: CITEXT 2.0 v2

2008-07-08 Thread Martijn van Oosterhout
think that with concerted coding effort it could be done in 2-3 months (judging by how long it took to write the first version). The problem is it needs some planner kung-fu which not many people have. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please

Re: [HACKERS] [WIP] patch - Collation at database level

2008-07-08 Thread Martijn van Oosterhout
all the collations used in template1, which shouldn't be hard to arrange. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc

Re: [HACKERS] [WIP] patch - Collation at database level

2008-07-08 Thread Martijn van Oosterhout
in pg_database as a string, rather than as an identifier. This sidesteps the problem entirly. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] [WIP] patch - Collation at database level

2008-07-08 Thread Martijn van Oosterhout
to where we want to go. Given that the current projected timeframe for full COLLATE support is something like 2-3 major releases, I don't really see the problem with doing this now. Who knows, it might prompt people to do something sooner. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED

Re: [HACKERS] introduction of WIP window function patch

2008-07-05 Thread Martijn van Oosterhout
just once at the end. That would make RANK() a normal aggrgate which returns the number of distinct values seen so far (assuming input is ordered) and ROW_NUMBER() is just an alias for COUNT(). I hope this is clear, let me know if it doesn't make sense. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] A Windows x64 port of PostgreSQL

2008-07-04 Thread Martijn van Oosterhout
is going to change their position on this now. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] [WIP] patch - Collation at database level

2008-07-02 Thread Martijn van Oosterhout
tweak the collation on a small scale. In any case, whatever collation library is used, we're unlikely to predefine every possible collation in the system, there's too many (assuming they're denumerable). Have a niceday, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog

Re: [HACKERS] Latest on CITEXT 2.0

2008-06-26 Thread Martijn van Oosterhout
be detoasted. * Am I in fact getting an appropriate nul-terminated string in my cilower() function using this code? char * str = DatumGetCString( DirectFunctionCall1( textout, PointerGetDatum( arg ) ) ); Yes. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED

Re: [HACKERS] Question about Encoding a Custom Type

2008-06-16 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Question about Encoding a Custom Type

2008-06-16 Thread Martijn van Oosterhout
you assume that text* values are NULL terminated, because they're not... char * cilower(text * arg) { // Do I need to free anything here? char * str = VARDATA_ANY( arg ); str here is not null terminated. You need text_to_cstring or something similar. Have a nice day, -- Martijn van

Re: [HACKERS] Overhauling GUCS

2008-06-05 Thread Martijn van Oosterhout
)iny t Shared_buffers 64MB Configuration stored to /etc/postgresql/8.3/postgresql.conf # This would probably solve most issues. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] ERROR: operator is not unique with Custom Data Type

2008-06-05 Thread Martijn van Oosterhout
postgresql to choose in this case. Whichever way you want it, make that direction implicit and the other direction assignment. Having A-B and B-A both as implicit just leads to ambiguity. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] ERROR: operator is not unique with Custom Data Type

2008-06-05 Thread Martijn van Oosterhout
doesn't work with 8.3? The casting rules wrt text have changed... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description

Re: [HACKERS] Case-Insensitve Text Comparison

2008-06-03 Thread Martijn van Oosterhout
for details on how it works precisely, but it's far nicer than merely adding an typmod, since that would cause you to throw errors at runtime if there's a problem. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain

Re: [HACKERS] Case-Insensitve Text Comparison

2008-06-02 Thread Martijn van Oosterhout
. I don't think GUCs are the correct mechanism for this. The SQL COLLATE syntax handles this just fine. Either the original COLLATE patch or the new one will let people tags strings with any collation they like. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org

Re: [HACKERS] Case-Insensitve Text Comparison

2008-06-02 Thread Martijn van Oosterhout
approach. Should probably just delete the page from the wiki altogether. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc

Re: [HACKERS] [PERFORM] Memory question on win32 systems

2008-05-29 Thread Martijn van Oosterhout
only. I hope my understanding is correct. Incorrect, the shared buffer cache is shared between all running postgresql processes and between connections. Also the OS cache is shared between all programs on the system. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org

Re: [HACKERS] WITH RECURSIVE patch V0.1

2008-05-19 Thread Martijn van Oosterhout
. The server won't, the universe will end first. This is a nice example of the halting problem: http://en.wikipedia.org/wiki/Halting_problem Which was proved unsolvable a long time ago. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] WITH RECURSIVE patch V0.1

2008-05-19 Thread Martijn van Oosterhout
. Then D is popped and E and F pushed. So the returned order is: A,B,C,D,E,F. You could also do B,C,A,E,F,D if you wanted. FIFO pushes A and D. It then pops A and puts B and C at *the end*. It then pops D and pushes E and F at the end. So you get the order A,D,B,C,E,F Hope this helps, -- Martijn van

Re: [HACKERS] What to do with inline warnings?

2008-05-14 Thread Martijn van Oosterhout
be, because clearly it has no idea now. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] What to do with inline warnings?

2008-05-14 Thread Martijn van Oosterhout
)__builtin_expect(x,1) #define unlikely(x) __builtin_expect(x,0) So you say things like: if( likely( x==0 ) ) And gcc will optimise that the branch is likely to be taken. Using macros means that you can arrange it so that for non-gcc compilers it's a no-op. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] Problem returning strings with pgsql 8.3.x

2008-05-13 Thread Martijn van Oosterhout
this cause the return value to be allocated inside a new memory block which gets freeds at the SPI_pop? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn

Re: [HACKERS] another ecpg crash

2008-05-11 Thread Martijn van Oosterhout
what is meant. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Auto-updated fields

2008-05-08 Thread Martijn van Oosterhout
BY functionality work for this? Or won't that handle updates? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital

Re: [HACKERS] Query Hints? No thanks. Data hints?

2008-05-06 Thread Martijn van Oosterhout
A. Certain operations preserve order, which may also be useful. You can always propose something, see where it goes. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you

Re: [HACKERS] Protection from SQL injection

2008-04-30 Thread Martijn van Oosterhout
the same effect. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Protection from SQL injection

2008-04-29 Thread Martijn van Oosterhout
interactive query interface impossible. I don't think it's reasonable to include a complete SQL parser into psql just so I can type normal queries. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant

Re: [HACKERS] table format specification

2008-04-29 Thread Martijn van Oosterhout
which can parse datafiles (as long as your database is in some kind of readable state). Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] we don't have a bugzilla

2008-04-28 Thread Martijn van Oosterhout
, it would be really nice if someone could summarise it all on a wiki page that we can point people to. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn

Re: [HACKERS] MERGE Specification

2008-04-25 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Index AM change proposals, redux

2008-04-24 Thread Martijn van Oosterhout
write the code but also investigate reasonable limits for behaviour also. For the first three I can't imagine what the costs would be, except the memory usage to store the unduplicated data once when its read in. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org

Re: [HACKERS] Index AM change proposals, redux

2008-04-24 Thread Martijn van Oosterhout
else seems to be asking for trouble. Basically, on a single page you compact: A B - 2 A B - 3 A C - 4 A D - 1 B F - 2 to: A B - [2, 3] (1) C - 4 (1) D - 1 B F - 2 Within the context of a single page it's perfectly clear. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http

Re: [HACKERS] [RFC] Localized literals

2008-04-23 Thread Martijn van Oosterhout
would become much more expensive. But none of this has anything ot do with encodings. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] pgkill on win32

2008-04-22 Thread Martijn van Oosterhout
is for. The current backend code already constructs BIOs for reading to support interrupting (see my_sock_read), so you could replace the read with any functions you wanted. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap

Re: [HACKERS] MERGE Specification

2008-04-22 Thread Martijn van Oosterhout
an update. What you really need for this though is a non-fatal _bt_check_unique so you can recover without having a savepoint for every row. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while

Re: [HACKERS] Regression test fails when BLCKSZ is 1kB

2008-04-22 Thread Martijn van Oosterhout
test checking the sorted results would at least preclude the chance that there really is something wrong. It was a guide, not a way of getting out of tests. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap

Re: [HACKERS] MERGE Specification

2008-04-22 Thread Martijn van Oosterhout
day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Regression test fails when BLCKSZ is 1kB

2008-04-21 Thread Martijn van Oosterhout
automatically, without having to eyeball the output. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital

Re: [HACKERS] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout

2008-04-18 Thread Martijn van Oosterhout
elsewhere) rather than working around it in countless individual places. maintainence_statement_timeout? :) Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying

Re: [HACKERS] Re: [COMMITTERS] pgsql: Repair two places where SIGTERM exit couldleave shared memory

2008-04-18 Thread Martijn van Oosterhout
On Thu, Apr 17, 2008 at 11:48:41AM -0400, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: Is this so? This happened to me the other day (hence the question about having COPY note failure earlier) because the disk filled up. I was confused because du showed nothing

Re: [HACKERS] Lessons from commit fest

2008-04-17 Thread Martijn van Oosterhout
other than adjust whitespace. It surely won't remove braces... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description

Re: [HACKERS] Re: [COMMITTERS] pgsql: Repair two places where SIGTERM exit couldleave shared memory

2008-04-17 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

[HACKERS] Timely reporting of COPY errors

2008-04-16 Thread Martijn van Oosterhout
in PQconsumeInput in places but it doesn't appear to help. Any ideas? -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Timely reporting of COPY errors

2008-04-16 Thread Martijn van Oosterhout
as to why PQconsumeInput doesn't work. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Lessons from commit fest

2008-04-15 Thread Martijn van Oosterhout
and why it is better than the others suggested. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] rule for update view that updates/inserts into 2 tables

2008-04-15 Thread Martijn van Oosterhout
to the view to limit the number of audit entries to one. How do I accomplish what I want to accomplish here? I'd prefer not to use a sp. Why not? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant

Re: [HACKERS] printTable API (was: Show INHERIT in \du)

2008-04-15 Thread Martijn van Oosterhout
: New version submitted (link) (brief summary of changes) If there are many more versions you can consider cutting, but you're not there yet. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while

Re: [HACKERS] pulling libpqtypes from queue

2008-04-15 Thread Martijn van Oosterhout
by distributors that'd be cool. I can think of some projects that could really benefit from a feature like this. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying

Re: [HACKERS] [SQL] rule for update view that updates/inserts into 2 tables

2008-04-15 Thread Martijn van Oosterhout
procedure definition and it would still have one roundtrip. But your way works also. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] Cached Query Plans (was: global prepared statements)

2008-04-13 Thread Martijn van Oosterhout
statements idea much better. Named the statements is no problem: DB frontends do that for you anyway sometimes. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying

Re: [HACKERS] question on how to correctly communicate with external library functions which return malloc()'ed strings

2008-04-11 Thread Martijn van Oosterhout
strings? See if you can avoid including that header altogether... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description

Re: [HACKERS] Adding pipelining support to set returning functions

2008-04-11 Thread Martijn van Oosterhout
it would favour plans that did not require seeking... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital

Re: [HACKERS] MSVC build broken with perl 5.10

2008-04-10 Thread Martijn van Oosterhout
the filename in $1 \s*:\s*(?:%\s*:\ )? # somethig with a %-sign ...etc... }x; Check the perlre manpage for more info. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain

Re: [HACKERS] [PATCHES] libpq type system 0.9a

2008-04-08 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] modules

2008-04-05 Thread Martijn van Oosterhout
in the cold... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] modules

2008-04-04 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Locale, Collation, ICU patch

2008-04-04 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] psql \G command -- send query and output using extended format

2008-04-03 Thread Martijn van Oosterhout
statement. It would solve the OPs problem. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Small TRUNCATE glitch

2008-04-03 Thread Martijn van Oosterhout
there complaints from people regularly truncating and refilling tables getting bad plans because they lost the statistics? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you

Re: Prereading using posix_fadvise (was Re: [HACKERS] Commitfest patches)

2008-03-28 Thread Martijn van Oosterhout
van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Commitfest patches

2008-03-28 Thread Martijn van Oosterhout
wouldn't feel more comfortable taking baby steps at first which will have less impact in cases where it's not being heavily used. I think the way it is now is neat and simple and enough for now. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line

Re: [HACKERS] Indexing for Expression type data using GIST

2008-03-27 Thread Martijn van Oosterhout
information about what the information represents we might be able to give you a better idea. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] TODO Item: Consider allowing control of upper/lower case folding of unquoted, identifiers

2008-03-27 Thread Martijn van Oosterhout
and not others, which is madness. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] HP-UX 11.11 PostgreSQL 8.3.1 - psql core dumps - Unresolved symbol: tgetent

2008-03-25 Thread Martijn van Oosterhout
it by adding -lcurses to the psql link line, but fixing readline would be better. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc

Re: [HACKERS] [GENERAL] tsearch2 in postgresql 8.3.1 - invalid byte sequence for encoding UTF8: 0xc3

2008-03-20 Thread Martijn van Oosterhout
decided it was a space, or sscanf didn't read it... Have anice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital

Re: [HACKERS] Unique Constraints using Non-Unique Indexes

2008-03-20 Thread Martijn van Oosterhout
this usage I don't know. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

<    1   2   3   4   5   6   7   8   9   10   >