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

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@postgresql.org>
> Date: Tue, 15 Jun 2004 12:36:47 -0300 (ADT)
> To: <pgsql-announce@postgresql.org>
> Cc: <pgsql-general@postgresql.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

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@postgresql.org>
> Date: Tue, 15 Jun 2004 12:36:47 -0300 (ADT)
> To: <pgsql-announce@postgresql.org>
> Cc: <pgsql-general@postgresql.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

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

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 <olly@lfix.co.uk> 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

Oliver Elphick <olly@lfix.co.uk> 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

Hunter Hillegas <lists@lastonepicked.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@postgresql.org

Hunter Hillegas <lists@lastonepicked.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@postgresql.org

On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=blue]
> Oliver Elphick <olly@lfix.co.uk> 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

On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=blue]
> Oliver Elphick <olly@lfix.co.uk> 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" <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

"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

-----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.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org




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

iD8DBQFA0UL3tl86P3SPfQ4RAr/PAJ4ti736mtBzfqAdJ4LCAedDQK9wRwCg0Un3
KjtXD4LFbZ+PfjWIgVpd5wA=
=2XCL
-----END PGP SIGNATURE-----


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

-----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.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org




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

iD8DBQFA0UL3tl86P3SPfQ4RAr/PAJ4ti736mtBzfqAdJ4LCAedDQK9wRwCg0Un3
KjtXD4LFbZ+PfjWIgVpd5wA=
=2XCL
-----END PGP SIGNATURE-----


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

On Tue, 2004-06-15 at 21:54, Tom Lane wrote:[color=blue]
> "Scott Marlowe" <smarlowe@qwest.net> writes:[color=green]
> > On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=darkred]
> >> I will push out a Fedora Core package within the next few days as well.[/color][/color]
>[color=green]
> > 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.
>[/color]

I notice we have yet to get a directory for 7.4.3 under /binary,
are you planning on putting them up on the ftp server as well?

Along those lines is anyone planning on doing a redhat 7.3 build ?

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


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

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

On Tue, 2004-06-15 at 21:54, Tom Lane wrote:[color=blue]
> "Scott Marlowe" <smarlowe@qwest.net> writes:[color=green]
> > On Tue, 2004-06-15 at 14:44, Tom Lane wrote:[color=darkred]
> >> I will push out a Fedora Core package within the next few days as well.[/color][/color]
>[color=green]
> > 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.
>[/color]

I notice we have yet to get a directory for 7.4.3 under /binary,
are you planning on putting them up on the ftp server as well?

Along those lines is anyone planning on doing a redhat 7.3 build ?

Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


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

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

On Friday 18 June 2004 09:21, Robert Treat wrote:[color=blue]
> I notice we have yet to get a directory for 7.4.3 under /binary,
> are you planning on putting them up on the ftp server as well?[/color]
[color=blue]
> Along those lines is anyone planning on doing a redhat 7.3 build ?[/color]

I'm running behind on this cycle. Been swamped at work.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu

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

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

On Friday 18 June 2004 09:21, Robert Treat wrote:[color=blue]
> I notice we have yet to get a directory for 7.4.3 under /binary,
> are you planning on putting them up on the ftp server as well?[/color]
[color=blue]
> Along those lines is anyone planning on doing a redhat 7.3 build ?[/color]

I'm running behind on this cycle. Been swamped at work.
--
Lamar Owen
Director of Information Technology
Pisgah Astronomical Research Institute
1 PARI Drive
Rosman, NC 28772
(828)862-5554
www.pari.edu

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

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