CVS log for pgsql/doc/Attic/FAQ

Up to [PostgreSQL CVS Repository] / pgsql / doc

Request diff between arbitrary revisions - Display revisions graphically

Keyword substitution: kv
Default branch: MAIN

Remove FAQ and FAQ_DEV ASCII and HTML files from CVS;  now on the wiki.

Per-language files kept for transator usage.

Update copyright for 2009.

Mention battery-backed cache under hardware selection options.

Update link to developer's FAQ from main FAQ.

Add new SQL training web site to FAQ:

    <LI><A href=
    "http://sqlzoo.net">http://sqlzoo.net</A>
    </LI>

More FAQ URL updates from Curtis Gallant.

Update FAQ URLs as suggested by Curtis Gallant.

Update wording from David Fetter.

Update to remove passive wording from FAQ, David Fetter

Add embedded usage mention to FAQ, per Greg Smith.

Update most recent release to 8.3.1.

Update text FAQ.

Remove mention of the Berkeley origins of the alias "Postgres" ---
seems unnecessary to mention in the FAQ, per discussion on IRC.

Fix markup.

Add new FAQ item:

    <H3 id="item1.15">1.15) How do I unsubscribe from the
    PostgreSQL email lists?  How do I avoid receiving duplicate
    emails?</H3>

Update FAQ for most recent release as 8.3.

Most recent Postgres version is 8.2.6, per report from Robert Treat.

Update copyrights in source tree to 2008.

FAQ wording and markup fix.

Euler Taveira de Oliveira

Simplify wording.

Add FAQ items about "Postgres" alias usage, remove old reference.

Markup cleanup.

Remove reference to gborg, instead reference pgfoundry.

Clarify restart is of the "database" server, in FAQ.

Remove use of "Postgres" aliases in the FAQ in second-in-paragraph
cases.

Re-add FAQ item:

    <H3 id="item4.19">4.19) Why do I get "relation with OID #####
    does not exist" errors when accessing temporary tables in PL/PgSQL
    functions?</H3>

Attached some minor corrections, mainly completion of removal of
the  "relation with OID ##### does not exist" item, and some URL
corrections.

Ian Barwick

Add mention of full text indexing for word searches.

Remove FAQ item about temp tables in plpsql having invalid oid problems,
per suggestions from Pavel Stehule.

Update sequence FAQ items, per suggestion from Pavel Stehule.

Typo fix.

Euler Taveira de Oliveira

Clarify user of "postmaster" vs. "server" in FAQs.

Brendan Jurd

Lowercase all mentions of "PostgreSQL" in URLs, per Magnus.

Rename "PostgreSQL" to "Postgres" in 7 places in the FAQ.

Fix markup.

Update pronunciation FAQ item.

Update to mention alternate project name is "Postgres".

Stamp releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20.

Update FAQs for 8.2.5.

Stamp releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20.

Update FAQs for 8.2.5.

Stamp releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20.

Update FAQs for 8.2.5.

Stamp releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20.

Update FAQs for 8.2.5.

Stamp releases 8.2.5, 8.1.10, 8.0.14, 7.4.18, 7.3.20.

Update FAQs for 8.2.5.

Upcoming most recent release will be 8.2.5.

Fix typo.

Update FAQ item:

   <H3 id="item3.6">3.6) What is the upgrade process for
   PostgreSQL?</H3>

to reference both versioning and specific upgrade instructions.

Remove duplicate text, per Magnus.

Update FAQ to mention most recent release for releases
8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19.

Update FAQ to mention most recent release for releases
8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19.

Update FAQ to mention most recent release for releases
8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19.

Update FAQ to mention most recent release for releases
8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19.

Stamp releases 8.2.4, 8.1.9, 8.0.13, 7.4.17, 7.3.19.

Update FAQ for 8.2.4.

Re-add FAQ item 3.7 which was accidentally removed in previous commit:

    <H3 id="item3.7">3.7) What computer hardware should I use?</H3>

In FAQ, reference upgrade info via URL.

Update upgrade FAQ info.

Update upgrade wording.

Update FAQ about minor updates.

Fix typo, per Dave Page.

Update minor release text.

Update upgrade text.

Update URL for set-returning functions.

Update FAQ for new 24-byte header, down from 28.

Update FAQ for 8.2.3.

Update for 8.2.3.

Backpatch FAQs to 8.2.X branch.

Update for 8.2.2 as most recent release.

Update workding for daylight savings time.

