aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* 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.
* Fix HAVING patch missing cast.Bruce Momjian1998-07-24
|
* I'm sorry, but I think I introduced a little bug with my last patch.Bruce Momjian1998-07-24
| | | | | | | | | | | Everyone using an [NOT] EXISTS subquery will have noticed that already. The bug is in "subselect.c" in the function "SS_process_sublinks()". Here the whole function as it *SHOULD BE*: Stephan
* I really hope that I haven't missed anything in this one...Marc G. Fournier1998-07-24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | From: t-ishii@sra.co.jp Attached are patches to enhance the multi-byte support. (patches are against 7/18 snapshot) * determine encoding at initdb/createdb rather than compile time Now initdb/createdb has an option to specify the encoding. Also, I modified the syntax of CREATE DATABASE to accept encoding option. See README.mb for more details. For this purpose I have added new column "encoding" to pg_database. Also pg_attribute and pg_class are changed to catch up the modification to pg_database. Actually I haved added pg_database_mb.h, pg_attribute_mb.h and pg_class_mb.h. These are used only when MB is enabled. The reason having separate files is I couldn't find a way to use ifdef or whatever in those files. I have to admit it looks ugly. No way. * support for PGCLIENTENCODING when issuing COPY command commands/copy.c modified. * support for SQL92 syntax "SET NAMES" See gram.y. * support for LATIN2-5 * add UNICODE regression test case * new test suite for MB New directory test/mb added. * clean up source files Basic idea is to have MB's own subdirectory for easier maintenance. These are include/mb and backend/utils/mb.
* Version 06-30-0248Byron Nikolaidis1998-07-22
|
* Fix _lo_commit: core if LO memmory context was not created (LO were not used?)Vadim B. Mikheev1998-07-22
|
* VariableCache (next XID generator) is placed in shmem.Vadim B. Mikheev1998-07-21
|
* Update.Bruce Momjian1998-07-21
|
* Update.Bruce Momjian1998-07-21
|
* Theses buffer leaks are caused by indexes that are kept open betweenBruce Momjian1998-07-21
| | | | | | | | | | | | | | | | | | | | | calls. Outside a transaction, the backend detects them as buffer leaks; it sends a NOTICE, and frees them. This sometimes cause a segmentation fault (at least on Linux). These indexes are initialized on the first lo_read/lo_write/lo_tell call, and (normally) closed on a lo_close call. Thus the buffer leaks appear when lo direct access functions are used, and not with lo_import/lo_export functions (libpq version calls lo_close before ending the command, and the backend version uses another path). The included patches (against recent snapshot, and against 6.3.2) cause indexes to be closed on transaction end (that is on explicit 'END' statment, or on command termination outside trasaction blocks), thus preventing the buffer leaks while increasing performance inside transactions. Some (all?) 'classic' memory leaks are also removed. I hope it will be ok. --- Pascal ANDRE, graduated from Ecole Centrale Paris andre@via.ecp.fr
* target list fixes.Bruce Momjian1998-07-20
|
* makeTargetEntry cleanup.Bruce Momjian1998-07-20
|
* Makefile removal of internal.c.Bruce Momjian1998-07-20
|
* Cleanup makeTargetEntry and remove internal.c.Bruce Momjian1998-07-20
|
* Use defines rather than constants for types.Bruce Momjian1998-07-20
|
* Fix problem brought in with 32K machine.Bruce Momjian1998-07-20
|
* Cleanup use of 16 that should be NAMEDATALEN.Bruce Momjian1998-07-20
|
* Cleanup Name usage.Bruce Momjian1998-07-20
|
* Fix temp name length.Bruce Momjian1998-07-20
|
* Remove un-needed references to Name.Bruce Momjian1998-07-20
|
* Update version.Bruce Momjian1998-07-20
|
* Remove unneeded strcpy() of timezone.Bruce Momjian1998-07-19
|
* Remove un-needed psort close.Bruce Momjian1998-07-19
|
* Lock fix from Tom Ivar Helbekkmo .Bruce Momjian1998-07-19
|
* 1) Queries using the having clause on base tables should work wellBruce Momjian1998-07-19
| | | | | | | | | | | | | | | | | | | | | | | | | now. Here some tested features, (examples included in the patch): 1.1) Subselects in the having clause 1.2) Double nested subselects 1.3) Subselects used in the where clause and in the having clause simultaneously 1.4) Union Selects using having 1.5) Indexes on the base relations are used correctly 1.6) Unallowed Queries are prevented (e.g. qualifications in the having clause that belong to the where clause) 1.7) Insert into as select 2) Queries using the having clause on view relations also work but there are some restrictions: 2.1) Create View as Select ... Having ...; using base tables in the select 2.1.1) The Query rewrite system: 2.1.2) Why are only simple queries allowed against a view from 2.1) ? 2.2) Select ... from testview1, testview2, ... having...; 3) Bug in ExecMergeJoin ?? Regards Stefan
* pg_dump -z has gotten rather thoroughly broken in the last coupleBruce Momjian1998-07-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | of days --- it was emitting stuff like REVOKE ALL on 'table' from PUBLIC; GRANT ALL on "table" to "Public"; neither of which work. While I was at it I cleaned up a few other things: * \connect commands are issued only in -z mode. In this way, reloading a pg_dump script made without -z will generate a simple database wholly owned by the invoking user, rather than a mishmash of tables owned by various people but lacking in access rights. (Analogy: cp versus cp -p.) * \connect commands are issued just before COPY FROM stdin commands; without this, reloading a database containing non-world-writable tables tended to fail because the COPY was not necessarily attempted as the table owner. * Redundant \connect commands are suppressed (each one costs a backend launch, so...). * Man page updated (-z wasn't ever documented). The first two items were discussed in a pgsql-hackers thread around 6 May 98 ("An item for the TODO list: pg_dump and multiple table owners") but no one had bothered to deal with 'em yet. regards, tom lane
* Make sparc/solaris not use complex macr.Bruce Momjian1998-07-19
|
* Attached are the three patches that were needed to get PostgreSQLBruce Momjian1998-07-19
| | | | | | | | | | | | | 6.3.2 to compile (and run) on my Sparc Solaris 2.5.1 box. Details below: pgsql.sparc.patch-template: Adds -D__sparc__ and -D__sun__, defintions which gcc does define, but Sun's cc does not. :( pgsql.sparc.patch-makefile: Adds a define so that 'lorder' is not used, as it is not found on my machine. Ryan Kirkpatrick
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-02 23:59:16 +0000