summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2001-09-07Update SGML with new hostnames for CVS and CVSup.Bruce Momjian
2001-09-07Revert treatment of NOTIFY in rules to its pre-7.1 behavior: notify willTom Lane
occur unconditionally, even if the rule should otherwise execute conditionally. This is more useful than giving an error, even though it's not truly the correct behavior. Per today's pghackers discussion.
2001-09-07Update FAQ.Bruce Momjian
2001-09-07Missed a few places that referred to a compile-time limit onTom Lane
max_connections.
2001-09-07Update FAQ.Bruce Momjian
2001-09-07Update FAQ.Bruce Momjian
2001-09-06Move the "how to write a PL call handler" parts from the CREATE LANGUAGEPeter Eisentraut
man page to the Programmer's Guide.
2001-09-06PAM authentication:Bruce Momjian
> pam_strerror() should be used a few more times, rather than just saying > "Error!". Also, the configure.in snippet seems wrong. You add > -I$pam_prefix/include/security to $INCLUDES and then you #include > <security/pam_appl.h>. This whole thing is probably unnecessary, since > PAM is a system library on the systems where it exists, so the headers > and libraries are found automatically, unlike OpenSSL and > Kerberos. See attached revised patch. (I'm sure the configure.in stuff can be done right/better, I'm just not enough of a autoconf guru to know what to change it to.) Dominic J. Eidson
2001-09-06 - new to_char(interval, text)Bruce Momjian
- new millisecond (ms) and microsecond (us) support - more robus parsing from string - used is separator checking for non-exact formats like to_date('2001-9-1', 'YYYY-MM-DD') - SGML docs are included Karel Zak
2001-09-06Next version of patch.Bruce Momjian
Now with documentation update and disabling of UTF conversion for Tcl <=8.0 On Fri, 24 Aug 2001, Vsevolod Lobko wrote: > On Thu, 23 Aug 2001, Tom Lane wrote: > > > > Is this looks better? > > > > It does, but one small gripe: the lack of semicolons will probably cause > > pg_indent to mess up the indentation. (I know emacs' autoindent mode > > will not work nicely with it, either.) Please set up the macros so that > > you write > > > > UTF_BEGIN; > > Tcl_DStringAppend(&unknown_src, UTF_E2U(part), -1); > > UTF_END; > > > > and then I'll be happy. > > Attached revised patch > > > Your point about overhead is a good one, so I retract the gripe about > > using a configure switch. But please include documentation patches to > > describe the configure option in the administrator's guide (installation > > section). > > This patch still uses configure switch for enabling feature. > > For enabling based on tcl version we have 2 posibilites: > 1) having feature enabled by default, but in pltcl.c check for tcl > version and disable it for old versions > 2) enable or disable at configure time based on tcl version, but there > are problem - current configure don't checks for tcl version at all > and my configure skills not enought for adding this > Vsevolod Lobko
2001-09-06Fix handling of pg_type.typdefault per bug report from Dave Blasby.Tom Lane
If there's anyone out there who's actually using datatype-defined default values, this will be an incompatible change in behavior ... but the old behavior was so broken that I doubt anyone was using it.
2001-09-06Overhaul ecpg manual page.Bruce Momjian
Update Italian jdbc error messages.
2001-09-04Update FAQ.Bruce Momjian
2001-09-04Update FAQ.Bruce Momjian
2001-09-04Add mention of bytea data type and escaping rules.Bruce Momjian
2001-09-04Bring references to ipcclean in sync with reality.Peter Eisentraut
2001-09-04Fix typo.Peter Eisentraut
2001-09-03Put some kind of grammatical uniformity in the <refpurpose> lines.Peter Eisentraut
2001-09-02New blood and fresh air for tutorialPeter Eisentraut
2001-08-31The actual execution results are different from examples.Tatsuo Ishii
2001-08-31Actual results are different from examplesTatsuo Ishii
2001-08-31Add ; to the create operator.Tatsuo Ishii
2001-08-31Since 7.1 the data type size of TIME has been increased.Tatsuo Ishii
2001-08-30Fix typo.Tatsuo Ishii
2001-08-29Install the SQL command man pages into a section appropriate for eachPeter Eisentraut
system. Some systems did not understand the 'l' section, and in general it wasn't entirely appropriate. On SCO OpenServer, the man pages won't be installed at all until someone figures out their man system.
2001-08-29Remove useless xreflabel.Peter Eisentraut
2001-08-28Include directory rearrangementPeter Eisentraut
Client headers are no longer in a subdirectory, since they have been made namespace-clean. Internal libpq headers are in a private subdirectory. Server headers are in a private subdirectory. pg_config has a new option to point there.
2001-08-27Fix some typos.Tom Lane
2001-08-26Documentation for transaction-ID-wraparound changes. Add a chapter toTom Lane
the Admin Guide about routine maintenance tasks. Currently this only discusses the various reasons for doing VACUUM, but perhaps it could be fleshed out with topics like log rotation.
2001-08-26Back out "Remove outdated documentation section of ecpg." for Michael.Bruce Momjian
2001-08-26Transaction IDs wrap around, per my proposal of 13-Aug-01. MoreTom Lane
documentation to come, but the code is all here. initdb forced.
2001-08-26Document single-letter createuser encryption options.Bruce Momjian
2001-08-25Replace implementation of pg_log as a relation accessed through theTom Lane
buffer manager with 'pg_clog', a specialized access method modeled on pg_xlog. This simplifies startup (don't need to play games to open pg_log; among other things, OverrideTransactionSystem goes away), should improve performance a little, and opens the door to recycling commit log space by removing no-longer-needed segments of the commit log. Actual recycling is not there yet, but I felt I should commit this part separately since it'd still be useful if we chose not to do transaction ID wraparound.
2001-08-25Add ENCRYPTED/UNENCRYPTED control in createuser script.Bruce Momjian
2001-08-24Add ecpg --help and --version. Renumber the exit status codes, which werePeter Eisentraut
documented wrong.
2001-08-24Start adding some more documentation about the number types. MakePeter Eisentraut
bigserial and alias for serial8 for consistency with bigint/int8.
2001-08-24Remove outdated documentation section of ecpg.Bruce Momjian
2001-08-24Rename config.h to pg_config.h and os.h to pg_config_os.h, fix a number ofPeter Eisentraut
places that were including the wrong files.
2001-08-22Add option to output SET SESSION AUTHORIZATION commands rather thanPeter Eisentraut
\connect, to avoid possible password prompts and such, at the drawback of having to have superuser access.
2001-08-21Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions inTom Lane
pgsql-hackers. pg_opclass now has a row for each opclass supported by each index AM, not a row for each opclass name. This allows pg_opclass to show directly whether an AM supports an opclass, and furthermore makes it possible to store additional information about an opclass that might be AM-dependent. pg_opclass and pg_amop now store "lossy" and "haskeytype" information that we previously expected the user to remember to provide in CREATE INDEX commands. Lossiness is no longer an index-level property, but is associated with the use of a particular operator in a particular index opclass. Along the way, IndexSupportInitialize now uses the syscaches to retrieve pg_amop and pg_amproc entries. I find this reduces backend launch time by about ten percent, at the cost of a couple more special cases in catcache.c's IndexScanOK. Initial work by Oleg Bartunov and Teodor Sigaev, further hacking by Tom Lane. initdb forced.
2001-08-21Update FAQ.Bruce Momjian
2001-08-21Add SCM_CREDS to get owner of unix-domain socket on BSD-like systems.Bruce Momjian
2001-08-20Update FAQ.Bruce Momjian
2001-08-16Sequences are now based on int8, not int4, arithmetic. SERIAL pseudo-typeTom Lane
has an alias SERIAL4 and a sister SERIAL8. SERIAL8 is just the same except the created column is type int8 not int4. initdb forced. Note this also breaks any chance of pg_upgrade from 7.1, unless we hack up pg_upgrade to drop and recreate sequences. (Which is not out of the question, but I don't wanna do it.)
2001-08-16Add new MD5 pg_hba.conf keyword. Prevent fallback to crypt.Bruce Momjian
2001-08-16Fix typo. pg_dump -B --> pg_dump -bTatsuo Ishii
2001-08-15Use MD5 for wire protocol encryption for >= 7.2 client/server.Bruce Momjian
Allow pg_shadow to be MD5 encrypted. Add ENCRYPTED/UNENCRYPTED option to CREATE/ALTER user. Add password_encryption postgresql.conf option. Update wire protocol version to 2.1.
2001-08-15Add convert.Tatsuo Ishii
2001-08-14Put back changes I overwrote in packaging 7.1.3.Bruce Momjian
2001-08-14sum() on int2 and int4 columns now uses an int8, not numeric, accumulatorTom Lane
for speed reasons; its result type also changes to int8. avg() on these datatypes now accumulates the running sum in int8 for speed; but we still deliver the final result as numeric, so that fractional accuracy is preserved. count() now counts and returns in int8, not int4. I am a little nervous about this possibly breaking users' code, but there didn't seem to be a strong sentiment for avoiding the problem. If we get complaints during beta, we can change count back to int4 and add a "count8" aggregate. For that matter, users can do it for themselves with a simple CREATE AGGREGATE command; the int4inc function is still present, so no C hacking is needed. Also added max() and min() aggregates for OID that do proper unsigned comparison, instead of piggybacking on int4 aggregates. initdb forced.