aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Move tablespace name up on to the same line in psql \d.Bruce Momjian2004-07-13
|
* Rename join ordering named join_1.outBruce Momjian2004-07-13
|
* Cause libpq and ecpg libraries to be built as proper shared librariesTom Lane2004-07-13
| | | | | | | | | | | | (.dylib format) on Mac OS X, while not messing up loadable modules for the backend (which are the same kind of animal as a shared library on every other platform, but not here). Also get the naming convention to match OS X practice, viz libFOO.version.so not libFOO.so.version. In support of that last, refactor code in Makefile.shlib to make it easier to have platform-specific shlib naming conventions. This patch is loosely based on the Fink project's current postgresql.patch. Tested by yours truly on OS X 10.3.4; does anyone have 10.2.* to check it on?
* Make installation instructions match reality.Peter Eisentraut2004-07-12
|
* Add tablespace location display for psql \d.Bruce Momjian2004-07-12
| | | | Gavin Sherry
* Add has_tablespace_privilege().Bruce Momjian2004-07-12
| | | | Christopher Kings-Lynne
* Add Win32-specific join ordering.Bruce Momjian2004-07-12
|
* Add blank line to new canonicalize_path file, which handles "a b\" properly.Bruce Momjian2004-07-12
|
* canonicalization adjustments.Bruce Momjian2004-07-12
|
* Put back canonicalization of PGDATA environment variable.Bruce Momjian2004-07-12
|
* Use strdup in pg_ctl for canonicalize_path on environment variable.Bruce Momjian2004-07-12
| | | | Simplify postmaster call too.
* This patch adds the following options to pg_dumpall, to be passed toBruce Momjian2004-07-12
| | | | | | | | | | | | | | pg_dump: -S, --superuser=NAME -O, --no-owner -X disable-dollar-quoting, --disable-dollar-quoting -X disable-triggers, --disable-triggers Christopher Kings-Lynne
* The attached patch, which incorporates the previous one sent andBruce Momjian2004-07-12
| | | | | | | | | | | | | | | | | | | | | currently unapplied regarding spi_internal.c, makes some additional fixes relating to return types, and also contains the fix for preventing the use of insecure versions of Safe.pm. There is one remaing return case that does not appear to work, namely return of a composite directly in a select, i.e. if foo returns some composite type, 'select * from foo()' works but 'select foo()' doesn't. We will either fix that or document it as a limitation. The function plperl_func_handler is a mess - I will try to get it cleaned up (and split up) in a subsequent patch, time permitting. Also, reiterating previous advice - this changes slightly the API for spi_exec_query - the returned object has either 2 or 3 members: 'status' (string) and 'proceesed' (int,- number of rows) and, if rows are returned, 'rows' (array of tuple hashes). Andrew Dunstan
* > win32 doesn't support a static initializer for mutexes, thus the firstBruce Momjian2004-07-12
| | | | | | | | | | | > user must initialize the lock. The problem are concurrent "first" users > - the pthread_mutex_t initialization must be synchronized. > The current implementation is broken, the attached patches fixes that: > mutex_initlock is a spinlock. If the pthread_mutex_t mutex is not > initialized, then the spinlock is acquired, if the pthread_mutex_t is > initialized if it's not yet initialized and then the spinlock is dropped. Manfred Spraul
* Back out thread fix until I get clarification.Bruce Momjian2004-07-12
|
* win32 doesn't support a static initializer for mutexes, thus the firstBruce Momjian2004-07-12
| | | | | | | | | | | | user must initialize the lock. The problem are concurrent "first" users - the pthread_mutex_t initialization must be synchronized. The current implementation is broken, the attached patches fixes that: mutex_initlock is a spinlock. If the pthread_mutex_t mutex is not initialized, then the spinlock is acquired, if the pthread_mutex_t is initialized if it's not yet initialized and then the spinlock is dropped. Manfred Spraul
* Remove TABLESPACE option of CREATE SEQUENCE; sequences will now alwaysTom Lane2004-07-12
| | | | | | | live in database or schema's default tablespace, as per today's discussion. Also, remove some unused keywords from the grammar (PATH, PENDANT, VERSION), and fix ALSO, which was added as a keyword but not added to the keyword classification lists, thus making it worse-than-reserved.
* New text.Bruce Momjian2004-07-12
|
* Fix library_path with canonicalization.Bruce Momjian2004-07-12
|
* Fix username mismatch in initdb. Magnus.Bruce Momjian2004-07-12
|
* Wording improvement.Bruce Momjian2004-07-12
|
* Tablespace examples for CREATE TABLE/INDEX/SCHEMA/DATABASE as well asBruce Momjian2004-07-12
| | | | | | some other examples for CREATE DATABASE. Gavin Sherry
* Move comma.Bruce Momjian2004-07-12
|
* The outer #define was forgotten. Attached patch adds it; please apply.Bruce Momjian2004-07-12
| | | | Alvaro
* Add:Bruce Momjian2004-07-12
| | | | > * Add session start time and last statement time to pg_stat_activity
* Added Matthew:Bruce Momjian2004-07-12
| | | | | | | < rather than in /contrib > rather than in /contrib (Matthew) 515a516 > * Matthew T. O'Connor <matthew@zeut.net>
* New Czech FAQ.Bruce Momjian2004-07-12
| | | | Pavel Stehule
* Add FAQ entry on hardware selection.Bruce Momjian2004-07-12
|
* Canonicalize preload_libraries after it is split up, not before.Bruce Momjian2004-07-12
|
* Remove:Bruce Momjian2004-07-11
| | | | < * Allow moving sequences and toast tables to other tablespaces
* Cleanup for canonicalization fixes, from Tom.Bruce Momjian2004-07-11
|
* Add:Bruce Momjian2004-07-11
| | | | > * Allow moving sequences and toast tables to other tablespaces
* This patch fixes a small error in the Porting PL/SQL to PL/pgSQLBruce Momjian2004-07-11
| | | | | | | section where a instr function parameter is mistyped as varchar. It works properly when changed to integer. Michael Glaesemann
* Example for create function using argument namesBruce Momjian2004-07-11
| | | | Gavin Sherry
* ALTER TABLE SET TABLESPACE. Gavin Sherry, some rework by Tom Lane.Tom Lane2004-07-11
|
* Update German FAQ>Bruce Momjian2004-07-11
|
* Update URL's for mysql conversion tools.Bruce Momjian2004-07-11
|
* Add:Bruce Momjian2004-07-11
| | | | > * Add NOVICE output level for helpful messages like automatic sequence/index creation
* Remove postgresql.conf of 'info' as a valid client_min_messages level.Bruce Momjian2004-07-11
|
* Use canonicalize_path for -D, GUC paths, and paths coming in fromBruce Momjian2004-07-11
| | | | environment variables.
* Move TablespaceCreateDbspace() call into smgrcreate(), which is where itTom Lane2004-07-11
| | | | | | | | | | | | probably should have been to begin with; this is to cover cases like needing to recreate the per-db directory during WAL replay. Also, fix heap_create to force pg_class.reltablespace to be zero instead of the database's default tablespace; this makes the world safe for CREATE DATABASE to handle all tables in the default tablespace alike, as per previous discussion. And force pg_class.reltablespace to zero when creating a relation without physical storage (eg, a view); this avoids possibly having dangling references in this column after a subsequent DROP TABLESPACE.
* Rename XLOG_BTREE_NEWPAGE xlog record type into XLOG_HEAP_NEWPAGE, andTom Lane2004-07-11
| | | | | | | | | | shift support code into heapam.c accordingly. This is in service of soon-to-be-committed ALTER TABLE SET TABLESPACE code that will want to use this same record type for both heaps and indexes. Theoretically I should have forced initdb for this, but in practice there is no change in xlog contents because CVS tip will never really emit this record type anyhow...
* Use standard macro for psql binary file open. Add comment explainingBruce Momjian2004-07-11
| | | | control-z requirement.
* Cause the format of BC timestamptz output to be 'datetime zone BC' ratherTom Lane2004-07-11
| | | | | | | than 'datetime BC zone', because the former is accepted by the timestamptz input converter while the latter may not be depending on spacing. This is not a loss of compatibility w.r.t. 7.4 and before, because until very recently there was never a case where we'd output both zone and 'BC'.
* Add:Bruce Momjian2004-07-11
| | | | > * Allow moving system tables to other tablespaces, where possible
* Fix trim_trailing_separator() to not trim c:\ nor \\network\ on Win32.Bruce Momjian2004-07-11
|
* Add:Bruce Momjian2004-07-11
| | | | > * Allow changing of already-created database and schema tablespaces
* Open files in binary mode on Win32 so control-z isn't seen as EOF.Bruce Momjian2004-07-11
|
* Add:Bruce Momjian2004-07-11
| | | | > * Add an option to sync() before fsync()'ing checkpoint files
* Add:Bruce Momjian2004-07-11
| | | | | | < > * Use a phantom command counter for nested subtransactions to reduce > tuple overhead
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-06 03:25:42 +0000