aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* I have added these macros to c.h:Bruce Momjian2005-12-25
| | | | | | | | | #define HIGHBIT (0x80) #define IS_HIGHBIT_SET(ch) ((unsigned char)(ch) & HIGHBIT) and removed CSIGNBIT and mapped it uses to HIGHBIT. I have also added uses for IS_HIGHBIT_SET where appropriate. This change is purely for code clarity.
* Minor doc tweak: "NOT NULL" is redundant with "SERIAL" in example.Neil Conway2005-12-25
|
* Spell fix. Andrew.Bruce Momjian2005-12-24
|
* Update why unified diff is _sometimes_ better.Bruce Momjian2005-12-24
|
* Previous commit message should have been:Bruce Momjian2005-12-24
| | | | Add comment marker for PG_ENCODING_BE_LAST.
* AddBruce Momjian2005-12-24
|
* Alignment cleanup.Bruce Momjian2005-12-24
|
* Formatting cleanups.Bruce Momjian2005-12-24
|
* Formatting cleanup.Bruce Momjian2005-12-24
|
* Fix long standing Asian multibyte charsets bug.Tatsuo Ishii2005-12-24
| | | | | | | | | | | See: Subject: [HACKERS] bugs with certain Asian multibyte charsets From: Tatsuo Ishii <ishii@sraoss.co.jp> To: pgsql-hackers@postgresql.org Date: Sat, 24 Dec 2005 18:25:33 +0900 (JST) for more details/
* Wups, fat-fingered the calculation the first time. Update comment inTom Lane2005-12-23
| | | | postgresql.conf.sample too.
* Update info about shared memory space calculation to match CVS tip's behavior.Tom Lane2005-12-23
|
* Fix make_relative_path() to support cases where target_path and bin_pathTom Lane2005-12-23
| | | | | | | | | | | differ by more than the last directory component. Instead of insisting that they match up to the last component, accept whatever common prefix they have, and try to replace the non-matching part of bin_path with the non-matching part of target_path in the actual executable's path. In one way this is tighter than the old code, because it insists on a match to the part of bin_path we want to substitute for, rather than blindly stripping one directory component from the executable's path. Per gripe from Martin Pitt and subsequent discussion.
* Allow CREATE/ALTER ROLE PASSWORD NULL to allow restoring the default statePeter Eisentraut2005-12-23
| | | | of having no password.
* Fix for rearranging encoding id ISO-8859-5 to ISO-8859-8.Tatsuo Ishii2005-12-23
| | | | | | | | | Also make the code more robust by searching for target encoding in the internal charset map. Problem reported by Sagi Bashari on 2005/12/21. See "[BUGS] BUG #2120: Crash when doing UTF8<->ISO_8859_8 encoding conversion" on pgsql-bugs list for more details.
* Add an officially exported libpq function to encrypt passwords, andTom Lane2005-12-23
| | | | | modify the previous \password patch to use it instead of depending on a not-officially-exported function. Per discussion.
* Add quotes around search_path "$user" so that SHOW output can be used inBruce Momjian2005-12-23
| | | | SET.
* Update item:Bruce Momjian2005-12-22
| | | | | | | > > A more complex solution would be to save multiple plans for different > cardinality and use the appropriate plan based on the EXECUTE values. >
* Adjust string comparison so that only bitwise-equal strings are consideredTom Lane2005-12-22
| | | | | | | | | | | | equal: if strcoll claims two strings are equal, check it with strcmp, and sort according to strcmp if not identical. This fixes inconsistent behavior under glibc's hu_HU locale, and probably under some other locales as well. Also, take advantage of the now-well-defined behavior to speed up texteq, textne, bpchareq, bpcharne: they may as well just do a bitwise comparison and not bother with strcoll at all. NOTE: affected databases may need to REINDEX indexes on text columns to be sure they are self-consistent.
* Update interval documenation to mention the storage system used.Bruce Momjian2005-12-22
|
* Add documentation example of using interval multiplication with 'days'.Bruce Momjian2005-12-21
| | | | Backpatch to 8.1.X.
* Add additional example for interval multiplication.Bruce Momjian2005-12-21
| | | | | | | | | Fix example for day and hours interval subtraction for new computation method. Update interval examples to display zero seconds, which is our default. Backpatch to 8.1.X.
* Multibyte encodings support for ISpell dictionaryTeodor Sigaev2005-12-21
|
* Teach planner how to rearrange join order for some classes of OUTER JOIN.Tom Lane2005-12-20
| | | | | | Per my recent proposal. I ended up basing the implementation on the existing mechanism for enforcing valid join orders of IN joins --- the rules for valid outer-join orders are somewhat similar.
* Fix broken markup.Tom Lane2005-12-20
|
* Add new psql command \password for changing role password with client-sidePeter Eisentraut2005-12-18
| | | | password encryption. Also alter createuser command to the same effect.
* Fix typo.Bruce Momjian2005-12-17
|
* Update s_lock.c comments.Bruce Momjian2005-12-17
|
* Update ASM comments.Bruce Momjian2005-12-17
|
* Remove item:Bruce Momjian2005-12-17
| | | | | | | | | | | | | < * Allow star join optimizations < < While our bitmap scan allows multiple indexes to be joined to get < to heap rows, a star joins allows multiple dimension _tables_ to < be joined to index into a larger main fact table. The join is < usually performed by either creating a cartesian product of all < the dimmension tables and doing a single join on that product or < using subselects to create bitmaps of each dimmension table match < and merge the bitmaps to perform the join on the fact table. Some < of these algorithms might be patented.
* Update:Bruce Momjian2005-12-17
| | | | | | | | < * Flush cached query plans when the dependent objects change or < when the cardinality of parameters changes dramatically > * Flush cached query plans when the dependent objects change, > when the cardinality of parameters changes dramatically, or > when new ANALYZE statistics are available
* Add mention of possible patent problems with star joins, per JoshuaBruce Momjian2005-12-17
| | | | | | | | Drake: < and merge the bitmaps to perform the join on the fact table. > and merge the bitmaps to perform the join on the fact table. Some > of these algorithms might be patented.
* Add:Bruce Momjian2005-12-17
| | | | | | | | | | | | * Allow star join optimizations While our bitmap scan allows multiple indexes to be joined to get to heap rows, a star joins allows multiple dimension _tables_ to be joined to index into a larger main fact table. The join is usually performed by either creating a cartesian product of all the dimmension tables and doing a single join on that product or using subselects to create bitmaps of each dimmension table match and merge the bitmaps to perform the join on the fact table.
* Add more function to TODO:Bruce Momjian2005-12-17
| | | | | | < * %Add pg_get_acldef(), pg_get_typedefault(), and pg_get_attrdef() > * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), > pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
* Update:Bruce Momjian2005-12-17
| | | | | | < * Flush cached query plans when the dependent objects change > * Flush cached query plans when the dependent objects change or > when the cardinality of parameters changes dramatically
* Update FAQ, second version.Bruce Momjian2005-12-17
| | | | J.Kuwamura
* Update Japanese FAQ.Bruce Momjian2005-12-17
| | | | J.Kuwamura
* Add:Bruce Momjian2005-12-17
| | | | | > * Allow the count returned by SELECT, etc to be to represent as an int64 > to allow a higher range of values
* Add URL for Solaris qsort() bug.Bruce Momjian2005-12-17
|
* Update doc mention that Solaris qsort() might be fixed.Bruce Momjian2005-12-17
|
* Add a note to Win32 gettimeofday() emulation, per Qingqing Zhou.Alvaro Herrera2005-12-16
|
* Force update.Bruce Momjian2005-12-16
|
* Fix some typos in the TODO list.Neil Conway2005-12-16
|
* Rethink prior patch to filter out dead backend entries from the pgstatsTom Lane2005-12-16
| | | | | | | | file. The original code probed the PGPROC array separately for each PID, which was not good for large numbers of backends: not only is the runtime O(N^2) but most of it is spent holding ProcArrayLock. Instead, take the lock just once and copy the active PIDs into an array, then use qsort and bsearch so that the lookup time is more like O(N log N).
* Defend against crash while processing Describe Statement or Describe PortalTom Lane2005-12-14
| | | | | | messages, when client attempts to execute these outside a transaction (start one) or in a failed transaction (reject message, except for COMMIT/ROLLBACK statements which we can handle). Per report from Francisco Figueiredo Jr.
* Fix problem with whole-row Vars referencing sub-select outputs, perTom Lane2005-12-14
| | | | | example from Jim Dew. Add some simple regression tests, since this is an area we seem to break regularly :-(
* Use a proper enum for tri-valued variables.Bruce Momjian2005-12-12
|
* Document tri-valued variables in createdb, +1, -1, 0.Bruce Momjian2005-12-12
|
* Update wording, query -> statement:Bruce Momjian2005-12-12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | < * %Allow pooled connections to list all prepared queries > * %Allow pooled connections to list all prepared statements 28c28 < the queries prepared in the current session. > the statements prepared in the current session. 143c143 < o Allow a warm standby system to also allow read-only queries > o Allow a warm standby system to also allow read-only statements 404c404 < * Add GUC to issue notice about queries that use unjoined tables > * Add GUC to issue notice about statements that use unjoined tables 490c490 < Another idea would be to allow actual SELECT queries in a COPY. > Another idea would be to allow actual SELECT statements in a COPY. 554c554 < o Allow function argument names to be queries from PL/PgSQL > o Allow function argument names to be statements from PL/PgSQL 591c591 < o Improve psql's handling of multi-line queries > o Improve psql's handling of multi-line statements < Currently, while \e saves a single query as one entry, interactive < queries are saved one line at a time. Ideally all queries > Currently, while \e saves a single statement as one entry, interactive > statements are saved one line at a time. Ideally all statements 665c665 < o Allow query results to be automatically batched to the client > o Allow statement results to be automatically batched to the client 667c667 < Currently, all query results are transfered to the libpq > Currently, all statement results are transfered to the libpq 672c672 < One complexity is that a query like SELECT 1/col could error > One complexity is that a statement like SELECT 1/col could error 739c739 < * Allow queries across databases or servers with transaction > * Allow statements across databases or servers with transaction < inheritance, allow it to work for UPDATE and DELETE queries, and allow < it to be used for all queries with little performance impact > inheritance, allow it to work for UPDATE and DELETE statements, and allow > it to be used for all statements with little performance impact 876c876 < * Consider automatic caching of queries at various levels: > * Consider automatic caching of statements at various levels: 947c947 < a single session using multiple threads to execute a query faster. > a single session using multiple threads to execute a statement faster. 1025c1025 < * Log queries where the optimizer row estimates were dramatically > * Log statements where the optimizer row estimates were dramatically 1146c1146 < of result sets using new query protocol > of result sets using new statement protocol
* Improve support of multibyte encoding:Teodor Sigaev2005-12-12
| | | | | | | | - tsvector_(in|out) - tsquery_(in|out) - to_tsvector - to_tsquery, plainto_tsquery - 'simple' dictionary
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-04 16:48:15 +0000