Tom Lane wrote:
[EMAIL PROTECTED] (Edwin S. Ramirez) writes:
It appears that the count('x') will no longer work without a type
cast. Is this on purpose?
warehouse=# select count('x') ;
ERROR: cannot accept a value of type any
Hm, that query seems like it should be legal. (You get
Bruce Momjian [EMAIL PROTECTED] writes:
What is COUNT('x') supposed to return? 1? Is that legal SQL?
Why not? Vanilla SQL would assume the string is CHAR type.
regards, tom lane
---(end of broadcast)---
TIP 3: if
Greg Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I hate to reply to this because I have already cast my vote, but
block_size does not report the size of a disk block. It reports the
size of a PostgreSQL block/page. Disk blocks are almost always 512
bytes in size.
Perhaps
[ General removed, hackers added.]
Where are we on nested transactions. Is it something we can get for 7.5?
---
Manfred Koizar wrote:
On Wed, 3 Dec 2003 08:08:49 - (GMT), John Sidney-Woollett
[EMAIL PROTECTED]
If I'm not wrong Neil Conway is working on
reimplement a double linked list.
Looking around I found this post of
Herb Sutter on comp.lang.c++:
In particular, a motivation behind two-way pointers is that you
can have a more
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
What is COUNT('x') supposed to return? 1? Is that legal SQL?
Why not?
Because there is nothing to count.
In general,
SELECT count(expr) FROM table1;
counts the number of rows in table1 where expr evaluates to not null.
If table1
Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
A bug in the information schema concerning the bit types must be
fixed.
Does anyone have a patch for this?
I suppose not, but it's being worked on.
What's the bug exactly? Is it worth delaying the release for? Given
Guys, where are we on tablespaces? Should I set up a project page or
does it need organization? I think we need to define the command syntax
and then implementation details. I don't think it is that hard and
certainly is possible for 7.5.
--
Bruce Momjian|
I could see how this would work if you always had a reference to one of the nodes.
The problem with the approach I can see is that you *have* to always know the value of
at least one pointer, and maintaining that will ultimately require more coding than
just having two pointers.
Assume
Peter Eisentraut [EMAIL PROTECTED] writes:
In general,
SELECT count(expr) FROM table1;
counts the number of rows in table1 where expr evaluates to not null.
Right. Edwin obscured the datatype issue by leaving off a table, but
the issue is real anyway:
regression=# select count(1) from
Gaetano Mendola [EMAIL PROTECTED] writes:
If I'm not wrong Neil Conway is working on
reimplement a double linked list.
No, he's working on keeping track of the list tail element (and length,
but the tail element is the important part). There was nothing about
double linking.
In particular, a
[ moved to -hackers ]
Bruce Momjian [EMAIL PROTECTED] writes:
We are also wonder if there is a version of Ident server
that the PostgreSQL community knows that will work
with IPv6.
That is the big question. I would think Solaris ships with one, but
maybe not. Is 7.4/Solaris/ident not a
On Sat, Dec 06, 2003 at 02:09:25PM -0500, Tom Lane wrote:
[ moved to -hackers ]
Bruce Momjian [EMAIL PROTECTED] writes:
We are also wonder if there is a version of Ident server
that the PostgreSQL community knows that will work
with IPv6.
That is the big question. I would think
Hi,
The ident server we currently use is pidentd 3.0.16
from :
http://www.lysator.liu.se/ or
ftp://ftp.lysator.liu.se/pub/ident/servers
I am looking to see if Solaris has an ident server but have not
found it.
Gan
At 8:21 pm +0100 2003/12/6, Kurt Roeckx wrote:
On Sat, Dec 06, 2003 at 02:09:25PM
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote:
Hi,
The ident server we currently use is pidentd 3.0.16
The only I could find in a short time was oidentd. It says it
runs on Linux, *BSD and Solaris. http://dev.ojnk.net/
I've been told that FreeBSD's inetd's internal identd
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote:
Hi,
The ident server we currently use is pidentd 3.0.16
from :
http://www.lysator.liu.se/ or
ftp://ftp.lysator.liu.se/pub/ident/servers
The ChangeLog of it says: Solaris 8 (including IPv6) support
added.
But I have a feeling
Marc G. Fournier [EMAIL PROTECTED] writes:
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first
The libpq SSL memory leak reported on -bugs would be good to fix.
BTW, is
Neil Conway wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
To accomodate ppls travel scheduales, we are going to move the 7.4.1
release up to Monday, *unless* there is a report before then about
something that needs to be fixed first
The libpq SSL memory leak reported on -bugs would
Neil Conway [EMAIL PROTECTED] writes:
The libpq SSL memory leak reported on -bugs would be good to fix.
We don't know yet if that's our bug or not.
BTW, is there a particular reason we're pushing out 7.4.1 so soon?
ISTM there wouldn't be anything wrong with waiting a week or two...
Well, we
I recently had the opportunity to take an upper-year/graduate-level
course on DBMS internals at my university. While taking that course, I
wrote some notes on course material as a study aid. I thought that
perhaps some of the people on -hackers might find the notes somewhat
useful, so Bruce was
Tom Lane wrote:
Neil Conway [EMAIL PROTECTED] writes:
The libpq SSL memory leak reported on -bugs would be good to fix.
We don't know yet if that's our bug or not.
BTW, is there a particular reason we're pushing out 7.4.1 so soon?
ISTM there wouldn't be anything wrong with waiting a
Bruce Momjian [EMAIL PROTECTED] writes:
So we have SSL, information schema (bit), and autovacuum. The last one
is an easy fix, not sure on the others.
I thought you already applied those autovacuum patches? Is there
something else pending for it?
regards, tom lane
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
So we have SSL, information schema (bit), and autovacuum. The last one
is an easy fix, not sure on the others.
I thought you already applied those autovacuum patches? Is there
something else pending for it?
I am still reading
Bruce Momjian [EMAIL PROTECTED] writes:
I am still reading email from yesterday, but this is a new patch in the
past 2 days. The problem is that time differences were overflowing int
values if the vacuum took a long time, or something like that. The fix
is to cast one to long long.
That's
Gaetano Mendola wrote:
If I'm not wrong Neil Conway is working on
reimplement a double linked list.
Looking around I found this post of
Herb Sutter on comp.lang.c++:
In particular, a motivation behind two-way pointers
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I am still reading email from yesterday, but this is a new patch in the
past 2 days. The problem is that time differences were overflowing int
values if the vacuum took a long time, or something like that. The fix
is to cast one to
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 06, 2003 5:02 PM
To: Gaetano Mendola
Cc: [EMAIL PROTECTED]
Subject: Re: [HACKERS] Double linked list with one pointer
Gaetano Mendola wrote:
If I'm not wrong Neil Conway is working on
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
That's no fix --- it will break the code on compilers without long long.
Here are the emails describing the problem. Seems they should see how
we do time differences in the backend as an example.
Now that I look at it, the code is
Bruce Momjian wrote:
Gaetano Mendola wrote:
I don't think the article is available online, alas, but you can find some
related source code demonstrating the technique at:
http://www.semantics.org/tyr/tyr0_5/list.h
That certainly is an amazing idea. You know the pointer you are
Kurt Roeckx wrote:
On Sat, Dec 06, 2003 at 01:30:02PM -0600, Seum-Lim Gan wrote:
Hi,
The ident server we currently use is pidentd 3.0.16
from :
http://www.lysator.liu.se/ or
ftp://ftp.lysator.liu.se/pub/ident/servers
The ChangeLog of it says: Solaris 8 (including IPv6) support
added.
Andrew Dunstan wrote:
Bruce Momjian wrote:
Gaetano Mendola wrote:
I don't think the article is available online, alas, but you can find some
related source code demonstrating the technique at:
http://www.semantics.org/tyr/tyr0_5/list.h
That certainly is an amazing
Andrew Dunstan [EMAIL PROTECTED] writes:
I must confess that it strikes me as a really really horrid and ugly
hack - very likely to be error-prone and non-portable and undebuggable,
and for almost no saving worth having. But maybe that's just me.
No, that was exactly my reaction too. I'd be
Shridhar Daithankar wrote:
Something like select reltuples from pg_class where relname='foo'?
Shridhar
[chuckles] - I had envisaged something more accurate that the last
ANALYZE, estimate_count would effectively *do* acquire_sample_rows()
then and there for you...
regards
Mark
33 matches
Mail list logo