Update timezone FAQ item:

    <P>USA saving time changes are included in PostgreSQL release 8.0.[4+],
    and all later major releases, e.g. 8.1.  Canada and Western Australia
    changes are included in 8.0.[10+], 8.1.[6+], and all later major
    releases.  PostgreSQL releases prior to 8.0 use the operating system's
    timezone database for daylight saving information.</P>

Backpatch FAQs to stable branch.

Add FAQ item about timezones and daylight savings time.

Update CVS HEAD for 2007 copyright.  Back branches are typically not
back-stamped for this.

Stamp release 8.2.1.  Update FAQs.

Stamp release 8.1.6.

Stamp release 8.0.10.

Stamp release 7.4.15.

Stamp release 7.3.17.

Update for release 8.2.1.

Backpatch FAQ entry for null concatenation.

Remove blank lines in HTML FAQ.

Add FAQ entry to mention using COALESCE() for concatenation of possible
NULLs.

Make URL to docs use /current/.

Update 8.2.X release to say 8.2.0 instead of just 8.2.

Update most recent version from 8.2 to 8.2.0.

Update for release 8.2.

Mention OIDs are now not created by default.

Add capitalization mention.

FAQ updates --- This is a small cosmetic patch that adds pt_BR IRC
channel to the lists of IRC channels, fixes a typo in the OID's
question, and corrects the PGCluster's project name.

Euler Taveira de Oliveira

Backpatch FAQs to 8.1.X.

Update FAQ for latest release 8.1.5.

Stamp releases 7.3.16, 7.4.14, 8.0.9, and 8.1.5.

Stamp releases 7.3.16, 7.4.14, 8.0.9, and 8.1.5.

Stamp releases 7.3.16, 7.4.14, 8.0.9, and 8.1.5.

Stamp releases 7.3.16, 7.4.14, 8.0.9, and 8.1.5.

Add space before SP4.

Update Win2000SP4 mention.

Update for company URL.

Ian Barwick

Reverse order of performance guides so powerpostgresql is first.

Update my email address.

Spelling fix.

Robert Treat

Update GUI FAQ.

Robert Treat

Update GUI tools URL.

Robert Treat

New wording, "What is the upgrade process for PostgreSQL?"

Update heading for upgrades.

Add mention that everyone should upgrade to minor releases.

Stamp releases 7.3.15, 7.4.13, and 8.0.8.

Stamp releases 7.3.15, 7.4.13, and 8.0.8.

Stamp releases 7.3.15, 7.4.13, and 8.0.8.

Stamp 8.1.4, except configure/configure.in.

Update for version 8.1.4.

Backpatch FAQs to 8.1.X.

Fix HTML markup.

Update tutorial URL's.

Update URL for SQL tutorial.

Update AIX FAQ:

At any rate, here's a revision to CVS HEAD to reflect some changes by
myself and by Seneca Cunningham for the AIX FAQ.  It touches on the
following issues:

1.  memcpy pointer patch for dynahash.c

2.  AIX memory management, which can, for 32 bit cases, bite people
    quite unexpectedly...

Chris Browne

Add, "How do I submit a patch" FAQ item.

Add second sentence:
    <P>The maximum table size, row size, and maximum number of columns
    can be quadrupled by increasing the default block size to 32k.  The
    maximum table size can also be increased using table partitioning.</P>

Update AIX FAQ to show readline options more clearly.

Backpatch FAQ's to 8.1.X.

Update for max row size.

Update max row size to 400gb, per Tom.

Update copyright for 2006.  Update scripts.

Fix computation of sample table size.

Fix computation of sample table size.

Backpatch FAQ changes to 8.1.X.

Remove mention of MIN/MAX() not using indexes.

Update FAQ latest version

Update FAQ latest version

Update FAQ latest version

Stamp 8.1.3, but exclude configure.in/configure change.

Update for 8.1.3.

Stamp release 8.1.2.

Stamp relesae 8.0.6.

Stamp release 7.4.11.

Stamp release 7.3.13.

Update version number.

Stamp 8.1.1.

Update for 8.1.1.

Update 8.1.X FAQs.

Update most recent version number.

Update wording and cleanup for new items.

Markup TODO as a URL.

Update item tags.

Change to using "id=" HTML tags instead of "name=" tags.

Update FAQ to explain process of submitting bug and feature requests.

Reorder "who controls PostgreSQL" to near the top.

Reorder version FAQ item to be right after "how do I get the software".

Clarify copyright wording.

Reorder bug items.

Backpatch FAQ's for 8.0.X.

Update FAQ for most recent release as 8.1.

Update version number in faq.

Update FAQ for version number.

Update FAQ's in 8.0.X branch.  (very small changes)

Update SQL conformance mention to 2003.

