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

Commit Graph

  • dfafeb6a89 Update Solaris FAQ to mention -fast. Bruce Momjian 2003-10-09 17:11:13 +00:00
  • b1d955ea7b Remove -pipe on Linux, per reports from Peter. Bruce Momjian 2003-10-09 16:52:45 +00:00
  • 85bd172c45 Add -pipe compile for Linux. Bruce Momjian 2003-10-09 14:47:59 +00:00
  • 7185455c08 Make template CFLAGS handling consistent. Bruce Momjian 2003-10-09 14:40:37 +00:00
  • 1dad866bb4 Someone report me small bug in contrib/pg_dumplo today. It's problem with a little dirty snprintf() usage which I used some years ago: Bruce Momjian 2003-10-09 13:38:05 +00:00
  • 6687152582 Re-add -pipe compile flags for bsd's. Bruce Momjian 2003-10-09 04:34:02 +00:00
  • b510c44202 Update: Bruce Momjian 2003-10-09 04:29:40 +00:00
  • 0e22cb1232 This centralizes the optimization defaults into configure.in, rather than having CFLAGS= in the template files. Bruce Momjian 2003-10-09 03:20:34 +00:00
  • c1a0d72da6 Add: Bruce Momjian 2003-10-09 03:17:24 +00:00
  • dcad7949f8 Change "query:" to "statement:". Bruce Momjian 2003-10-09 02:40:18 +00:00
  • 6acca5765e Add quotes to CFLAG define. Bruce Momjian 2003-10-09 02:37:09 +00:00
  • f8d90fcc0a Protected access to variable m_preparedCount via synchronized function to prevent multiple threads using automatic cursors on the same connection from stomping over each others cursor. Jan Wieck 2003-10-09 01:17:07 +00:00
  • 67afe3d861 Add: < 346a346 > * Remove CREATE CONSTRAINT TRIGGER Bruce Momjian 2003-10-08 22:29:58 +00:00
  • 5fc9d0e3f6 Add 2-phase info, add Win32 URL: Bruce Momjian 2003-10-08 21:44:06 +00:00
  • 46c27c6997 New translations Peter Eisentraut 2003-10-08 20:35:39 +00:00
  • d5ea0d5ecb Add: Bruce Momjian 2003-10-08 19:33:53 +00:00
  • c99a41be95 New translations Peter Eisentraut 2003-10-08 18:38:49 +00:00
  • 2ff4091862 Add quotes around -O setting for consistency. Bruce Momjian 2003-10-08 18:23:08 +00:00
  • 7ceadb8fab Change some awkward wording in the pg_autovacuum README file. I really only read this because of Niel :-) Bruce Momjian 2003-10-08 18:18:04 +00:00
  • 163f0b2d48 Removed my debug printf() call from numeric.c Michael Meskes 2003-10-08 08:28:57 +00:00
  • bdae05f5d1 Use calloc() to allocate empty structures. Bruce Momjian 2003-10-08 03:52:32 +00:00
  • b8382c2688 Have log_min_duration_statement = 0 always print duration/statement. Bruce Momjian 2003-10-08 03:49:38 +00:00
  • cfd992ecba Fixed floating point exception in long=>numeric conversion. Michael Meskes 2003-10-07 18:36:46 +00:00
  • d665217278 Fix include used by entab. Bruce Momjian 2003-10-07 17:40:09 +00:00
  • 06e6aa236c Add missing include file. Peter Eisentraut 2003-10-07 08:07:56 +00:00
  • 3cda980298 Fixed error handling in Informix compat str to date conversion. Michael Meskes 2003-10-07 05:46:56 +00:00
  • 34e9ab027b New Italian translation Peter Eisentraut 2003-10-06 21:50:45 +00:00
  • b05ff39d7c Fix binary_oper_exact() so that the heuristic 'an unknown literal on one side of a binary operator is probably supposed to be the same type as the other operand' will be applied for domain types. This worked in 7.3 but was broken in 7.4 due to code rearrangements. Mea culpa. Tom Lane 2003-10-06 20:09:47 +00:00
  • f98cbb76a0 Translation updates Peter Eisentraut 2003-10-06 17:37:39 +00:00
  • fec58f6c3f During ALTER TABLE ADD FOREIGN KEY, try to check the existing rows using a single LEFT JOIN query instead of firing the check trigger for each row individually. Stephan Szabo, with some kibitzing from Tom Lane and Jan Wieck. Tom Lane 2003-10-06 16:38:28 +00:00
  • a0ab31dcc6 New Slovene translations Peter Eisentraut 2003-10-06 16:31:16 +00:00
  • aeb1f6478e - Fixed constant listing in execute using clause. - Fixed typo in ecpg for Informix dec_t type. - Fixed precision handling in Informix compat funxtions. Michael Meskes 2003-10-06 06:44:55 +00:00
  • 5e3aaf5402 Translation updates Peter Eisentraut 2003-10-06 06:20:11 +00:00
  • 0eceaaf9b7 Modify COPY FROM to match the null-value string against the column value before it is de-backslashed, not after. This allows the null string \N to be reliably distinguished from the data value \N (which must be represented as \\N). Per bug report from Manfred Koizar ... but it's amazing this hasn't been reported before ... Also, be consistent about encoding conversion for null string: the form specified in the command is in the server encoding, but what is sent to/from client must be in client encoding. This never worked quite right before either. Tom Lane 2003-10-06 02:38:53 +00:00
  • 351adb8dfb Fix order of operations within SendQuery() so that the time spent in data transfer during COPY is included in the \timing display. Also avoid portability problems if tv_usec is unsigned on some platform. Tom Lane 2003-10-06 01:11:12 +00:00
  • a1dcd8f6dd Add a little more smarts to estimate_hash_bucketsize(): if there's no statistics, but there is a unique index on the column, we can safely assume it's well-distributed. Tom Lane 2003-10-05 22:44:25 +00:00
  • 22347dc102 Make psql \timing show three digits. Bruce Momjian 2003-10-05 22:36:00 +00:00
  • eceff4cc55 Translation updates Peter Eisentraut 2003-10-05 21:52:37 +00:00
  • 83a234926c When revoking privileges from the owner, don't revoke the grant options, to avoid recursively revoking everything from everyone. Peter Eisentraut 2003-10-05 21:49:12 +00:00
  • 8f3b879462 Update MySQL mention. Bruce Momjian 2003-10-05 14:25:29 +00:00
  • 8e6b74e4fd Fixed bug in day of week processing. Michael Meskes 2003-10-05 11:12:00 +00:00
  • 88605109db Update MySQL mention. Bruce Momjian 2003-10-05 03:52:08 +00:00
  • f261af3f74 Translation update Peter Eisentraut 2003-10-04 22:50:20 +00:00
  • fa09ee6026 Document the always-true-but-previously-undocumented fact that PQfnumber() will downcase the supplied field name unless it is double-quoted. Also, upgrade the routine's handling of double quotes to match the backend, in particular support doubled double quotes within quoted identifiers. Per pgsql-interfaces discussion a couple weeks ago. Tom Lane 2003-10-04 21:05:21 +00:00
  • b833c3d4a4 Fix pg_get_constraintdef() to ensure CHECK constraints are always shown with required outer parentheses. Breakage seems to be leftover from domain-constraint patches. This could be smarter about suppressing extra parens, but at this stage of the release cycle I want certainty not cuteness. Tom Lane 2003-10-04 18:22:59 +00:00
  • ec1fbbb546 Modify: Bruce Momjian 2003-10-04 18:19:57 +00:00
  • 0a14ffe5b5 Translation updates Peter Eisentraut 2003-10-04 18:13:16 +00:00
  • 8bc9fcb51f Translation update Peter Eisentraut 2003-10-04 18:09:08 +00:00
  • 5ba1fab5fa Update INSTALL file for 7.4. Bruce Momjian 2003-10-04 03:14:13 +00:00
  • 1c4d4cb17d Fix log_duration and log_min_duration_statement to print properly, as pointed out by Peter. Bruce Momjian 2003-10-04 02:47:04 +00:00
  • 7ca44855fc Update MySQL mention. Bruce Momjian 2003-10-04 02:37:05 +00:00
  • 5f0eb3fd83 Update MySQL mention. Bruce Momjian 2003-10-04 01:39:51 +00:00
  • 75e76e1cf5 Translation updates Peter Eisentraut 2003-10-04 01:07:05 +00:00
  • 4cb67993a7 Format help message internally consistent. Peter Eisentraut 2003-10-04 01:06:38 +00:00
  • 9951474c71 Change transaction status indicator in prompt from %T to %x. Peter Eisentraut 2003-10-04 01:04:46 +00:00
  • beb935148a New translation Peter Eisentraut 2003-10-03 22:39:34 +00:00
  • ef88199f61 Issue 'SET check_function_bodies = false' to suppress possible restore failures in SQL functions, due to forward references or unqualified references to objects in other schemas. Per recent discussion. Tom Lane 2003-10-03 20:10:59 +00:00
  • 15c194c1d5 Add GUC parameter check_function_bodies to control whether validation of function bodies is done at CREATE FUNCTION time. This is normally true but can be set false to avoid problems with forward references, wrong schema search path, etc. This is just the backend patch, still need to adjust pg_dump to make use of it. Tom Lane 2003-10-03 19:26:49 +00:00
  • 251033186f Cause PQescapeString to stop processing at a null character, rather than generating an invalid output string. Per observation and patch from Igor Shevchenko. Further code cleanup and documentation by Tom Lane. Tom Lane 2003-10-03 18:26:14 +00:00
  • 3b4c142030 Remove assorted compilation failures introduced by latest ecpg changes. Also remove -g, which has no business in CPPFLAGS in the first place, let alone being hardwired there by a sub-Makefile. Tom Lane 2003-10-03 17:04:48 +00:00
  • 1bd5e054ed Hide Informix datatypes. They are not seen by our built process anymore. Michael Meskes 2003-10-03 10:07:28 +00:00
  • 17f682488b brand her beta4 REL7_4_BETA4 PostgreSQL Daemon 2003-10-03 03:08:14 +00:00
  • 19c90bcc25 Add a bit more locking to vac_update_relstats and vac_update_dbstats to make them comparable to what UpdateStats does in the same situation. I'm not certain two instances of vac_update_relstats could run in parallel for the same relation, but parallel invocations of vac_update_dbstats do seem possible. Tom Lane 2003-10-02 23:19:44 +00:00
  • f8ee74faeb When dumping CREATE INDEX, must show opclass name if the opclass isn't in the schema search path. Otherwise pg_dump doesn't correctly dump scenarios where a custom opclass is created in 'public' and then used by indexes in other schemas. Tom Lane 2003-10-02 22:25:08 +00:00
  • bea8af9152 When dumping CREATE INDEX, must show opclass name if the opclass isn't in the schema search path. Otherwise pg_dump doesn't correctly dump scenarios where a custom opclass is created in 'public' and then used by indexes in other schemas. Tom Lane 2003-10-02 22:24:54 +00:00
  • b4966453f6 Do not return from PQrequestCancel until postmaster has finished processing the request; this ensures that the request won't be taken to cancel a subsequently-issued query. Race condition originally noted by Oliver Jowett in the context of JDBC, but libpq has it too. Tom Lane 2003-10-02 19:52:44 +00:00
  • bf2f5d9463 Don't use 0 as a spelling of NULL. Tom Lane 2003-10-02 14:47:44 +00:00
  • d938e8b0f4 Add documentation about \pset footer to \?. Peter Eisentraut 2003-10-02 06:39:31 +00:00
  • 14528ffe6b String fixes/improvements found by Alvaro Herrera Peter Eisentraut 2003-10-02 06:36:37 +00:00
  • e78b0079a2 Change some notices to warnings and vice versa according to criteria developed on -hackers. Peter Eisentraut 2003-10-02 06:34:04 +00:00
  • 5b806ecf55 Remove NOTICE about foreign key creating implicit triggers, because it no longer conveys useful information. Peter Eisentraut 2003-10-02 06:32:46 +00:00
  • 08c33c426b Attached is a patch for contrib/tablefunc. It fixes two issues raised by Lars Boegild Thomsen (full email below) and also corrects the regression expected output for a recent backend message adjustment. Please apply. Tom Lane 2003-10-02 03:51:40 +00:00
  • 04b40923d6 Add code to check that IF/WHILE/EXIT test expressions are boolean, and try to coerce the values to boolean if not. Per recent discussions. Tom Lane 2003-10-01 21:47:42 +00:00
  • 55d85f42a8 Repair RI trigger visibility problems (this time for sure ;-)) per recent discussion on pgsql-hackers: in READ COMMITTED mode we just have to force a QuerySnapshot update in the trigger, but in SERIALIZABLE mode we have to run the scan under a current snapshot and then complain if any rows would be updated/deleted that are not visible in the transaction snapshot. Tom Lane 2003-10-01 21:30:53 +00:00
  • 6099bc03f3 Adjust documentation examples to match recent error message rewordings. A couple other minor fixes. Tom Lane 2003-09-30 03:22:33 +00:00
  • 444af9e0e8 Minor copy-editing. Tom Lane 2003-09-30 01:56:11 +00:00
  • f038e08929 Use slightly less broken markup. Tom Lane 2003-09-30 01:26:29 +00:00
  • 47ed658c59 heap_open => relation_open to avoid unwanted restriction on relkind. Per gripe from Gaetano Mendola. Tom Lane 2003-09-30 00:59:51 +00:00
  • e33f205a94 Adjust btree index build procedure so that the btree metapage looks invalid (has the wrong magic number) until the build is entirely complete. This turns out to cost no additional writes in the normal case, since we were rewriting the metapage at the end of the process anyway. In normal scenarios there's no real gain in security, because a failed index build would roll back the transaction leaving an unused index file, but for rebuilding shared system indexes this seems to add some useful protection. Tom Lane 2003-09-29 23:40:26 +00:00
  • 6b4caf53e6 Release updates by Tom. Bruce Momjian 2003-09-29 23:16:44 +00:00
  • 0e319c7ad7 Improve context display for failures during COPY IN, as recently discussed on pghackers. Tom Lane 2003-09-29 22:06:40 +00:00
  • 34c64955cd Update Jan's completed item. Bruce Momjian 2003-09-29 21:42:04 +00:00
  • 7bc0678e0b Remove, already done: Bruce Momjian 2003-09-29 21:41:29 +00:00
  • 8dd0573772 Update HISTORY for 7.4. Bruce Momjian 2003-09-29 21:25:43 +00:00
  • fb72fc8b80 Add: Bruce Momjian 2003-09-29 21:15:19 +00:00
  • 36f15ddecd Fixed type lookup in spi_prepare for possible qualified type name specification. Jan Wieck 2003-09-29 19:24:06 +00:00
  • 2f98ece4de The brackets aren't put on the CHECK constraints properly. Bruce Momjian 2003-09-29 18:55:56 +00:00
  • 6000e32805 I've not changed any malloc/calloc to palloc. It looks to me that these memory areas are for the lifetime of the backend and in the interests of not breaking something that's not broken I left alone. Bruce Momjian 2003-09-29 18:54:38 +00:00
  • 243f11ccf1 [ Patch applied only to 7.3.X.] Bruce Momjian 2003-09-29 18:53:08 +00:00
  • 4b4c43b146 This patch fixes an obvious bug in the "should I print the duration of this query?" logic in postgres.c Bruce Momjian 2003-09-29 18:50:58 +00:00
  • fc7a2affab I discovered that TupleDescGetAttInMetadata and BuildTupleFromCStrings don't deal well with tuples having dropped columns. The attached fixes the issue. Please apply. Bruce Momjian 2003-09-29 18:22:48 +00:00
  • f3db606592 > > > > a) Write documentation how the win32 console needs to be set up so that > > psql can handle 8-bit characters. > > Where should it be added? The Section "Installation on Windows" in the > > Administrator's Guide seems natural to me. > > > > b) Add code to psql that prints a warning on startup of psql when the > > console codepage differs from the windows codepage, something like > > > > Warning: Console codepage (850) differs from windows codepage (1252) > > 8-bit characters will not work correctly. See PostgreSQL > > documentation "Installation on Windows" for details. > Attached are two patches: Bruce Momjian 2003-09-29 18:21:33 +00:00
  • a17b53753e This patch makes a few incremental improvements to geqo.sgml and arch-dev.sgml Bruce Momjian 2003-09-29 18:18:35 +00:00
  • 04e401f97f A) Fixes a bug that prevented mirroring of data on a table that has had a column dropped. Bruce Momjian 2003-09-29 18:16:48 +00:00
  • b8d7e1e798 Change 7.3.4 release note format to match the rest of the 7.3.x releases. Bruce Momjian 2003-09-29 18:15:12 +00:00
  • e22c891361 Update release notes. Bruce Momjian 2003-09-29 18:06:48 +00:00
  • e7a9ba4872 Add: Bruce Momjian 2003-09-29 16:52:14 +00:00
  • 55fbc98b3f Adjust the new Norwegian translation for some of the easier message changes between 7.3 and 7.4, for example quoting and function names. Peter Eisentraut 2003-09-29 16:41:33 +00:00
  • 275c909a8c Apparently, gettext doesn't like double parentheses around argument. What were they doing here anyway? Peter Eisentraut 2003-09-29 16:39:18 +00:00
  • f4d5d620f2 Make message fit guidelines. Peter Eisentraut 2003-09-29 16:38:04 +00:00