aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* In chapter:Bruce Momjian2001-05-30
| | | | | | | | | | | | | | | | | | | 7.7. Keys you have However, my application requires that each collection will also have a unique name. Why? So that a human being who wants to modify a collection will be able to identify it. It's much harder to know, if you have two collections named "Life Science", the the one tagged 24433 is the one you need, and the one tagged 29882 is not I think 'the the' shouldn't be repeated twice. Although taken from an email it would be cool to fix. Cheers, Maxim Maletsky
* Cause plpgsql's PERFORM to behave according to its documentation,Tom Lane2001-05-28
| | | | | | | | | | | | which says that PERFORM will execute any SELECT query and discard the result. The former implementation would in fact raise an error if the result contained more than one row or more than one column. Also, change plpgsql's error-logging mechanism to emit the additional messages about error location at NOTICE rather than DEBUG level. This allows them to be seen by the client without having to dig into the postmaster log file (which may be nonexistent or inaccessible by the client).
* markup fixPeter Eisentraut2001-05-28
|
* Sample output that appears below the table attributes for \d:Bruce Momjian2001-05-28
| | | | | | | | | | | | | | | Indicies: palm_buy_date_idx palm_user_date_idx Primary Key: palm_buyers_pkey Unique Key: palm_buyers_username Constraint: "$1" ((sex = 'M'::bpchar) OR (sex = 'F'::bpchar)) Note that check constraint name now shown as well. (Makes it a lot easier to test inheritance support in ADD/DROP constraint :) ) Attached is a docs change for psql. Christopher Kings
* Make UPDATE and DELETE privileges distinct. Add REFERENCES and TRIGGERPeter Eisentraut2001-05-27
| | | | | privileges. INSERT and COPY FROM now require INSERT (only). Add privileges regression test.
* Oops, only wanted python change in the last commit. Backing out.Bruce Momjian2001-05-25
|
* While changing Cygwin Python to build its core as a DLL (like Win32Bruce Momjian2001-05-25
| | | | | | | | | | | | | | | Python) to support shared extension modules, I have learned that Guido prefers the style of the attached patch to solve the above problem. I feel that this solution is particularly appropriate in this case because the following: PglargeType PgType PgQueryType are already being handled in the way that I am proposing for PgSourceType. Jason Tishler
* SQL function bit_lengthPeter Eisentraut2001-05-24
|
* Update FAQ.Bruce Momjian2001-05-22
|
* Make bit and bit varying types reject too long input. (They already triedPeter Eisentraut2001-05-22
| | | | | | to do that, but inconsistently.) Make bit type reject too short input, too, per SQL. Since it no longer zero pads, 'zpbit*' has been renamed to 'bit*' in the source, hence initdb.
* more indices -> indexesPeter Eisentraut2001-05-22
|
* ELSEIF PL/PgSQL doc patch.Bruce Momjian2001-05-22
| | | | Klaus Reger
* Make char(n) and varchar(n) types raise an error if the inserted string isPeter Eisentraut2001-05-21
| | | | | too long. While I was adjusting the regression tests I moved the array things all into array.sql, to make things more manageable.
* Allow special '$libdir' macro to show up in object file path in CREATEPeter Eisentraut2001-05-19
| | | | | FUNCTION command. Guard against trying to load a directory. Update documentation some.
* Change "indices" to "indexes", per OED.Peter Eisentraut2001-05-17
|
* Add -U and -W options to pg_dump and friends to support non-interactivePeter Eisentraut2001-05-17
| | | | | specification of username (like in psql). pg_dumpall now works with password authentication.
* Add dynamic_library_path parameter and automatic appending of sharedPeter Eisentraut2001-05-17
| | | | library extension.
* Add HISTORY items for 7.1.2.Bruce Momjian2001-05-17
|
* redo record -> undo record, Tom Lane.Bruce Momjian2001-05-15
|
* Remove unused tables pg_variable, pg_inheritproc, pg_ipl tables. InitdbBruce Momjian2001-05-14
| | | | forced.
* Fix 'set path' for csh.Bruce Momjian2001-05-14
|
* Add index. Only some parts of the manual set have index entries so far...Peter Eisentraut2001-05-12
|
* Add command '\pset footer' to psql to turn off default "(x rows)" footer.Peter Eisentraut2001-05-12
|
* PL/Python should build portably now, if you can get over the fact thatPeter Eisentraut2001-05-12
| | | | | there's no shared libpython. Test suite works as well. Also, add some documentation.
* Improve discussion of %TYPE and %ROWTYPE.Tom Lane2001-05-11
|
* Stamp CVS as 7.2. Update all interface version numbers. This is theBruce Momjian2001-05-11
| | | | | time to do it, not during beta because people are using this stuff in production sometimes.
* Stamp for 7.1.2. Ready when you are...Bruce Momjian2001-05-11
|
* Update FAQ.Bruce Momjian2001-05-11
|
* First cut at making indexscan cost estimates depend on correlationTom Lane2001-05-09
| | | | between index order and table order.
* Add --echo option to createlang and droplang.Peter Eisentraut2001-05-09
| | | | from Oliver Elphick
* Change --with-pltcl-unknown to --enable-pltcl-unknownBruce Momjian2001-05-09
|
* This patch adds a new configure option --with-pltcl-unknown whichBruce Momjian2001-05-09
| | | | | | | | | | | | | | | | | | | | | enables pltcl unknown support. Also it adds substituting of tclsh with tclsh that was by configure in pltcl_*mod scripts. For example, On freebsd, tclsh can be called tclsh8.2 or tclsh8.3 depending on installed version of Tcl. After patching files src/pl/tcl/modules/pltcl_listmod src/pl/tcl/modules/pltcl_loadmod src/pl/tcl/modules/pltcl_delmod must be renamed(copied,repocopied) to src/pl/tcl/modules/pltcl_listmod.in src/pl/tcl/modules/pltcl_loadmod.in src/pl/tcl/modules/pltcl_delmod.in seva@sevasoft.kiev.ua
* Fix libpq++'s FieldSize to return int, not short.Bruce Momjian2001-05-09
|
* Here's a version of my suggested diffs transplanted to 7.1 beta 5. I'mBruce Momjian2001-05-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | still looking at the best way to integrate Tom Vijlbrief's fixes (insofar as they're still needed); would 7.2 be a suitable time for incompatible API changes? Jeroen Changes: (*) Introduced bool, true, false (replacing some int, 1, 0) (*) Made some member functions const (*) Documented GetIsNull() (*) Marked DisplayTuples() and PrintTuples() as obsolescent; fixed possible portability problem (assumed that NULL pointer equals all-zero bit pattern) (*) PrintTuples(): renamed width parameter to fillAlign to conform with other usage; fixed memory leak and compile issue w.r.t. field separator (should also slightly improve performance) (*) Fixed some minor compilation issues (*) Moved "using namespace std;" out of headers, where they didn't belong; used new (temporary) preprocessor macro PGSTD to do this (*) Made ToString() static, removed unneeded memset(), made buffer size adapt to sizeof(int) (*) Made some constructors explicit (*) Changed some const std::string & parameters to plain std::string (*) Marked PgCursor::Cursor(std::string) as obsolescent (setter with same name as getter--bad style) (*) Renamed some paramaters previously named "string" (*) Introduced size_type typedef for number of tuples in result set (*) PgTransaction now supports re-opening after closing, and aborts if not explicitly committed prior to destruction J. T. Vermeulen
* If it's true that the ALTER TABLE x ADD CONSTRAINT x CHECK (x) syntax isBruce Momjian2001-05-09
| | | | | | | supported in 7.1.1, here is a patch to that alter_table.sgml that documents it. Christopher Kings-Lynne
* Cause planner to make use of average-column-width statistic that is nowTom Lane2001-05-09
| | | | | | | | collected by ANALYZE. Also, add some modest amount of intelligence to guesses that are used for varlena columns in the absence of any ANALYZE statistics. The 'width' reported by EXPLAIN is finally something less than totally bogus for varlena columns ... and, in consequence, hashjoin estimating should be a little better ...
* Update runtime shared memory computations.Bruce Momjian2001-05-08
|
* Add SET SESSION AUTHORIZATION command.Peter Eisentraut2001-05-08
|
* Remove pgadmin.sgml file.Bruce Momjian2001-05-08
|
* Remove LISP manual reference. Added to web "interfaces" page.Bruce Momjian2001-05-08
|
* drop_function.sgml:Bruce Momjian2001-05-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | =================== In Notes: Refer to CREATE FUNCTION for information on creating aggregate functions. ^^^^^^^^^^^^^^^^^^^ I assume it must read C function instead. In Compatibility SQL/PSM: SQL/PSM is a proposed standard. We had that before: remove proposed. drop_index.sgml: ================ <REFNAME>: Removes existing indexes from a database as far as I can see index should be singular. The command description is written as if only one index can be removed at a time. Interestingly enough, in v7.0.2 it was in fact singular. Am I mistaken here? drop_operator.sgml: =================== In Outputs the arguments are referred to as type and type2, but the synopsis and Inputs section these are left_type and right_type, respectively. Also, oper is used in Outputs versus id in Inputs/Synopsis. In the translation I follow the replaceables used in the Inputs/Synopsis part. Frank Wegmann
* drop_function.sgml:Bruce Momjian2001-05-08
| | | | | | | | | | =================== In Notes: Refer to CREATE FUNCTION for information on creating aggregate functions. ^^^^^^^^^^^^^^^^^^^ I assume it must read C function instead. Frank Wegmann
* Further cleanup of RAISE discussion; in particular, remove exampleTom Lane2001-05-08
| | | | that doesn't actually work.
* Fix raise mention that %% output as %.Bruce Momjian2001-05-08
|
* Update RAISE manual concerning % format symbols.Bruce Momjian2001-05-08
|
* Update RAISE mention in manual to take string/variable not format/identifier.Bruce Momjian2001-05-08
|
* Add mention of functional indexes for case-insensitive comparisons.Bruce Momjian2001-05-07
|
* Add \cd command to psql.Peter Eisentraut2001-05-07
|
* Solaris startup cleanup from Justin CliftBruce Momjian2001-05-07
|
* Rewrite of planner statistics-gathering code. ANALYZE is now available asTom Lane2001-05-07
| | | | | | | | | | | | | | | | | a separate statement (though it can still be invoked as part of VACUUM, too). pg_statistic redesigned to be more flexible about what statistics are stored. ANALYZE now collects a list of several of the most common values, not just one, plus a histogram (not just the min and max values). Random sampling is used to make the process reasonably fast even on very large tables. The number of values and histogram bins collected is now user-settable via an ALTER TABLE command. There is more still to do; the new stats are not being used everywhere they could be in the planner. But the remaining changes for this project should be localized, and the behavior is already better than before. A not-very-related change is that sorting now makes use of btree comparison routines if it can find one, rather than invoking '<' twice.
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-09 20:17:00 +0000