aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* More op_class cleanup.Bruce Momjian1998-08-11
|
* Remove NOBTREE defines, and make findoidlinks handle regproc.Bruce Momjian1998-08-11
|
* cleanup.Bruce Momjian1998-08-11
|
* Add new \w write command to psql.Bruce Momjian1998-08-10
|
* Update flowchart.Bruce Momjian1998-08-10
|
* Update flowchart.Bruce Momjian1998-08-10
|
* Cleanups of optimizer.Bruce Momjian1998-08-10
|
* Cleanup optimizer function names and clarify code.Bruce Momjian1998-08-10
|
* Update pgindent.Bruce Momjian1998-08-09
|
* New pgindent.Bruce Momjian1998-08-09
|
* cleanups.Bruce Momjian1998-08-09
|
* The attached patch implements some changes that were discussed aBruce Momjian1998-08-09
| | | | | | | | | | | | | | | | | | | | | | | | | couple weeks ago on the hackers and interfaces lists: 1. When the backend sends a NOTICE message and closes the connection (typically, because it was told to by the postmaster after another backend coredumped), libpq will now print the notice and close the connection cleanly. Formerly, the frontend app would usually terminate ungracefully due to a SIGPIPE. (I am not sure if 6.3.2 behaved that way, but the current cvs sources do...) 2. libpq's various printouts to stderr are now fed through a single "notice processor" routine, which can be overridden by the application to direct notices someplace else. This should ease porting libpq to Windows. I also noticed and fixed a problem in PQprint: when sending output to a pager subprocess, it would disable SIGPIPE in case the pager terminates early (this is good) --- but afterwards it reset SIGPIPE to SIG_DFL, rather than restoring the application's prior setting (bad). regards, tom lane
* OPTIMIZER_DEBUG additions.Bruce Momjian1998-08-07
|
* Make large objects their own relkind type. Fix dups in pg_class_mbBruce Momjian1998-08-06
| | | | files. Fix sequence creation hack for relkind type.
* flowchart updateBruce Momjian1998-08-05
|
* flowchart updateBruce Momjian1998-08-05
|
* Fix for \d index display.Bruce Momjian1998-08-05
|
* From: David Hartwig <daybee@bellatlantic.net>Marc G. Fournier1998-08-05
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | I have attached a patch to allow GROUP BY and/or ORDER BY function or expressions. Note worthy items: 1. The expression or function need not be in the target list. Example: SELECT name FROM foo GROUP BY lower(name); 2. Simplified the grammar to use expressions only. 3. Cleaned up earlier patch in this area to make use of existing utility functions. 3. Reduced some of the members in the SortGroupBy parse node. The original data members were redundant with the new expression node. (MUST do a "make clean" now) 4. Added a new parse node "JoinUsing". The JOIN USING clause was overloading this SortGroupBy structure. With the afore mentioned reduction of members, the two clauses lost all their commonality. 5. A bug still exist where, if a function or expression is GROUPed BY, and an aggregate function does not include a attribute from the expression or function, the backend crashes. (or something like that) The bug pre-dates this patch. Example: SELECT lower(a) AS lowcase, count(b) FROM foo GROUP BY lowcase; *** BOOM *** --Also when not in target list SELECT count(b) FROM foo GROUP BY lower(a); *** BOOM AGAIN ***
* From: Dr. Michael Meskes <meskes@online-club.de>Marc G. Fournier1998-08-05
| | | | So this should finally get cursors working. There was an ugly bug in it.
* OR processing cleanup.Bruce Momjian1998-08-04
|
* Add Indices display to \d command.Bruce Momjian1998-08-04
|
* Fix encoding grammer problem.Bruce Momjian1998-08-04
|
* MergeSort was sometimes called mergejoin and was confusing. NowBruce Momjian1998-08-04
| | | | it is now only mergejoin.
* EXPLAIN VERBOSE prints the plan, and now pretty-prints the plan toBruce Momjian1998-08-04
| | | | the postmaster log file.
* Make EXPLAIN show output more clearly.Bruce Momjian1998-08-04
|
* Update flow chart.Bruce Momjian1998-08-04
|
* Update mark/reset index code for multiple indexes, (OR code).Bruce Momjian1998-08-03
| | | | Thanks for Vadim for fixes.
* Fix typo in man pages.Bruce Momjian1998-08-03
|
* Cleanup of OR processing.Bruce Momjian1998-08-03
|
* Allows the following query to succeed: "SELECT NULL ORDER BY 1;"Thomas G. Lockhart1998-08-02
| | | | | | | | | | There are three or four cases in transformSortClause() and I had fixed only one case for UNION. A second case is now fixed, in the same way; I assigned INT4OID to the column type for the "won't actually happen" sort. Didn't want to skip the code entirely, since the backend needs to _try_ a sort to get the NULLs right. I'm not certain under what circumstances the other cases are invoked and these are not yet fixed up, though perhaps they don't need to be...
* Fix for OR handling with multiple indexes.Bruce Momjian1998-08-02
|
* run autoconfBruce Momjian1998-08-02
|
* Fix MULTIBYTE typo.Bruce Momjian1998-08-02
|
* Fix duplicate inside initdb.shBruce Momjian1998-08-01
|
* Cleanup of OR fix.Bruce Momjian1998-08-01
|
* Allow index use with OR clauses.Bruce Momjian1998-08-01
|
* Adrian Hall reported a problem to me that snprintf() doesn't exist in, atMarc G. Fournier1998-08-01
| | | | | | | | least, Solaris 2.5.1. We use it in backend/utils/adt/int8.c. Add a check to configure so that we see if it exists or not, and, if not, compile in snprintf.c from backend/port, which was taken from, and falls under the same Berkeley license as us, the FreeBSD libc/stdio ...
* Lmgr cleanup, new locking modes for LLL.Vadim B. Mikheev1998-08-01
|
* Matching clauses to functional indices was broken, now fixed.Vadim B. Mikheev1998-07-31
|
* Fix scan adjustment.Vadim B. Mikheev1998-07-30
|
* Use Snapshot in heap access methods.Vadim B. Mikheev1998-07-27
|
* Missed a few files in the last round of commits from Tatsuo, as wellMarc G. Fournier1998-07-27
| | | | as needed to run autoconf ...
* From: t-ishii@sra.co.jpMarc G. Fournier1998-07-26
| | | | | | | | | As Bruce mentioned, this is due to the conflict among changes we made. Included patches should fix the problem(I changed all MB to MULTIBYTE). Please let me know if you have further problem. P.S. I did not include pathces to configure and gram.c to save the file size(configure.in and gram.y modified).
* I missed addding initdb.sh ...Marc G. Fournier1998-07-26
|
* Update flowchart. Add arrow.Bruce Momjian1998-07-26
|
* Fix compile error. Make transaction/work optional on all transactionBruce Momjian1998-07-26
| | | | | statements. More cleanups of psql help. Fix for shift/reduce on UNION in subselect.
* Update psql help syntax to remove <> and uppercaese keywords.Bruce Momjian1998-07-25
|
* Add mention of actual SQL command to create*/destroy* commands.Bruce Momjian1998-07-24
|
* Add mention of SQL commands to create/destroy man pages.Bruce Momjian1998-07-24
|
* Add mention of psql and template1 to create*, destroy* commandBruce Momjian1998-07-24
| | | | manual pages.