summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2001-06-07reset all: command line and .conf options change defaultsBruce Momjian
on RESET ALL those are restored. show all: GUC + non-GUC. SHOW ALL, RESET ALL Marko Kreen
2001-06-04This patch adds support for %TYPE in CREATE FUNCTION argument and returnBruce Momjian
types. This version has an elog() to remind the user the type resolution is not dynamic. Ian Lance Taylor
2001-06-02Native Language Support (NLS)Peter Eisentraut
Use --enable-nls to turn it on; see installation instructions for details. See developer's guide how to make use of it in programs and how to add translations. psql sources have been almost fully prepared and an incomplete German translation has been provided. In the backend, only elog() calls are currently translatable, and the provided German translation file is more of a placeholder.
2001-06-01Clean up some minor problems exposed by further thought about Panon's bugTom Lane
report on old-style functions invoked by RI triggers. We had a number of other places that were being sloppy about which memory context FmgrInfo subsidiary data will be allocated in. Turns out none of them actually cause a problem in 7.1, but this is for arcane reasons such as the fact that old-style triggers aren't supported anyway. To avoid getting burnt later, I've restructured the trigger support so that we don't keep trigger FmgrInfo structs in relcache memory. Some other related cleanups too: it's not really necessary to call fmgr_info at all while setting up the index support info in relcache entries, because those ScanKeyEntry structs are never used to invoke the functions. This should speed up relcache initialization a tiny bit.
2001-06-01Update release 1.09 dateBruce Momjian
2001-05-31Forgot SGML section section id tag for 7.1.Bruce Momjian
2001-05-30Update FAQ.Bruce Momjian
2001-05-30Update FAQ.Bruce Momjian
2001-05-30Oops, had 0.2 release date wrong.Bruce Momjian
2001-05-30This is a docs patch to go with my DROP CONSTRAINT patch.Bruce Momjian
Christopher Kings
2001-05-30Correct obsolete example of FROM-less query.Tom Lane
2001-05-30In chapter:Bruce Momjian
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
2001-05-28Cause plpgsql's PERFORM to behave according to its documentation,Tom Lane
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).
2001-05-28markup fixPeter Eisentraut
2001-05-28Sample output that appears below the table attributes for \d:Bruce Momjian
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
2001-05-27Make UPDATE and DELETE privileges distinct. Add REFERENCES and TRIGGERPeter Eisentraut
privileges. INSERT and COPY FROM now require INSERT (only). Add privileges regression test.
2001-05-25Oops, only wanted python change in the last commit. Backing out.Bruce Momjian
2001-05-25While changing Cygwin Python to build its core as a DLL (like Win32Bruce Momjian
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
2001-05-24SQL function bit_lengthPeter Eisentraut
2001-05-22Update FAQ.Bruce Momjian
2001-05-22Make bit and bit varying types reject too long input. (They already triedPeter Eisentraut
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.
2001-05-22more indices -> indexesPeter Eisentraut
2001-05-22ELSEIF PL/PgSQL doc patch.Bruce Momjian
Klaus Reger
2001-05-21Make char(n) and varchar(n) types raise an error if the inserted string isPeter Eisentraut
too long. While I was adjusting the regression tests I moved the array things all into array.sql, to make things more manageable.
2001-05-19Allow special '$libdir' macro to show up in object file path in CREATEPeter Eisentraut
FUNCTION command. Guard against trying to load a directory. Update documentation some.
2001-05-17Change "indices" to "indexes", per OED.Peter Eisentraut
2001-05-17Add -U and -W options to pg_dump and friends to support non-interactivePeter Eisentraut
specification of username (like in psql). pg_dumpall now works with password authentication.
2001-05-17Add dynamic_library_path parameter and automatic appending of sharedPeter Eisentraut
library extension.
2001-05-17Add HISTORY items for 7.1.2.Bruce Momjian
2001-05-15redo record -> undo record, Tom Lane.Bruce Momjian
2001-05-14Remove unused tables pg_variable, pg_inheritproc, pg_ipl tables. InitdbBruce Momjian
forced.
2001-05-14Fix 'set path' for csh.Bruce Momjian
2001-05-12Add index. Only some parts of the manual set have index entries so far...Peter Eisentraut
2001-05-12Add command '\pset footer' to psql to turn off default "(x rows)" footer.Peter Eisentraut
2001-05-12PL/Python should build portably now, if you can get over the fact thatPeter Eisentraut
there's no shared libpython. Test suite works as well. Also, add some documentation.
2001-05-11Improve discussion of %TYPE and %ROWTYPE.Tom Lane
2001-05-11Stamp CVS as 7.2. Update all interface version numbers. This is theBruce Momjian
time to do it, not during beta because people are using this stuff in production sometimes.
2001-05-11Stamp for 7.1.2. Ready when you are...Bruce Momjian
2001-05-11Update FAQ.Bruce Momjian
2001-05-09First cut at making indexscan cost estimates depend on correlationTom Lane
between index order and table order.
2001-05-09Add --echo option to createlang and droplang.Peter Eisentraut
from Oliver Elphick
2001-05-09Change --with-pltcl-unknown to --enable-pltcl-unknownBruce Momjian
2001-05-09This patch adds a new configure option --with-pltcl-unknown whichBruce Momjian
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
2001-05-09Fix libpq++'s FieldSize to return int, not short.Bruce Momjian
2001-05-09Here's a version of my suggested diffs transplanted to 7.1 beta 5. I'mBruce Momjian
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
2001-05-09If it's true that the ALTER TABLE x ADD CONSTRAINT x CHECK (x) syntax isBruce Momjian
supported in 7.1.1, here is a patch to that alter_table.sgml that documents it. Christopher Kings-Lynne
2001-05-09Cause planner to make use of average-column-width statistic that is nowTom Lane
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 ...
2001-05-08Update runtime shared memory computations.Bruce Momjian
2001-05-08Add SET SESSION AUTHORIZATION command.Peter Eisentraut
2001-05-08Remove pgadmin.sgml file.Bruce Momjian
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-26 00:02:34 +0000