summaryrefslogtreecommitdiff
path: root/doc
Commit message (Collapse)AuthorAgeFilesLines
* Fix erroneous direct reference to postgres.tar.gz, per bug reportTom Lane2003-08-041-2/+2
| | | | from Garrick Staples.
* Add a note that AND and OR are commutative. Apparently, they are not inPeter Eisentraut2003-08-042-3/+11
| | | | certain other products.
* Remove --enable-recode feature, since it's been broken by IPv6 changes,Tom Lane2003-08-042-93/+4
| | | | and seems to have too few users to justify maintaining.
* Remove docs that say psql \encoding doesn't track SET client_encoding.Bruce Momjian2003-08-021-8/+1
|
* Update, add Greg:Bruce Momjian2003-08-011-4/+5
| | | | | | | | < * Fernando Nasser <fnasser@redhat.com> of Red Hat < * Gavin Sherry <swm@linuxworld.com.au> of Alcove Systems Engineering > * Fernando is Fernando Nasser <fnasser@redhat.com> of Red Hat > * Gavin is Gavin Sherry <swm@linuxworld.com.au> of Alcove Systems Engineering > * Greg is Greg Sabino Mullane <greg@turnstep.com>
* Add:Bruce Momjian2003-08-011-3/+3
| | | | | < > o Allow PL/pgSQL EXECUTE query_var INTO record_var;
* Make ecpg SQLSTATE-aware. Map existing SQLCODE assignments to SQLSTATEs,Peter Eisentraut2003-08-011-198/+953
| | | | | rather than parsing the message. Add some documentation about embedded SQL.
* --enable-thread-safeness -> --enable-thread-safetyBruce Momjian2003-08-013-6/+6
|
* Improve description of restoring pg_dumpall backups, per gripe fromTom Lane2003-08-011-8/+13
| | | | Havard Eidnes.
* Very minor editing.Tom Lane2003-07-311-3/+4
|
* Cause library-preload feature to report error if specified initializationTom Lane2003-07-311-15/+21
| | | | | function is not found. Also, make all the PL libraries have initialization functions with standard names. Patch from Joe Conway.
* Modify:Bruce Momjian2003-07-311-3/+3
| | | | > * Implement dirty reads or shared row locks and use them in RI triggers
* Modify:Bruce Momjian2003-07-311-3/+3
| | | | > * Implement dirty reads or shared locks and use them in RI triggers
* contraints -> constraintsBruce Momjian2003-07-311-2/+2
| | | | Rod Taylor
* Update Turkish FAQ, Devrim GUNDUZBruce Momjian2003-07-312-1955/+2320
|
* Add fflush of stdout when outputing query.Bruce Momjian2003-07-311-2/+2
|
* Add pretty-printing variants of pg_get_viewdef and related functions.Tom Lane2003-07-301-6/+57
| | | | Patch from Andreas Pflug.
* Add:;Bruce Momjian2003-07-301-2/+3
| | | | > * Allow server log information to be output as INSERT statements
* Modify:Bruce Momjian2003-07-301-3/+3
| | | | > * Allow log lines to include session-level information, like database and user
* Add:Bruce Momjian2003-07-301-2/+3
| | | | > * Add database name and user name to logging options
* Apply (a somewhat revised version of) Greg Mullane's patch to eliminateTom Lane2003-07-298-125/+121
| | | | | | | | | heuristic determination of day vs month in date/time input. Add the ability to specify that input is interpreted as yy-mm-dd order (which formerly worked, but only for yy greater than 31). DateStyle's input component now has the preferred spellings DMY, MDY, or YMD; the older keywords European and US are now aliases for the first two of these. Per recent discussions on pgsql-general.
* Rename psql's VERBOSE variable to VERBOSITY, per suggestion from Bruce.Tom Lane2003-07-281-2/+2
|
* Move ERRCODE_XXX macros into their own header file.Tom Lane2003-07-271-8/+20
|
* elog mop-up.Tom Lane2003-07-271-7/+8
|
* > Joe Conway <mail@joeconway.com> writes:Bruce Momjian2003-07-271-3/+34
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | >>ISTM that "source" is worth knowing. > > Hm, possibly. Any other opinions? This version has the seven fields I proposed, including "source". Here's an example that shows why I think it's valuable: regression=# \x Expanded display is on. regression=# select * from pg_settings where name = 'enable_seqscan'; -[ RECORD 1 ]----------- name | enable_seqscan setting | on context | user vartype | bool source | default min_val | max_val | regression=# update pg_settings set setting = 'off' where name = 'enable_seqscan'; -[ RECORD 1 ]--- set_config | off regression=# select * from pg_settings where name = 'enable_seqscan'; -[ RECORD 1 ]----------- name | enable_seqscan setting | off context | user vartype | bool source | session min_val | max_val | regression=# alter user postgres set enable_seqscan to 'off'; ALTER USER (log out and then back in again) regression=# \x Expanded display is on. regression=# select * from pg_settings where name = 'enable_seqscan'; -[ RECORD 1 ]----------- name | enable_seqscan setting | off context | user vartype | bool source | user min_val | max_val | In the first case, enable_seqscan is set to its default value. After setting it to off, it is obvious that the value has been changed for the session only. In the third case, you can see that the value has been set specifically for the user. Joe Conway
* here are the patches for psql on Win32:Bruce Momjian2003-07-271-1/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | psql4win32.patch - changes in the psql source code psql-ref.patch - changes in the documentation psql-ref.sgml (for new builtin variable WIN32_CONSOLE) To apply them use "patch -p 1" in the root directory of the postgres source directory. These patches fix the following problems of psql on Win32 (all changes only have effect #ifdef WIN32): a) Problem: Static library libpq.a did not work Solution: Added WSAStartup() in fe-connect.c b) Problem: Secret Password was echoed by psql Solution: Password echoing disabled in sprompt.c c) Problem: 8bit characters were displayed/interpreted wrong in psql This is due to the fact that the Win32 "console" uses a different encoding than the rest of the Windows system Solution: Introduced a new psql variable WIN32_CONSOLE When set with "\set WIN32_console", the function OemToChar() is applied after reading input and CharToOem() before displaying Output Christoph Dalitz
* At long last I put together a patch to support 4 client SSL negotiationBruce Momjian2003-07-262-11/+77
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | modes (and replace the requiressl boolean). The four options were first spelled out by Magnus Hagander <mha@sollentuna.net> on 2000-08-23 in email to pgsql-hackers, archived here: http://archives.postgresql.org/pgsql-hackers/2000-08/msg00639.php My original less-flexible patch and the ensuing thread are archived at: http://dbforums.com/t623845.html Attached is a new patch, including documentation. To sum up, there's a new client parameter "sslmode" and environment variable "PGSSLMODE", with these options: sslmode description ------- ----------- disable Unencrypted non-SSL only allow Negotiate, prefer non-SSL prefer Negotiate, prefer SSL (default) require Require SSL The only change to the server is a new pg_hba.conf line type, "hostnossl", for specifying connections that are not allowed to use SSL (for example, to prevent servers on a local network from accidentally using SSL and wasting cycles). Thus the 3 pg_hba.conf line types are: pg_hba.conf line types ---------------------- host applies to either SSL or regular connections hostssl applies only to SSL connections hostnossl applies only to regular connections These client and server options, the postgresql.conf ssl = false option, and finally the possibility of compiling with no SSL support at all, make quite a range of combinations to test. I threw together a test script to try many of them out. It's in a separate tarball with its config files, a patch to psql so it'll announce SSL connections even in absence of a tty, and the test output. The test is especially informative when run on the same tty the postmaster was started on, so the FATAL: errors during negotiation are interleaved with the psql client output. I saw Tom write that new submissions for 7.4 have to be in before midnight local time, and since I'm on the east coast in the US, this just makes it in before the bell. :) Jon Jensen
* Done:Bruce Momjian2003-07-251-3/+3
| | | | > * -Allow SSL-enabled clients to turn off SSL transfers
* Add mention of new SSL capabilities.Bruce Momjian2003-07-252-8/+17
|
* Error message editing in backend/utils (except /adt).Tom Lane2003-07-251-2/+1
|
* Begin improving markup of (past) release notes.Peter Eisentraut2003-07-251-1036/+941
|
* Add to 7.3.4 release notes:Bruce Momjian2003-07-241-1/+2
| | | | * Repair breakage in timestamp-to-date conversion for dates before 2000
* New WAL fix release text is:Bruce Momjian2003-07-231-2/+2
| | | | Prevent rare possibility of server startup failure (Tom)
* Mention increasing sort_mem during a restore.Bruce Momjian2003-07-231-2/+4
|
* Add:Bruce Momjian2003-07-231-2/+3
| | | | > * Add GUC variable to prevent waiting on locks
* Rename --with-threads to --enable-thread-safeness, per Peter.Bruce Momjian2003-07-233-8/+9
|
* Update German FAQ.Bruce Momjian2003-07-232-10/+10
|
* Update FAQ.Bruce Momjian2003-07-232-4/+4
| | | | Ian Barwick
* Just a spot of copy-editing.Tom Lane2003-07-231-9/+10
|
* Update to 7.3.4 as newest release.Bruce Momjian2003-07-232-4/+4
|
* Stamp 7.3.4.Bruce Momjian2003-07-231-1/+42
|
* Add GUC parameter to control rendezvous name.Bruce Momjian2003-07-221-1/+11
|
* Error message editing in backend/libpq, backend/postmaster, backend/tcop.Tom Lane2003-07-221-1/+8
| | | | | Along the way, fix some logic problems in pgstat_initstats, notably the bogus assumption that malloc returns zeroed memory.
* Add:Bruce Momjian2003-07-221-2/+5
| | | | > o Allow PL/pgSQL to name columns by ordinal position, e.g. rec.(3)
* Add:Bruce Momjian2003-07-221-2/+3
| | | | > * Prevent COMMENT ON DATABASE from using a database name
* Add:Bruce Momjian2003-07-211-2/+3
| | | | > o Add PL/PHP (Joe, Jan)
* Add:Bruce Momjian2003-07-211-2/+4
| | | | | > * Have AFTER triggers execute after the appropriate SQL statement in a > function, not at the end of the function
* I updated Japanese translation of PostgreSQL FAQBruce Momjian2003-07-212-1293/+1198
| | | | | | | according to your version on May/30. (HTML and TEXT files are gzipped.) Jun Kuwamura
* Update URL's.Bruce Momjian2003-07-202-4/+4
|
* Done:Bruce Momjian2003-07-201-3/+3
| | | | * -Allow LIMIT/OFFSET to use expressions (Tom)
View Lorry Controller Status