[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
PostgreSQL 8.1.13-0ubuntu0.6.06 from dapper-proposedupgrades , installs and works fine here. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
Thanks for testing! postgresql-8.1 copied to dapper-updates. ** Changed in: postgresql-8.1 (Ubuntu Dapper) Status: Fix Committed = Fix Released -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
The very same version of postgresql-8.2 was successfully verified in gutsy. I verified that the .debs did not get misbuilt. This should give sufficient confidence in the feisty update as well, thus I copied it to feisty-updates. ** Changed in: postgresql-8.2 (Ubuntu Feisty) Status: Fix Committed = Fix Released -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
No signs of any regression report on the upstream MLs or in Debian/Ubuntu bug trackers after 8 days. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
Anyone else using PostgreSQL who could give this a test? My own testing isn't sufficient for SRU verification. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
PostgreSQL 8.3 in hardy-proposed looks fine to me. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
PostgreSQL 8.2 in gutsy-proposed worked fine here. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
I copied hardy and gutsy to -updates, since they got peer-tested. Keeping dapper and feisty in -proposed until more testing feedback arrives. Thanks so far! ** Changed in: postgresql-8.3 (Ubuntu Hardy) Status: Fix Committed = Fix Released ** Changed in: postgresql-8.2 (Ubuntu Gutsy) Status: Fix Committed = Fix Released -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
I installed the real hardy-proposed .debs onto my dapper/feisty/gutsy/hardy test systems, and ran the extensive postgresql-common test suite ( 1000 integration tests). The upstream test suite is run during build and makes the build fail on regresssions, to that worked everywhere as well. I am monitoring the upstream bug lists. No signs of regressions so far. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
Changes for Hardy and Intrepid (8.3.1 - 8.3.3): http://www.postgresql.org/docs/8.3/static/release-8-3-2.html http://www.postgresql.org/docs/8.3/static/release-8-3-3.html Changes for Feisty and Gutsy (8.2.7 - 8.2.9): http://www.postgresql.org/docs/8.3/static/release-8-2-8.html http://www.postgresql.org/docs/8.3/static/release-8-2-9.html Changes for Dapper (8.1.11 - 8.1.13): http://www.postgresql.org/docs/8.3/static/release-8-1-12.html http://www.postgresql.org/docs/8.3/static/release-8-1-13.html -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
James, Stuart, any chance this version could be tested in the DC? It fixes a wealth of bugs. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
I need to upgrade staging.launchpad.net to PG 8.3 in preparation for the production migration next Tuesday, so I'm fine with testing it there if the packages can be installed on chokecherry. -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
8.1.13 accepted into dapper-proposed. Testing feedback appreciated! ** Tags added: verification-needed ** Changed in: postgresql-8.1 (Ubuntu Dapper) Status: In Progress = Fix Committed -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
8.2.9 accepted into gutsy-proposed. ** Changed in: postgresql-8.2 (Ubuntu Gutsy) Status: In Progress = Fix Committed -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
8.2.9 accepted into feisty-proposed. ** Changed in: postgresql-8.2 (Ubuntu Feisty) Status: In Progress = Fix Committed -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
postgresql-8.3 (8.3.3-1) unstable; urgency=low
* New upstream bugfix release (note that 8.3.2 was never officially released
due to the discovery of another major bug):
- Make pg_get_ruledef() parenthesize negative constants.
Before this fix, a negative constant in a view or rule might be
dumped as, say, -42::integer, which is subtly incorrect: it should
be (-42)::integer due to operator precedence rules. Usually this
would make little difference, but it could interact with another
recent patch to cause PostgreSQL to reject what had been a valid
SELECT DISTINCT view query. Since this could result in pg_dump
output failing to reload, it is being treated as a high-priority
fix. The only released versions in which dump output is actually
incorrect are 8.3.1 and 8.2.7.
- Make ALTER AGGREGATE ... OWNER TO update pg_shdepend.
This oversight could lead to problems if the aggregate was later
involved in a DROP OWNED or REASSIGN OWNED operation.
- Fix incorrect archive truncation point calculation for the %r macro
in recovery_command parameters. This could lead to data loss if a
warm-standby script relied on %r to decide when to throw away WAL
segment files.
- Fix ALTER TABLE ADD COLUMN ... PRIMARY KEY so that the new column
is correctly checked to see if it's been initialized to all
non-nulls.
- Fix REASSIGN OWNED so that it works on procedural languages too.
- Fix problems with SELECT FOR UPDATE/SHARE occurring as a subquery
in a query with a non-SELECT top-level operation.
- Fix possible CREATE TABLE failure when inheriting the same
constraint from multiple parent relations that inherited that
constraint from a common ancestor.
- Fix pg_get_ruledef() to show the alias, if any, attached to the
target table of an UPDATE or DELETE.
- Restore the pre-8.3 behavior that an out-of-range block number in a
TID being used in a TidScan plan results in silently not matching
any rows. 8.3.0 and 8.3.1 threw an error instead.
- Fix GIN bug that could result in a too many LWLocks taken failure.
- Fix broken GiST comparison function for tsquery.
- Fix tsvector_update_trigger() and ts_stat() to accept domains over
the types they expect to work with.
- Fix failure to support enum data types as foreign keys.
- Avoid possible crash when decompressing corrupted data.
- Fix race conditions between delayed unlinks and DROP DATABASE.
In the worst case this could result in deleting a newly created
table in a new database that happened to get the same OID as the
recently-dropped one; but of course that is an extremely
low-probability scenario.
- Repair two places where SIGTERM exit of a backend could leave
corrupted state in shared memory.
- Fix possible crash due to incorrect plan generated for an x IN
(SELECT y FROM ...) clause when x and y have different data
types; and make sure the behavior is semantically correct when the
conversion from y's type to x's type is lossy.
- Fix oversight that prevented the planner from substituting known
Param values as if they were constants.
- Fix planner failure when an indexable MIN or MAX aggregate is used
with DISTINCT or ORDER BY.
- Fix planner to ensure it never uses a physical tlist for a plan
node that is feeding a Sort node.
- Avoid unnecessary copying of query strings.
- Make TransactionIdIsCurrentTransactionId() use binary search
instead of linear search when checking child-transaction XIDs.
This fixes some cases in which 8.3.0 was significantly slower than
earlier releases.
- Fix conversions between ISO-8859-5 and other encodings to handle
Cyrillic Yo characters (e and E with two dots).
- Fix several datatype input functions, notably array_in(), that were
allowing unused bytes in their results to contain uninitialized,
unpredictable values. This could lead to failures in which two
apparently identical literal values were not seen as equal, resulting in
the parser complaining about unmatched ORDER BY and DISTINCT
expressions.
- Fix a corner case in regular-expression substring matching
(substring(string from pattern)).
The problem occurs when there is a match to the pattern overall but
the user has specified a parenthesized subexpression and that
subexpression hasn't got a match. An example is substring('foo'
from 'foo(bar)?'). This should return NULL, since (bar) isn't
matched, but it was mistakenly returning the whole-pattern match
instead (ie, foo).
- Prevent cancellation of an auto-vacuum that was launched to prevent
XID wraparound.
- Improve ANALYZE's handling of in-doubt tuples (those inserted or
deleted by a not-yet-committed transaction) so that the counts it
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
8.3.3 accepted into hardy-proposed. ** Changed in: postgresql-8.3 (Ubuntu Hardy) Status: In Progress = Fix Committed -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
8.2 needs to be updated in gutsy and feisty. ** Changed in: postgresql-8.2 (Ubuntu) Status: New = Invalid ** Also affects: postgresql-8.3 (Ubuntu) Importance: Undecided Status: New ** Also affects: postgresql-8.1 (Ubuntu) Importance: Undecided Status: New -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
postgresql-8.1 is dapper only. ** Changed in: postgresql-8.1 (Ubuntu Feisty) Status: New = Invalid ** Changed in: postgresql-8.1 (Ubuntu Gutsy) Status: New = Invalid ** Changed in: postgresql-8.1 (Ubuntu Hardy) Status: New = Invalid -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
8.3 is for hardy and intrepid. ** Changed in: postgresql-8.3 (Ubuntu Dapper) Status: New = Invalid ** Changed in: postgresql-8.1 (Ubuntu Intrepid) Status: New = Invalid ** Changed in: postgresql-8.3 (Ubuntu Feisty) Status: New = Invalid ** Changed in: postgresql-8.2 (Ubuntu Dapper) Status: New = Invalid ** Changed in: postgresql-8.3 (Ubuntu Gutsy) Status: New = Invalid ** Changed in: postgresql-8.2 (Ubuntu Hardy) Status: New = Won't Fix ** Changed in: postgresql-8.3 (Ubuntu Intrepid) Importance: Undecided = High Assignee: (unassigned) = Martin Pitt (pitti) Status: New = In Progress -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
gutsy/8.2 prepared. ** Changed in: postgresql-8.2 (Ubuntu Gutsy) Assignee: (unassigned) = Martin Pitt (pitti) Status: New = In Progress -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
hardy/8.3 prepared. Intrepid will be auto-synced from Debian. ** Changed in: postgresql-8.3 (Ubuntu Hardy) Status: New = Fix Committed -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
Feisty/8.2 prepared. ** Changed in: postgresql-8.2 (Ubuntu Feisty) Status: New = Fix Committed ** Changed in: postgresql-8.2 (Ubuntu Feisty) Importance: Undecided = High Assignee: (unassigned) = Martin Pitt (pitti) ** Changed in: postgresql-8.2 (Ubuntu Feisty) Status: Fix Committed = In Progress -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
** Changed in: postgresql-8.3 (Ubuntu Hardy) Importance: Undecided = High Assignee: (unassigned) = Martin Pitt (pitti) Status: Fix Committed = In Progress -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238587] Re: PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13
dapper/8.1 update prepared. ** Changed in: postgresql-8.1 (Ubuntu Dapper) Importance: Undecided = High Assignee: (unassigned) = Martin Pitt (pitti) Status: New = In Progress -- PostgreSQL bug fix releases 8.3.3/8.2.9/8.1.13 https://bugs.launchpad.net/bugs/238587 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
