PostgreSQL 7.4.3 Now Available ...

[Marc G. Fournier]

After several fixes were backpatches to the 7_4_STABLE branch, we have now
released a 7.4.3. As the list of Changes since 7.4.2 is quite small, they
are included in this email:

* Fix temporary memory leak when using non-hashed aggregates (Tom)
* ECPG fixes, including some for Informix compatibility (Michael)
* Fixes for compiling with thread-safety, particularly Solaris (Bruce)
* Fix error in COPY IN termination when using the old network
protocol (ljb)
* Several important fixes in pg_autovacuum (Matthew T. O'Connor)
* Fix problem with reading tar-format dumps on NetBSD and BSD/OS (Bruce)
* Several JDBC fixes
* Fix ALTER SEQUENCE RESTART where last_value equals the restart
value (Tom)
* Repair failure to recalculate nested sub-selects (Tom)
* Fix problems with non-constant expressions in LIMIT/OFFSET
* Support FULL JOIN with no join clause, such as X FULL JOIN Y ON
TRUE (Tom)
* Fix another zero-column table bug (Tom)
* Improve handling of non-qualified identifiers in GROUP BY clauses
in sub-selects (Tom)
* Do not generate "NATURAL CROSS JOIN" when decompiling rules (Tom)
* Add checks for invalid field length in binary COPY (Tom)
* Avoid locking conflict between ANALYZE and LISTEN/NOTIFY
* Numerous translation updates (various contributors)

As always, this release is available on all our mirrors, viable at:

http://www.postgresql.org/mirrors-www.html

And, thanks to David Fetter, is also available via BitTorrent at:

http://bt.postgresql.org

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Hunter Hillegas]

Re: PostgreSQL 7.4.3 Now Available ...

Anyone else having trouble expanding the archives? I tried the tar.gz and
the tar.bz2, both gave errors on decompression.

[color=blue]
> From: "Marc G. Fournier" <scrappy@postgr esql.org>
> Date: Tue, 15 Jun 2004 12:36:47 -0300 (ADT)
> To: <pgsql-announce@postgr esql.org>
> Cc: <pgsql-general@postgre sql.org>
> Subject: [GENERAL] PostgreSQL 7.4.3 Now Available ...
>
> After several fixes were backpatches to the 7_4_STABLE branch, we have now
> released a 7.4.3. As the list of Changes since 7.4.2 is quite small, they
> are included in this email:[/color]



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Hunter Hillegas]

Re: PostgreSQL 7.4.3 Now Available ...

Anyone else having trouble expanding the archives? I tried the tar.gz and
the tar.bz2, both gave errors on decompression.

[color=blue]
> From: "Marc G. Fournier" <scrappy@postgr esql.org>
> Date: Tue, 15 Jun 2004 12:36:47 -0300 (ADT)
> To: <pgsql-announce@postgr esql.org>
> Cc: <pgsql-general@postgre sql.org>
> Subject: [GENERAL] PostgreSQL 7.4.3 Now Available ...
>
> After several fixes were backpatches to the 7_4_STABLE branch, we have now
> released a 7.4.3. As the list of Changes since 7.4.2 is quite small, they
> are included in this email:[/color]



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Oliver Elphick]

Re: PostgreSQL 7.4.3 Now Available ...

On Tue, 2004-06-15 at 16:36, Marc G. Fournier wrote:[color=blue]
> After several fixes were backpatches to the 7_4_STABLE branch, we have now
> released a 7.4.3.[/color]

A Debian package of this new release has been uploaded to the Debian
archive and should be available from Debian mirrors by tomorrow.

--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
=============== =============== ==========
"Therefore being justified by faith, we have peace with
God through our Lord Jesus Christ." Romans 5:1


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Oliver Elphick]

Re: PostgreSQL 7.4.3 Now Available ...

On Tue, 2004-06-15 at 16:36, Marc G. Fournier wrote:[color=blue]
> After several fixes were backpatches to the 7_4_STABLE branch, we have now
> released a 7.4.3.[/color]

A Debian package of this new release has been uploaded to the Debian
archive and should be available from Debian mirrors by tomorrow.

--
Oliver Elphick olly@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
=============== =============== ==========
"Therefore being justified by faith, we have peace with
God through our Lord Jesus Christ." Romans 5:1


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tom Lane]

Re: PostgreSQL 7.4.3 Now Available ...

Oliver Elphick <olly@lfix.co.u k> writes:[color=blue]
> A Debian package of this new release has been uploaded to the Debian
> archive and should be available from Debian mirrors by tomorrow.[/color]

I will push out a Fedora Core package within the next few days as well.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tom Lane]

Re: PostgreSQL 7.4.3 Now Available ...

Oliver Elphick <olly@lfix.co.u k> writes:[color=blue]
> A Debian package of this new release has been uploaded to the Debian
> archive and should be available from Debian mirrors by tomorrow.[/color]

