aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* 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.
* Support for installing NLS files, and update support to use gettextMagnus Hagander2007-03-24
| | | | from gnuwin32.
* 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 comment that pg_dump 'append' format is used only by pg_dump, perBruce Momjian2007-03-22
| | | | Dave Page.
* 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.
* 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 support for running regression tests on procedural languagesMagnus Hagander2007-03-21
|
* Properly return exitcode when regression tests fails.Magnus Hagander2007-03-21
|
* Native shared memory implementation for win32.Magnus Hagander2007-03-21
| | | | Uses same underlying tech as before, but not the sysv emulation layer.
* Add three new regexp functions: regexp_matches, regexp_split_to_array,Neil Conway2007-03-20
| | | | | | | | | | | | and regexp_split_to_table. These functions provide access to the capture groups resulting from a POSIX regular expression match, and provide the ability to split a string on a POSIX regular expression, respectively. Patch from Jeremy Drake; code review by Neil Conway, additional comments and suggestions from Tom and Peter E. This patch bumps the catversion, adds some regression tests, and updates the docs.
* Bumping catversion due to changes to pg_trigger and pg_rewrite.Jan Wieck2007-03-20
| | | | | | | | | BTW, the comment in this file says that we hope we never have more than 10 catversion changes per day, but to even make this possible we should start counting at zero, shouldn't we? Jan
* Changes pg_trigger and extend pg_rewrite in order to allow triggers andJan Wieck2007-03-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | rules to be defined with different, per session controllable, behaviors for replication purposes. This will allow replication systems like Slony-I and, as has been stated on pgsql-hackers, other products to control the firing mechanism of triggers and rewrite rules without modifying the system catalog directly. The firing mechanisms are controlled by a new superuser-only GUC variable, session_replication_role, together with a change to pg_trigger.tgenabled and a new column pg_rewrite.ev_enabled. Both columns are a single char data type now (tgenabled was a bool before). The possible values in these attributes are: 'O' - Trigger/Rule fires when session_replication_role is "origin" (default) or "local". This is the default behavior. 'D' - Trigger/Rule is disabled and fires never 'A' - Trigger/Rule fires always regardless of the setting of session_replication_role 'R' - Trigger/Rule fires when session_replication_role is "replica" The GUC variable can only be changed as long as the system does not have any cached query plans. This will prevent changing the session role and accidentally executing stored procedures or functions that have plans cached that expand to the wrong query set due to differences in the rule firing semantics. The SQL syntax for changing a triggers/rules firing semantics is ALTER TABLE <tabname> <when> TRIGGER|RULE <name>; <when> ::= ENABLE | ENABLE ALWAYS | ENABLE REPLICA | DISABLE psql's \d command as well as pg_dump are extended in a backward compatible fashion. Jan
* Further buildfarm experience shows that actually we can't run the plancacheTom Lane2007-03-19
| | | | | | test in parallel with the rules test at all, because the former wants to create a couple of temp views, which can sometimes show up in the latter's output. Let's try it in the next parallel group instead.
* Fix 8.2 breakage of domains over array types, and add a regression test caseTom Lane2007-03-19
| | | | to cover it. Per report from Anton Pikhteryev.
* ecpglib requires libpgport, per Andrew DunstanMagnus Hagander2007-03-19
|
* Fix ecpg/preproc makefile for parallel builds: parser.o must dependTom Lane2007-03-18
| | | | | on preproc.h, else make may try to build it before preproc.h is ready. Per failures seen here and in buildfarm.
* Code cleanup: mark some variables with the "const" modifier, when theyNeil Conway2007-03-18
| | | | are initialized with a string literal. Patch from Stefan Huehner.
* Code cleanup for function prototypes: change two K&R-style prototypesNeil Conway2007-03-18
| | | | to ANSI-style, and change "()" -> "(void)". Patch from Stefan Huehner.
* Simplified sortby ruleMichael Meskes2007-03-17
|
* - Changed some whitespacing in connect statement.Michael Meskes2007-03-17
| | | | | | | - Made some chars const as proposed by Stefan Huehner <stefan@huehner.org>. - Synced parser and keyword lists. - Copied two token parsing from backend parser to ecpg parser. - Also added a test case for this.
* msvc build actually needs Bison 2.2 or later, not 2.1. Or 1.875 as before.Magnus Hagander2007-03-17
|
* Add cvs tags to msvc build files, along with a (very short) comment aboutMagnus Hagander2007-03-17
| | | | what each script does.
* Oops, forgot to remove the old genbki script.Magnus Hagander2007-03-17
|
* Turn most vc build scripts into modules instead of scripts, and just haveMagnus Hagander2007-03-17
| | | | | | | skeleton scripts calling them. To make it easier for the buildfarm (or other "outside callers") to use these modules directly. Per suggestion from Andrew Dunstan.
* SPI_cursor_open failed to enforce that only read-only queries could beTom Lane2007-03-17
| | | | | | | executed in read_only mode. This could lead to various relatively-subtle failures, such as an allegedly stable function returning non-stable results. Bug goes all the way back to the introduction of read-only mode in 8.0. Per report from Gaetano Mendola.
* Ooops, got only one of the two ArrayExpr variants correct in firstTom Lane2007-03-17
| | | | | | cut at exprTypmod support. Also, experimentation shows that we need to label the type of Const nodes that are numeric with a specific typmod.
* Fix up the remaining places where the expression node structure would loseTom Lane2007-03-17
| | | | | | | | | | | | | | available information about the typmod of an expression; namely, Const, ArrayRef, ArrayExpr, and EXPR and ARRAY SubLinks. In the ArrayExpr and SubLink cases it wasn't really the data structure's fault, but exprTypmod() being lazy. This seems like a good idea in view of the expected increase in typmod usage from Teodor's work to allow user-defined types to have typmods. In particular this responds to the concerns we had about eliminating the special-purpose hack that exprTypmod() used to have for BPCHAR Consts. We can now tell whether or not such a Const has been cast to a specific length, and report or display properly if so. initdb forced due to changes in stored rules.