Update FAQ's in 8.0.X branch.

Update numbering.

Michael Fuhr

8.0.3 is now the most recent version.

Update disk space computation because oids are now optional.

Update MD5 mention for long values.

Add new FAQ information.

Martijn van Oosterhout

Add mp3 entry to FAQ.

Update Russian FAQ.

Viktor Vislobokov

Add missing <P>.

Backpatch FAQ's to 8.0.X for release.

Remove encryption FAQ item now that we have a doc section.

Update "control" item.
Rosser Schwarz

Typo fix, Dave Held

Add FAQ on who controls the project.

Update FAQ.

Update replication FAQ.

Christopher Browne

Update wording.

Clean up HTML.

Add replication FAQ item.

Add line break.

Update book items.

Update FAQ by eliminating non-frequent items like large objects and
extending questions.  Update wording of various entries.

Update H4 tag to H3 to be consistent with heading levels.

Update FAQ items to point to existing web pages rather than duplication
such information.  Remove MySQL mention.  Move server-side debug item to
developer's FAQ.  Update URLs.

Update FAQ release number to 8.0.2.

Backpatch FAQ's to 8.0.X.

Update to 8.0.1.

Here's the patch to fix a lot of markup errors in the HTML FAQs. Doesn't
change content (at least not supposed to).

Magnus Hagander

Here's the patch to fix a lot of markup errors in the HTML FAQs. Doesn't
change content (at least not supposed to).

Magnus Hagander

Fix plpgsql error message for dropped temporary tables.

Updatge wording.

Backpatch FAQ to 8.0.X.

Fix markup.

Fix HTML markup and add NULL sorting item to existing NULL FAQ item.

Greg Sabino Mullan

Update question text:

    <H4><A name="4.20">4.20</A>) Why do I get "missing oid" errors when
    accessing temporary tables in PL/PgSQL functions?</H4>

Merlin Moncure

Update Momjain book URL.

Update URL for Momjian book.

Backpatch FAQ to 8.0.X.

Update FAQ numbering.

Backpatch FAQ to 8.0.X.

Remove pgsql_tmp directory FAQ item.

Add Josh's performance page.

Backpatch FAQ changes to 8.0.X.

Final FAQ cleanups to remove information about very old releases.

Remove outer join simulation using UNION now that we have had outer
joins for quite a long time.

Remove FAQ about database terms.

Remove FAQ mention of DROP column.

Update LIMIT/FETCH FAQ item.

Update connections FAQ item.

Fix markup typo.

Update debeug FAQ.

Restructure debug FAQ entry.

Reorganize FAQ entry on performance.

Update admin tools FAQ.

Update PHP mention.

Remove "Support" FAQ item.  We now have a tab on our web site.

Wording improvement.

Reorder support FAQ items.

Update section to mention developer's FAQ.

Mention releases are every 10-12 months now.

Simplify FAQ item about obtaining support.

Clarify license FAQ item.

Modernize the FAQ item "What is PostgreSQL" to skip most historical
information.

Backpatch FAQ to 8.0.X.

Update FAQ text file.

Backpatch FAQ to 8.0.X.

Fix ampersand in URL.

Backpatch FAQ changes to 8.0.X.

Remove IN/slow FAQ item because it only applies to <=7.3.X.

Remove GEQO and Rtree FAQ items.

More index item rewording.kUpdate FAQ.

Reword index/slow query item.

Remove FAQ item about binary cursors.

Remove FAQ items about IPC errors.  We now report the help description
right in the failure.  We can always re-add it if required.

Merge two Interfaces FAQ items into one.

Merge unix and non-unix platform faq items, and remove Y2K item.

Update OID item description.

Mention Rekall is GPL now.

Document that Rekall is GPL now.

Fix typo.

Fix typo.

Spelling fix.

Mention ALTER COLUMN TYPE in FAQ.

Update to 8.0.0 for packaging.

Remove </a>

Alvaro

Update TORA item.

Euler Taveira de Oliveira

Merge query of system objects FAQ items.

Update OS/2 URL.

Remove mp3 that is now missing.

Remove duplicate novell mention.

HTML cleanup.

Add OS/2 port mention.

Updates from Ian Barwick.
Update FAQ with new URL's for site.

Update FAQ.

Update FAQ with new URL's for site.

Update from Ian Barwick

Add French IRC channel.

Add Spanish IRC channel to FAQ.

Update IRC mention.

Reorder IRC examples.

Mega-clarifications from Joachim Wieland.

Add mention of Cygwin. Update version number.

Fix typo.

Remove replicaiton FAQ item.

