aboutsummaryrefslogtreecommitdiff
path: root/src/backend
Commit message (Collapse)AuthorAge
* Use Snapshot in heap access methods.Vadim B. Mikheev1998-07-27
|
* 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).
* 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
|
* 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.
* 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
|
* 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
|
* 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
|
* Remove unneeded strcpy() of timezone.Bruce Momjian1998-07-19
|
* Remove un-needed psort close.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
* My mailer munged the intro text in my last post. Here is the textBruce Momjian1998-07-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | in a more readable form. -- I am submitting the following patches to the June 6, 1998 snapshot of PostgreSQL. These patches implement a port of PostgreSQL to SCO UnixWare 7, and updates the Univel port (UnixWare 2.x). The patched files, and the reason for the patch are: File Reason for the patch --------------- --------------------------------------------------------------- src/backend/port/dynloader/unixware.c src/backend/port/dynloader/unixware.h src/include/port/unixware.h src/makefiles/Makefile.unixware src/template/unixware Created for the UNIXWARE port. src/include/port/univel.h Modifed this file to work with the changes made to s_lock.[ch]. src/backend/storage/buffer/s_lock.c src/include/storage/s_lock.h Moved the UNIXWARE (and Univel) tas() function from s_lock.c to s_lock.h. The UnixWare compiler asm construct is treated as a macro and needs to be in the s_lock.h file. I also reworked the tas() function to correct some errors in the code. src/include/version.h.in The use of the ## operator with quoted strings in the VERSION macro caused problems with the UnixWare C compiler. I removed the ## operators since they were not needed in this case. The macro expands into a sequence of quoted strings that will be concatenated by any ANSI C compiler. src/config.guess This script was modified to recognize SCO UnixWare 7. src/configure src/configure.in The configure script was modified to recognize SCO UnixWare 7. Billy G. Allie
* Conditionally execute Junk filter only when ORDER BY of columnsBruce Momjian1998-07-19
| | | | not in target list.
* Add auto-size to screen to \d? commands. Use UNION to show allBruce Momjian1998-07-18
| | | | | \d? results in one query. Add \d? field search feature. Rename MB to MULTIBYTE.
* Rename Rel to RelOptInfo.Bruce Momjian1998-07-18
|
* Fix for Group ReScan suggested by Vadim.Bruce Momjian1998-07-16
|
* Patch for ReScan of Group.Bruce Momjian1998-07-16
|
* Allow UNION/UNION ALL in subselects.Bruce Momjian1998-07-15
|
* Fix for COPY problem and atttypmod.Bruce Momjian1998-07-15
|
* Allow UNION in subselect.Bruce Momjian1998-07-15
|
* Fix explain for union and inheritance. Rename Append structureBruce Momjian1998-07-15
| | | | members to be clearer. Fix cost computation for these.
* Fix for UNION selects with constant NULL expressions; e.g.Thomas G. Lockhart1998-07-14
| | | | SELECT 1 UNION SELECT NULL;
* Major man page update from Tom Lane. cBruce Momjian1998-07-14
|
* Fix for AS name quotation problem.Bruce Momjian1998-07-13
|
* Currently, building on any platform that hasn't got getrusage()Bruce Momjian1998-07-13
| | | | | | | | | | | | | | | | | | | | | | | requires manual editing of src/backend/port/getrusage.c, because its substitute version of getrusage is #if'd out. There is no good reason for that, because configure won't even include the file into the Makefile unless the platform hasn't got getrusage. Furthermore, we only have one working substitute version of getrusage --- the alleged HPUX syscall-based code doesn't work. (It causes a coredump because the syscall returns a struct rusage that's much larger than the stub struct defined in src/include/rusagestub.h.) The times()-based emulation works fine on HPUX, however. I propose, therefore, that getrusage.c should just unconditionally compile the times-based version, and rely on configure to include the file only if needed. This will be one less manual configuration step on all platforms that need this code. Patch attached. Tom Lane.
* Inline function, rename libpq variablees, change lrel to lockrel.Bruce Momjian1998-07-13
|
* removed unneeded long spec on constants.Bruce Momjian1998-07-12
|
* Change atttypmod from int16 to int32, for Thomas.Bruce Momjian1998-07-12
|
* Reverse out unused patch.Bruce Momjian1998-07-12
|
* Print relation name before vacuum, results after vacuum.Bruce Momjian1998-07-12
|
* Fix for views that use AS with two words.Bruce Momjian1998-07-09
|
* Handle case of GROUP BY target list column number out of range.Thomas G. Lockhart1998-07-09
|
* From: Tom Lane <tgl@sss.pgh.pa.us>Marc G. Fournier1998-07-09
| | | | | | | | | | | | | | | | | | Making PQrequestCancel safe to call in a signal handler turned out to be much easier than I feared. So here are the diffs. Some notes: * I modified the postmaster's packet "iodone" callback interface to allow the callback routine to return a continue-or-drop-connection return code; this was necessary to allow the connection to be closed after receiving a Cancel, rather than proceeding to launch a new backend... Being a neatnik, I also made the iodone proc have a typechecked parameter list. * I deleted all code I could find that had to do with OOB. * I made some edits to ensure that all signals mentioned in the code are referred to symbolically not by numbers ("SIGUSR2" not "2"). I think Bruce may have already done at least some of the same edits; I hope that merging these patches is not too painful.
* Allow floating point constants for "def_arg" numeric arguments.Thomas G. Lockhart1998-07-08
| | | | | | Used in the generic "CREATE xxx" parsing. Do some automatic type conversion for inserts from other columns. Previous trouble with "resjunk" regression test remains for now.
* Include 8-byte integer type.Thomas G. Lockhart1998-07-08
| | | | At the moment, probably only works for i686/gcc and Alphas...
* Rename signal to SIGHUP.Bruce Momjian1998-07-07
|
* Update lock manager README.Bruce Momjian1998-07-06
|
* Rename shared memory area.Bruce Momjian1998-06-30
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-31 01:16:18 +0000