473,289 Members | 2,106 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

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:

* 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: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

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

http://archives.postgresql.org

Nov 23 '05 #1
18 1552
Anyone else having trouble expanding the archives? I tried the tar.gz and
the tar.bz2, both gave errors on decompression.

From: "Marc G. Fournier" <sc*****@postgresql.org>
Date: Tue, 15 Jun 2004 12:36:47 -0300 (ADT)
To: <pg************@postgresql.org>
Cc: <pg***********@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:


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

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

Nov 23 '05 #2
Anyone else having trouble expanding the archives? I tried the tar.gz and
the tar.bz2, both gave errors on decompression.

From: "Marc G. Fournier" <sc*****@postgresql.org>
Date: Tue, 15 Jun 2004 12:36:47 -0300 (ADT)
To: <pg************@postgresql.org>
Cc: <pg***********@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:


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

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

Nov 23 '05 #3
On Tue, 2004-06-15 at 16:36, Marc G. Fournier wrote:
After several fixes were backpatches to the 7_4_STABLE branch, we have now
released a 7.4.3.


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 ol**@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

Nov 23 '05 #4
On Tue, 2004-06-15 at 16:36, Marc G. Fournier wrote:
After several fixes were backpatches to the 7_4_STABLE branch, we have now
released a 7.4.3.


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 ol**@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

Nov 23 '05 #5
Oliver Elphick <ol**@lfix.co.uk> writes:
A Debian package of this new release has been uploaded to the Debian
archive and should be available from Debian mirrors by tomorrow.


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

Nov 23 '05 #6
Oliver Elphick <ol**@lfix.co.uk> writes:
A Debian package of this new release has been uploaded to the Debian
archive and should be available from Debian mirrors by tomorrow.


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

Nov 23 '05 #7
Hunter Hillegas <li***@lastonepicked.com> writes:
Anyone else having trouble expanding the archives? I tried the tar.gz and
the tar.bz2, both gave errors on decompression.


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 ma*******@postgresql.org

Nov 23 '05 #8
Hunter Hillegas <li***@lastonepicked.com> writes:
Anyone else having trouble expanding the archives? I tried the tar.gz and
the tar.bz2, both gave errors on decompression.


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 ma*******@postgresql.org

Nov 23 '05 #9
On Tue, 2004-06-15 at 14:44, Tom Lane wrote:
Oliver Elphick <ol**@lfix.co.uk> writes:
A Debian package of this new release has been uploaded to the Debian
archive and should be available from Debian mirrors by tomorrow.


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


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

Nov 23 '05 #10
On Tue, 2004-06-15 at 14:44, Tom Lane wrote:
Oliver Elphick <ol**@lfix.co.uk> writes:
A Debian package of this new release has been uploaded to the Debian
archive and should be available from Debian mirrors by tomorrow.


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


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

Nov 23 '05 #11
"Scott Marlowe" <sm******@qwest.net> writes:
On Tue, 2004-06-15 at 14:44, Tom Lane wrote:
I will push out a Fedora Core package within the next few days as well.
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?


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

Nov 23 '05 #12
"Scott Marlowe" <sm******@qwest.net> writes:
On Tue, 2004-06-15 at 14:44, Tom Lane wrote:
I will push out a Fedora Core package within the next few days as well.
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?


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

Nov 23 '05 #13
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,

On Tue, 15 Jun 2004, Tom Lane wrote:
I will push out a Fedora Core package within the next few days as well.


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

Nov 23 '05 #14
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,

On Tue, 15 Jun 2004, Tom Lane wrote:
I will push out a Fedora Core package within the next few days as well.


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

Nov 23 '05 #15
On Tue, 2004-06-15 at 21:54, Tom Lane wrote:
"Scott Marlowe" <sm******@qwest.net> writes:
On Tue, 2004-06-15 at 14:44, Tom Lane wrote:
I will push out a Fedora Core package within the next few days as well.

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?


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


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

Nov 23 '05 #16
On Tue, 2004-06-15 at 21:54, Tom Lane wrote:
"Scott Marlowe" <sm******@qwest.net> writes:
On Tue, 2004-06-15 at 14:44, Tom Lane wrote:
I will push out a Fedora Core package within the next few days as well.

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?


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


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

Nov 23 '05 #17
On Friday 18 June 2004 09:21, Robert Treat wrote:
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 ?


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

Nov 23 '05 #18
On Friday 18 June 2004 09:21, Robert Treat wrote:
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 ?


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

Nov 23 '05 #19

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

22
by: Marc G. Fournier | last post by:
After almost 12 months of intense development, and testing, we are proud to announce the availability of PostgreSQL v7.4. An overview of the major changes in v7.4 include: IN/NOT IN subqueries...
7
by: Peter Eisentraut | last post by:
SuSE RPMs for PostgreSQL 7.4 are available at ftp://ftp.postgresql.org/pub/binary/v7.4/suse or a mirror http://www.postgresql.org/mirrors-www.html or at
1
by: Marc G. Fournier | last post by:
After several fixes were backpatches to the 7_3_STABLE branch, we have now released a 7.3.5. As the list of Changes since 7.3.4 is quite small, they are included in this email: * Force...
2
by: Josué Maldonado | last post by:
Hello list, Does anyone know about or use a good postgresql reporting tool. I appreciate any help or comment about it. -- Josué Maldonado
3
by: Rod Early | last post by:
I have the task of converting a SQL Server 2000 database to PostgreSQL. The data itself does not need to be converted, but the structure and stored procedures must be. I expect that converting...
8
by: Marc G. Fournier | last post by:
After almost 9 months of development, the PostgreSQL Global Development Group is proud to announce that development on PostgreSQL 8.0.0 has now finished, and is ready for some serious testing. ...
0
by: Marc G. Fournier | last post by:
After 4 weeks of work, involving alot of bug fixes, and documentation improvements, to the source tree, we have just released our 4th Beta of 8.0.0. Most of the items on Bruce's Open Items list...
1
by: Devrim GUNDUZ | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - --------------------------------------------------------------------- PostgreSQL RPM Set Update 2004-10-26 Version(s): 7.3.8, 7.4.6
0
by: Marc G. Fournier | last post by:
Its been almost 4 weeks since Beta4, and alot of work, involving alot of bug fixes, and documentation improvements, to the source tree, we have just released our 5th Beta of 8.0.0. All of our...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.