Its been almost 4 weeks since we've released Beta2, and there have been
enough improvements to the code to warrant a new Beta, to reduce the
number of "already fixed" bug reports.
For a complete list of changes/improvement since Beta 1 was released, please
see:
ftp://ftp.postgresql.org/pub/
On Mon, 2004-09-27 at 16:29, Marc G. Fournier wrote:
> Its been almost 4 weeks since we've released Beta2, and there have been
> enough improvements to the code to warrant a new Beta, to reduce the
> number of "already fixed" bug reports.
>
> For a complete list of changes/improvement since Beta
On Mon, 27 Sep 2004, Robby Russell wrote:
On Mon, 2004-09-27 at 16:29, Marc G. Fournier wrote:
Its been almost 4 weeks since we've released Beta2, and there have been
enough improvements to the code to warrant a new Beta, to reduce the
number of "already fixed" bug reports.
For a complete list of c
Hi, I am trying to deal with a deadlock situation caused by foreign key references on
insert and I was wondering if anyone knows what order the foreign keys are locked (or
evaluated) in for a particular table? Deferring the locks is unfortunately not a good
option for me...
Thanks,
Shawn
Even simpler: COALESCE( a = b, a IS NULL AND b IS NULL )
-- Dean
Greg Stark wrote on 2004-09-27 08:17:
Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Sun, 26 Sep 2004 20:16:52 +0200, David Helgason <[EMAIL PROTECTED]> wrote:
>
> > > On a similar note, I've found myself wanting an extended '=' op
On 27. sep 2004, at 22:08, Dean Gibson (DB Administrator) wrote:
Greg Stark wrote on 2004-09-27 08:17:
Stephan Szabo <[EMAIL PROTECTED]> writes:
>> On Sun, 26 Sep 2004 20:16:52 +0200, David Helgason <[EMAIL PROTECTED]>
wrote:
>>> On a similar note, I've found myself wanting an extended '='
operat
Core dump on select from psql on AIX 5.x
I have the following task at hand -
A huge table, one of the column data has duplicated entries. I want to find
those duplicated records in this column -
select count(*), col-x from table-x group by col-x having count(*) >1;
Of course, the above query wi
This is the Problem:
I'm building a Large DataMart with a big
table and I want to improve the performace using aggregates I mean a set of
table that store some specific aggregacion of the main table, like materialized
views, I know that this feature is not implemented yet in postgres, And
I had a bunch of tables that had v_ prepended to their names. I've
renamed all of the tables so that they don't have that prefix anymore
so that v_address is now addresses. The name of this table's sequence
is still v_addresses_address_id_seq. This is fine except for the fact
that I'm using
To all,
Running into an out of memory error on our data warehouse server. This
occurs only with our data from the 'September' section of a large fact
table. The exact same query running over data from August or any prior
month for that matter works fine which is why this is so weird. Note that
J
On Mon, Sep 27, 2004 at 03:19:47PM -0400, Shawn Chisholm wrote:
>
> Hi, I am trying to deal with a deadlock situation caused by foreign
> key references on insert and I was wondering if anyone knows what
> order the foreign keys are locked (or evaluated) in for a particular
> table? Deferring the
Sean Shanny <[EMAIL PROTECTED]> writes:
> -> Seq Scan on f_pageviews t1 (cost=0.00..11762857.88
> rows=1 width=8)
> Filter: ((date_key >= 610) AND (date_key <= 631))
How many rows are actually going to match that filter condition? (The
symptoms seem
Tom,
We have been running pg_autovacuum on this entire DB so I did not even
consider that. I am running an analyze verbose now.
We should see about 82mm rows that will match the Filter: ((date_key >= 610)
AND (date_key <= 631))
I'll update in an hour or so.
--sean
On 9/27/04 11:49 PM, "Tom L
Hi,
I was wondering if the .net connector for pgsql works fine on Visual C#
on PocketPC 2002/2003 too. Any comments on past experiences is truly
appreciated.
Thanks,
Fed
---(end of broadcast)---
TIP 6: Have you searched our list archives?
> > Druid? http://druid.sourceforge.net/
>
> from reading the description, it looks like they might have something,
> but there is *no* documentation and i can't figure out how they want
> me to run the install jar file.
java -jar druid-3.5-install.jar
Bye, Chris.
---
15 matches
Mail list logo
