Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 258978 - dev-db/postgresql{,-base,-docs,-server}-{7.4.25,8.{0.21,1.17,2.13,3.7}} version bump
Summary: dev-db/postgresql{,-base,-docs,-server}-{7.4.25,8.{0.21,1.17,2.13,3.7}} versi...
Status: RESOLVED FIXED
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: New packages (show other bugs)
Hardware: All Linux
: High enhancement (vote)
Assignee: PgSQL Bugs
URL: http://www.postgresql.org/docs/8.3/st...
Whiteboard:
Keywords:
: 262860 (view as bug list)
Depends on:
Blocks:
 
Reported: 2009-02-14 15:44 UTC by Andreas Prieß
Modified: 2009-10-22 20:14 UTC (History)
5 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas Prieß 2009-02-14 15:44:53 UTC
New minor version available with some fixes.
One fix prevents rows to be lost under certain conditons:

"Fix whole-index GiST scans to work correctly (Teodor)
This error could cause rows to be lost if a table is clustered on a GiST index."

Emerging the new version works with renamed ebuilds. The resulting postgresql works so far in my development environment.


Reproducible: Always

Steps to Reproduce:
Comment 1 Johan Bergström 2009-02-15 12:17:16 UTC
Works here too. please add to ~testing
Comment 2 Chris Ribble 2009-02-17 17:45:51 UTC
Please add to ~arch. :)

Comment 3 Jeff Kowalczyk 2009-02-18 14:24:21 UTC
I'm eager for this version bump too: ubuntu 8.10 intrepid is on postgresql-8.3.6 as of yesterday, and the pg_dump plaintext ordering of schema elements has changed, resulting in unwanted diff artifacts between 8.3.5 and 8.3.6.
Comment 4 Euler Taveira de Oliveira 2009-03-13 20:53:14 UTC
(In reply to comment #3)
> I'm eager for this version bump too: ubuntu 8.10 intrepid is on
> postgresql-8.3.6 as of yesterday, and the pg_dump plaintext ordering of schema
> elements has changed, resulting in unwanted diff artifacts between 8.3.5 and
> 8.3.6.
> 

This is due to a bug in the order of composite types. See [1] for details. Also, PostgreSQL doesn't guarantee pg_dump order.

[1] http://www.postgresql.org/docs/8.3/static/release-8-3-6.html
Comment 5 Johan Bergström 2009-03-17 14:17:49 UTC
8.3.7 is out any second now. Skip 8.3.6 entirely perhaps?
Comment 6 Holger Hoffstätte 2009-03-17 14:49:22 UTC
(In reply to comment #5)
> 8.3.7 is out any second now. Skip 8.3.6 entirely perhaps?

I bumped my ebuilds already and it just works, so yes. Maybe we can also kick off a stabilization request, as 8.4 is just around the corner. Current stable is the ancient pre-slotted 8.0 version :(
Comment 7 Lars Wendler (Polynomial-C) (RETIRED) gentoo-dev 2009-03-18 20:36:48 UTC
*** Bug 262860 has been marked as a duplicate of this bug. ***
Comment 8 Johan Bergström 2009-03-19 16:27:56 UTC
(In reply to comment #6)
> (In reply to comment #5)
> > 8.3.7 is out any second now. Skip 8.3.6 entirely perhaps?
> 
> I bumped my ebuilds already and it just works, so yes. Maybe we can also kick
> off a stabilization request, as 8.4 is just around the corner. Current stable
> is the ancient pre-slotted 8.0 version :(

I agree. The 8.3 branch is treated as stable on many larger companies and brought enough features to motivate a move from < 8.3. The only version one perhaps should avoid is 8.3.4 and its GIN index bug
Comment 9 Caleb Cushing 2009-03-19 20:04:19 UTC
bug 230817 is the stabilization request, and yes all the new versions are out so you might as well skip the ones you missed.
Comment 10 Caleb Cushing 2009-03-19 20:04:48 UTC
,-docs should be in the summary
Comment 11 Caleb Tennis (RETIRED) gentoo-dev 2009-04-09 22:50:39 UTC
8.3.7 is in portage.  Is anyone interested really in the other versions?
Comment 12 Johan Bergström 2009-04-22 14:58:37 UTC
(In reply to comment #11)
> 8.3.7 is in portage.  Is anyone interested really in the other versions?
> 

I'd advise against anything except the latest minor which basically is what postgresql recommends in their "upgrade guide" as well. I guess PostGreSQL 8.4 beta could be interesting to start testing out?
Comment 13 Patrick Lauer gentoo-dev 2009-10-22 20:14:06 UTC
Been there, done that. Didn't get a T-Shirt.