summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2006-07-10Test commit.Bruce Momjian
2006-07-06Please find attached two patches for documentation and regression testsBruce Momjian
for the usage of full time zone names. Joachim Wieland
2006-07-04Documentation fixes for FILLFACTOR patch. Minor other editorialization.Tom Lane
2006-07-04Modify:Bruce Momjian
< o -Add PQescapeIdentifier() > o Add PQescapeIdentifierConn()
2006-07-04Remove libpq's PQescapeIdentifier(), not safe from injection attacks.Bruce Momjian
2006-07-03Code review for FILLFACTOR patch. Change WITH grammar as per earlierTom Lane
discussion (including making def_arg allow reserved words), add missed opt_definition for UNIQUE case. Put the reloptions support code in a less random place (I chose to make a new file access/common/reloptions.c). Eliminate header inclusion creep. Make the index options functions safely user-callable (seems like client apps might like to be able to test validity of options before trying to make an index). Reduce overhead for normal case with no options by allowing rd_options to be NULL. Fix some unmaintainably klugy code, including getting rid of Natts_pg_class_fixed at long last. Some stylistic cleanup too, and pay attention to keeping comments in sync with code. Documentation still needs work, though I did fix the omissions in catalogs.sgml and indexam.sgml.
2006-07-03Fix broken markup.Tom Lane
2006-07-02Add FILLFACTOR to CREATE INDEX.Bruce Momjian
ITAGAKI Takahiro
2006-07-02Done:Bruce Momjian
> * -Add fillfactor to control reserved free space during index creation
2006-07-02Done:Bruce Momjian
< o Add ALTER TABLE tab ADD/DROP INHERITS parent < < This allows tables to be added/removed from an inheritance < hierarchy. This is particularly useful for table partitioning. < http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php < > o -Add ALTER TABLE tab INHERIT / NO INHERIT parent
2006-07-02ALTER TABLE ... ADD/DROPS INHERIT (actually INHERIT / NO INHERIT)Bruce Momjian
Open items: There were a few tangentially related issues that have come up that I think are TODOs. I'm likely to tackle one or two of these next so I'm interested in hearing feedback on them as well. . Constraints currently do not know anything about inheritance. Tom suggested adding a coninhcount and conislocal like attributes have to track their inheritance status. . Foreign key constraints currently do not get copied to new children (and therefore my code doesn't verify them). I don't think it would be hard to add them and treat them like CHECK constraints. . No constraints at all are copied to tables defined with LIKE. That makes it hard to use LIKE to define new partitions. The standard defines LIKE and specifically says it does not copy constraints. But the standard already has an option called INCLUDING DEFAULTS; we could always define a non-standard extension LIKE table INCLUDING CONSTRAINTS that gives the user the option to request a copy including constraints. . Personally, I think the whole attislocal thing is bunk. The decision about whether to drop a column from children tables or not is something that should be up to the user and trying to DWIM based on whether there was ever a local definition or the column was acquired purely through inheritance is hardly ever going to match up with user expectations. . And of course there's the whole unique and primary key constraint issue. I think to get any traction at all on this you have a prerequisite of a real partitioned table implementation where the system knows what the partition key is so it can recognize when it's a leading part of an index key. Greg Stark
2006-06-30Update item for GUID:Bruce Momjian
< * Add 128-bit Universally Unique Identifier (UUID) > * Add Globally/Universally Unique Identifier (GUID/UUID)
2006-06-29Remove the separate 'stats buffer' process, letting backend stats messagesTom Lane
be delivered directly to the collector process. The extra process context swaps required to transfer data through the buffer process seem to outweigh any value the buffering might have. Per recent discussion and tests. I modified Bruce's draft patch to use poll() rather than select() where available (this makes a noticeable difference on my system), and fixed up the EXEC_BACKEND case.
2006-06-29Change URL for SITC:Bruce Momjian
< http://momjian.us/cgi-bin/pgsitc > http://archives.postgresql.org/pgsql-hackers/2006-06/msg01534.php
2006-06-29Add:Bruce Momjian
> * Add 128-bit Universally Unique Identifier (UUID)
2006-06-28Editorialization for the additions to the CREATE TABLE reference pageNeil Conway
made as part of the recent INCLUDING CONSTRAINTS patch. The text could stand further improvement, but this is at least a step in the right direction.
2006-06-28Add URL for SITCBruce Momjian
> http://momjian.us/cgi-bin/pgsitc
2006-06-28Update:Bruce Momjian
< o Add support for WITH HOLD cursors > o Add support for WITH HOLD and SCROLL cursors > > PL/pgSQL cursors should support the same syntax as > backend cursors. >
2006-06-28Update Russian FAQ.Bruce Momjian
Viktor Vislobokov
2006-06-27Add GUC update_process_title to control whether 'ps' display is updatedBruce Momjian
for every command, default to on.
2006-06-27Default stats_command_string to 'on', now that its overhead is minimal.Bruce Momjian
2006-06-27Revert patch, doesn't do what it should:Bruce Momjian
* %Disallow changing default expression of a SERIAL column Dhanaraj M
2006-06-27Will revert in next patch more cleanly.Bruce Momjian
> * -Disallow changing DEFAULT expression of a SERIAL column
2006-06-27Not done:Bruce Momjian
< * -Disallow changing DEFAULT expression of a SERIAL column > * %Disallow changing DEFAULT expression of a SERIAL column
2006-06-27Add INCLUDING CONSTRAINTS to CREATE TABLE LIKE.Bruce Momjian
Greg Stark
2006-06-27Done:Bruce Momjian
< * %Disallow changing DEFAULT expression of a SERIAL column? < < This should be done only if the existing SERIAL problems cannot be < fixed. < > * -Disallow changing DEFAULT expression of a SERIAL column
2006-06-27Done:Bruce Momjian
> o -Add PQescapeIdentifier()
2006-06-27Add PQescapeIdentifier() to libpqBruce Momjian
Christopher Kings-Lynne
2006-06-26Change the row constructor syntax (ROW(...)) so that list elements foo.*Tom Lane
will be expanded to a list of their member fields, rather than creating a nested rowtype field as formerly. (The old behavior is still available by omitting '.*'.) This syntax is not allowed by the SQL spec AFAICS, so changing its behavior doesn't violate the spec. The new behavior is substantially more useful since it allows, for example, triggers to check for data changes with 'if row(new.*) is distinct from row(old.*)'. Per my recent proposal.
2006-06-26Use Unix newlines, instead of DOS ones.Bruce Momjian
2006-06-25Update my info:Bruce Momjian
> * Bruce is Bruce Momjian <bruce@momjian.us> of EnterpriseDB
2006-06-25Add:Bruce Momjian
< * Reuse index tuples that point to rows that are not visible to anyone? > * Reuse index tuples that point to heap tuples that are not visible to > anyone?
2006-06-24Update entry:Bruce Momjian
< * Allow heap reuse of UPDATEd rows if old and new versions are on the < same heap page? > * Allow heap reuse of UPDATEd rows if no indexed columns are changed, > and old and new versions are on the same heap page? < This is possible for same-page updates because a single index row < can point to both old and new values. > While vacuum handles DELETEs fine, updating of non-indexed columns, like > counters, are difficult for VACUUM to handle efficiently. This method > is possible for same-page updates because a single index row can be > used to point to both old and new values.
2006-06-24Add UPDATE entry for row reuse.Bruce Momjian
> > * Allow heap reuse of UPDATEd rows if old and new versions are on the > same heap page? > > This is possible for same-page updates because a single index row > can point to both old and new values. > http://archives.postgresql.org/pgsql-hackers/2006-06/msg01305.php
2006-06-19Some editorial work on the documentation of the current-date/timeTom Lane
functions.
2006-06-19Take the statistics collector out of the loop for monitoring backends'Tom Lane
current commands; instead, store current-status information in shared memory. This substantially reduces the overhead of stats_command_string and also ensures that pg_stat_activity is fully up to date at all times. Per my recent proposal.
2006-06-18Update my email address.Bruce Momjian
2006-06-18Merge postmaster and postgres command into just postgres. postmasterPeter Eisentraut
symlink is kept for now for compatibility. To call single-user mode, use postgres --single.
2006-06-16Code review for SELECT INTO STRICT patch: use saner choices of errorTom Lane
SQLSTATEs, fix some documentation problems.
2006-06-16Clean up after someone's curious idea that it'd be good to stripTom Lane
leading zeroes from the SQLSTATE codes. They're strings, people, not numbers.
2006-06-16docs for DROP ... IF EXISTS for the following cases:Andrew Dunstan
language, tablespace, trigger, rule, opclass, function, aggregate. operator, and cast.
2006-06-16Add:Bruce Momjian
> o Allow PL/python to composite types and result sets > once buggy assert-enabled versions of python can be detected > > http://archives.postgresql.org/pgsql-patches/2006-04/msg00087.php
2006-06-16Add:Bruce Momjian
> > * Fix CREATE CAST on DOMAINs > > http://archives.postgresql.org/pgsql-hackers/2006-05/msg00072.php
2006-06-16Document issues with non-default tablespaces and pg_dumpall restores.Bruce Momjian
Backpatch documentation addition to 8.1.X.
2006-06-16Add URL for ISO dates:Bruce Momjian
> http://archives.postgresql.org/pgsql-bugs/2006-04/msg00248.php
2006-06-16Add URL for currency type:Bruce Momjian
> http://archives.postgresql.org/pgsql-general/2005-08/msg01432.php
2006-06-16Add URL for updatable views:Bruce Momjian
> http://archives.postgresql.org/pgsql-hackers/2006-03/msg00586.php
2006-06-16Add:Bruce Momjian
> * Consider shrinking expired tuples to just their headers > http://archives.postgresql.org/pgsql-patches/2006-03/msg00142.php
2006-06-16Add URL to:Bruce Momjian
* Auto-fill the free space map by scanning the buffer cache or by checking pages written by the background writer
2006-06-16Add URL for freespace map filling.Bruce Momjian
> > http://archives.postgresql.org/pgsql-hackers/2006-02/msg01125.php >
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-30 01:28:39 +0000