summaryrefslogtreecommitdiff
path: root/src/backend/utils
Commit message (Collapse)AuthorAgeFilesLines
* Use Snapshot in heap access methods.Vadim B. Mikheev1998-07-277-47/+23
|
* From: t-ishii@sra.co.jpMarc G. Fournier1998-07-2612-37/+46
| | | | | | | | | 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 really hope that I haven't missed anything in this one...Marc G. Fournier1998-07-2422-16/+1390
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
* Cleanup use of 16 that should be NAMEDATALEN.Bruce Momjian1998-07-204-10/+11
|
* Cleanup Name usage.Bruce Momjian1998-07-202-31/+28
|
* Remove unneeded strcpy() of timezone.Bruce Momjian1998-07-191-7/+1
|
* Add auto-size to screen to \d? commands. Use UNION to show allBruce Momjian1998-07-183-18/+18
| | | | | \d? results in one query. Add \d? field search feature. Rename MB to MULTIBYTE.
* Change atttypmod from int16 to int32, for Thomas.Bruce Momjian1998-07-123-10/+10
|
* From: Tom Lane <tgl@sss.pgh.pa.us>Marc G. Fournier1998-07-091-1/+3
| | | | | | | | | | | | | | | | | | 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.
* Include 8-byte integer type.Thomas G. Lockhart1998-07-082-7/+529
| | | | At the moment, probably only works for i686/gcc and Alphas...
* Rename signal to SIGHUP.Bruce Momjian1998-07-071-2/+2
|
* Fix for hang after postmaster restart. Add new proc_exit andBruce Momjian1998-06-274-14/+14
| | | | shmem_exit to replace exitpg().
* Add SLEEP_ON_ABORTBruce Momjian1998-06-181-2/+5
|
* port name cleanupBruce Momjian1998-06-181-1/+2
|
* Hello!Bruce Momjian1998-06-162-89/+60
| | | | | | | | | | | | | | | | | | | | | | | | Attached to the mail is locale-patch.tar.gz. In the archive there are: file README.locale short description directory src/test/locale test suite; currently only koi8-r tests, but the suite can be easily extended file locale.patch the very patch; to apply: patch < locale.patch; should be applied to postgres-6.3.2 (at least I created it with 6.3.2 without any additional patches) Files touched by the patch: src/include/utils/builtins.h src/backend/utils/adt/char.c src/backend/utils/adt/varchar.c src/backend/utils/adt/varlena.c Oleg
* Remove un-needed braces around single statements.Bruce Momjian1998-06-1539-429/+53
|
* Fix macros that were not properly surrounded by parens or braces.Bruce Momjian1998-06-156-143/+166
|
* Auto-seed random so user's can't request random values based onBruce Momjian1998-06-091-1/+17
| | | | our postmaster random seed used from cancel.
* Another for for exec() removal and finding binaries.Bruce Momjian1998-06-091-26/+28
|
* Fixed exec path problem.Bruce Momjian1998-06-081-9/+9
|
* Remove fork()/exec() and only do fork(). Small cleanups.Bruce Momjian1998-05-294-18/+9
|
* Require #define variable ALLOW_ABSOLUTE_DBPATHS if absolute paths areThomas G. Lockhart1998-05-291-1/+5
| | | | | | | | allowed to be used for alternate database locations. Probably best to default to not allowed, as now, since there are security and integrity issues which should be considered carefully before opening things up. Will update docs to discuss this issue.
* Add conversion functions to and from the "name" data type.Thomas G. Lockhart1998-05-292-4/+126
|
* Ensure string is completely null padded on input (as advertised).Thomas G. Lockhart1998-05-291-1/+8
|
* Allow cancel from client of backend query. Change some int variablesBruce Momjian1998-05-192-5/+7
| | | | to bool's.
* Fix CACHEDEBUG debugging statements; usually not used and apparentlyThomas G. Lockhart1998-05-091-5/+5
| | | | broke a long time ago when some definitions changed.
* Add routines to convert between varchar and bpchar.Thomas G. Lockhart1998-05-092-14/+136
| | | | Add routines to allow sizing of varchar and bpchar into target columns.
* Make a few line routines visible.Thomas G. Lockhart1998-05-091-41/+157
| | | | Incorporate patches from Gautam for line/point intersection.
* Define "tz_hour" and "tz_minute" arguments to date_part().Thomas G. Lockhart1998-05-091-138/+89
| | | | Fix up "ISO-style" timespan decoding and encoding.
* From: Jeroen van Vianen <jeroenv@design.nl>Marc G. Fournier1998-04-292-2/+30
| | | | | | | | | | Attached patch will add a version() function to Postges, e.g. template1=> select version(); version ------------------------------------------------------------ PostgreSQL 6.3.2 on i586-pc-linux-gnu, compiled by gcc 2.8.1 (1 row)
* From: t-ishii@sra.co.jpMarc G. Fournier1998-04-273-10/+142
| | | | | | | | | | | | | | | | | | | | | | | Hi, here are patches I promised (against 6.3.2): * character_length(), position(), substring() are now aware of multi-byte characters * add octet_length() * add --with-mb option to configure * new regression tests for EUC_KR (contributed by "Soonmyung. Hong" <hong@lunaris.hanmesoft.co.kr>) * add some test cases to the EUC_JP regression test * fix problem in regress/regress.sh in case of System V * fix toupper(), tolower() to handle 8bit chars note that: o patches for both configure.in and configure are included. maybe the one for configure is not necessary. o pg_proc.h was modified to add octet_length(). I used OIDs (1374-1379) for that. Please let me know if these numbers are not appropriate.
* From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>Marc G. Fournier1998-04-271-2/+2
| | | | | | | | | | Ok, I have finally gotten all of the defines for Dec/Alpha and Linux/Alpha sorted out as Marc asked. There is no longer any need for '-Dalpha' or '-Dlinuxalpha' in either the Dec/Alpha or the Linux/Alpha template files (./src/template/{alpha,linuxalpha}). I have replaced every instance of 'alpha' or '__alpha__' with '__alpha', as that appears to be the common symbol between C compilers on both operating systems (RH4.2 & DecUnix 4.0b) for alpha.
* This patch...Bruce Momjian1998-04-273-54/+47
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 1. Removes the unnecessary "#define AbcRegProcedure 123"'s from pg_proc.h. 2. Changes those #defines to use the names already defined in fmgr.h. 3. Forces the make of fmgr.h in backend/Makefile instead of having it made as a dependency in access/common/Makefile *hack*hack*hack* 4. Rearranged the #includes to a less helter-skelter arrangement, also changing <file.h> to "file.h" to signify a non-system header. 5. Removed "pg_proc.h" from files where its only purpose was for the #defines removed in item #1. 6. Added "fmgr.h" to each file changed for completeness sake. Turns out that #6 was not necessary for some files because fmgr.h was being included in a roundabout way SIX levels deep by the first include. "access/genam.h" ->"access/relscan.h" ->"utils/rel.h" ->"access/strat.h" ->"access/skey.h" ->"fmgr.h" So adding fmgr.h really didn't add anything to the compile, hopefully just made it clearer to the programmer. S Darren.
* Re-apply Darren's char2-16 removal code.Bruce Momjian1998-04-265-484/+7
|
* Inline some small functions called for every row.Bruce Momjian1998-04-241-48/+5
|
* More work in the right direction on linux/alphaMarc G. Fournier1998-04-121-2/+2
| | | | From: Ryan Kirkpatrick <rkirkpat@nag.cs.colorado.edu>
* Back out char2-char16 removal. Add later.Bruce Momjian1998-04-075-7/+484
|
* Hi,Bruce Momjian1998-04-0611-90/+37
| | | | | | | | | | | | | | | | | | | | | | Attached you'll find a (big) patch that fixes make dep and make depend in all Makefiles where I found it to be appropriate. It also removes the dependency in Makefile.global for NAMEDATALEN and OIDNAMELEN by making backend/catalog/genbki.sh and bin/initdb/initdb.sh a little smarter. This no longer requires initdb.sh that is turned into initdb with a sed script when installing Postgres, hence initdb.sh should be renamed to initdb (after the patch has been applied :-) ) This patch is against the 6.3 sources, as it took a while to complete. Please review and apply, Cheers, Jeroen van Vianen
* Remove GetDatabaseName/Path and use globals. Make consts later.Bruce Momjian1998-04-052-28/+5
|
* Fix for memory leak.Bruce Momjian1998-04-052-8/+8
|
* The following uuencoded, gzip'd file will ...Bruce Momjian1998-03-305-484/+7
| | | | | | | | | | | 1. Remove the char2, char4, char8 and char16 types from postgresql 2. Change references of char16 to name in the regression tests. 3. Rename the char16.sql regression test to name.sql. 4. Modify the regression test scripts and outputs to match up. Might require new regression.{SYSTEM} files... Darren King
* There's a patch attached to fix gcc 2.8.x warnings, except for theBruce Momjian1998-03-301-3/+5
| | | | | | | | | | | | | | | | | | | | | | | | yyerror ones from bison. It also includes a few 'enhancements' to the C programming style (which are, of course, personal). The other patch removes the compilation of backend/lib/qsort.c, as qsort() is a standard function in stdlib.h and can be used any where else (and it is). It was only used in backend/optimizer/geqo/geqo_pool.c, backend/optimizer/path/predmig.c, and backend/storage/page/bufpage.c > > Some or all of these changes might not be appropriate for v6.3, since we > > are in beta testing and since they do not affect the current functionality. > > For those cases, how about submitting patches based on the final v6.3 > > release? There's more to come. Please review these patches. I ran the regression tests and they only failed where this was expected (random, geo, etc). Cheers, Jeroen
* > > I'm using text[] arrays. Some of my array elements have '"'Bruce Momjian1998-03-201-4/+14
| | | | | | | | > > characters in them. Dumping and reloading using pg_dumpall > > doesn't work with this and dumping the entire array and > > then trying to parse it is hopeless. Doug Gibson
* From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>Marc G. Fournier1998-03-151-2/+2
| | | | | | | | For substr() and substring() on the text data type, the relevant code is in varlena.c. You are right, there is a problem. I have a patch which I will apply to the source tree soon. The copy enclosed below probably does not preserve tabs correctly so cannot be applied directly; the relevant change is simply changing the ">=" to ">"...
* From: t-ishii@sra.co.jpMarc G. Fournier1998-03-152-9/+25
| | | | | | | | | | | | | | | Included are patches intended for allowing PostgreSQL to handle multi-byte charachter sets such as EUC(Extende Unix Code), Unicode and Mule internal code. With the MB patch you can use multi-byte character sets in regexp and LIKE. The encoding system chosen is determined at the compile time. To enable the MB extension, you need to define a variable "MB" in Makefile.global or in Makefile.custom. For further information please take a look at README.mb under doc directory. (Note that unlike "jp patch" I do not use modified GNU regexp any more. I changed Henry Spencer's regexp coming with PostgreSQL.)
* Add one-line fix to allow redefining built-in functions.Thomas G. Lockhart1998-03-071-1/+2
| | | | Bug introduced in mid-January.
* Fix money type USE_LOCALE support at least for default "C" locale.Thomas G. Lockhart1998-03-021-26/+53
| | | | Still has questionable code for some locale-specific strings.
* pgindent run before 6.3 release, with Thomas' requested changes.Bruce Momjian1998-02-2650-1257/+1359
|
* From: Jan Wieck <jwieck@debis.com>Marc G. Fournier1998-02-255-21/+21
| | | | | | | | | | seems that my last post didn't make it through. That's good since the diff itself didn't covered the renaming of pg_user.h to pg_shadow.h and it's new content. Here it's again. The complete regression test passwd with only some float diffs. createuser and destroyuser work. pg_shadow cannot be read by ordinary user.
* From: "Denis V. Dmitrienko" <denis@null.net>Marc G. Fournier1998-02-243-3/+180
| | | | | | | | | | | What it does: It solves stupid problem with cyrillic charsets IP-based on-fly recoding. take a look at /data/charset.conf for details. You can use any tables for any charset. Tables are from Russian Apache project. Tables in this patch contains also Ukrainian characters. Then run ./configure --enable-recode