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.
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 post
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.
[ 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 s
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 t
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 rel
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| http://can
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 CurrentNo
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 particula
[ 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
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
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 feeli
"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
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 -
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
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 kin
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
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 rea
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.
Tha
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
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 c
> -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 wor
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 i
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 coming
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.
Bu
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
> >>
> >>
> >
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'
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
