the null bitmap, if present, always
covers all the columns...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
On Fri, Sep 29, 2006 at 10:59:13AM +0100, Heikki Linnakangas wrote:
Martijn van Oosterhout wrote:
On Fri, Sep 29, 2006 at 09:35:31AM +0100, Heikki Linnakangas wrote:
We could get rid of t_hoff, because we should always be able to
calculate the header size. Then we're down to 18 bytes
the original
proposal. That adds some complexity. but it's doable.
This way doesn't change the current index format much.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
of decimal places could be defined per currency...
Interesting thought, probably wouldn't take more than an hour to whip
up.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
not-host-dependant representation of the data.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
?
Converting to/from text format for when dealing with client
applications. Numeric can convert faster than plain integers sometimes.
Numeric isn't that slow really...
Have a ncie day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each
,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
On Thu, Sep 28, 2006 at 01:29:57PM -0700, Luke Lonergan wrote:
Martijn,
On 9/28/06 12:42 PM, Martijn van Oosterhout kleptog@svana.org wrote:
- Only supports one currency (dollars)
What are the manifestations of this?
test=# select '100'::money;
money
-
$100.00
(1 row
accurately describes the actual problem.
Have a ncie day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
But maybe that introduces too many quoting issues. Ofcourse, being able
to provide a complete connect string would be good too...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability
, so a ^C would have been a no-op.
psql uses simple_prompt which I beleive comes from the port directory.
And there is definitly a loop there to retry on no input. That hasn't
changed any time recently as far as I can tell.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
/archives/gtk-devel-list/2000-May/msg00029.html
Do you really think it's worth making a macro rather than just a normal
function?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
by a pointer to
the actual standard.
Well you could always use te HTML4 #305; which most tools should
understand. At least browsers have good support for this kind of
entity.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability
On Sat, Sep 23, 2006 at 11:54:47AM +0200, Peter Eisentraut wrote:
Martijn van Oosterhout wrote:
Well you could always use te HTML4 #305; which most tools should
understand. At least browsers have good support for this kind of
entity.
Please review the recent thread on pgsql-docs before
version 3, which is quite some time ago now.
So to me (a more docbook novice) it seems like it's the stylesheet
that's limiting you to latin1, not the docbook parser.
Anyway, the problem has been solved, so we can all get back to testing
the beta now.
Have a nice day,
--
Martijn van Oosterhout
For dsl file just copy the stylesheet.dsl file in the postgresql source
tree.
Why it doesn't work in the current docs I don't know, but I think we can
rule out limitations of HTML or Docbook.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each
get lost in the possibilites. Adding just a
single step domain to base type conversion seems pretty safe, but
anything more is going to be hard.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his
want.
I agree that maybe being able to specify it during function creation
would be nice, but it's not like it's impossible now.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability
.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
. That's what makes it expensive.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
and we should wonder why that cast implicit now anyway.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
? At the end of the
day it's the patch that gets reviewed, not the wiki page. Once the
patch is in it's just historical interest I guess...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability
of committing it should get sorted out. Did
you use the scripts to find free numbers?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital
their summaries with members of both/all sides of a given
discussion and with members of the core group.
It would be helpful if people commented on the stuff already there and
said if it's good, bad or otherwise.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org
-platform library to do the job.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
yet.
Have anice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
being in CVS, which gives it all
the access protection it needs. A wiki todo list can stay where it is,
just that it's not official.
[I've just made a reference to the TODO list in CVS from the wiki, that
should help].
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org
and ipv6 *never* fit.
Ie, we'll essentially end up with an ipv4inet and an ipv6inet. Sad in a way.
Eh? Either will always fit. ipv6 is 128 *bits* and the new varlena
header goes to 128 *bytes*. That should fit easily, no?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
Really? Where was that? Did it get deleted in the meantime? Who's
responsible for that kind of thing?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
it into a generic money type. Win win.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
. Especially for the analyse-from-autovacuum
case, perhaps an ANALYSE NOLOCK or whatever.
For stuff run from autovacuum, would it be reasonable for the
automatically run version to just abort if it sees someone doing the
same thing?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
for a type that can
store a single UTF-8 character is smart. I just can't see enough use to
make it worth it.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
indicater, with different
letters meaning different things.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
the lengths of all the previous datums first.
Good summary though, probably worth putting on the wiki so next time we
don't have to search the archives.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his
scans, executing stored plans, etc.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
will have to apply to -lssl,
-lcrypto, -lkrb5, -lk5crypto and quite possibly others. Do we really
want to go there?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
you're actually saving anything.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
the
users are doing, just how many resources they're taking.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
requires recoding, wheres changing collation does not.
I think it'd just become a special case of the Relabel node.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
On Fri, Sep 08, 2006 at 11:58:59AM +0100, Heikki Linnakangas wrote:
Martijn van Oosterhout wrote:
I think that if SQL COLLATE gets in we'll get this almost for free.
Collation and charset are both properties of strings. Once you've got a
mechanism to know the collation of a string, you just
should honour that. Moving all
this to the client doesn't seem like a good move at all.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
for the buffer cache. If you're RAM
limited, that's the last thing you want.
Currently, the executor will use the contents of the actual disk page
when possible, saving a lot of copying.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his
.
Well, that's not true, which part of the docs were you looking at?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
On Fri, Sep 08, 2006 at 12:19:19PM -0400, Tom Lane wrote:
Martijn van Oosterhout kleptog@svana.org writes:
On Fri, Sep 08, 2006 at 10:35:58AM -0400, Tom Lane wrote:
what's more, the docs suggest that it doesn't support anything wider
than UTF16.
Well, that's not true, which part
the
u_strCompareIter() interface, where the two strings are defined as
iterators. We setup the iterator to understand whatever charset
postgres is currently running.
Many of the other function have iterator versions also, so you can
avoid UTF-16 entirely if you like.
Have a nice day,
--
Martijn van
That way only people who actually want static linking need be bothered.
Have a ncie day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
every other fixed length type.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
to step forward through the string and return the code point at
each point.
Here's the docs for C++ class, but there's a equivalent C interface.
http://icu.sourceforge.net/apiref/icu4c/classCharacterIterator.html#_details
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http
/output functions should ignore
dashes, to make it straightforward to store UUIDs directly in there.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
it has to fit in a register. On the
whole, the CPU register size is the same as the pointer size, so
2*sizeof(pointer) is unlikely to fit...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability
On Thu, Sep 07, 2006 at 01:11:49PM +0100, Gregory Stark wrote:
Martijn van Oosterhout kleptog@svana.org writes:
The fundamental property of a Datum is that you can pass it by value to
a C function. This generally means it has to fit in a register. On the
whole, the CPU register size
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
gives you that, pretty much.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
doesn't help you if you want to do
accent-insensetive matching. Sometimes you don't just want to change
the order, you also want to change what is equal.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according
be in the next release.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
can't do
that; for some reason it's picked up the static version of termcap.
In any case, it shouldn't be using termcap at all. Something in the
makefile is including it obviously...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according
the developers FAQ?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
think in and of itself it is very difficult. As long as you don't want
to have the typmod to avoid storing data in the datum (which the
raw(64) example is) it should be fairly straightforward...
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each
in tables seems
silly.
Err, where does postgres use this information? I beleive there is a
project on pgfoundary that has some standard datasets.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
/programming/ansic-library.html#stdlib
http://cplus.kompf.de/cliblist.html
http://docs.hp.com/en/B9106-90010/strtod.3C.html
returning ERANGE on underflow was in the ANSI C standard.
Can't find the text itself though,
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org
it autogenerated. Provide a generation function (not
absolutly necessary) and you're done.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital
.
Yes that'd be nice, but not entirely straightforward.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
code left over, possibly from the days before the Name data type?
attlen -2 is used for cstring (null terminated strings).
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability
On Tue, Sep 05, 2006 at 01:42:57PM +0100, Gregory Stark wrote:
Martijn van Oosterhout kleptog@svana.org writes:
attlen -2 is used for cstring (null terminated strings).
Hope this helps,
Well that's what the code I quoted indicates. But when do we ever store a
cstring in a tuple
then.
BTW, I seem to remember something about the stuff in the RFC not being
good for some reason, not unique enough or too predictable. Do you know
anything about that?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability
. If the
purpose behind all of this is to save disk space, perhaps the root of
the problem is that disk representation and memory representation are
intimately tied?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each
On Sun, Sep 03, 2006 at 08:30:13PM -0700, Neil Conway wrote:
Martijn van Oosterhout said:
Ok, it looks like pages can be arranged hierarchically.
Well, a prefix like Todo: is not the incantation one needs to use to
arrange pages in hierarchies. You probably want / to indicate a subpage
...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
a part
of the executor is shared between two executions) that might provide a
way to solve some of the trickier multiple evaluation problems with
rules. Again, it would just be a tuplestore the stored the results for
multiple executions.
Have a nice day,
--
Martijn van Oosterhout kleptog
as people hit reply-to-all the whole
thread will be archived in the bug.
I assume other bug trackers have a similar feature...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
promise, but until the wiki is there we
won't know...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
to just a few. Then all some developer has to do is scan the wannabe
list and copy the links to the main list.
Is this kind of setup ossible?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his
beleive the idea was to not make the site editable by the public?
Does't that kind of defeat the purpose of getting more people to
takeover work?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his
items (and progress
info). With
Todo:Contents
being a front page?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
with out.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
/backend/tcop/postgres.c#rev1.420
That was over two years ago, I'm not sure whether any of the ideas
mentioned in there have been implemented since.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his
on first execution, like Oracle does.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
is
making some assumptions about the code that arn't true, so we tell the
compiler not to do that.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description
well, so perhaps the right approach is to get interface writers
to appreciate the difference and indicate if named or unnamed prepares
are used.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his
the same problem? I imagine most interfaces like
out-of-band parameters (no escaping issues), why do they not use this?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
preparation is the default
... what else were you thinking of?
Perl DBI (DBD::Pg) defaults to prepared plans when connecting to a
version 8.0 or higher server.
Or at least, that's the way I read the documentation.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org
.
I see from the source that DBD::Pg does use PQexecParams() sometimes so
maybe it does support out-of-line parameters...
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate
option anyday, but that's just the types of queries
I'm doing.
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
whether or not you want to plan straightaway or at bind time.
Would this be acceptable?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
-dec_test.c.diff file).
It changed and changed back again, very odd...
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
thing initdb actually needs is an implementation of
find_matching_encoding(ctype), which returns a value of enum pg_enc.
check_encodings_match() stays in initdb, and get_encoding_from_locale()
becomes internal to libpq.
How does that sound?
Have a nice day,
--
Martijn van Oosterhout kleptog
a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
to be able to cover some of the stuff done
during the upgrade, so it'd be useless after anyway.
Hope this helps,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description
spurious
results. At DEBUG lavel maybe?
Have a nice day,
--
Martijn van Oosterhout kleptog@svana.org http://svana.org/kleptog/
From each according to his ability. To each according to his ability to
litigate.
signature.asc
Description: Digital signature
701 - 800 of 1563 matches
Mail list logo