hcq/postgresql
1
0
Fork 0
mirror of https://git.postgresql.org/git/postgresql.git synced 2026-02-26 08:17:01 +08:00
Code Issues Packages Projects Releases Wiki Activity

Commit Graph

  • 66d56a8efe Fix username mismatch in initdb. Magnus. Bruce Momjian 2004-07-12 01:54:10 +00:00
  • a919fdfd3d Wording improvement. Bruce Momjian 2004-07-12 01:37:01 +00:00
  • 7bcdf2ebee Tablespace examples for CREATE TABLE/INDEX/SCHEMA/DATABASE as well as some other examples for CREATE DATABASE. Bruce Momjian 2004-07-12 01:22:53 +00:00
  • 3095c104f0 Move comma. Bruce Momjian 2004-07-12 01:10:17 +00:00
  • eba9be883c The outer #define was forgotten. Attached patch adds it; please apply. Bruce Momjian 2004-07-12 01:00:45 +00:00
  • 098d0304d7 Add: Bruce Momjian 2004-07-12 00:39:11 +00:00
  • 1ec448cda3 Added Matthew: Bruce Momjian 2004-07-12 00:23:59 +00:00
  • 233afe6a90 New Czech FAQ. Bruce Momjian 2004-07-12 00:22:51 +00:00
  • 2bd17a5f52 Add FAQ entry on hardware selection. Bruce Momjian 2004-07-12 00:18:57 +00:00
  • 118ec0daa8 Canonicalize preload_libraries after it is split up, not before. Bruce Momjian 2004-07-12 00:09:07 +00:00
  • 0589ab68c5 Remove: Bruce Momjian 2004-07-11 23:52:05 +00:00
  • 421089dc35 Cleanup for canonicalization fixes, from Tom. Bruce Momjian 2004-07-11 23:49:51 +00:00
  • a1f3209c07 Add: Bruce Momjian 2004-07-11 23:31:27 +00:00
  • 8dbd10d96d This patch fixes a small error in the Porting PL/SQL to PL/pgSQL section where a instr function parameter is mistyped as varchar. It works properly when changed to integer. Bruce Momjian 2004-07-11 23:26:51 +00:00
  • cf9fd800ec Example for create function using argument names Bruce Momjian 2004-07-11 23:23:43 +00:00
  • af4de81469 ALTER TABLE SET TABLESPACE. Gavin Sherry, some rework by Tom Lane. Tom Lane 2004-07-11 23:13:58 +00:00
  • 08d89db34d Update German FAQ> Bruce Momjian 2004-07-11 23:07:18 +00:00
  • d7c89ea9b2 Update URL's for mysql conversion tools. Bruce Momjian 2004-07-11 22:52:18 +00:00
  • 5c9d069daf Add: Bruce Momjian 2004-07-11 21:57:03 +00:00
  • 5ff9566686 Remove postgresql.conf of 'info' as a valid client_min_messages level. Bruce Momjian 2004-07-11 21:48:25 +00:00
  • 7b0f060d54 Use canonicalize_path for -D, GUC paths, and paths coming in from environment variables. Bruce Momjian 2004-07-11 21:34:04 +00:00
  • 8801110b20 Move TablespaceCreateDbspace() call into smgrcreate(), which is where it probably should have been to begin with; this is to cover cases like needing to recreate the per-db directory during WAL replay. Also, fix heap_create to force pg_class.reltablespace to be zero instead of the database's default tablespace; this makes the world safe for CREATE DATABASE to handle all tables in the default tablespace alike, as per previous discussion. And force pg_class.reltablespace to zero when creating a relation without physical storage (eg, a view); this avoids possibly having dangling references in this column after a subsequent DROP TABLESPACE. Tom Lane 2004-07-11 19:52:52 +00:00
  • 94d4d240bb Rename XLOG_BTREE_NEWPAGE xlog record type into XLOG_HEAP_NEWPAGE, and shift support code into heapam.c accordingly. This is in service of soon-to-be-committed ALTER TABLE SET TABLESPACE code that will want to use this same record type for both heaps and indexes. Tom Lane 2004-07-11 18:01:45 +00:00
  • 98e9775a3a Use standard macro for psql binary file open. Add comment explaining control-z requirement. Bruce Momjian 2004-07-11 13:29:16 +00:00
  • c8c40bbc9e Cause the format of BC timestamptz output to be 'datetime zone BC' rather than 'datetime BC zone', because the former is accepted by the timestamptz input converter while the latter may not be depending on spacing. This is not a loss of compatibility w.r.t. 7.4 and before, because until very recently there was never a case where we'd output both zone and 'BC'. Tom Lane 2004-07-11 04:57:20 +00:00
  • 59429adea9 Add: Bruce Momjian 2004-07-11 03:10:50 +00:00
  • ff2fbacc42 Fix trim_trailing_separator() to not trim c:\ nor \\network\ on Win32. Bruce Momjian 2004-07-11 02:59:42 +00:00
  • eee93173d4 Add: Bruce Momjian 2004-07-11 02:03:22 +00:00
  • 330c6c42be Open files in binary mode on Win32 so control-z isn't seen as EOF. Bruce Momjian 2004-07-11 00:54:55 +00:00
  • e5ca4bde79 Add: Bruce Momjian 2004-07-11 00:28:30 +00:00
  • 6063d11464 Add: Bruce Momjian 2004-07-11 00:26:36 +00:00
  • 130f89e93f Allow configuration files to be placed outside the data directory. Bruce Momjian 2004-07-11 00:18:45 +00:00
  • b4a98c5fcc Add: Bruce Momjian 2004-07-11 00:18:28 +00:00
  • 5dfd5063e2 Defend against overrun of ExtraOptions array --- strictly paranoia, since the person or script starting the postmaster has to be trusted anyway. Tom Lane 2004-07-10 23:29:16 +00:00
  • 99b225c528 Check more test points (in fact, every week in 1970..2004) to get a more accurate matching of our time zone to the system's zone. This method is able to distinguish Antarctica/Casey from Australia/Perth, as in Chris K-L's recent example; and it is not materially slower than before, because the extra checks generally don't get done against very many time zones. Tom Lane 2004-07-10 23:06:50 +00:00
  • b9f698eccb Fix BSD-only coding in port.c (passing a local variable to putenv). Also a quick but half-baked attempt to make trim_trailing_separator do the right thing with path consisting only of '/' --- still needs work for Windows I think. Tom Lane 2004-07-10 22:58:42 +00:00
  • 54affc0921 Test HAVING condition before computing targetlist of an Aggregate node. This is required by SQL spec to avoid failures in cases like SELECT sum(win)/sum(lose) FROM ... GROUP BY ... HAVING sum(lose) > 0; AFAICT we have gotten this wrong since day one. Kudos to Holger Jakobs for being the first to notice. Tom Lane 2004-07-10 18:39:44 +00:00
  • 82f755ec80 Test HAVING condition before computing targetlist of an Aggregate node. This is required by SQL spec to avoid failures in cases like SELECT sum(win)/sum(lose) FROM ... GROUP BY ... HAVING sum(lose) > 0; AFAICT we have gotten this wrong since day one. Kudos to Holger Jakobs for being the first to notice. Tom Lane 2004-07-10 18:39:23 +00:00
  • afa035c204 Clarify schema meanings in pg_dump manual page by referring to object definitions more frequently. Bruce Momjian 2004-07-10 15:51:28 +00:00
  • 732f2fda82 Add --enable-thread-safety-force to force a thread compile even if the OS thread tests fail. Bruce Momjian 2004-07-10 01:24:29 +00:00
  • 56442e9fab OK, another try at Darwin threads. Bruce Momjian 2004-07-08 18:25:22 +00:00
  • 2ba666ef01 Remove OSX thread flags. No consistent report. Bruce Momjian 2004-07-08 16:27:58 +00:00
  • d5bf36f606 Add OSX thread support for next 7.4.X Bruce Momjian 2004-07-07 13:04:48 +00:00
  • 4525418451 Add OSX thread support for next 7.4.X Bruce Momjian 2004-07-07 13:04:45 +00:00
  • f8d390402b Formatting improvements: Bruce Momjian 2004-07-07 12:48:54 +00:00
  • b4e660e352 Regenerate: Bruce Momjian 2004-07-07 12:45:50 +00:00
  • 8f599aa6ea regenerate. Bruce Momjian 2004-07-07 12:45:16 +00:00
  • aec271475a Bold dash line. > \#A dash (-) marks changes that will appear in the upcoming 7.5 release.# Bruce Momjian 2004-07-07 12:44:34 +00:00
  • a08baad671 Update highlighting of dash. Bruce Momjian 2004-07-07 12:25:02 +00:00
  • ea0078da2d Move section: Bruce Momjian 2004-07-06 20:29:31 +00:00
  • 28c4dd14cd Add comment describing ereport() NOTICE/WARNING distinction. Bruce Momjian 2004-07-06 19:51:59 +00:00
  • 33fe94b286 Reorder dash mention to be more prominient. Bruce Momjian 2004-07-06 16:18:31 +00:00
  • abef61155d Fix broken logic for pretty-printing parenthesis-suppression in UNION et al. Tom Lane 2004-07-06 04:50:54 +00:00
  • 07b4c48b6a Fix broken logic for pretty-printing parenthesis-suppression in UNION et al. Tom Lane 2004-07-06 04:50:21 +00:00
  • a21bb2722a Done: Bruce Momjian 2004-07-06 03:23:31 +00:00
  • a0e592141e Revert broken rpath addition. Tom Lane 2004-07-05 23:24:12 +00:00
  • ab50ed8f57 Fix unchecked mallocs/strdups added by recent placeholder-config-vars patch. Tom Lane 2004-07-05 23:14:14 +00:00
  • e5a806bb29 Added free() calls against memory leak in interval.c. Michael Meskes 2004-07-05 18:54:01 +00:00
  • 1fcaceeae0 Added free() calls against memory leak in interval.c. Michael Meskes 2004-07-05 18:51:51 +00:00
  • 073f7312a4 - Fixed indicator in SET DESCRIPTOR. - Added special handling of descriptor header information. - Some code cleanup. Michael Meskes 2004-07-05 09:45:54 +00:00
  • da09dea3e3 Fix paragraph mention in ALTER DATABASE manual page. Bruce Momjian 2004-07-05 02:34:43 +00:00
  • 9535ab9c85 Allow plperl to compile with Perl 5.05. Bruce Momjian 2004-07-05 02:18:31 +00:00
  • 959b353db2 Fix misspellings: langauge -> language. Tom Lane 2004-07-04 23:34:24 +00:00
  • 8715789928 Made sure SET DESCRIPTOR accepts all data types including constants. Michael Meskes 2004-07-04 15:02:24 +00:00
  • a72dd7a9e4 Okay, I've had it with answering newbie questions about why plpgsql FOR loops are giving weird syntax errors. Restructure parsing of FOR loops so that the integer-loop-vs-query-loop decision is driven off the presence of '..' between IN and LOOP, rather than the presence of a matching record/row variable name. Hopefully this will make the behavior a bit more transparent. Tom Lane 2004-07-04 02:49:04 +00:00
  • f5c798ee82 Fix no-longer-correct bit-pushing in TransactionIdSetStatus, per Alvaro. Tom Lane 2004-07-03 02:55:56 +00:00
  • e34082ee3b Add missing operators of the form interval-plus-datetime, as required for better SQL compliance in this area, per recent discussion. Mark related operators as commutators where possible. (The system doesn't actually care about commutator marking for operators not returning boolean, at the moment, but this seems forward-thinking and besides it made it easier to verify that we hadn't missed any.) Also, remove interval-minus-time and interval-minus-timetz operators. I'm not sure how these got in, but they are nonstandard and had very obviously broken behavior. (minus is not commutative in anyone's book.) I doubt anyone had ever used 'em, because we'd surely have gotten a bug report about it if so. Tom Lane 2004-07-02 22:50:23 +00:00
  • 0b89d261c7 Andreas Pflug wrote: From an idea of Bruce, the attached patch implements the function pg_tablespace_databases(oid) RETURNS SETOF oid which delivers as set of database oids having objects in the selected tablespace, enabling an admin to examine only the databases affecting the tablespace for objects instead of scanning all of them. Joe Conway 2004-07-02 18:59:25 +00:00
  • 6d6c8b0d96 Translation update Peter Eisentraut 2004-07-02 15:07:10 +00:00
  • 4a9468bf29 Translation update Peter Eisentraut 2004-07-02 15:02:29 +00:00
  • cd4fd672dd Attached is a 1 line bug fix for dbmirror that was submitted. It fixes a bug where some transactions could be dropped when writing mirrored SQL statements to files. -- Steven Singer Joe Conway 2004-07-02 00:58:09 +00:00
  • 25ee160acd More paranoia in AtEOSubXact_SPI: don't assume we can safely use SPI_finish for cleaning up. It seems possible that the memory contexts SPI_finish would try to touch are already gone; and there's no need for SPI itself to delete them, since the containing contexts will surely be going away anyway at transaction end. Tom Lane 2004-07-01 21:17:13 +00:00
  • 1732cb0dbe plperl update from Andrew Dunstan, deriving (I believe) from Command Prompt's plperlNG. Review and minor cleanup/improvements by Joe Conway. Joe Conway 2004-07-01 20:50:22 +00:00
  • b6197fe069 Further review of xact.c state machine for nested transactions. Fix problems with starting subtransactions inside already-failed transactions. Clean up some comments. Tom Lane 2004-07-01 20:11:03 +00:00
  • e15d0bb8e8 Removed unused variable and added a typecast. Michael Meskes 2004-07-01 18:32:58 +00:00
  • 13629df5a1 Add double metaphone code from Andrew Dunstan. Also change metaphone so that an empty input string causes an empty output string to be returned, instead of throwing an ERROR -- per complaint from Aaron Hillegass, and consistent with double metaphone. Fix examples in README.soundex pointed out by James Robinson. Joe Conway 2004-07-01 03:25:48 +00:00
  • 77a436ba55 Fix seriously nasty memory leak in new TransactionIdIsInProgress code. Tom Lane 2004-07-01 03:13:05 +00:00
  • 573a71a5da Nested transactions. There is still much left to do, especially on the performance front, but with feature freeze upon us I think it's time to drive a stake in the ground and say that this will be in 7.5. Tom Lane 2004-07-01 00:52:04 +00:00
  • 4c9aa572fa Revert mistaken #include change, per Merlin Moncure. Tom Lane 2004-06-30 15:30:41 +00:00
  • 90326c01c9 Added SET DESCRIPTOR command. Note that this still has some bugs. The functionality is there though, it's just a matter of fixing the bugs now. Cleaned up error handling in preprocessor. Michael Meskes 2004-06-30 15:01:58 +00:00
  • 57bc0bf196 Override upstream DSSSL style sheet formatting changes Peter Eisentraut 2004-06-29 20:46:35 +00:00
  • c7beffcc1d Override upstream DSSSL style sheet formatting changes Peter Eisentraut 2004-06-29 20:44:34 +00:00
  • bc7589a292 Comma splice police Peter Eisentraut 2004-06-29 19:57:40 +00:00
  • bb89237531 1 Eliminate duplicate field HLWORD->skip 2 Rework support for html tags in parser 3 add HighlightAll to headline function for generating highlighted whole text with saved html tags Teodor Sigaev 2004-06-28 16:19:09 +00:00
  • e48cfacb84 Arrays can be read as arrays or as character strings now. Michael Meskes 2004-06-28 11:47:42 +00:00
  • 04ab0cb5c1 Remove some no-longer-needed #includes. Tom Lane 2004-06-28 01:19:11 +00:00
  • adc507f242 Fix some bogus code in ConstBit production --- it managed to work, but only because 14627 still contained the same node that BitWithoutLength had just produced. Make it more transparent. Also adjust ConstCharacter to be coded the same way for consistency. Tom Lane 2004-06-28 00:18:47 +00:00
  • b3d36a2467 Fix bogus line break within a file name, as noted by Alvaro. Tom Lane 2004-06-27 22:58:19 +00:00
  • a3c695d0c2 - Only use typedefs inside their scope. - Variables that are out of scope, were not removed all the time. - Make a varchar NULL set everything to 0 when not using indicators. Michael Meskes 2004-06-27 12:32:47 +00:00
  • 03ad5da8f8 - Only use typedefs inside their scope. - Variables that are out of scope, were not removed all the time. - Make a varchar NULL set everything to 0 when not using indicators. - Synced parser. Michael Meskes 2004-06-27 12:28:42 +00:00
  • 4eb5f0a8e2 Translation updates Dennis Bjorklund 2004-06-27 09:35:14 +00:00
  • 0ceeb4cbbe Adjust pgstat message definitions so that the target message size is specified in just one place and adhered to exactly, rather than just more or less. A side effect is to increase PGSTAT_ACTIVITY_SIZE (maximum reported query length) from 256 to nearly 1000. Tom Lane 2004-06-26 16:32:04 +00:00
  • b2ca707746 Translation updates Dennis Bjorklund 2004-06-26 07:19:16 +00:00
  • 03e1e6cad8 Translation updates: update-po Dennis Bjorklund 2004-06-26 07:11:31 +00:00
  • ac1cbcc961 Translation updates Dennis Bjorklund 2004-06-26 07:03:06 +00:00
  • ddf6518b95 Fix to work better with Exuberant's version of ctags. Tom Lane 2004-06-25 22:00:40 +00:00
  • 0adfa2c39d Support renaming of tablespaces, and changing the owners of aggregates, conversions, functions, operators, operator classes, schemas, types, and tablespaces. Fold the existing implementations of alter domain owner and alter database owner in with these. Tom Lane 2004-06-25 21:55:59 +00:00
  • 1621192b11 Translation updates Dennis Bjorklund 2004-06-25 17:53:22 +00:00
  • a0e842d81b Add pg_get_serial_sequence() function, and cause pg_dump to use it. This eliminates the assumption that a serial column's sequence will have the same name on reload that it was given in the original database. Tom Lane 2004-06-25 17:20:29 +00:00
  • ef2880263c #ifdef out file permissions check on SSL key file when on Windows, as we also have done for the data directory permissions check. Tom Lane 2004-06-25 15:07:52 +00:00