summaryrefslogtreecommitdiff
path: root/src
AgeCommit message (Collapse)Author
2003-12-18Be a little smarter in group_clauses_by_indexkey_for_join: detect casesTom Lane
where a joinclause is redundant with a restriction clause. Original coding believed this was impossible and didn't need to be checked for, but that was a thinko ...
2003-12-17information_schema.constraint_column_usage and key_column_usage shouldTom Lane
not discriminate against system columns, since we support constraints on system columns, and in fact constraints on OID are moderately useful.
2003-12-17Fix DecodeInterval to handle '-0.1' sanely, per gripe from Tilo Schwarz.Tom Lane
2003-12-17Reorder tests in parse_coerce so that ANY/ANYELEMENT/ANYARRAY coercionTom Lane
does not affect UNKNOWN-type literals or Params. This fixes the recent complaint about count('x') being broken, and improves consistency in a few other respects too.
2003-12-17Remove pg_id.Peter Eisentraut
2003-12-17Repair planner failure when there are multiple IN clauses, each withTom Lane
a join in its subselect. In this situation we *must* build a bushy plan because there are no valid left-sided or right-sided join trees. Accordingly, hoary sanity check needs an update. Per report from Alessandro Depase.
2003-12-17revoked patch from Kris Jurka to fix multiarguments, and changed test to createDave Cramer
a temp table
2003-12-17patch from Kris Jurka to fix large object 7.1 compatible protocol issuesDave Cramer
modified test case from Alexey Yudichev to be part of the testsuite
2003-12-17- Added just another patch by Dave that fixes a reversed order inMichael Meskes
variable listing for output variables in cursor definitions - Fixed incorrect if call in long=>numeric conversion.
2003-12-17added polish translation submitted by Piotr MajDave Cramer
2003-12-16Fix constraint_column_usage for foreign keys.Peter Eisentraut
2003-12-15Add mention with might need to use cp -R someday for portability.Bruce Momjian
2003-12-14I posted some bufmgr cleanup a few weeks ago, but it conflicted withNeil Conway
some concurrent changes Jan was making to the bufmgr. Here's an updated version of the patch -- it should apply cleanly to CVS HEAD and passes the regression tests. This patch makes the following changes: - remove the UnlockAndReleaseBuffer() and UnlockAndWriteBuffer() macros, and replace uses of them with calls to the appropriate functions. - remove a bunch of #ifdef BMTRACE code: it is ugly & broken (i.e. it doesn't compile) - make BufferReplace() return a bool, not an int - cleanup some logic in bufmgr.c; should be functionality equivalent to the previous code, just cleaner now - remove the BM_PRIVATE flag as it is unused - improve a few comments, etc.
2003-12-12This patch properly sets the prototype for the on_shmem_exit andPeter Eisentraut
on_proc_exit functions, and adjust all other related code to use the proper types too. by Kurt Roeckx
2003-12-12add missing SQLState by Patrick HigginsDave Cramer
2003-12-12cancel row updates sets values to null by Kris JurkaDave Cramer
2003-12-12patch to indicate why test cases failed from Oliver JowettDave Cramer
2003-12-12patch to fix returning he information schema as a system object by Kris JurkaDave Cramer
2003-12-12fix casting pooled connections to PGStatement problem patch by JariPDave Cramer
2003-12-12patch to build under jdk1.1 from Richard ScrantonDave Cramer
2003-12-12binary stream patch by Kris Jurka fixes empty stream failureDave Cramer
2003-12-12metadata encoding patch from Kris JurkaDave Cramer
2003-12-11New translationPeter Eisentraut
2003-12-11Fix thinko in comment.Tom Lane
2003-12-11build number set to 300 to avoid conflict with 7.4 buildsDave Cramer
threadsafe patch from Karl von Randow applied
2003-12-11patch to deal with unique foreign keys in 7.4 from Kris JurkaDave Cramer
2003-12-11tch to make sure PSQLState is Serializable and a test case to prove itDave Cramer
2003-12-11patch to make sure PSQLState is Serializable and a test case to prove itDave Cramer
2003-12-10incremented build to 211Dave Cramer
2003-12-09query_tree_mutator should copy RangeTblEntry nodes even when it's notTom Lane
planning to modify them itself. Otherwise we end up with shared RTE substructure, which breaks inheritance_planner because the rte->inh flag needs to be independent in each copied subquery. Per bug report from Chris Piker.
2003-12-08Whole-row references were broken for subqueries and functions, becauseTom Lane
attr_needed/attr_widths optimization failed to allow for Vars with attno zero in this case. Per report from Tatsuo Ishii.
2003-12-08Work around naming conflict between zlib and OpenSSL by tweaking inclusionTom Lane
order. Remove some unnecessary #includes (that duplicate c.h).
2003-12-07Remove test on c.relkind from check_constraints view; unnecessary andTom Lane
prevents view from showing constraints on domains. This addresses the other half of Claus Colloseus' bug report.
2003-12-07Fix typmod interpretation for bit types. (It was erroneously assumed thatPeter Eisentraut
for bit(x), the typmod stores x+4, like for the character types.)
2003-12-07One more pass at reducing the cost of pg_dump's new implementation:Tom Lane
reduce the number of times TopoSort() has to be executed by trying to extract multiple dependency loops from each pass, instead of only one. This saves about another factor of ten on the regression database. This could be considered as another exercise in grokking Fred Brooks' maxim: Representation *is* the essence of programming.
2003-12-07Repair indexed bytea like operations, and related selectivityJoe Conway
functionality. Per bug report by Alvar Freude: http://archives.postgresql.org/pgsql-bugs/2003-12/msg00022.php
2003-12-07Speed up findObjectByCatalogId() to get rid of the other salientTom Lane
bottleneck in the new pg_dump code.
2003-12-06Replace not-very-bright implementation of topological sort with a betterTom Lane
one (use a priority heap to keep track of items ready to output, instead of searching the input array each time). This brings the runtime of pg_dump back to about what it was in 7.4.
2003-12-06Massive overhaul of pg_dump: make use of dependency information fromTom Lane
pg_depend to determine a safe dump order. Defaults and check constraints can be emitted either as part of a table or domain definition, or separately if that's needed to break a dependency loop. Lots of old half-baked code for controlling dump order removed.
2003-12-05Guard against bug in Solaris' bsearch(), per Michael Wildpaner.Tom Lane
2003-12-03catversion change needed by previous read-onlu GUC variables commit.Joe Conway
2003-12-03Added new group of read-only GUC variables to allow simple accessJoe Conway
to certain compile-time options (FUNC_MAX_ARGS, INDEX_MAX_KEYS, NAMEDATALEN, BLCKSZ, HAVE_INT64_TIMESTAMP). Also added "category", "short_desc", and "extra_desc" to the pg_settings view. Per recent discussion here: http://archives.postgresql.org/pgsql-patches/2003-11/msg00363.php
2003-12-03Planner failed to be smart about binary-compatible expressions in pathkeysTom Lane
and hash bucket-size estimation. Issue has been there awhile but is more critical in 7.4 because it affects varchar columns. Per report from Greg Stark.
2003-12-03Added patch by Dave Cramer for array handling in ecpglib.Michael Meskes
2003-12-02Add a warning to AtEOXact_SPI() to catch cases where the currentJoe Conway
transaction has been committed without SPI_finish() being called first. Per recent discussion here: http://archives.postgresql.org/pgsql-patches/2003-11/msg00286.php
2003-12-02Fix some small errors.Peter Eisentraut
2003-12-02Code and docs review for numeric-factorial patch.Tom Lane
2003-12-01Fix initdb use of mkdir_p().Bruce Momjian
Andrew Dunstan
2003-12-01The attached patch enables contrib/cube to build cleanly under CygwinBruce Momjian
(again). Please consider this patch for the 7.4.1 branch (if there will be one) too. Jason Tishler
2003-12-01This patch refactors execTuples.c in two ways.Bruce Momjian
Neil Conway