aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Allow non-superuser database owners to create procedural languages.Tom Lane2007-03-26
| | | | | | | | | | A DBA is allowed to create a language in his database if it's marked "tmpldbacreate" in pg_pltemplate. The factory default is that this is set for all standard trusted languages, but of course a superuser may adjust the settings. In service of this, add the long-foreseen owner column to pg_language; renaming, dropping, and altering owner of a PL now follow normal ownership rules instead of being superuser-only. Jeremy Drake, with some editorialization by Tom Lane.
* Add checking of end of line in parsing stopword list. Thanks to sharp eyes ↵Teodor Sigaev2007-03-26
| | | | of Tom lane
* Fix stopword and synonym files parsing bug in MSVC build, per report fromTeodor Sigaev2007-03-26
| | | | Magnus Hagander. Also, now it ignores space symbol after stopwords.
* Fix pg_wchar_table's maxmblen field of EUC_CN, EUC_TW, MULE_INTERNALTatsuo Ishii2007-03-26
| | | | and GB18030. patches from ITAGAKI Takahiro.
* Seems some people have been forgetting to run autoheader.Tom Lane2007-03-26
|
* Add -lcrypto as one of the possible link dependencies of libkrb5.Tom Lane2007-03-26
| | | | | Per report from Jim Rosenberg. This possibly should get back-patched, but I'm a bit suspicious of it still because of the lack of prior reports.
* Remove assertion that constraint_exclusion risks wrong answers ifTom Lane2007-03-26
| | | | | table constraints are changed; this is no longer true now that we have a plan invalidation mechanism.
* Fix plancache's invalidation callback to do the right thing for a SITom Lane2007-03-26
| | | | | | reset event, namely invalidate everything. This oversight probably explains the rare failures that some buildfarm machines have been showing for the plancache regression test.
* Make _SPI_execute_plan pass the query source string down to ProcessUtilityTom Lane2007-03-25
| | | | | | if possible. I had left this undone in the first pass at the API change for ProcessUtility, but forgot to revisit it after the plancache changes made it possible to do it.
* Remove the prohibition on executing cursor commands through SPI_execute.Tom Lane2007-03-25
| | | | | | | | | Vadim had included this restriction in the original design of the SPI code, but I'm darned if I can see a reason for it. I left the macro definition of SPI_ERROR_CURSOR in place, so as not to needlessly break any SPI callers that are checking for it, but that code will never actually be returned anymore.
* Clean up the representation of special snapshots by including a "methodTom Lane2007-03-25
| | | | | | | | | | | | | | | | | | | | | pointer" in every Snapshot struct. This allows removal of the case-by-case tests in HeapTupleSatisfiesVisibility, which should make it a bit faster (I didn't try any performance tests though). More importantly, we are no longer violating portable C practices by assuming that small integers are distinct from all pointer values, and HeapTupleSatisfiesDirty no longer has a non-reentrant API involving side-effects on a global variable. There were a couple of places calling HeapTupleSatisfiesXXX routines directly rather than through the HeapTupleSatisfiesVisibility macro. Since these places had to be changed anyway, I chose to make them go through the macro for uniformity. Along the way I renamed HeapTupleSatisfiesSnapshot to HeapTupleSatisfiesMVCC to emphasize that it's only used with MVCC-type snapshots. I was sorely tempted to rename HeapTupleSatisfiesVisibility to HeapTupleSatisfiesSnapshot, but forebore for the moment to avoid confusion and reduce the likelihood that this patch breaks some of the pending patches. Might want to reconsider doing that later.
* Add new encoding EUC_JIS_2004 and SHIFT_JIS_2004,Tatsuo Ishii2007-03-25
| | | | | along with new conversions among EUC_JIS_2004, SHIFT_JIS_2004 and UTF-8. catalog version has been bump up.
* Add:Bruce Momjian2007-03-25
| | | | | | | > > * Allow BEFORE INSERT triggers on views > > http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php
* Add:Bruce Momjian2007-03-24
| | | | | > o Add more logical syntax CLUSTER table ORDER BY index; > support current syntax for backward compatibility
* Support for installing NLS files, and update support to use gettextMagnus Hagander2007-03-24
| | | | from gnuwin32.
* Document that LDAP URLs should be double-quoted in pg_hba.conf becauseBruce Momjian2007-03-24
| | | | | | commas are often present in the URL. Backpatch to 8.2.X.
* Install contrib sql and readme filesMagnus Hagander2007-03-24
|
* Properly parse the name of contrib modules that aren't named the sameMagnus Hagander2007-03-24
| | | | way as their directory (notably xml2/pgxml and intarray/_int)
* Set the node properly, per Tom.Alvaro Herrera2007-03-23
|
* Separate the code to start a new worker into its own function. The code isAlvaro Herrera2007-03-23
| | | | exactly the same, modulo whitespace.
* Separate fetch of pg_autovacuum tuple into its own function.Alvaro Herrera2007-03-23
|
* We no longer need to palloc the VacuumStmt node; keeping it on the stack isAlvaro Herrera2007-03-23
| | | | simpler.
* Adjust DatumGetBool macro so that it isn't fooled by garbage in the DatumTom Lane2007-03-23
| | | | | | | | | | to the left of the actual bool value. While in most cases there won't be any, our support for old-style user-defined functions violates the C spec to the extent of calling functions that might return char or short through a function pointer declared to return "char *", which we then coerce to Datum. It is not surprising that the result might contain garbage high-order bits ... what is surprising is that we didn't see such cases long ago. Per report from Magnus.
* Fix plancache so that any required replanning is done with the sameTom Lane2007-03-23
| | | | | | | | | search_path that was active when the plan was first made. To do this, improve namespace.c to support a stack of "override" search path settings (we must have a stack since nested replan events are entirely possible). This facility replaces the "special namespace" hack formerly used by CREATE SCHEMA, and should be able to support per-function search path settings as well.
* Allow 4 bytes UTF-8 (UCS-4 range 00010000-001FFFFF)Tatsuo Ishii2007-03-23
| | | | This is necessary to support JIS X 0213 <--> UTF-8 conversion.
* Forgot commit: support for special-cases in pgcryptoMagnus Hagander2007-03-23
|
* Support for running contribcheck on msvcMagnus Hagander2007-03-23
|
* Generate SQL files for /contrib (based on .sql.in)Magnus Hagander2007-03-23
|
* Add define to exclude configured libraries, to be able to easily build aMagnus Hagander2007-03-23
| | | | stripped down version of libpq. To be used by the installer.
* Remove headers for old sysv shmem emulation that I forgot.Magnus Hagander2007-03-23
| | | | | Also remove headers for old sysv semaphore emulation that were forgotten when that was changed about a year ago.
* Cleanup for procarray.c.Bruce Momjian2007-03-23
|
* Add:Bruce Momjian2007-03-22
| | | | | | | | > > * Fix cases where invalid byte encodings are accepted by the database, > but throw an error on SELECT > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00767.php
* Add comment that pg_dump 'append' format is used only by pg_dump, perBruce Momjian2007-03-22
| | | | Dave Page.
* Add to TODO:Bruce Momjian2007-03-22
| | | | | | | CLUSTER: > > o %Add VERBOSE option to report tables as they are processed, > like VACUUM VERBOSE
* Commit newest version of xmlpath().Bruce Momjian2007-03-22
| | | | Nikolay Samokhvalov
* In pg_dump, strcasecmp -> pg_strcasecmp.Bruce Momjian2007-03-22
|
* Add xmlpath() to evaluate XPath expressions, with namespaces support.Bruce Momjian2007-03-22
| | | | Nikolay Samokhvalov
* Arrange for PreventTransactionChain to reject commands submitted as partTom Lane2007-03-22
| | | | | | | of a multi-statement simple-Query message. This bug goes all the way back, but unfortunately is not nearly so easy to fix in existing releases; it is only the recent ProcessUtility API change that makes it fixable in HEAD. Per report from William Garrison.
* Allow the pgstat process to restart immediately after a receivingBruce Momjian2007-03-22
| | | | SIGQUIT signal, rather than waiting for PGSTAT_RESTART_INTERVAL.
* Allow DROP TABLESPACE to succeed (with a warning) if the pg_tblspc symlinkTom Lane2007-03-22
| | | | | | | | | | | doesn't exist. This allows DROP to be used to clean out the pg_tablespace catalog entry in a situation where a previous DROP attempt failed before committing but after having removed the directories and symlink. Per report from William Garrison. Even though his test case depends on an unrelated bug in PreventTransactionChain, it's certainly possible for this situation to arise due to other problems, eg a system crash at just the right time.
* Properly enforce pg_dump -F formation options; only single letter orBruce Momjian2007-03-22
| | | | full words support, per report from Mark Stosberg.
* Remove the currently unused FRONTEND case in dllist.c. This allows the usageAlvaro Herrera2007-03-22
| | | | | of palloc instead of malloc, which means a list can be freed simply by deleting the memory context that contains it.
* Fix parser bug on Windows with UTF8 encoding and C locale, the reason wasTeodor Sigaev2007-03-22
| | | | sizeof(wchar_t) = 2 instead of 4.
* Remove tabs in SGML files.Bruce Momjian2007-03-22
|
* Remove tabs from SGML file.Bruce Momjian2007-03-22
|
* Forgot to add file needed for PL regression testsMagnus Hagander2007-03-22
|
* Fix some problems with selectivity estimation for partial indexes.Tom Lane2007-03-21
| | | | | | | | | | | | | | | | | | | | | First, genericcostestimate() was being way too liberal about including partial-index conditions in its selectivity estimate, resulting in substantial underestimates for situations such as an indexqual "x = 42" used with an index on x "WHERE x >= 40 AND x < 50". While the code is intentionally set up to favor selecting partial indexes when available, this was too much... Second, choose_bitmap_and() was likewise easily fooled by cases of this type, since it would similarly think that the partial index had selectivity independent of the indexqual. Fixed by using predicate_implied_by() rather than simple equality checks to determine redundancy. This is a good deal more expensive but I don't see much alternative. At least the extra cost is only paid when there's actually a partial index under consideration. Per report from Jeff Davis. I'm not going to risk back-patching this, though.
* Add:Bruce Momjian2007-03-21
| | | | | | | | | < < > o During index creation, pre-sort the tuples to improve build speed > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php >
* Remove TODO item, not wanted:Bruce Momjian2007-03-21
| | | | | | | | | | | | | | < * Add NUMERIC division operator that doesn't round? < < Currently NUMERIC _rounds_ the result to the specified precision. < This means division can return a result that multiplied by the < divisor is greater than the dividend, e.g. this returns a value > 10: < < SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6; < < The positive modulus result returned by NUMERICs might be considered < inaccurate, in one sense. <
* Add documentation about vcregress.Magnus Hagander2007-03-21
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 13:25:22 +0000