Add index mention:

    <P>In pre-8.0 releases, indexes often can not be used unless the data
    types exactly match the index's column types.  This is particularly
    true of int2, int8, and numeric column indexes.</P>

Update tcp connection faq.

Update that 8.0 will support MS Win natively.

Update newest version number.

Fix number for FAQ item.

Update tuple header size.

*** empty log message ***

New text.

Wording improvement.

Move comma.

Add FAQ entry on hardware selection.

This is a small fix in FAQ. It just clean up some old comments and
change an old -not-working piece of code.

Update FAQ from Robert Treat

Update FAQ with current release version.

Add mention of the developer's FAQ.

Add mention of PostgreSQL as a community project.

Update datestamp.

*** empty log message ***

Update null storage description.

Add MySQL mention of licensing difference.

Favor Freenode rather than EFnet in IRC listing.  Freenode is more popular.

Update for 7.4.1 as newest version.

Stamp 7.4.1.

Update 7.4.1 FAQ's to current.

*** empty log message ***

Remove win32-only mention for pgadmin.

*** empty log message ***

Update most recent version to 7.4.

SERIAL no longer creates an index by default, as of 7.3.

Update FAQ for 7.4 branch.

pgadmin III released.

Update FAQ and TODO for 7.4.

Update freenode mention.

Update IRC to mention freenet instead of openprojects.

Typo fix.

Update for 7.4 --- prefer IN to EXISTS.

Update max existing db size to 32tb.

Update MySQL mention.

Update MySQL mention.

Update MySQL mention.

Update MySQL mention.

Improve wording of increasing page size.

Update max tasble size to 32TB.

Update URL.

Update URL to be momjian.postgresql.org.

Update this branch to match CVS head, includes WIN32 improvements.

Add WIN32 URL.

Add mention of OID wraparound.

Fix unixware template --- had spaces around equals.

Add mention of new SSL capabilities.

Update FAQ.

Ian Barwick

Update to 7.3.4 as newest release.

Stamp 7.3.4 release.

Update URL's.

Update FAQ from Ian Barwick.

Add item about sending success stories to http://advocacy.postgresql.org.

Add info about selecting a random row.

Add item for changing a column's data type.

Update CVS with new FAQ.

Add mention of Novell Netware 6 port.

Add mention of OpenProjects IRC channel.  It is as large as EFNet now.

Add mention of new sets returning functions capability.

Update links, from Ian Barwick

Increase max known database size.

Update FAQ.

Update URL.

New URL for FAQ.

*** empty log message ***

Update changes from Ian Barwick.

Update FAQ's in head and 7.3.X.

Update to 7.3.2 as newest release.

Update URL's.

Update FAQ.

Remove mention of 6.5 max backends.

Mark IN performance problem as fixed in 7.4

Add section on testing index scan.

Update CHAR().

Update CHAR() description.

Improve CHAR() description.

Update Russian FAQ.  Update all FAQ's for 7.3.X branch.

*** empty log message ***

Update FAQ for 7.3.1.

Stamp 7.3.1

Update release to mark 7.3.

Improvements from Neil Conway.

Updates from Ian Barwick.

Update char/varchar()/text/bytea to mention they have similar performance
characteristics.

Update for tables returning function, item 5.3, from Joe Conway.

Improvements to Ian Barwick patch.

FAQ updates from Ian Barwick.

Update FAQ.

Add replication, encryption, and cross database FAQ items.

Update IN/EXISTS item.

Brand 7.2.3.

Update FAQ for 7.2.3 version.

Add mention of 1 terrabyte databases.

Mark 7.2.2 as newest release.

Update FAQ.

Improve wording of upgrade section.

Update contributions link.

Update FAQ.

Update FAQ.

Remove references to pre-7.1;  too old.

Update FAQ.

Add NULL space mention.

Update FAQ.

Add more info on regex's using INDEX.

Update FAQ.

Add MIN/MAX LIMIT/OFFSET mention.

Update FAQ.

Fix link.

Update performance section.

Update fsync FAQ item.

Fix link.

Move ruler to separate sections.

Add item for plpgsql temp table access.

Update DROP COLUMN example to use transactions and rollback-able DROP TABLE>

Add how to get database/user listing information.

Add mention of -DLINUX_PROFILE to profile mention.

Point to developers site, not my hostname.

Update FAQ.

Update FAQ.

Update for 7.2.1.

Update FAQ.

Update FAQ for 7.2.1.

Update FAQ.

Update FAQ.

Update FAQ.

Update FAQ.

Update FAQ.

Update FAQ.

Update FAQ.

Update FAQ.

Update FAQ.

Update FAQ.