aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Improve psql's \dC command to take a pattern parameter. Casts are shownTom Lane2008-11-06
| | | | | if their source or target types match the pattern (using the same definition of "match" as \dT does). Per recent discussion.
* The logic in systable_beginscan to translate heap attribute numbers toHeikki Linnakangas2008-11-06
| | | | | index column numbers needs to handle the case where you have more than one scankey on the same index column. toast_fetch_datum_slice() needs it.
* This maneuver really requires a comment ...Tom Lane2008-11-05
|
* change fix for suppress_redundant_updates_trigger() where relation has Oids, ↵Andrew Dunstan2008-11-05
| | | | to only apply if present Oid is invalid, per second thought from TGL
* fix suppress_redundant_updates_trigger() where relation has Oids, per gripe ↵Andrew Dunstan2008-11-05
| | | | from KaiGai Kohei
* A few additional test cases for array functionalityPeter Eisentraut2008-11-05
|
* Rename several aliases for PLpgSQL_datum.dno to also be called dno.Tom Lane2008-11-05
| | | | | | Hopefully this will forestall future confusion about their roles. Jonah Harris
* Revert unwanted patch, per Tom.Alvaro Herrera2008-11-04
|
* Remove unused rfno from PLpgSQL_recfieldAlvaro Herrera2008-11-04
| | | | Jonah Harris
* Fix bug introduced in recent patch to make plpython cope with OUT arguments:Tom Lane2008-11-04
| | | | | the proc->argnames array has to be initialized to zero immediately on creation, since the error recovery path will try to free its elements.
* ADD array_ndims functionPeter Eisentraut2008-11-04
| | | | Author: Robert Haas <robertmhaas@gmail.com>
* Fix compiler warning about uninitialized variablePeter Eisentraut2008-11-04
|
* Disallow LOCK TABLE outside a transaction block (or function), since this caseTom Lane2008-11-04
| | | | | almost certainly represents user error. Per a gripe from Sebastian Böhm and subsequent discussion.
* Fix compiler warnings (including a seriously bogus elog call); minorTom Lane2008-11-04
| | | | code beautification.
* Use bool for a boolean flag.Tom Lane2008-11-03
|
* Allow uuid_in() to parse a wider variety of variant input formats for the UUIDPeter Eisentraut2008-11-03
| | | | | | | data type. This patch takes the approach of allowing an optional hyphen after each group of four hex digits. Author: Robert Haas <robertmhaas@gmail.com>
* Dept of second thoughts: seems it'd be safer if pg_typeof is markedTom Lane2008-11-03
| | | | stable not immutable, since it depends on system catalog contents.
* Clean up the messy semantics (not to mention inefficiency) of PageGetTempPageTom Lane2008-11-03
| | | | | | by splitting it into three functions with better-defined behaviors. Zdenek Kotala
* suppress_redundant_updates_trigger function.Andrew Dunstan2008-11-03
|
* Fix silly typo in previous commit.Alvaro Herrera2008-11-03
|
* Fix TransactionIdSetStatusBit so that it doesn't try to change a transactionAlvaro Herrera2008-11-03
| | | | | | | | from COMMITTED to SUBCOMMITTED during recovery. This wasn't previously possible, but it is now due to the recent changes on clog commit protocol for subtransactions. Simon Riggs
* Fix two error-recovery bugs in describeOneTableDetails(), and make the codeTom Lane2008-11-03
| | | | | | | | to dump sequence values cope with sequences outside the search path and/or having names that need quoting. No back-patch needed because these are new problems in 8.4. Kris Jurka (also a little bit of code beautification by tgl)
* Reduce the acceptable staleness of pgstat data for autovacuum, per theAlvaro Herrera2008-11-03
| | | | longstanding note in the source that this patch removes.
* Add pg_typeof() function.Tom Lane2008-11-03
| | | | Brendan Jurd
* Small shell syntax improvement.Bruce Momjian2008-11-03
|
* Fix mistakes in comment headersAlvaro Herrera2008-11-03
|
* Fix incorrect comment in SSL codeMagnus Hagander2008-11-03
|
* Change the pgstat logic so that the stats collector writes the stats file onlyTom Lane2008-11-03
| | | | | | | | | | | | | | | | | | upon requests from backends, rather than on a fixed 500msec cycle. (There's still throttling logic to ensure it writes no more often than once per 500msec, though.) This should result in a significant reduction in stats file write traffic in typical scenarios where the stats are demanded only infrequently. This approach also means that the former difficulty with changing stats_temp_directory on-the-fly has gone away, so remove the caution about that as well as the thrashing we did to minimize the trouble window. In passing, also fix pgstat_report_stat() so that we will send a stats message if we have function call stats but not table stats to report; this fixes a bug in the recent patch to support function-call stats. Martin Pihlak
* Remove the last vestiges of the MAKE_PTR/MAKE_OFFSET mechanism. We haven'tTom Lane2008-11-02
| | | | | | | | | allowed different processes to have different addresses for the shmem segment in quite a long time, but there were still a few places left that used the old coding convention. Clean them up to reduce confusion and improve the compiler's ability to detect pointer type mismatches. Kris Jurka
* Remove all uses of the deprecated functions heap_formtuple, heap_modifytuple,Tom Lane2008-11-02
| | | | | | | | | | | and heap_deformtuple in favor of the newer functions heap_form_tuple et al (which do the same things but use bool control flags instead of arbitrary char values). Eliminate the former duplicate coding of these functions, reducing the deprecated functions to mere wrappers around the newer ones. We can't get rid of them entirely because add-on modules probably still contain many instances of the old coding style. Kris Jurka
* Move from strcmp to strncmp to be more tolerant for changes to the parser.Michael Meskes2008-11-01
|
* Use string component in index structure.Michael Meskes2008-11-01
|
* Do not eat memory even in case of an out-of-memory error.Michael Meskes2008-11-01
|
* Simplify ExecutorRun's API and save some trivial number of cycles by havingTom Lane2008-10-31
| | | | | | | it just return void instead of sometimes returning a TupleTableSlot. SQL functions don't need that anymore, and noplace else does either. Eliminating the return value also means one less hassle for the ExecutorRun hook functions that will be supported beginning in 8.4.
* Update FSM on WAL replay. This is a bit limited; the FSM is only updatedHeikki Linnakangas2008-10-31
| | | | | | | | | | | | | | | | | on non-full-page-image WAL records, and quite arbitrarily, only if there's less than 20% free space on the page after the insert/update (not on HOT updates, though). The 20% cutoff should avoid most of the overhead, when replaying a bulk insertion, for example, while ensuring that pages that are full are marked as full in the FSM. This is mostly to avoid the nasty worst case scenario, where you replay from a PITR archive, and the FSM information in the base backup is really out of date. If there was a lot of pages that the outdated FSM claims to have free space, but don't actually have any, the first unlucky inserter after the recovery would traverse through all those pages, just to find out that they're full. We didn't have this problem with the old FSM implementation, because we simply threw the FSM information away on a non-clean shutdown.
* Allow SQL-language functions to return the output of an INSERT/UPDATE/DELETETom Lane2008-10-31
| | | | | | | | | RETURNING clause, not just a SELECT as formerly. A side effect of this patch is that when a set-returning SQL function is used in a FROM clause, performance is improved because the output is collected into a tuplestore within the function, rather than using the less efficient value-per-call mechanism.
* Added missing ';'Michael Meskes2008-10-31
|
* Unite ReadBufferWithFork, ReadBufferWithStrategy, and ZeroOrReadBufferHeikki Linnakangas2008-10-31
| | | | | | | | | | | | functions into one ReadBufferExtended function, that takes the strategy and mode as argument. There's three modes, RBM_NORMAL which is the default used by plain ReadBuffer(), RBM_ZERO, which replaces ZeroOrReadBuffer, and a new mode RBM_ZERO_ON_ERROR, which allows callers to read corrupt pages without throwing an error. The FSM needs the new mode to recover from corrupt pages, which could happend if we crash after extending an FSM file, and the new page is "torn". Add fork number to some error messages in bufmgr.c, that still lacked it.
* Add test case for CREATE CAST.Heikki Linnakangas2008-10-31
|
* Add support for user-defined I/O conversion casts.Heikki Linnakangas2008-10-31
|
* Message improvementPeter Eisentraut2008-10-31
| | | | (also backported to 8.3)
* Revert previous patch to put the shared memory segment on win32Magnus Hagander2008-10-30
| | | | | | | | in the Global\ namespace, because it caused permission errors on a lot of platforms. We need to come up with something better for 8.4, but for now revert to the pre-8.3.4 behaviour.
* Update time zone data files to tzdata release 2008i (DST law changes inTom Lane2008-10-30
| | | | Argentina, Brazil, Mauritius, Syria).
* Fix recoveryLastXTime logic so that it actually does what one would expect.Tom Lane2008-10-30
| | | | Per gripe from Kevin Grittner. Backpatch to 8.3, where the bug was introduced.
* Move forgotten comment closer to where it matters.Peter Eisentraut2008-10-29
|
* Support for Sun Studio compiler on LinuxPeter Eisentraut2008-10-29
| | | | | | | This basically takes some build system code that was previously labeled "Solaris" and ties it to the compiler rather than the operating system. Author: Julius Stroffek <Julius.Stroffek@Sun.COM>
* Update on array features supportPeter Eisentraut2008-10-29
|
* Since SQL:2003, the array size specification in the SQL ARRAY syntax hasPeter Eisentraut2008-10-29
| | | | been optional.
* Unicode escapes in strings and identifiersPeter Eisentraut2008-10-29
|
* Be more tense about not creating tuplestores with randomAccess = true unlessTom Lane2008-10-29
| | | | | | | | backwards scan could actually happen. In particular, pass a flag to materialize-mode SRFs that tells them whether they need to require random access. In passing, also suppress unneeded backward-scan overhead for a Portal's holdStore tuplestore. Per my proposal about reducing I/O costs for tuplestores.