== PostgreSQL Weekly News - May 11 2008 == == PostgreSQL Product News ==
DBD::Pg 2.7.1 released. http://search.cpan.org/dist/DBD-Pg/ OpenX 2.5.67-beta released, now with PostgreSQL support. http://www.openx.org/beta pgsnap 0.3.1 released. http://pgsnap.projects.postgresql.org/ pg_top 3.6.2 released. http://ptop.projects.postgresql.org/ psqlODBC 08.03.0200 released. http://psqlodbc.projects.postgresql.org/release.html PostgreSQL Data Wizard 8.4 released. http://www.sqlmaestro.com/products/postgresql/datawizard/ == PostgreSQL Jobs for May == http://archives.postgresql.org/pgsql-jobs/2008-05/threads.php == PostgreSQL Local == BWPUG will be holding their first ever meeting Wednesday, May 14th, at OmniTI world headquarters in Columbia, MD. http://pugs.postgresql.org/bwpug PGCon 2008 will be May 20-23 in Ottawa. http://www.pgcon.org/2008/ The Greek PUG will be putting up a booth at the third Greek FLOSS conference on May 27-28 at NTUA, Athens. http://www.postgresql.gr LAPUG will be meeting May 30, 2008 at Cal Poly Non-trivial updateable views, from Keith Larson http://pugs.postgresql.org/node/390 PGDay will be in Portland the day before OSCON. http://pugs.postgresql.org/taxonomy/term/53 Utah Open Source Conference 2008's CfP is open through June 1. This 2nd annual conference is August 28-30, 2008 in Salt Lake City, UT http://2008.utosc.com/ == PostgreSQL in the News == Planet PostgreSQL: http://www.planetpostgresql.org/ General Bits, Archives and occasional new articles: http://www.varlena.com/GeneralBits/ PostgreSQL Weekly News is brought to you this week by David Fetter Submit news and announcements by Sunday at 3:00pm Pacific time. Please send English language ones to [EMAIL PROTECTED], German language to [EMAIL PROTECTED], Italian language to [EMAIL PROTECTED] == Applied Patches == Bruce Momjian committed: - Mark TODO as done: "Improve display of enums to show valid enum values." - Mark TODO as done: "Add function to report the time of the most recent server reload." - Update libpqxx URL in README. - Point to our download URL, rather than listing interface in the README file: - In pgsql/src/bin/psql/variables.c, have boolean pset values checked against typical boolean values, rather than only 'off'. - In TODO, add item, make text search section: "Consider changing error to warning for strings larger than one megabyte." - Update TODO to read: "Allow dictionaries to change the token that is passed on to later dictionaries." - Add URL for TODO: "Consider increasing the number of default statistics target, and reduce statistics target overhead." - Fixed TODO typo. - In pgsql/doc/src/sgml/postgres.sgml, move Client Authentication right after Server Configuration in docs. Scott Marlowe - In pgsql/doc/src/sgml/ref/psql-ref.sgml, remove OID/foreign key mention in psql variable interpolation docs. - Add to TODO: "Add database and transaction-level triggers." - Add to TODO: "Add CREATE SCHEMA ... LIKE that copies a schema." - Update TODO wording to read: "Improve detection of shared memory segments being used by others by checking the SysV shared memory field 'nattch'" - Have psql output tab as the proper number of spaces, rather than \x09. - In pgsql/src/backend/utils/adt/numeric.c, have numeric 0 ^ 4.3 return 1, rather than an error, and have 0 ^ 0.0 return 1, rather than error. This was already the float8 behavior. - Add psql '\pset format wrapped' mode to wrap output to screen width, or file/pipe output too if \pset columns' is set. Bryce Nesbitt - Add regression test for various power expressions with a zero base, and adjust source code to be more modular. - Add to TODO: "Improve the /contrib installation experience." - Update C comments to mention SQL:2003 handling of power return values. - Adjust power() error messages to be more descriptive. - Mark TODO as done: "Prevent parent tables from altering or dropping constraints. Prevent child tables from altering or dropping constraints." - Add to TODO: "Clear table counters on TRUNCATE." - Update alternative output regression files for new float8 test of power(). - Add URL for TODO: "Add column to pg_stat_activity that shows the progress of long-running commands like CREATE INDEX and VACUUM." - Add to TODO: "Allow an existing index to be marked as a table's primary key." - Add URL for TODO: "Allow an existing index to be marked as a table's primary key." Magnus Hagander committed: - In pgsql/src/interfaces/libpq/win32.mak, add more dependencies from libpgport required by standalone msvc build of libpq. Hiroshi Saito. - Make the pg_stat_activity view call a SRF (pg_stat_get_activity()) instead of calling a bunch of individual functions. This function can also be called directly, taking a PID as an argument, to return only the data for a single PID. - Make the new pg_stat_get_activity use OUT parameters, so you don't have to specify the column names and types. Also simplifies the view. Per comments from Tom Lane. Tom Lane committed: - In pgsql/src/include/utils/syscache.h, convert the list of syscache names from a series of #define's into an enum, to avoid the pain of manually renumbering them anytime we insert another name in alphabetical order. An excellent idea from Alex Hunsaker and NikhilS' inherited-constraints patch --- whether or not the rest of that gets in, this should. Dunno why we never thought of it before. - In pgsql/src/backend/utils/cache/syscache.c, the CONSTROID syscache should show conrelid as a relation OID column. Not clear that there's any observable bug at present from this omission, but it seems like something to fix going forward. - Fix rules regression test for recent pg_stat_activity change. - Fix contrib/xml2 makefile to not override CFLAGS, and in passing make it auto-configure properly for libxslt present or not. - Fix memory stomp that's turning the whole buildfarm pink: you can't hack up pg_wcsformat without changing pg_wcssize to match. Add some comments to try to make that clearer, and make a couple other minor editorializations. - Fix bogus expected output that should have made it quite clear that something was wrong with that tab patch. - In pgsql/contrib/pgbench/pgbench.c, give a warning if -s switch is used with a non-custom pgbench test. Also, clean up the code that assigned the scale into :scale variables. Greg Smith and Tom Lane - Fix an ancient oversight in change_varattnos_of_a_node: it neglected to update varoattno along with varattno. This resulted in having Vars that were not seen as equal(), causing inheritance of the "same" constraint from different parent relations to fail. An example is: create table pp1 (f1 int check (f1>0)); create table cc1 (f2 text, f3 int) inherits (pp1); create table cc2(f4 float) inherits(pp1,cc1); Backpatch as far as 7.4. (The test case still fails in 7.4, for reasons that I don't feel like investigating at the moment.) This is a backpatch commit only. The fix will be applied in HEAD as part of the upcoming pg_constraint patch. - Change the rules for inherited CHECK constraints to be essentially the same as those for inherited columns; that is, it's no longer allowed for a child table to not have a check constraint matching one that exists on a parent. This satisfies the principle of least surprise (rows selected from the parent will always appear to meet its check constraints) and eliminates some longstanding bogosity in pg_dump, which formerly had to guess about whether check constraints were really inherited or not. The implementation involves adding conislocal and coninhcount columns to pg_constraint (paralleling attislocal and attinhcount in pg_attribute) and refactoring various ALTER TABLE actions to be more like those for columns. Alex Hunsaker, Nikhil Sontakke, Tom Lane - In pgsql/src/bin/psql/print.c, restore psql's former behavior that padding spaces to the right of the last output column are not emitted. (That change already caused more noise in the regression test output files than I would like.) Provide some needed editorial help for comments, clean up code formatting. Alvaro Herrera committed: - In pgsql/doc/src/sgml/pgstandby.sgml, add Simon Riggs' email address. Heikki Linnakangas committed: - Fix incorrect archive truncation point calculation in the %r recovery_command parameter. This fixes bug 4137 reported by Wojciech Strzalka, where a WAL file is deleted too early when starting the recovery of a warm standby server. Also add a sanity check in pg_standby so that it will refuse to delete anything earlier than the file being restored, and improve the debug message in case nothing is deleted. Simon Riggs. Backpatch to 8.3, which is where %r was introduced. - In pgsql/src/backend/access/transam/xlog.c, fix Assert introduced in previous patch. Peter Eisentraut committed: - Add "%option noinput" to the scanners to avoid compiler warnings. GCC 4.3 began to realize that the input() function isn't used and printed warnings. Andrew Dunstan committed: - In pgsql/src/tools/msvc/Mkvcbuild.pm, improve logic for finding object files on OBJS lines in contrib Makefiles. If this unbreaks buildfarm mastodon, apply everywhere. - In pgsql/src/tools/msvc/Mkvcbuild.pm, remaining pieces of fix for contrib makefiles. - In pgsql/src/tools/msvc/Mkvcbuild.pm, backpatch fixes for contrib makefiles. == Rejected Patches (for now) == No one was disappointed this week :) == Pending Patches == Pavel Stehule sent in another revision of his patch to add CASE to PL/PgSQL. Alex Hunsaker sent in two more revisions of his patch for fixing the problems with identifying constraints which should be inherited. Heikki Linnakangas sent in another revision of his WIP Map Forks patch. Simon Riggs sent in a patch which adds --schema-pre-load and --schema-post-load options both to pg_dump and pg_restore. Magnus Hagander sent in a patch which adds some error checking to the thread locking parts in libpq. Bruce Momjian sent in two revisions of a patch to do something more sane with tabs in psql output. Pavel Stehule sent in another revision of his patch to add options to PL/PgSQL's RAISE statement. Brendan Jurd sent in another revision of his printTable API. Bernd Helmle sent in another revision (via git) of his updateable views patch. Peter Eisentraut sent in a patch to fix flex warnings from GCC 4.3. Jan Urbanski sent in a patch as infrastructure for his Summer of Code project which changes the assumption that update_attstats() constructs an array whose elements are of the same type as the corresponding attribute. Alvaro Herrera sent in another revision of his snapshot management patch. Hans-Juergen Schoenig sent in a patch intended to fix a performance issue in concurrent scans. David Gould sent in a patch to add a lock timeout option to pg_dump. ---------------------------(end of broadcast)--------------------------- -To unsubscribe from this list, send an email to: [EMAIL PROTECTED]
