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

Commit Graph

  • a4477341b8 Update TODO list. Bruce Momjian 2001-01-28 15:42:42 +00:00
  • 0543cded86 Update TODO list. Bruce Momjian 2001-01-28 15:41:58 +00:00
  • 677fe55c12 Update FAQ. Bruce Momjian 2001-01-28 15:18:45 +00:00
  • da86b9cb5c Update TODO list. Bruce Momjian 2001-01-28 05:05:11 +00:00
  • 3e896ebe4a Used LEFT OUTER JOIN for various queries Philip Warner 2001-01-28 03:47:49 +00:00
  • 2f9bdffc37 Applied (slightly modified) patches from Tatsuo: Philip Warner 2001-01-28 02:57:06 +00:00
  • d7f0b7ef6e Here is an update on the Win32 patch. Modified files are 'config.h.win32' and two 'win32.mak'. Addresses the following: Bruce Momjian 2001-01-27 21:49:59 +00:00
  • b72ca55ed5 Update FAQ. Bruce Momjian 2001-01-27 20:19:34 +00:00
  • f3416bef03 Add 'foreign' file. Bruce Momjian 2001-01-27 19:49:45 +00:00
  • 2679a38a1f Add missing pgaccess files. Bruce Momjian 2001-01-27 18:36:24 +00:00
  • 2a7ab4d916 Update to pgaccess 0.98.7. Bruce Momjian 2001-01-27 18:34:38 +00:00
  • 7fcd675dc3 When dropping the schema, reconnect as owner of each object. Philip Warner 2001-01-27 12:35:29 +00:00
  • 94bf45265f Make into appendix, correct some items. Peter Eisentraut 2001-01-27 11:12:53 +00:00
  • dc7a0009f0 Add permission check for CHECKPOINT. Peter Eisentraut 2001-01-27 10:19:52 +00:00
  • 80caa741ab Fix failure to create sequences for more than one SERIAL column in a table. Tom Lane 2001-01-27 07:23:48 +00:00
  • 8505fc8f98 Update TODO list. Bruce Momjian 2001-01-27 05:49:12 +00:00
  • 13eadd430f Update TODO list. Bruce Momjian 2001-01-27 05:40:51 +00:00
  • a6f0adbe38 Looks like I broke cases involving combinations of deferred update/delete triggers ... oops ... but the regress tests should have covered this ... Tom Lane 2001-01-27 05:16:58 +00:00
  • 76beb79d27 in the tutorial, chapter 2., "Relational Data Model Formalities" (sql490.htm), there is Bruce Momjian 2001-01-27 05:07:28 +00:00
  • a6584742ed Update TODO list. Bruce Momjian 2001-01-27 04:42:56 +00:00
  • f44639e1bf Don't crash if subquery appears multiple times in jointree. This should not happen anyway, but let's try not to get completely confused if it does (due to rewriter bugs or whatever). Tom Lane 2001-01-27 04:42:32 +00:00
  • 352871ac93 Repair bug reported by Huxton, 1/24/01. We need to include a rule's original table ('OLD' table) in its join tree if OLD is referenced by either the rule action, the rule qual, or the original query qual that will be added to the rule action. However, we only want one instance of the original table to be included; so beware of the possibility that the rule action already has a jointree entry for OLD. Tom Lane 2001-01-27 04:40:59 +00:00
  • a60537240f Update FAQ. Bruce Momjian 2001-01-27 04:38:54 +00:00
  • 2696cf0412 Update FAQ. Bruce Momjian 2001-01-27 04:35:16 +00:00
  • d67328f72a Just a quick patch to make the geometry test on Sparc/Linux regression tests for Pgsql 7.1beta3 pass. This is very similr to the one I submitted back in July for Linux/Alpha. Apparently non-x86 Linux machines like to compute nth place float point digits like Sun/Solaris does? Otherwise, 7.1beta3 runs without problems (i.e. all other regression tests pass) on my Sparc 20 running Debian GNU/Linux 2.2. Bruce Momjian 2001-01-27 04:26:37 +00:00
  • c9c8d53d80 Refuse to try to attach a condition to a NOTIFY or other utility statement, rather than coredumping (as prior 7.1 code did) or silently dropping the condition (as 7.0 did). This is annoying but there doesn't seem to be any good way to fix it, short of a major querytree restructuring. Tom Lane 2001-01-27 01:44:20 +00:00
  • c1a63c944d Suppress coredump when EXPLAINing query that is rewritten to include a NOTIFY. Tom Lane 2001-01-27 01:41:19 +00:00
  • 1dc3051088 Re-read Unix-socket lock file every so often (every CheckPoint interval, actually) to ensure that its file access time doesn't get old enough to tempt a /tmp directory cleaner to remove it. Still another reason we should never have put the sockets in /tmp in the first place ... Tom Lane 2001-01-27 00:05:31 +00:00
  • 1c63587f24 Clean up markup, add description of contrib/array operators by Joel Burton <jburton@scw.org>. Peter Eisentraut 2001-01-26 23:40:39 +00:00
  • b78d1bed07 Change float8-to-int8 conversion to round to nearest, rather than truncating to integer. Remove regress test that checks whether 4567890123456789 can be converted to float without loss; since that's 52 bits, it's on the hairy edge of failing with IEEE float8s, and indeed rint seems to give platform-dependent results for it. Tom Lane 2001-01-26 22:50:26 +00:00
  • 5a832218fd odbc1.diff changes the text on the Protocol Radio buttons on the driver dialogue from '6.4/6.5' to '6.5+' and removes some C++ comments from resource.h (which VC++ insists on putting there). Bruce Momjian 2001-01-26 22:41:59 +00:00
  • 7edafafd73 gcc complains about improperly terminated comment. Tom Lane 2001-01-26 22:25:36 +00:00
  • c5c71aa51d Update TODO list. Bruce Momjian 2001-01-26 22:17:52 +00:00
  • 61737a7b47 Add some links from data type chapter to section on literal constants. Peter Eisentraut 2001-01-26 22:04:22 +00:00
  • 6434ce65c4 Update TODO list. Bruce Momjian 2001-01-26 21:34:25 +00:00
  • 304d7e4aa1 Update TODO list. Bruce Momjian 2001-01-26 21:17:25 +00:00
  • a9b1bac610 Update TODO list. Bruce Momjian 2001-01-26 21:16:15 +00:00
  • bffeb1380e Update TODO list. Bruce Momjian 2001-01-26 20:59:00 +00:00
  • db3f5fa421 Update TODO list. Bruce Momjian 2001-01-26 20:35:41 +00:00
  • f433d0d3cd Special case in ProcSleep() wasn't sufficiently general: must check to see if we shouldn't block whenever we insert ourselves anywhere before the end of the queue, not only at the front. Tom Lane 2001-01-26 18:23:12 +00:00
  • c6e6d292bc First step in attempt to fix tree at runtime: create upper levels and new root page if old root one was splitted but new root page wasn't created. New code is protected by FixBTree bool flag setted to FALSE, so nothing should be affected by this untested approach. Vadim B. Mikheev 2001-01-26 01:24:31 +00:00
  • 19c4197bd2 Synced gram.y and preproc.y. Michael Meskes 2001-01-25 20:35:19 +00:00
  • 7e44f8f9e5 For missing owner of database, default to superuser. Peter Eisentraut 2001-01-25 17:28:15 +00:00
  • e01e14ed66 Avoid bogus failures due to 'ps x | grep postmaster' detecting 'grep postmaster' process. Peter Eisentraut 2001-01-25 16:32:25 +00:00
  • f118c36a78 Added an alternative constructor to PGSQLException so that debugging some more osteric bugs is easier. If only 1 arg is supplied and it's of type Exception, then that Exception's stacktrace is now included. Peter Mount 2001-01-25 09:16:36 +00:00
  • 97f447b2cd Add to TODO.detail. Bruce Momjian 2001-01-25 03:53:25 +00:00
  • 8293e2191e Update TODO list. Bruce Momjian 2001-01-25 03:50:31 +00:00
  • cb8fd60875 Update TODO list. Bruce Momjian 2001-01-25 03:50:11 +00:00
  • 211f5afd40 Whoops, forgot to do ProcLockWakeup() after deadlock checker rearranges wait queues. Tom Lane 2001-01-25 03:45:50 +00:00
  • 8cb2c013b6 Add. Bruce Momjian 2001-01-25 03:36:34 +00:00
  • a05eae029a Re-implement deadlock detection and resolution, per design notes posted to pghackers on 18-Jan-01. Tom Lane 2001-01-25 03:31:16 +00:00
  • 40203e4f3e Further to the previous ODBC patches I posted today, I found a couple of problems with char array sizes having set a couple of constants to 0 for unlimited query length and row length. This additional patch cleans those problems up by defining a new constant (STD_STATEMENT_LEN) to 65536 and using that in place of MAX_STATEMENT_LEN. Bruce Momjian 2001-01-25 03:28:27 +00:00
  • 0e968ee705 > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: 24 January 2001 16:51 > To: Dave Page > Subject: Re: [PATCHES] ODBC Patch for OJs/Large Querys & Rows > > > > SQL_OJ_LEFT = Left outer joins are supported. > > Yes. <snip> Bruce Momjian 2001-01-25 03:27:47 +00:00
  • be1276846e I decided to give this a go after all :-) The attached patch does the following but it does *not* check whether the user is connected to PostgreSQL 7.0.x or 7.1 first (as would be required for some of the features) - the driver doesn't do this at all afaik and it's beyond my capabilities to implement such checking in code that doesn't look like it was written by my 1 year old daughter! Bruce Momjian 2001-01-25 03:27:05 +00:00
  • 4e45005ffb This patch fixes an arrayindexoutofbounds exception that was just introduced into the code. The fix is a fix to org.postgresql.core.ByteArrayDim1.java. Bruce Momjian 2001-01-25 00:02:58 +00:00
  • ba6fda5191 Add ./include/config.h.win32 to RELEASE update list. Bruce Momjian 2001-01-25 00:01:17 +00:00
  • 78a6da6d53 Add to inheritance Bruce Momjian 2001-01-25 00:00:48 +00:00
  • 9aab097d6d Update TODO list. Bruce Momjian 2001-01-24 23:55:32 +00:00
  • 26e566446f Attached is a revised patch that removes the static SimpleDateFormat objects that Thomas pointed out might be a problem. Bruce Momjian 2001-01-24 23:41:04 +00:00
  • 7b9dc71405 WAL documentation, from Oliver Elphick and Vadim Mikheev. Peter Eisentraut 2001-01-24 23:15:19 +00:00
  • 43bac8406a Update based on documentation written by Vadim Mikheev and Oliver Elphick. Peter Eisentraut 2001-01-24 21:56:23 +00:00
  • 623bf843d2 Change Copyright from PostgreSQL, Inc to PostgreSQL Global Development Group. Bruce Momjian 2001-01-24 19:43:33 +00:00
  • ae22682f2a Update TODO list. Bruce Momjian 2001-01-24 19:33:36 +00:00
  • 718fc7e0d1 Fix bogus pattern for STRING. Peter Eisentraut 2001-01-24 19:01:31 +00:00
  • 7df3bb50f0 Add all possible config file options. Bruce Momjian 2001-01-24 18:37:31 +00:00
  • 3347fbad79 Put back old config contents until I am finished. Bruce Momjian 2001-01-24 15:57:49 +00:00
  • 0843ec088c Add "idle in transaction" status message Bruce Momjian 2001-01-24 15:53:59 +00:00
  • 87070ccc13 It looks Ok, but it has one unnecessary step. There is no need to do the "mv privkey.pem cert.pem.pw" if you just use "privkey.pem" in the following openssl command (e.g. openssl rsa -in privkey.pem -out cert.pem". But there is nothing wrong with it as it is now, as far as I can see. Bruce Momjian 2001-01-24 15:19:36 +00:00
  • ab37224426 Fix formatting of db crash. Bruce Momjian 2001-01-24 14:32:32 +00:00
  • eb0eadb90e Add. Bruce Momjian 2001-01-24 14:24:40 +00:00
  • d2c2551867 Add file. Bruce Momjian 2001-01-24 13:40:08 +00:00
  • dd47964381 Update TODO list. Bruce Momjian 2001-01-24 13:38:42 +00:00
  • b869f45d1e Removed the 8k row limit reported by DatabaseMetaData Peter Mount 2001-01-24 09:22:01 +00:00
  • 92681e975d Oops, got binary in there too. Bruce Momjian 2001-01-24 05:49:09 +00:00
  • 3f0f30d1a1 Add comment for getpwid() safety. Bruce Momjian 2001-01-24 05:24:43 +00:00
  • 80d24370e0 Oops, had .o file in there. Bruce Momjian 2001-01-24 05:06:15 +00:00
  • 64b53d7452 Update TODO list. Bruce Momjian 2001-01-24 05:05:31 +00:00
  • 843657b066 attached is take-2 of a patch which fixes a bug related to the use of getpwuid when running in standalone mode. this patch allocates some persistent storage (using strdup) to store the username obtained with getpwuid in src/backend/main/main.c. this is necessary because later on, getpwuid is called again (in ValidateBinary). Bruce Momjian 2001-01-24 03:50:06 +00:00
  • cb5427ee47 I would like to do a interface change in pgcrypto. (Good timing, I know :)) At the moment the digest() function returns hexadecimal coded hash, but I want it to return pure binary. I have also included functions encode() and decode() which support 'base64' and 'hex' encodings, so if anyone needs digest() in hex he can do encode(digest(...), 'hex'). Bruce Momjian 2001-01-24 03:46:16 +00:00
  • bd0a767eab Here is a patch to make the current snapshot compile on Win32 (native, libpq and psql) again. Changes are: 1) psql requires the includes of "io.h" and "fcntl.h" in command.c in order to make a call to open() work (io.h for _open(), fcntl.h for the O_xxx) 2) PG_VERSION is no longer defined in version.h[.in], but in configure.in. Since we don't do configure on native win32, we need to put it in config.h.win32 :-( 3) Added define of SYSCONFDIR to config.h.win32 - libpq won't compile without it. This functionality is *NOT* tested - it's just defined as "" for now. May work, may not. 4) DEF_PGPORT renamed to DEF_PGPORT_STR Bruce Momjian 2001-01-24 03:42:38 +00:00
  • a939e97451 Update Bruce Momjian 2001-01-24 03:40:33 +00:00
  • 2c591cb821 Add oid2name. Add streaming option later. Bruce Momjian 2001-01-24 00:41:25 +00:00
  • a8b275e76d Removed a dangerours DropRelationBuffers() call. Hiroshi Inoue 2001-01-24 00:36:17 +00:00
  • 997ee51631 Make functional index copy attstorage from the column data type, rather than forcing 'plain'. This probably does not matter right now, but I think it needs to be consistent with the regular (not-functional) index case, where attstorage is copied from the underlying table. Clean up some other dead and infelicitous code too. Tom Lane 2001-01-24 00:06:07 +00:00
  • c654c69c05 Narrow scope of critical section, per discussion 1/19/01. Tom Lane 2001-01-23 23:32:45 +00:00
  • 4e27b308e2 Do _bt_wrtbuf() outside critical section, per discussion with Vadim 1/19. Tom Lane 2001-01-23 23:29:22 +00:00
  • d7157d32cb The -R option didn't accept an argument, which made it kind of useless. Peter Eisentraut 2001-01-23 22:46:14 +00:00
  • f69ff0c4bd Give 'a_expr ::= a_expr Op' production a slightly lower precedence than Op, so that the sequence 'a_expr Op Op a_expr' will be parsed as a_expr Op (Op a_expr) not (a_expr Op) Op a_expr as formerly. In other words, prefer treating user-defined operators as prefix operators to treating them as postfix operators, when there is an ambiguity. Also clean up a couple of other infelicities in production priority assignment --- for example, BETWEEN wasn't being given the intended priority, but that of AND. Tom Lane 2001-01-23 22:39:08 +00:00
  • edfca4b98b Subject: Bug in SQLForeignKeys() Bruce Momjian 2001-01-23 20:36:30 +00:00
  • 3de8407ea7 Remove useless leftover global variable Ps_status_buffer. Peter Eisentraut 2001-01-23 20:33:29 +00:00
  • 6b3c8e3167 Add Bruce Momjian 2001-01-23 16:22:11 +00:00
  • ab2c905152 Add email. Bruce Momjian 2001-01-23 16:21:47 +00:00
  • 04a843b249 Update TODO list. Bruce Momjian 2001-01-23 16:19:45 +00:00
  • 11cb9acb68 Some more additions to contrib for JDBC Peter Mount 2001-01-23 10:22:22 +00:00
  • d09fc12044 Moved database name handling to libecpg. Michael Meskes 2001-01-23 08:15:50 +00:00
  • 786f1a59cd Fix all the places that called heap_update() and heap_delete() without bothering to check the return value --- which meant that in case the update or delete failed because of a concurrent update, you'd not find out about it, except by observing later that the transaction produced the wrong outcome. There are now subroutines simple_heap_update and simple_heap_delete that should be used anyplace that you're not prepared to do the full nine yards of coping with concurrent updates. In practice, that seems to mean absolutely everywhere but the executor, because *noplace* else was checking. Tom Lane 2001-01-23 04:32:23 +00:00
  • 7a2a1acd52 Add Bruce Momjian 2001-01-23 04:01:17 +00:00
  • 56970c1bc0 Fix some int4->int32. Bruce Momjian 2001-01-23 03:10:25 +00:00
  • b686fb5bf1 Remove no-longer-needed restriction against referencing system attributes in a FieldSelect node --- all the places that manipulate these work just fine with system attribute numbers. OK, it's a new feature, so shoot me ... Tom Lane 2001-01-23 02:32:26 +00:00
  • e5cdecd01b Update TODO list. Bruce Momjian 2001-01-23 02:27:04 +00:00