aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add missing file; new docs for start_transaction.Bruce Momjian2002-08-04
|
* This patch fixes a probably harmless write of uninitialized memory inBruce Momjian2002-08-04
| | | | | | | the statistics collector and makes a number of corrections to the documentation for SET, SHOW, and COPY. Neil Conway
* The attached patch implements START TRANSACTION, per SQL99. TheBruce Momjian2002-08-04
| | | | | | | | | | | functionality of the command is basically identical to that of BEGIN; it just accepts a few extra options (only one of which PostgreSQL currently implements), and is standards-compliant. The patch includes a simple regression test and documentation. [ Regression tests removed, per Peter.] Neil Conway
* Here is a doc patch for the SHOW X changes and new config-settingsBruce Momjian2002-08-04
| | | | | | functions. If there are no objections, please apply. Joe Conway
* ALTER TABLE DROP COLUMN works. Patch by Christopher Kings-Lynne,Tom Lane2002-08-02
| | | | | | | | | | code review by Tom Lane. Remaining issues: functions that take or return tuple types are likely to break if one drops (or adds!) a column in the table defining the type. Need to think about what to do here. Along the way: some code review for recent COPY changes; mark system columns attnotnull = true where appropriate, per discussion a month ago.
* Instead of having a configure-time DEFAULT_ATTSTATTARGET, store -1 inTom Lane2002-07-31
| | | | | | | | attstattarget to indicate 'use the default'. The default is now a GUC variable default_statistics_target, and so may be changed on the fly. Along the way we gain the ability to have pg_dump dump the per-column statistics target when it's not the default. Patch by Neil Conway, with some kibitzing from Tom Lane.
* Move backend_pid to functions/misc.Bruce Momjian2002-07-31
|
* Rename pid function to backend_pid().Bruce Momjian2002-07-31
|
* Would it be wise to have the plsql.sgml file renamed to plpgsql.sgml?Bruce Momjian2002-07-30
| | | | | | | | | All of the internal tags are of the latter. The other thing I noticed is that most of the quick examples in the file use a para and synopsis. Is there a reason we're not using <example/> ? Rod Taylor
* Replace ad-hoc insertions into pg_opclass and friends with CREATETom Lane2002-07-30
| | | | OPERATOR CLASS commands. Further tweaking of documentation for same.
* IMPROVED VERSION APPLIED:Bruce Momjian2002-07-30
| | | | | | | | | | | | | | The attached patch completes the following TODO item: * Generate failure on short COPY lines rather than pad NULLs I also restructed a lot of the existing COPY code, did some code review on the column list patch sent in by Brent Verner a little while ago, and added some regression tests. I also added an explicit check (and resultant error) for extra data before the end-of-line. Neil Conway
* Here are two patches. The guc_and_tablefunc patch addresses the twoBruce Momjian2002-07-30
| | | | | | | | | | | | | | | | changes mentioned above, and also adds a new function to the tablefunc API. The tablefunc API change adds the following function: * Oid foidGetTypeId(Oid foid) - Get a function's typeid given the * function Oid. Use this together with TypeGetTupleDesc() to get a * TupleDesc which is derived from the function's declared return type. In the next post I'll send the contrib/tablefunc patch, which illustrates the usage of this new function. Also attached is a doc patch for this change. The doc patch also adds a function that I failed to document previously. Joe Conway
* Update contributions link.Bruce Momjian2002-07-30
|
* Rewrite xindex.sgml for CREATE OPERATOR CLASS. catalogs.sgml finallyTom Lane2002-07-30
| | | | | contains descriptions of every single system table. Update 'complex' tutorial example too.
* Update FAQ.Bruce Momjian2002-07-30
|
* Update FAQ.Bruce Momjian2002-07-29
|
* Implement CREATE/DROP OPERATOR CLASS. Work still remains: need moreTom Lane2002-07-29
| | | | | | | documentation (xindex.sgml should be rewritten), need to teach pg_dump about it, need to update contrib modules that currently build pg_opclass entries by hand. Original patch by Bill Studenmund, grammar adjustments and general update for 7.3 by Tom Lane.
* Structure reference pages consistently. Document that structure.Peter Eisentraut2002-07-28
| | | | Add information about environment variables.
* Clean documentation subtree during make clean.Peter Eisentraut2002-07-28
|
* Remove unused system table columns:Peter Eisentraut2002-07-24
| | | | | | | | | | | | | | | | | | | | | | | | pg_language.lancompiler pg_operator.oprprec pg_operator.oprisleft pg_proc.proimplicit pg_proc.probyte_pct pg_proc.properbyte_cpu pg_proc.propercall_cpu pg_proc.prooutin_ratio pg_shadow.usetrace pg_type.typprtlen pg_type.typreceive pg_type.typsend Attempts to use the obsoleted attributes of pg_operator or pg_proc in the CREATE commands will be greeted by a warning. For pg_type, there is no warning (yet) because pg_dump scripts still contain these attributes. Also remove new but already obsolete spellings isVolatile, isStable, isImmutable in WITH clause. (Use new syntax instead.)
* Add pg_conversion system catalog. Update description for multibyte support.Tatsuo Ishii2002-07-24
|
* Add unique index on pg_cast.oid, and document pg_cast table.Peter Eisentraut2002-07-22
|
* Fix typo.Tatsuo Ishii2002-07-22
|
* Add CREATE CONVERSION/DROP CONVERSOION reference manualTatsuo Ishii2002-07-22
|
* Code review for SHOW output changes; fix horology expected files forTom Lane2002-07-20
| | | | new SHOW output format.
* Make note that ALTER TABLE can change table owner these days.Tom Lane2002-07-19
|
* pg_cast table, and standards-compliant CREATE/DROP CAST commands, plusPeter Eisentraut2002-07-18
| | | | | | | | | | | extension to create binary compatible casts. Includes dependency tracking as well. pg_proc.proimplicit is now defunct, but will be removed in a separate commit. pg_dump provides a migration path from the previous scheme to declare casts. Dumping binary compatible casts is currently impossible, though.
* Implement DROP SCHEMA. It lacks support for dropping conversions andTom Lane2002-07-18
| | | | | operator classes, both of which are schema-local and so should really be droppable.
* Fix copy-and-pasteo (CASCADE/RESTRICT in wrong place).Tom Lane2002-07-18
|
* Here (finally ;-)) is a doc patch covering the Table Function C API. ItBruce Momjian2002-07-18
| | | | | | | | reflects the changes in the tablefunc-fix patch that I sent in the other day. It also refers to "see contrib/tablefunc for more examples", which is next on my list of things to finish and submit. Joe Conway
* The attached patch (against HEAD) implementsBruce Momjian2002-07-18
| | | | | | | | | | | | | | | COPY x (a,d,c,b) from stdin; COPY x (a,c) to stdout; as well as the corresponding changes to pg_dump to use the new functionality. This functionality is not available when using the BINARY option. If a column is not specified in the COPY FROM statement, its default values will be used. In addition to this functionality, I tweaked a couple of the error messages emitted by the new COPY <options> checks. Brent Verner
* Add more dependency insertions --- this completes the basic pg_dependTom Lane2002-07-16
| | | | | functionality. Of note: dropping a table that has a SERIAL column defined now drops the associated sequence automatically.
* > pgsql-bugs@postgresql.org wrote:Bruce Momjian2002-07-16
| | | | | | | | | | | | | | | | | | | | | > > David Clark (dclarknospam@opsi.co.za) reports a bug with a severity > > Table 3-7 SQL Literal escaped octets shows the input escape > > representation for a single quote as '\\'' , but the third paragraph > > below table 3-8 SQL Output Escaped Octets says that the single quote > > must be input as '\'' > > Nice catch. '\'' is correct as shown in the example in Table 3-7. > > > > > Also in the same paragraph mentioned above it says input for the > > single quote must be '\'' (or '\\134') shouldn't this be (or '\\047') > > Also a bug. Should be '\\047', as you pointed out. > Here's a patch to fix the binary string doc errors. Joe Conway
* Add mention of TOAST storage for character columns.Bruce Momjian2002-07-16
|
* Mark 'line' as 'not implemented' in SGML and psql \dT, per ThomasBruce Momjian2002-07-16
| | | | Lockhart. initdb not forced.
* This fixes 2 inaccuracies in the recently added SQL99 feature list docs.Bruce Momjian2002-07-16
| | | | | | | | | | | UNIQUE and DISTINCT predicates are both listed as implemented -- AFAIK, neither is. I also included another trivial patch which adds the default location of the DSSSL stylesheets on my system (Debian unstable, docbook-dsssl 1.76) to the list of paths that configure looks for. Neil Conway
* Fix \? and \pset pager handling. \? wasn't honoring pager before.Bruce Momjian2002-07-15
|
* Remove no-longer-appropriate notes about lack of CASCADE/RESTRICT behavior.Tom Lane2002-07-14
|
* Add SET statement_timeout capability. Timeout is in ms. A value ofBruce Momjian2002-07-13
| | | | zero turns off the timer.
* Re-add -I documentation, per Tom.Bruce Momjian2002-07-13
|
* Second phase of committing Rod Taylor's pg_depend/pg_constraint patch.Tom Lane2002-07-12
| | | | | | | | | | | | pg_relcheck is gone; CHECK, UNIQUE, PRIMARY KEY, and FOREIGN KEY constraints all have real live entries in pg_constraint. pg_depend exists, and RESTRICT/CASCADE options work on most kinds of DROP; however, pg_depend is not yet very well populated with dependencies. (Most of the ones that are present at this point just replace formerly hardwired associations, such as the implicit drop of a relation's pg_type entry when the relation is dropped.) Need to add more logic to create dependency entries, improve pg_dump to dump constraints in place of indexes and triggers, and add some regression tests.
* Remove references to pre-7.1; too old.Bruce Momjian2002-07-11
|
* Update FAQ.Bruce Momjian2002-07-11
|
* Fix pg_restore flags in documentation.Bruce Momjian2002-07-10
|
* Don't document that UNDO is certain to be added in the future.Bruce Momjian2002-07-05
|
* Add explanation of the various *_min_messages elog() values.Bruce Momjian2002-07-05
|
* Fix capitalization.Bruce Momjian2002-07-05
|
* Add NULL space mention.Bruce Momjian2002-07-04
|
* Move INTERSECT DISTINCT to the supported category. Error in docs.Thomas G. Lockhart2002-07-04
|
* Document function args are required for pg_restore -P.Bruce Momjian2002-07-04
| | | | | | | Fix pg_dump to not quote the function name in the storage tag. Fix pg_dump so GRANT/REVOKE(ACL) tag entries are not quoted, for consistency. Fix pg_restore to properly handle quotes and some spaces in -P.
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-28 05:27:11 +0000