aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Update sequence_1.out for recent changes in sequence regression test.Tom Lane2011-01-06
|
* Update documentation to say that \lo_import sets :LASTOID, notBruce Momjian2011-01-05
| | | | lo_insert.
* Rename pg_upgrade variables, for clarity.Bruce Momjian2011-01-05
|
* Update pg_upgrade C comments.Bruce Momjian2011-01-05
|
* Fix for recent pg_upgrade commit to fix large objects relfilenodeBruce Momjian2011-01-05
| | | | handling. (metadata user ids still an open issue).
* In pg_upgrade, adjust transfer_relfile()'s parameters to be more logical.Bruce Momjian2011-01-05
|
* Clarify pg_upgrade's creation of the map file structure. Also cleanBruce Momjian2011-01-05
| | | | up pg_dump's calling of pg_upgrade_support functions.
* Give superusers REPLIACTION permission by defaultMagnus Hagander2011-01-05
| | | | | | | This can be overriden by using NOREPLICATION on the CREATE ROLE statement, but by default they will have it, making it backwards compatible and "less surprising" (given that superusers normally override all checks).
* In pg_upgrade, copy pg_largeobject_metadata and its index for 9.0+Bruce Momjian2011-01-04
| | | | | servers because, like pg_largeobject, it is a system table whose contents are not dumped by pg_dump --schema-only.
* In pg_upgrade, fix backward logging display of link operations.Bruce Momjian2011-01-04
|
* Simplify functions and parameters used by pg_upgrade.Bruce Momjian2011-01-04
|
* Improve psql tab completion for CREATE/ALTER ROLE [NO]REPLICATION.Itagaki Takahiro2011-01-04
| | | | Missing support for VALID UNTIL in CREATE ROLE is also added.
* Fix crash in ALTER OPERATOR CLASS/FAMILY .. SET SCHEMA.Robert Haas2011-01-03
| | | | | | | In the previous coding, the parser emitted a List containing a C string, which is no good, because copyObject() can't handle it. Dimitri Fontaine
* Update comments in RecordTransactionCommit() to mention unlogged tables.Robert Haas2011-01-03
|
* Bump catversion, forgot in previous commit.Magnus Hagander2011-01-03
|
* Add views and functions to monitor hot standby query conflictsMagnus Hagander2011-01-03
| | | | | Add the view pg_stat_database_conflicts and a column to pg_stat_database, and the underlying functions to provide the information.
* Add missing part of replication role docsMagnus Hagander2011-01-03
| | | | Noted by Peter E.
* perltidy run on the MSVC build systemMagnus Hagander2011-01-03
| | | | | Forgot this with previuos commit, line it up so it's easier to submit (readable) patches against the MSVC build system.
* Implement remaining fields of information_schema.sequences viewPeter Eisentraut2011-01-02
| | | | | | | | | Add new function pg_sequence_parameters that returns a sequence's start, minimum, maximum, increment, and cycle values, and use that in the view. (bug #5662; design suggestion by Tom Lane) Also slightly adjust the view's column order and permissions after review of SQL standard.
* Fix typo.Robert Haas2011-01-02
| | | | Noted by Magnus Hagander.
* Basic foreign table support.Robert Haas2011-01-01
| | | | | | | | | | | Foreign tables are a core component of SQL/MED. This commit does not provide a working SQL/MED infrastructure, because foreign tables cannot yet be queried. Support for foreign table scans will need to be added in a future patch. However, this patch creates the necessary system catalog structure, syntax support, and support for ancillary operations such as COMMENT and SECURITY LABEL. Shigeru Hanada, heavily revised by Robert Haas
* Minor wordsmithing.Robert Haas2011-01-01
| | | | As suggested by Tom Lane, in response to a gripe from Leslie S Satenstein.
* Fix pg_dump support for security labels on columns.Robert Haas2011-01-01
| | | | Along the way, correct an erroneous comment.
* Allow casting a table's row type to the table's supertype if it's a typed tablePeter Eisentraut2011-01-01
| | | | | This is analogous to the existing facility that allows casting a row type to a supertable's row type.
* Add #include <time.h> to pg_ctl.c to fix compiler warning.Bruce Momjian2011-01-01
|
* Stamp copyrights for year 2011.Bruce Momjian2011-01-01
|
* Furter pg_upgrade optimizations to reduce function call argument count.Bruce Momjian2011-01-01
|
* In pg_upgrade, remove use of whichCluster, and just pass old/new clusterBruce Momjian2011-01-01
| | | | | | | pointers, which simplifies the code. This was not possible in 9.0 because everything was in a single nested struct, but is possible now. Per suggestion from Tom.
* In pg_upgrade, rename "CLUSTERNAME" to "CLUSTER_NAME".Bruce Momjian2010-12-31
|
* Include the first valid listen address in pg_ctl to improve server startBruce Momjian2010-12-31
| | | | | "wait" detection and add postmaster start time to help determine if the postmaster is actually using the specified data directory.
* Invert and rename flag variable to improve code readability.Tom Lane2010-12-31
| | | | No change in functionality. Per discussion with Robert.
* Move symbols for ExecMergeJoin's state machine into nodeMergejoin.c.Tom Lane2010-12-30
| | | | | There's no reason for these values to be known anywhere else. After doing this, executor/execdefs.h is vestigial and can be removed.
* Support RIGHT and FULL OUTER JOIN in hash joins.Tom Lane2010-12-30
| | | | | | | | | | | | | | | | | | | | | | This is advantageous first because it allows us to hash the smaller table regardless of the outer-join type, and second because hash join can be more flexible than merge join in dealing with arbitrary join quals in a FULL join. For merge join all the join quals have to be mergejoinable, but hash join will work so long as there's at least one hashjoinable qual --- the others can be any condition. (This is true essentially because we don't keep per-inner-tuple match flags in merge join, while hash join can do so.) To do this, we need a has-it-been-matched flag for each tuple in the hashtable, not just one for the current outer tuple. The key idea that makes this practical is that we can store the match flag in the tuple's infomask, since there are lots of bits there that are of no interest for a MinimalTuple. So we aren't increasing the size of the hashtable at all for the feature. To write this without turning the hash code into even more of a pile of spaghetti than it already was, I rewrote ExecHashJoin in a state-machine style, similar to ExecMergeJoin. Other than that decision, it was pretty straightforward.
* Remove tabs in SGMLPeter Eisentraut2010-12-30
|
* Avoid unnecessary public struct declaration in slru.hAlvaro Herrera2010-12-30
| | | | | | | | Instead, declare a public wrapper of the sole function using it for external callers, so that they don't have to always pass a NULL argument. Author: Kevin Grittner
* Doc wording improvement: taken -> acceptedBruce Momjian2010-12-29
| | | | with time zone</type>.) <type>timestamptz</type> is accepted as an
* Improve pg_upgrade's checks for required executables.Tom Lane2010-12-29
| | | | | | | | | | | | | | Don't insist on pg_dumpall and psql being present in the old cluster, since they are not needed. Do insist on pg_resetxlog being present (in both old and new), since we need it. Also check for pg_config, but only in the new cluster. Remove the useless attempt to call pg_config in the old cluster; we don't need to know the old value of --pkglibdir. (In the case of a stripped-down migration installation there might be nothing there to look at anyway, so any future change that might reintroduce that need would have to be considered carefully.) Per my attempts to build a minimal previous-version installation to support pg_upgrade.
* Bump XLOG_PAGE_MAGIC.Robert Haas2010-12-29
| | | | | | The unlogged tables patch (commit 53dbc27c62d8e1b6c5253feba04a5094cb8fe046, 2010-12-29) should have done this, since it changes the format of an XLOG_SMGR_CREATE record.
* Support unlogged tables.Robert Haas2010-12-29
| | | | | | | The contents of an unlogged table are WAL-logged; thus, they are not available on standby servers and are truncated whenever the database system enters recovery. Indexes on unlogged tables are also unlogged. Unlogged GiST indexes are not currently supported.
* Add REPLICATION privilege for ROLEsMagnus Hagander2010-12-29
| | | | | | | | | | | This privilege is required to do Streaming Replication, instead of superuser, making it possible to set up a SR slave that doesn't have write permissions on the master. Superuser privileges do NOT override this check, so in order to use the default superuser account for replication it must be explicitly granted the REPLICATION permissions. This is backwards incompatible change, in the interest of higher default security.
* Avoid unexpected conversion overflow in planner for distant date values.Tom Lane2010-12-28
| | | | | | | | | | | | | | The "date" type supports a wider range of dates than int64 timestamps do. However, there is pre-int64-timestamp code in the planner that assumes that all date values can be converted to timestamp with impunity. Fortunately, what we really need out of the conversion is always a double (float8) value; so even when the date is out of timestamp's range it's possible to produce a sane answer. All we need is a code path that doesn't try to force the result into int64. Per trouble report from David Rericha. Back-patch to all supported versions. Although this is surely a corner case, there's not much point in advertising a date range wider than timestamp's if we will choke on such values in unexpected places.
* Reclassify DEFAULT as a column_constraint item in the CREATE TABLE syntax.Tom Lane2010-12-28
| | | | | | | | | | | | | | This is how it was documented originally, but several years ago somebody decided that DEFAULT isn't a type of constraint. Well, the grammar thinks it is. The documentation was wrong in two ways: it alleged that DEFAULT had to appear before any other kind of constraint, and it alleged that you can't prefix a DEFAULT clause with a "CONSTRAINT name" clause, when in fact you can. (The latter behavior probably isn't SQL-standard, but our grammar has always allowed it.) This patch responds to Fujii Masao's observation that the ALTER TABLE documentation mistakenly implied that you couldn't include DEFAULT in ALTER TABLE ADD COLUMN; though this isn't the way he proposed fixing it.
* No release notes update, just advance the dateREL9_1_ALPHA3Peter Eisentraut2010-12-28
|
* Fix ill-advised placement of PGRES_COPY_BOTH enum value.Tom Lane2010-12-28
| | | | | It must be added at the end of the ExecStatusType enum to avoid ABI breakage compared to previous libpq versions. Noted by Magnus.
* Another fix for larger postmaster.pid files.Bruce Momjian2010-12-28
|
* Fix list of functions that are restricted to superusersMagnus Hagander2010-12-28
| | | | | Move the list of what's restricted to superusers into the table itself, so it doesn't get missed again.
* Fix code to properly pull out shared memory key now that theBruce Momjian2010-12-27
| | | | | postmaster.pid file is larger than in previous major versions. This is a bug introduced when I added lines to the file recently.
* Mark unaccent functions as STABLE, rather than defaulting to VOLATILE.Bruce Momjian2010-12-27
|
* Update SGML docs describing the contents of the postmaster.pid file,Bruce Momjian2010-12-27
| | | | per change to the file for pg_ctl.
* Remove -fno-operator-names switch from cpluspluscheck.Tom Lane2010-12-27
| | | | No longer needed now that bitand() and bitor() have been renamed.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 02:03:55 +0000