I will push out a Fedora Core package within the next few days as well.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tom Lane]

Re: PostgreSQL 7.4.3 Now Available ...

Hunter Hillegas <lists@lastonep icked.com> writes:[color=blue]
> Anyone else having trouble expanding the archives? I tried the tar.gz and
> the tar.bz2, both gave errors on decompression.[/color]

I verified the tar.gz late last night. Maybe you forgot to download in
binary mode?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org

[Tom Lane]

Re: PostgreSQL 7.4.3 Now Available ...

Hunter Hillegas <lists@lastonep icked.com> writes:[color=blue]
> Anyone else having trouble expanding the archives? I tried the tar.gz and
> the tar.bz2, both gave errors on decompression.[/color]

I verified the tar.gz late last night. Maybe you forgot to download in
binary mode?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postg resql.org

[Scott Marlowe]

Re: PostgreSQL 7.4.3 Now Available ...

On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=blue]
> Oliver Elphick <olly@lfix.co.u k> writes:[color=green]
> > A Debian package of this new release has been uploaded to the Debian
> > archive and should be available from Debian mirrors by tomorrow.[/color]
>
> I will push out a Fedora Core package within the next few days as well.[/color]

Do those get pushed out into the FC update system, to be picked
automatically by the update program? Or is that only for security
updates?


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Scott Marlowe]

Re: PostgreSQL 7.4.3 Now Available ...

On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=blue]
> Oliver Elphick <olly@lfix.co.u k> writes:[color=green]
> > A Debian package of this new release has been uploaded to the Debian
> > archive and should be available from Debian mirrors by tomorrow.[/color]
>
> I will push out a Fedora Core package within the next few days as well.[/color]

Do those get pushed out into the FC update system, to be picked
automatically by the update program? Or is that only for security
updates?


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

[Tom Lane]

Re: PostgreSQL 7.4.3 Now Available ...

"Scott Marlowe" <smarlowe@qwest .net> writes:[color=blue]
> On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=green]
>> I will push out a Fedora Core package within the next few days as well.[/color][/color]
[color=blue]
> Do those get pushed out into the FC update system, to be picked
> automatically by the update program? Or is that only for security
> updates?[/color]

AFAIK it'll get pushed out the same as any other FC update.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Tom Lane]

Re: PostgreSQL 7.4.3 Now Available ...

"Scott Marlowe" <smarlowe@qwest .net> writes:[color=blue]
> On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=green]
>> I will push out a Fedora Core package within the next few days as well.[/color][/color]
[color=blue]
> Do those get pushed out into the FC update system, to be picked
> automatically by the update program? Or is that only for security
> updates?[/color]

AFAIK it'll get pushed out the same as any other FC update.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Devrim GUNDUZ]

Re: PostgreSQL 7.4.3 Now Available ...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Tue, 15 Jun 2004, Tom Lane wrote:
[color=blue]
> I will push out a Fedora Core package within the next few days as well.[/color]

I've already built (S)RPMS for FC 2 by just modifying spec file and
modifying some patches for rpm build. All are tested and they are working
fine. Oh, also updated to latest jdbc drivers.

If anyone needs, I've uploaded them to:

http://www.gunduz.org/postgresql/packages-7.4.3/

SRPM and -debuginfo will be uploaded tonight, since they are big files
and my DSL is a bit slow. The UPLOAD-NOT-FINISHED file will be removed
after these packages will be uploaded. BTW, spec file has been uploaded,
too.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.o rg devrim.gunduz~l inux.org.tr

http://www.tdmsoft.com

http://www.gunduz.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFA0UL3tl8 6P3SPfQ4RAr/PAJ4ti736mtBzfq AdJ4LCAedDQK9wR wCg0Un3
KjtXD4LFbZ+PfjW IgVpd5wA=
=2XCL
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Devrim GUNDUZ]

Re: PostgreSQL 7.4.3 Now Available ...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Tue, 15 Jun 2004, Tom Lane wrote:
[color=blue]
> I will push out a Fedora Core package within the next few days as well.[/color]

I've already built (S)RPMS for FC 2 by just modifying spec file and
modifying some patches for rpm build. All are tested and they are working
fine. Oh, also updated to latest jdbc drivers.

If anyone needs, I've uploaded them to:

http://www.gunduz.org/postgresql/packages-7.4.3/

SRPM and -debuginfo will be uploaded tonight, since they are big files
and my DSL is a bit slow. The UPLOAD-NOT-FINISHED file will be removed
after these packages will be uploaded. BTW, spec file has been uploaded,
too.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.o rg devrim.gunduz~l inux.org.tr

http://www.tdmsoft.com

http://www.gunduz.org

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFA0UL3tl8 6P3SPfQ4RAr/PAJ4ti736mtBzfq AdJ4LCAedDQK9wR wCg0Un3
KjtXD4LFbZ+PfjW IgVpd5wA=
=2XCL
-----END PGP SIGNATURE-----


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings