summaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAgeFilesLines
* Skip stripping postgres_fe.h include file.Bruce Momjian2006-07-131-1/+2
|
* More include file adjustments.Bruce Momjian2006-07-139-22/+9
|
* More include file adjustments.Bruce Momjian2006-07-1315-21/+34
|
* Allow include files to compile own their own.Bruce Momjian2006-07-13124-190/+259
| | | | | | | Strip unused include files out unused include files, and add needed includes to C files. The next step is to remove unused include files in C files.
* Improve pginclude tools to process include file usage by other include files.Bruce Momjian2006-07-132-4/+11
|
* Remove trailing comma from CreateStmtLikeOption enum definition. ThisNeil Conway2006-07-131-2/+2
| | | | is harmless, but it causes a warning with Tru64's cc.
* Fix pgrminclude to work for stripping include files.Bruce Momjian2006-07-121-15/+16
|
* Clean up for warning:Joe Conway2006-07-121-6/+6
| | | | | | | | | fe-auth.c:573: warning: passing argument 1 of 'free' discards qualifiers from pointer target type pg_krb5_authname used to return a (const char *) to memory allocated by krb. Somewhere along the lines this was changed so that a copy was made, returned, and freed instead. However the const modifier was never removed.
* Apply entab fix from Marko Kreen for these problems:Alvaro Herrera2006-07-112-3/+4
| | | | | | | | - halt.c did not include stdlib.h, thus missed exit() prototype - Makefile ignores BINDIR for install. - Makefile calls install with user/group args, thus failing for regular user. While trying it I noticed that the Makefile does not support VPATH builds ...
* Tweak fillfactor code as per my recent proposal. Fix nbtsort.c so thatTom Lane2006-07-116-24/+37
| | | | | | it can handle small fillfactors for ordinary-sized index entries without failing on large ones; fix nbtinsert.c to distinguish leaf and nonleaf pages; change the minimum fillfactor to 10% for all index types.
* Improve pginclude tests.Bruce Momjian2006-07-111-7/+11
|
* Improve pginclude compile flags.Bruce Momjian2006-07-112-5/+8
|
* Update pginclude documentation.Bruce Momjian2006-07-111-2/+9
|
* Add support to GIN for =(anyarray,anyarray) operationTeodor Sigaev2006-07-116-5/+52
|
* Have pgrminclude process include files too.Bruce Momjian2006-07-111-5/+3
|
* Add $CFLAGS support to pgrminclude.Bruce Momjian2006-07-111-2/+2
|
* Move pgrminclude debug code to be more effective.Bruce Momjian2006-07-111-5/+5
|
* Improve shell script wrapping.Bruce Momjian2006-07-111-2/+4
|
* Add comments to pgrminclude.Bruce Momjian2006-07-111-1/+4
|
* Alphabetically order reference to include files, "S"-"Z".Bruce Momjian2006-07-1113-56/+56
|
* Alphabetically order reference to include files, "N" - "S".Bruce Momjian2006-07-1120-48/+48
|
* Alphabetically order reference to include files, "G" - "M".Bruce Momjian2006-07-1112-28/+28
|
* GIN improvementsTeodor Sigaev2006-07-113-70/+217
| | | | | | | | - Replace sorted array of entries in maintenance_work_mem to binary tree, this should improve create performance. - More precisely calculate allocated memory, eliminate leaks with user-defined extractValue() - Improve wordings in tsearch2
* Sort reference of include files, "A" - "F".Bruce Momjian2006-07-1118-38/+38
|
* Reverse inclusion order of <ws2tcpip.h> and <winsock2.h>, per Dave Page.Tom Lane2006-07-111-1/+1
|
* Allow each C include file to compile on its own by including any neededBruce Momjian2006-07-1113-38/+62
| | | | header files.
* Add libpq include directory to script.Bruce Momjian2006-07-111-2/+2
|
* Fix ALTER TABLE to check pre-existing NOT NULL constraints when rewritingTom Lane2006-07-101-31/+38
| | | | | | a table. Otherwise a USING clause that yields NULL can leave the table violating its constraint (possibly there are other cases too). Per report from Alexander Pravking.
* Move pthread-win32.h to /port, modify bcc/msvc makefiles.Bruce Momjian2006-07-103-2/+2
|
* Improve compile line for tool.Bruce Momjian2006-07-101-2/+3
|
* Update usage documention for pgincludeBruce Momjian2006-07-101-4/+6
|
* Add $CFLAGS handling to pgcompinclude.Bruce Momjian2006-07-101-2/+2
|
* Fix 'find' args for pgcompinclude tool.Bruce Momjian2006-07-101-2/+2
|
* Improve tool coding.Bruce Momjian2006-07-101-3/+3
|
* Improve vacuum code to track minimum Xids per table instead of per database.Alvaro Herrera2006-07-1018-257/+506
| | | | | | | | | | | | | | | | | | | | | | | | | | To this end, add a couple of columns to pg_class, relminxid and relvacuumxid, based on which we calculate the pg_database columns after each vacuum. We now force all databases to be vacuumed, even template ones. A backend noticing too old a database (meaning pg_database.datminxid is in danger of falling behind Xid wraparound) will signal the postmaster, which in turn will start an autovacuum iteration to process the offending database. In principle this is only there to cope with frozen (non-connectable) databases without forcing users to set them to connectable, but it could force regular user database to go through a database-wide vacuum at any time. Maybe we should warn users about this somehow. Of course the real solution will be to use autovacuum all the time ;-) There are some additional improvements we could have in this area: for example the vacuum code could be smarter about not updating pg_database for each table when called by autovacuum, and do it only once the whole autovacuum iteration is done. I updated the system catalogs documentation, but I didn't modify the maintenance section. Also having some regression tests for this would be nice but it's not really a very straightforward thing to do. Catalog version bumped due to system catalog changes.
* Improve script by processing only C files.Bruce Momjian2006-07-101-2/+2
|
* Testing commit stuffAlvaro Herrera2006-07-101-1/+1
|
* Fix typo in comment.Alvaro Herrera2006-07-081-2/+2
|
* WIN32 fixes:Bruce Momjian2006-07-066-6/+56
| | | | | | | | | I take out patch for this as a promise. This is client-build support of MS-VC6+. Fix for different getaddrinfo structure ordering on Win32 for IPv6. Hiroshi Saito
* Attached patch is required ot build with the CRT that comes with VisualBruce Momjian2006-07-062-3/+9
| | | | | | | | | | Studio 2005. Basically MS defined errcode in the headers with a typedef, so we have to #define it out of the way. While at it, fix a function declaration in plpython that didn't match the implementation (volatile missing). Magnus Hagander
* Please find attached two patches for documentation and regression testsBruce Momjian2006-07-069-57/+275
| | | | | | for the usage of full time zone names. Joachim Wieland
* Fixed remaining Coverity bugs.Michael Meskes2006-07-053-10/+30
|
* Remove libpq's PQescapeIdentifier(), not safe from injection attacks.Bruce Momjian2006-07-043-43/+3
|
* Fix typos in comments.Neil Conway2006-07-041-3/+3
|
* Code review for FILLFACTOR patch. Change WITH grammar as per earlierTom Lane2006-07-0355-1074/+1069
| | | | | | | | | | | | | | | | discussion (including making def_arg allow reserved words), add missed opt_definition for UNIQUE case. Put the reloptions support code in a less random place (I chose to make a new file access/common/reloptions.c). Eliminate header inclusion creep. Make the index options functions safely user-callable (seems like client apps might like to be able to test validity of options before trying to make an index). Reduce overhead for normal case with no options by allowing rd_options to be NULL. Fix some unmaintainably klugy code, including getting rid of Natts_pg_class_fixed at long last. Some stylistic cleanup too, and pay attention to keeping comments in sync with code. Documentation still needs work, though I did fix the omissions in catalogs.sgml and indexam.sgml.
* Do a pass of code review for the ALTER TABLE ADD INHERITS patch. KeepNeil Conway2006-07-024-138/+135
| | | | | | | | | the read lock we hold on the table's parent relation until commit. Update equalfuncs.c for the new field in AlterTableCmd. Various improvements to comments, variable names, and error reporting. There is room for further improvement here, but this is at least a step in the right direction.
* Add FILLFACTOR to CREATE INDEX.Bruce Momjian2006-07-0260-303/+1378
| | | | ITAGAKI Takahiro
* ALTER TABLE ... ADD/DROPS INHERIT (actually INHERIT / NO INHERIT)Bruce Momjian2006-07-026-13/+617
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Open items: There were a few tangentially related issues that have come up that I think are TODOs. I'm likely to tackle one or two of these next so I'm interested in hearing feedback on them as well. . Constraints currently do not know anything about inheritance. Tom suggested adding a coninhcount and conislocal like attributes have to track their inheritance status. . Foreign key constraints currently do not get copied to new children (and therefore my code doesn't verify them). I don't think it would be hard to add them and treat them like CHECK constraints. . No constraints at all are copied to tables defined with LIKE. That makes it hard to use LIKE to define new partitions. The standard defines LIKE and specifically says it does not copy constraints. But the standard already has an option called INCLUDING DEFAULTS; we could always define a non-standard extension LIKE table INCLUDING CONSTRAINTS that gives the user the option to request a copy including constraints. . Personally, I think the whole attislocal thing is bunk. The decision about whether to drop a column from children tables or not is something that should be up to the user and trying to DWIM based on whether there was ever a local definition or the column was acquired purely through inheritance is hardly ever going to match up with user expectations. . And of course there's the whole unique and primary key constraint issue. I think to get any traction at all on this you have a prerequisite of a real partitioned table implementation where the system knows what the partition key is so it can recognize when it's a leading part of an index key. Greg Stark
* Fix oversight in planning for multiple indexscans driven byTom Lane2006-07-013-39/+84
| | | | | | | | ScalarArrayOpExpr index quals: we were estimating the right total number of rows returned, but treating the index-access part of the cost as if a single scan were fetching that many consecutive index tuples. Actually we should treat it as a multiple indexscan, and if there are enough of 'em the Mackert-Lohman discount should kick in.
* Revise the planner's handling of "pseudoconstant" WHERE clauses, that isTom Lane2006-07-0120-295/+465
| | | | | | | | | | | | | | | | | | | clauses containing no variables and no volatile functions. Such a clause can be used as a one-time qual in a gating Result plan node, to suppress plan execution entirely when it is false. Even when the clause is true, putting it in a gating node wins by avoiding repeated evaluation of the clause. In previous PG releases, query_planner() would do this for pseudoconstant clauses appearing at the top level of the jointree, but there was no ability to generate a gating Result deeper in the plan tree. To fix it, get rid of the special case in query_planner(), and instead process pseudoconstant clauses through the normal RestrictInfo qual distribution mechanism. When a pseudoconstant clause is found attached to a path node in create_plan(), pull it out and generate a gating Result at that point. This requires special-casing pseudoconstants in selectivity estimation and cost_qual_eval, but on the whole it's pretty clean. It probably even makes the planner a bit faster than before for the normal case of no pseudoconstants, since removing pull_constant_clauses saves one useless traversal of the qual tree. Per gripe from Phil Frost.
View Lorry Controller Status