aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add db-local user names, per discussion on hackers.Bruce Momjian2002-08-18
|
* Fix typo.Tom Lane2002-08-17
|
* [ Newest version of patch applied.]Bruce Momjian2002-08-17
| | | | | | | | | | | | | | | | | | This patch is an updated version of the lock listing patch. I've made the following changes: - write documentation - wrap the SRF in a view called 'pg_locks': all user-level access should be done through this view - re-diff against latest CVS One thing I chose not to do is adapt the SRF to use the anonymous composite type code from Joe Conway. I'll probably do that eventually, but I'm not really convinced it's a significantly cleaner way to bootstrap SRF builtins than the method this patch uses (of course, it has other uses...) Neil Conway
* Add libpq connection timeout parameter.Bruce Momjian2002-08-17
| | | | Denis A Ustimenko
* Improve documentation of trigger firing queue handling, cleanup.Bruce Momjian2002-08-17
| | | | Neil Conway
* Editorial corrections.Tom Lane2002-08-17
|
* Broken markup.Tom Lane2002-08-17
|
* Add missing links.Tom Lane2002-08-17
|
* Add doc file for pg_resetxlog.Bruce Momjian2002-08-17
|
* Move pg_controldata to /bin.Bruce Momjian2002-08-17
|
* Modify pg_dump to dump foreign-key constraints as constraints, not asTom Lane2002-08-16
| | | | | | | sets of triggers. Also modify psql \d command to show foreign key constraints as such and hide the triggers. pg_get_constraintdef() function added to backend to support these. From Rod Taylor, code review and some editorialization by Tom Lane.
* Improve wording.Bruce Momjian2002-08-16
|
* Move pg_controldata from /contrib to src/bin.Bruce Momjian2002-08-16
|
* This patch improves the "Client Authentication" section of the user'sBruce Momjian2002-08-16
| | | | | | guide in a few minor ways. Neil Conway
* This patch improves the "Database Users and Permissions" section ofBruce Momjian2002-08-16
| | | | | | | the Administrator's Guide. This section needs a lot more work, but this is a start anyway... Neil Conway
* Tom Lane wrote:Bruce Momjian2002-08-15
| | | | | | | | | | | | | | | | | > There's no longer a separate call to heap_storage_create in that routine > --- the right place to make the test is now in the storage_create > boolean parameter being passed to heap_create. A simple change, but > it passeth patch's understanding ... Thanks. Attached is a patch against cvs tip as of 8:30 PM PST or so. Turned out that even after fixing the failed hunks, there was a new spot in bufmgr.c which needed to be fixed (related to temp relations; RelationUpdateNumberOfBlocks). But thankfully the regression test code caught it :-) Joe Conway
* Reorder entry to be alphabetical to match others.Bruce Momjian2002-08-15
|
* PostgreSQL 7.2.1 DocumentationBruce Momjian2002-08-15
| | | | | | | | | | | | | Chapter 1. libpq - C Library 1.3. Command Execution Functions 1.3.3. Escaping binary strings for inclusion in SQL queries I found the line "The result string length does not include the terminating zero byte of the result." is not right. The result string length does indeed include the terminating zero byte. Christoph Haller
* > Neil Conway <nconway@klamath.dyndns.org> writes:Bruce Momjian2002-08-15
| | | | | | | | | | | | | > > This patch improves the documentation of the UPDATE and ALTER TABLE > > commands to elaborate on the effect of specifying an "ONLY" clause. > > Unfortunately this is still only half the truth ... see the > SQL_INHERITANCE configuration variable. Okay, I've attached an updated patch with more information on SQL_INHERITANCE and inheritance behavior in prior releases. Neil Conway
* I'm giving a try at some TODO items. Currently it's the turn of theBruce Momjian2002-08-15
| | | | | | | | | | | PGPASSWORDFILE environment variable. I have modified libpq to make use of this variable. I present the first cut here. Currently the format for the file should be host:port:database:user:password Alvaro Herrera
* Add Cyrillic and other encodings for encoding conversion.Tatsuo Ishii2002-08-14
| | | | Patches submitted by Kaori Inaba (i-kaori@sra.co.jp).
* Update for longer NAMEDATALEN.Bruce Momjian2002-08-13
|
* Change NAMEDATALEN to 64, INDEX_MAX_KEYS/MAX_FUNC_ARGS to 32, per ↵Bruce Momjian2002-08-13
| | | | discussion on hackers.
* Remove obsolete uses of lanispl. Only used in pg_dump now, but can bePeter Eisentraut2002-08-13
| | | | removed altogether if pg_dump doesn't need it anymore.
* Correct description of sequence privileges.Peter Eisentraut2002-08-12
|
* Change memory-space accounting mechanism in tuplesort.c and tuplestore.cTom Lane2002-08-12
| | | | | | | | to make a reasonable attempt at accounting for palloc overhead, not just the requested size of each memory chunk. Since in many scenarios this will make for a significant reduction in the amount of space acquired, partially compensate by doubling the default value of SORT_MEM to 1Mb. Per discussion in pgsql-general around 9-Jun-2002..
* Code review of CLUSTER patch. Clean up problems with relcache gettingTom Lane2002-08-11
| | | | confused, toasted data getting lost, etc.
* Create/drop cast now requires ownership of at least one of the types.Peter Eisentraut2002-08-11
|
* Editorial improvements.Tom Lane2002-08-11
|
* Mention ANALYZE after CLUSTER.Bruce Momjian2002-08-10
|
* Major improvement in CLUSTER which preserves table characteristics usingBruce Momjian2002-08-10
| | | | | | | | | | | | relfilenode. I sent the CLUSTER patch a few days ago and I think it was missed. I append it again, this time including the regression test files. For the committer, please note that you have to cvs add the files as they don't exist. Maybe add to the parallel and serial schedules also, but I don't know such stuff. Alvaro Herrera (<alvherre[a]atentus.com>)
* psql prints its version number in its startup message, per recentTom Lane2002-08-10
| | | | | discussion. Also, cause the \timing command to display time in a format consistent with the backend's EXPLAIN ANALYZE output.
* Allow schema-qualified operator names to be used in the optionalTom Lane2002-08-10
| | | | arguments of CREATE OPERATOR.
* Make sure all clients have the same understanding of default user namePeter Eisentraut2002-08-10
| | | | | and database. In particular, make script wrappers understand the PGDATABASE environment variable.
* psql backslash commands are schema-aware. Pattern matching behaviorTom Lane2002-08-10
| | | | | follows recent pghackers discussion. This commit includes all the relevant fixes from Greg Mullane's patch of 24-June.
* Make sure monetary, numeric, and time locale categories are set to C andPeter Eisentraut2002-08-09
| | | | are only activated temporarily to read out formatting information.
* has_table_privilege spawns scions has_database_privilege, ↵Tom Lane2002-08-09
| | | | | | | | | | | has_function_privilege, has_language_privilege, has_schema_privilege to let SQL queries test all the new privilege types in 7.3. Also, add functions pg_table_is_visible, pg_type_is_visible, pg_function_is_visible, pg_operator_is_visible, pg_opclass_is_visible to test whether objects contained in schemas are visible in the current search path. Do some minor cleanup to centralize accesses to pg_database, as well.
* Some improvements in geometric-operators documentation.Tom Lane2002-08-08
|
* Fix bug in encoding conversion tableTatsuo Ishii2002-08-08
|
* Add SQL99 CONVERT() function.Tatsuo Ishii2002-08-06
|
* This patch fixes two typos in the documentation for the newly addedBruce Momjian2002-08-06
| | | | | | START TRANSACTION command. Neil Conway
* Forgot to add/remove files.Peter Eisentraut2002-08-05
|
* Add User's Guide chapters on Data Definition and Data Manipulation.Peter Eisentraut2002-08-05
| | | | | | | | | | | | Still needs to be filled with more information, but it gives us a framework to have a User's Guide with complete coverage of the basic SQL operations. Move arrays into data type chapter, inheritance into DDL chapter (for now). Make <comment>s show up in the output while the version number ends in "devel". Allow cross-book references with entities &cite-user; etc.
* Preliminary code review for anonymous-composite-types patch: fix breakageTom Lane2002-08-05
| | | | | | | | of functions returning domain types, update documentation for typtype, move get_typtype to lsyscache.c (actually, resurrect the old version), add defense against creating pseudo-typed table columns, fix some bogus list-parsing in grammar. Issues remain with respect to alias handling and type checking; Joe is on those.
* Rename backend_pid to pg_backend_pid, move docs to monitoring section.Bruce Momjian2002-08-04
|
* Attached are two patches to implement and document anonymous compositeBruce Momjian2002-08-04
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | types for Table Functions, as previously proposed on HACKERS. Here is a brief explanation: 1. Creates a new pg_type typtype: 'p' for pseudo type (currently either 'b' for base or 'c' for catalog, i.e. a class). 2. Creates new builtin type of typtype='p' named RECORD. This is the first of potentially several pseudo types. 3. Modify FROM clause grammer to accept: SELECT * FROM my_func() AS m(colname1 type1, colname2 type1, ...) where m is the table alias, colname1, etc are the column names, and type1, etc are the column types. 4. When typtype == 'p' and the function return type is RECORD, a list of column defs is required, and when typtype != 'p', it is disallowed. 5. A check was added to ensure that the tupdesc provide via the parser and the actual return tupdesc match in number and type of attributes. When creating a function you can do: CREATE FUNCTION foo(text) RETURNS setof RECORD ... When using it you can do: SELECT * from foo(sqlstmt) AS (f1 int, f2 text, f3 timestamp) or SELECT * from foo(sqlstmt) AS f(f1 int, f2 text, f3 timestamp) or SELECT * from foo(sqlstmt) f(f1 int, f2 text, f3 timestamp) Included in the patches are adjustments to the regression test sql and expected files, and documentation. p.s. This potentially solves (or at least improves) the issue of builtin Table Functions. They can be bootstrapped as returning RECORD, and we can wrap system views around them with properly specified column defs. For example: CREATE VIEW pg_settings AS SELECT s.name, s.setting FROM show_all_settings()AS s(name text, setting text); Then we can also add the UPDATE RULE that I previously posted to pg_settings, and have pg_settings act like a virtual table, allowing settings to be queried and set. Joe Conway
* Add IS OF type predicate.Thomas G. Lockhart2002-08-04
|
* Add Myannar Time, Iran Time variant name, and Marquesas Time.Thomas G. Lockhart2002-08-04
|
* Fix broken markup.Tom Lane2002-08-04
|
* Neil's patch claimed a column list didn't work for COPY BINARY.Tom Lane2002-08-04
| | | | Which was true when he submitted it, but is so no longer.
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-28 01:55:09 +0000