aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Update shared_buffer comment in postgresql.conf.Bruce Momjian2003-01-15
|
* Back out ORDER BY addition to Inet, for Tom.Bruce Momjian2003-01-15
|
* Allow merge and hash joins to occur on arbitrary expressions (anything notTom Lane2003-01-15
| | | | | | | | | | | | | | | | containing a volatile function), rather than only on 'Var = Var' clauses as before. This makes it practical to do flatten_join_alias_vars at the start of planning, which in turn eliminates a bunch of klugery inside the planner to deal with alias vars. As a free side effect, we now detect implied equality of non-Var expressions; for example in SELECT ... WHERE a.x = b.y and b.y = 42 we will deduce a.x = 42 and use that as a restriction qual on a. Also, we can remove the restriction introduced 12/5/02 to prevent pullup of subqueries whose targetlists contain sublinks. Still TODO: make statistical estimation routines in selfuncs.c and costsize.c smarter about expressions that are more complex than plain Vars. The need for this is considerably greater now that we have to be able to estimate the suitability of merge and hash join techniques on such expressions.
* Reorder VARCHAR() to appear before CHAR() in docs.Bruce Momjian2003-01-15
|
* This patch fixes an incorrect statement and makes a few cleanups toBruce Momjian2003-01-15
| | | | | | | | contrib/fulltextindex/README.fti Backpatched to 7.3.X too. Neil Conway
* This patch includes some minor fixes and improvements to the SGML docsBruce Momjian2003-01-15
| | | | | | for PL/PgSQL. Neil Conway
* Add ORDER BY for inet regression, pointed out by Rod Taylor.Bruce Momjian2003-01-15
|
* Add sql_features table to information schema. Generate the features listPeter Eisentraut2003-01-14
| | | | in the documentation from that same data.
* Readd #include netinet/in.h for FreeBSD.Bruce Momjian2003-01-14
|
* Escape ampersand.Peter Eisentraut2003-01-14
|
* Bumped up build number to 200Barry Lind2003-01-14
|
* Patch from Florian Wunderlich to correctly support java Timestamps. PreviouslyBarry Lind2003-01-14
| | | | | | | | | | | the code would only capture milliseconds where as both postgres and the java Timestamp object support greater resolution. Also fixed a bug reported by Rhett Sutphin where the last digit of the fractional seconds was lost when using timestamp without time zone Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java jdbc/org/postgresql/test/jdbc2/TimestampTest.java
* Patch from Aaron Mulder to have pooled connections implement PGConnectionBarry Lind2003-01-14
| | | | | | Modified Files: jdbc/org/postgresql/jdbc2/optional/PooledConnectionImpl.java jdbc/org/postgresql/test/jdbc2/optional/BaseDataSourceTest.java
* Patch from Kris Jurka to improve the performance of getImportedKeys().Barry Lind2003-01-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Use explicit joins to avoid using the genetic query optimizer. Also fixed a regression test that was failing to compile. This change also cleans up how key names are reported as per: A change to the value of the FK_NAME column. Currently the returned value is the triggers arguments which look like "<unnamed>\000t2\000t1\000UNSPECIFIED\000a\000a\000" This was required for server versions < 7.3 when a user did not supply constraint names. Every constraint was named "<unnamed>" . 7.3 has enforced unique constraint names per table so unnamed foreign keys will have different names "$1", "$2" and so on. I've used logic along the lines of the following to preserve the unique names in the original scheme, but allow people who go to the trouble of naming their constraints to see them: if (triggerargs.startsWith("<unnamed>")) { fkname = [the whole ugly trigger args name originally used]; } else { fkname = [the actual fk name]; } Modified Files: jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java jdbc/org/postgresql/test/jdbc2/optional/ConnectionPoolTest.java
* Add:Bruce Momjian2003-01-14
| | | | > o Allow PL/PgSQL to support array element assignment
* Add Hugarian FAQ, from Laszlo HornyakBruce Momjian2003-01-13
|
* Fix information_schema.sql install to work when building outsideTom Lane2003-01-13
| | | | source tree.
* Reconsider mechanism for marking sub-selects that are at top level ofTom Lane2003-01-13
| | | | | | a qualification clause (and hence can get away with being sloppy about distinguishing FALSE from UNKNOWN). We need to know this in subselect.c; marking the subplans in setrefs.c is too late.
* Change Adjust_lo_type() so that it doesn't cause an errorHiroshi Inoue2003-01-13
| | | | even when cast functions are allowed to be volatile.
* Fixes to pgcvslog for last narrive entry.Bruce Momjian2003-01-13
|
* Cause planner to account for evaluation costs in targetlists andTom Lane2003-01-13
| | | | | | | | HAVING quals. Normally this is an insignificant effect --- but it will not be insignificant when these clauses contain sub-selects. The added costs cannot affect the planning of the query containing them, but they might have an impact when the query is a sub-query of a larger one.
* Recent changes in sublink representation require exprType() to acceptTom Lane2003-01-13
| | | | SubPlan nodes, else explaining queries containing sublinks may fail.
* Revise cost_qual_eval() to compute both startup (one-time) and per-tupleTom Lane2003-01-12
| | | | | | costs for expression evaluation, not only per-tuple cost as before. This extension is needed in order to deal realistically with hashed or materialized sub-selects.
* Fix wrong/misleading comments, be more consistent about where to callTom Lane2003-01-12
| | | | ExecAssignResultTypeFromTL().
* Fix some minor grammatical errors.Tom Lane2003-01-12
|
* Update CHAR().Bruce Momjian2003-01-12
|
* Replace RelidGetNamespaceId() by get_rel_namespace().Peter Eisentraut2003-01-12
|
* Update CHAR() description.Bruce Momjian2003-01-12
|
* Update date only.Bruce Momjian2003-01-12
|
* Improve CHAR() description.Bruce Momjian2003-01-12
|
* First cut at implementing IN (and NOT IN) via hashtables. There isTom Lane2003-01-12
| | | | more to be done yet, but this is a good start.
* SGML build cleanups from Neil Conway.Bruce Momjian2003-01-12
|
* Fix capitalization.Bruce Momjian2003-01-11
|
* Back out flockfile change for NetBSD. Giles Lean reports they are notBruce Momjian2003-01-11
| | | | supported.
* Cause symlinks for shared-library versioning to run in the standardTom Lane2003-01-11
| | | | | | direction on HP-UX; our former approach has been obsolete since HPUX 9. Giles Lean
* Fix markup problem in link to other SGML file.Bruce Momjian2003-01-11
|
* Fix typo in an error messageTatsuo Ishii2003-01-11
|
* > > This patch improves the documentation for the shared_buffers GUC param.Bruce Momjian2003-01-11
| | | | | | | | > > I'd suggest that the runtime.sgml description explicitly say "values of > at least a few thousand are recommended for production installations". Neil Conway
* Rewrite for-loop, because this is not the Obfuscated C Code Contest.Bruce Momjian2003-01-11
| | | | Manfred Koizar
* A tiny patch to fix a typo in configure.in and another one inBruce Momjian2003-01-11
| | | | | | RELEASE_CHANGES. Manfred Koizar
* Add doc links from SET to SET_CONSTRAINTS, SET_SESSION_AUTH,Bruce Momjian2003-01-11
| | | | SET_TRANSACTION.
* Fix markup.Peter Eisentraut2003-01-11
|
* Create a new file executor/execGrouping.c to centralize utility routinesTom Lane2003-01-10
| | | | shared by nodeGroup, nodeAgg, and soon nodeSubplan.
* Add missing <limits.h> for INT64_IS_BUSTED case.Tom Lane2003-01-10
|
* Read-only transactions, as defined in SQL.Peter Eisentraut2003-01-10
|
* Do not shell-quote the name of the editor, so that the editor can be aPeter Eisentraut2003-01-10
| | | | command with arguments.
* Further tweaking of parsetree & plantree representation of SubLinks.Tom Lane2003-01-10
| | | | | | | Simplify SubLink by storing just a List of operator OIDs, instead of a list of incomplete OpExprs --- that was a bizarre and bulky choice, with no redeeming social value since we have to build new OpExprs anyway when forming the plan tree.
* Add optional drop behavior clause to REVOKE command, for SQL conformance.Peter Eisentraut2003-01-10
| | | | Currently, only RESTRICT is allowed.
* Clean ip.c.Peter Eisentraut2003-01-10
|
* Adjust parser so that 'x NOT IN (subselect)' is converted toTom Lane2003-01-09
| | | | | | | | | | | 'NOT (x IN (subselect))', that is 'NOT (x = ANY (subselect))', rather than 'x <> ALL (subselect)' as we formerly did. This opens the door to optimizing NOT IN the same way as IN, whereas there's no hope of optimizing the expression using <>. Also, convert 'x <> ALL (subselect)' to the NOT(IN) style, so that the optimization will be available when processing rules dumped by older Postgres versions. initdb forced due to small change in SubLink node representation.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 18:52:00 +0000