676e3c7 | Marc G. Fournier | 22 December 1996, 03:28:25 UTC | Here's a little patch to keep the compiler quiet when compiling PostgreSQL V6.0 on the SPARC Solaris2 platform. Submitted by: Keith Parks <emkxp01@mtcc.demon.co.uk> | 22 December 1996, 03:28:25 UTC |
e768c41 | Marc G. Fournier | 22 December 1996, 03:26:52 UTC | I found that when changing databases from within psql the prompt went sort of strange. bash$ psql disks Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL type \? for help on slash commands type \q to quit type \g or terminate with semicolon to execute query You are currently connected to the database: disks disks=> \c postgres closing connection to database: disks connecting to new database: postgres postgres== \c disks closing connection to database: postgres connecting to new database: disks disks== \q bash$ Note the => changes to == after a connect and stays that way on subsequent database changes. Submitted by: Keith Parks <emkxp01@mtcc.demon.co.uk> | 22 December 1996, 03:26:52 UTC |
502a653 | Marc G. Fournier | 22 December 1996, 03:23:35 UTC | This allows GROUP BY to use column aliases, and ORDER and GROUP BY can use column numbers, like ANSI. Submitted by: Bruce Momjian <maillist@candle.pha.pa.us> | 22 December 1996, 03:23:35 UTC |
b1c7cba | Marc G. Fournier | 22 December 1996, 03:20:00 UTC | There are a number of tests "[" that fail if the variable is not enclosed in quotes (") and the sed scripts need to be in single quotes Submitted by: Keith Parks <emkxp01@mtcc.demon.co.uk> | 22 December 1996, 03:20:00 UTC |
7441e1f | Vadim B. Mikheev | 14 December 1996, 08:26:08 UTC | Fix over fix: JMP_BUF gone away and we have SIGJMP_BUF now. Excuse me. | 14 December 1996, 08:26:08 UTC |
76fae39 | Vadim B. Mikheev | 14 December 1996, 08:19:40 UTC | if (settings->opt.fieldSep); ^ - deleted free(settings->opt.fieldSep); | 14 December 1996, 08:19:40 UTC |
8c68e07 | Vadim B. Mikheev | 14 December 1996, 07:54:22 UTC | Avoiding: cc1: warnings being treated as errors datum.c: In function `DatumGetSize': datum.c:57: warning: unsigned value >= 0 is always 1 gmake[3]: *** [datum.o] Error 1 There was: if (byVal) { if (len >= 0 && len <= sizeof(Datum)) { but len has type Size (unsigned int) and so now there is: if (byVal) { if (len <= sizeof(Datum)) { size = len; } else { elog(WARN, "datumGetSize: Error: type=%ld, byVaL with len=%d", (long) type, len); } } else { /* not byValue */ | 14 December 1996, 07:54:22 UTC |
9ec39eb | Vadim B. Mikheev | 14 December 1996, 06:07:44 UTC | const register ... --> register const ... | 14 December 1996, 06:07:44 UTC |
a98d974 | Vadim B. Mikheev | 14 December 1996, 05:54:36 UTC | Avoiding cc1: warnings being treated as errors exc.c: In function 'ExcRaise': exc.c:186: warning: passing arg 1 of 'Longjmp' from incompatible pointer type gmake[3]: *** [exc.o] Error 1 Now we have: #if defined (JMP_BUF) longjmp(efp->context, 1); #else siglongjmp(efp->context, 1); #endif | 14 December 1996, 05:54:36 UTC |
8696192 | Vadim B. Mikheev | 14 December 1996, 05:19:12 UTC | Avoiding cc1: warnings being treated as errors transsup.c: In function `TransBlockGetLastTransactionIdStatus': transsup.c:122: warning: unsigned value >= 0 is always 1 gmake[3]: *** [transsup.o] Error 1 ... | 14 December 1996, 05:19:12 UTC |
bed4db7 | Vadim B. Mikheev | 14 December 1996, 04:55:52 UTC | Unuseful tupDesc = CreateTupleDesc(attr_count, attr); in CopyFrom is eliminated (now I can copy 2000000-table from file without memmory exhausting). | 14 December 1996, 04:55:52 UTC |
3cbebb4 | Bruce Momjian | 13 December 1996, 02:51:20 UTC | remove that pesky 95 | 13 December 1996, 02:51:20 UTC |
e606e4d | Bruce Momjian | 13 December 1996, 02:41:32 UTC | Small regression and doc patch | 13 December 1996, 02:41:32 UTC |
a3f4ae0 | Bruce Momjian | 11 December 1996, 23:08:08 UTC | Change postgres95 to PostgreSQL. | 11 December 1996, 23:08:08 UTC |
8934853 | Bruce Momjian | 11 December 1996, 23:06:40 UTC | Require seimcolons between statements. | 11 December 1996, 23:06:40 UTC |
4cecf0b | Bruce Momjian | 11 December 1996, 00:32:08 UTC | Rename postgres95 to PostgreSQL. Add comment for SELECT NULL | 11 December 1996, 00:32:08 UTC |
403e9c0 | Marc G. Fournier | 10 December 1996, 03:29:41 UTC | Test two...branch REL2_0B works...I think | 10 December 1996, 03:29:41 UTC |
14a3ecf | CVS to git conversion script | 09 December 1996, 01:24:54 UTC | This commit was manufactured by cvs2git to create branch 'REL2_0B'. Sprout from master 1996-12-09 01:24:53 UTC Bryan Henderson <bryanh@giraffe.netgate.net> 'Remove include of libpq-fe.h. This file has nothing to do with libpq.' Delete: src/bin/monitor/Makefile src/bin/monitor/monitor.c | 09 December 1996, 01:24:54 UTC |
33edbdb | Bryan Henderson | 09 December 1996, 01:24:53 UTC | Remove include of libpq-fe.h. This file has nothing to do with libpq. | 09 December 1996, 01:24:53 UTC |
79729c0 | Bryan Henderson | 09 December 1996, 01:23:51 UTC | Add comments defining "typelem" column of pg_type. | 09 December 1996, 01:23:51 UTC |
b36e304 | Bryan Henderson | 09 December 1996, 01:22:17 UTC | Add comments describing interface to heap_getattr(). | 09 December 1996, 01:22:17 UTC |
6cfb12e | Bryan Henderson | 09 December 1996, 01:16:51 UTC | Add CUSTOM_CC variable for Makefile.custom. Thanks Kurt Lidl. | 09 December 1996, 01:16:51 UTC |
8cedf57 | Bruce Momjian | 07 December 1996, 04:39:38 UTC | Reduce printing from debug level 2 ande layout change. | 07 December 1996, 04:39:38 UTC |
2e20099 | Bruce Momjian | 07 December 1996, 04:38:40 UTC | Reduce printing from deub level 2 ande layout change. | 07 December 1996, 04:38:40 UTC |
c0941ab | Bruce Momjian | 07 December 1996, 04:38:11 UTC | Remove Dan's fix of SELECT NULL to fix INSERT NULL. | 07 December 1996, 04:38:11 UTC |
7f8b8b9 | Bruce Momjian | 07 December 1996, 04:37:06 UTC | Fix for SELECT NULL. | 07 December 1996, 04:37:06 UTC |
c90c058 | Bruce Momjian | 07 December 1996, 04:36:38 UTC | Fix from Jan agreed with by Massimo. | 07 December 1996, 04:36:38 UTC |
4e064c0 | Vadim B. Mikheev | 06 December 1996, 09:45:30 UTC | _bt_updateitem is returned in code, but works only if sizes of keys are equal. | 06 December 1996, 09:45:30 UTC |
c3e10a4 | Vadim B. Mikheev | 06 December 1996, 09:41:45 UTC | 1. _bt_compare fixed to work properly with new code in _bt_insertonpg (old _bt_compare always returned >= 0 while comparing with P_HIKEY on root page - it breaks root page when _bt_insertonpg tries insert new minimal key into root page). 2. Fixed bug concerns "empty" pages: non-rightmost pages with only P_HIKEY present on it. Such pages appear after vacuum. | 06 December 1996, 09:41:45 UTC |
64397b7 | Bruce Momjian | 04 December 1996, 14:23:16 UTC | Remove duplicate patch for COUNT fix. | 04 December 1996, 14:23:16 UTC |
9005a38 | Bryan Henderson | 04 December 1996, 03:06:33 UTC | Change portname "sparc" to "sunos4" and change some portname dependencies to feature dependencies. Thanks Kurt J. Lidl. | 04 December 1996, 03:06:33 UTC |
071797f | Bruce Momjian | 03 December 1996, 17:01:35 UTC | Change tests to lowercase for esthetics. | 03 December 1996, 17:01:35 UTC |
e5fbe30 | Vadim B. Mikheev | 03 December 1996, 05:50:11 UTC | pname=NULL -> pname="" (stringinfo.c:appendStringInfo doesn't like NULL). | 03 December 1996, 05:50:11 UTC |
f2af019 | Bruce Momjian | 03 December 1996, 05:06:35 UTC | Make COUNT,SUM case insensitive. | 03 December 1996, 05:06:35 UTC |
514d69b | Bryan Henderson | 03 December 1996, 00:11:07 UTC | Remove #if defined(bsdi) define SIGJMP_BUF, per Kurt Lidl. | 03 December 1996, 00:11:07 UTC |
5819336 | Bruce Momjian | 02 December 1996, 14:17:59 UTC | Reduce regression diffs | 02 December 1996, 14:17:59 UTC |
5f9bdb7 | Bruce Momjian | 02 December 1996, 06:31:20 UTC | Reduce regression diff size with timezone changes and cleanup. | 02 December 1996, 06:31:20 UTC |
7980b8a | Bruce Momjian | 01 December 1996, 20:28:39 UTC | Fix for inclusion of new prompt output. | 01 December 1996, 20:28:39 UTC |
1eae8e1 | Bruce Momjian | 01 December 1996, 19:48:39 UTC | Fix compiler warning about unitialized variables. | 01 December 1996, 19:48:39 UTC |
63df35e | Bruce Momjian | 30 November 1996, 18:07:02 UTC | This patch changes quite a few instances of references of Oid's as ints and longs. Touches on quite a few function args as well. Most other files look ok as far as Oids go...still checking though... Since Oids are type'd as unsigned ints, they should prolly be used with the %ud format string in elog and sprintf messages. Not sure what kind of strangeness that could produce. Darren King | 30 November 1996, 18:07:02 UTC |
f0a9e64 | Bruce Momjian | 30 November 1996, 17:49:02 UTC | As someone asked for this feature - patch for 1.09 follows. Now You can do queries like select sum(some_func(x)) from ... select min(table1.x + table2.y) from table1, table2 where ... and so on. Vadim | 30 November 1996, 17:49:02 UTC |
8735272 | Bruce Momjian | 30 November 1996, 17:47:07 UTC | Change end-of-line comma to semicolon. | 30 November 1996, 17:47:07 UTC |
d3e0860 | Bruce Momjian | 30 November 1996, 04:56:18 UTC | Aded mention that != maps to <>. | 30 November 1996, 04:56:18 UTC |
440279e | Bruce Momjian | 30 November 1996, 03:41:20 UTC | Add indicator for in quote or in query to prompt. | 30 November 1996, 03:41:20 UTC |
2d7aacb | Bruce Momjian | 30 November 1996, 03:38:09 UTC | Added BETWEEN and IN to grammar. Map != to <>. | 30 November 1996, 03:38:09 UTC |
a3d773a | Bruce Momjian | 29 November 1996, 15:56:18 UTC | Allow select oid,* from table. Allow * anywhere in target list. | 29 November 1996, 15:56:18 UTC |
a962c61 | Vadim B. Mikheev | 29 November 1996, 10:29:45 UTC | vrl_min_tlen added to VRelListData. | 29 November 1996, 10:29:45 UTC |
03659a2 | Vadim B. Mikheev | 29 November 1996, 10:27:59 UTC | Added: dynamic re-moving page from list of pages usable for shrinking if its free-space < min_tuple_len. | 29 November 1996, 10:27:59 UTC |
7b4426e | Bryan Henderson | 29 November 1996, 06:24:14 UTC | Throw some double quotes on the pile! | 29 November 1996, 06:24:14 UTC |
316e81c | Bruce Momjian | 29 November 1996, 04:49:46 UTC | Fix for BSDI compile. | 29 November 1996, 04:49:46 UTC |
ba876c1 | Bruce Momjian | 28 November 1996, 05:46:08 UTC | Changed saved_relname size to save memory. | 28 November 1996, 05:46:08 UTC |
c7cba57 | Vadim B. Mikheev | 28 November 1996, 04:37:38 UTC | Fix for "might be used uninitialized" warnings. | 28 November 1996, 04:37:38 UTC |
f0e7004 | Bryan Henderson | 28 November 1996, 03:32:18 UTC | Make strdup work for Ultrix. Thanks Erik Bertelsen | 28 November 1996, 03:32:18 UTC |
0667fd9 | Vadim B. Mikheev | 27 November 1996, 15:15:54 UTC | TransactionIdIsInProgress is commented out | 27 November 1996, 15:15:54 UTC |
6450bef | Bruce Momjian | 27 November 1996, 13:49:46 UTC | Convert ' to " in dates. Update example code to show empty query as "". | 27 November 1996, 13:49:46 UTC |
c9ec450 | Bruce Momjian | 27 November 1996, 13:48:58 UTC | Remove unused define's. | 27 November 1996, 13:48:58 UTC |
134c35c | Bruce Momjian | 27 November 1996, 13:48:23 UTC | no change | 27 November 1996, 13:48:23 UTC |
79b1a0f | Bruce Momjian | 27 November 1996, 13:47:05 UTC | Allow all empty queries to return EMPTY. | 27 November 1996, 13:47:05 UTC |
9c0afea | Bryan Henderson | 27 November 1996, 08:16:44 UTC | More stuff to make it compile on various ports. | 27 November 1996, 08:16:44 UTC |
a38365e | Vadim B. Mikheev | 27 November 1996, 07:35:06 UTC | New structures for new vacuum. | 27 November 1996, 07:35:06 UTC |
948720e | Vadim B. Mikheev | 27 November 1996, 07:33:42 UTC | New mdtruncate() & smgrtruncate() funcs. | 27 November 1996, 07:33:42 UTC |
b41aa39 | Vadim B. Mikheev | 27 November 1996, 07:32:10 UTC | TransactionIdIsInProgress moved to shmem.c | 27 November 1996, 07:32:10 UTC |
f0c5a6c | Vadim B. Mikheev | 27 November 1996, 07:27:20 UTC | Shrinking and other things. | 27 November 1996, 07:27:20 UTC |
3385497 | Vadim B. Mikheev | 27 November 1996, 07:25:52 UTC | New smgrtruncate smgr' interface func. | 27 November 1996, 07:25:52 UTC |
a2a33e1 | Vadim B. Mikheev | 27 November 1996, 07:24:02 UTC | New mdtruncate() func for single segment relations (< 2Gb). | 27 November 1996, 07:24:02 UTC |
3643248 | Vadim B. Mikheev | 27 November 1996, 07:20:07 UTC | TransactionIdIsInProgress is here now and gives quality answer by scanning PROC structures of all running backend. | 27 November 1996, 07:20:07 UTC |
47312ec | Vadim B. Mikheev | 27 November 1996, 07:17:48 UTC | Setting MyProc->xid to InvalidTransactionId while creating PROC structure (it's for new TransactionIdIsInProgress func). | 27 November 1996, 07:17:48 UTC |
713b65e | Vadim B. Mikheev | 27 November 1996, 07:14:51 UTC | Setting MyProc->xid to current transaction' id in StartTransaction and to InvalidTransactionId in CommitTransaction & AbortTransaction (it's for new TransactionIdIsInProgress func). | 27 November 1996, 07:14:51 UTC |
1db76d7 | Vadim B. Mikheev | 27 November 1996, 07:10:59 UTC | TransactionIdIsInProgress moved to shmem.c | 27 November 1996, 07:10:59 UTC |
89c7e18 | Bryan Henderson | 27 November 1996, 01:46:52 UTC | Forgot in yesterday's Ultrix compile work. | 27 November 1996, 01:46:52 UTC |
8cfe27d | Bryan Henderson | 26 November 1996, 08:12:39 UTC | OK, I think I've got the postconfig thing right now. | 26 November 1996, 08:12:39 UTC |
93f7225 | Bryan Henderson | 26 November 1996, 07:39:11 UTC | Whoops, redo Ultrix patch so the other ports still compile. | 26 November 1996, 07:39:11 UTC |
c118543 | Bryan Henderson | 26 November 1996, 06:33:18 UTC | Fix double-colon syntax error on fe-lobj.o. | 26 November 1996, 06:33:18 UTC |
46d58fb | Bryan Henderson | 26 November 1996, 03:20:35 UTC | Make it compile on Ultrix. Thanks Erik Bertelson. | 26 November 1996, 03:20:35 UTC |
02c0eb6 | Bryan Henderson | 26 November 1996, 02:45:05 UTC | Properly structure ProcedureNameIndexScan so it doesn't generate "may be used before being set" warnings. | 26 November 1996, 02:45:05 UTC |
bf14017 | Bryan Henderson | 26 November 1996, 01:17:56 UTC | Put in #include <fcntl.h> for those systems that don't have it included by something else. | 26 November 1996, 01:17:56 UTC |
f93f780 | Bryan Henderson | 26 November 1996, 01:14:38 UTC | -Werror fixes from D'Arcy. | 26 November 1996, 01:14:38 UTC |
46c4e6f | Bryan Henderson | 25 November 1996, 06:33:51 UTC | Include fcntl.h, which is not automatically included by sys/file.h on all systems. | 25 November 1996, 06:33:51 UTC |
1d84088 | Bryan Henderson | 25 November 1996, 05:51:50 UTC | Go back to $(postconfig...) from $(exec postconfig...) so it works on non-bash. | 25 November 1996, 05:51:50 UTC |
6c2925b | Bruce Momjian | 25 November 1996, 03:03:48 UTC | Prevent empty queries from crashing server. | 25 November 1996, 03:03:48 UTC |
02db1f5 | Bryan Henderson | 24 November 1996, 05:58:57 UTC | Fix access through null pointer info->rule_action. Thanks Darren King. | 24 November 1996, 05:58:57 UTC |
9602150 | Bryan Henderson | 24 November 1996, 05:46:12 UTC | Fix syntax error: missing argument to elog(). Thanks Darren King. | 24 November 1996, 05:46:12 UTC |
092c7a6 | Bryan Henderson | 24 November 1996, 04:44:24 UTC | Typecasts, etc. to make compile work on AIX. Thanks Darren King.. | 24 November 1996, 04:44:24 UTC |
d3f9d6a | Bryan Henderson | 24 November 1996, 04:07:17 UTC | Move include of signal.h inside pqsignal.h so it's always where it's needed. | 24 November 1996, 04:07:17 UTC |
7e499bd | Bryan Henderson | 24 November 1996, 03:55:19 UTC | Add dep: rule. | 24 November 1996, 03:55:19 UTC |
5c410fa | Bryan Henderson | 23 November 1996, 09:51:57 UTC | First pass at getting shared libraries on AIX properly built. | 23 November 1996, 09:51:57 UTC |
45f1d32 | Bryan Henderson | 23 November 1996, 09:42:51 UTC | Eliminate pesky "postconfig not found" message. | 23 November 1996, 09:42:51 UTC |
eda3771 | Bruce Momjian | 22 November 1996, 06:45:14 UTC | Fix for \g strdup error. | 22 November 1996, 06:45:14 UTC |
25fe3c7 | Bryan Henderson | 22 November 1996, 04:43:48 UTC | Include ctype.h to fix Kurt Lidl's compile problem. | 22 November 1996, 04:43:48 UTC |
4da9c59 | Bryan Henderson | 22 November 1996, 04:39:53 UTC | Include stdio.h to fix Craig Anderson's compile problem. | 22 November 1996, 04:39:53 UTC |
86ab9a5 | Bryan Henderson | 22 November 1996, 04:33:34 UTC | Fix bug: No -D option to postgres | 22 November 1996, 04:33:34 UTC |
e67cc8a | Bryan Henderson | 22 November 1996, 04:32:41 UTC | Fix bug: -D options implies -d option. | 22 November 1996, 04:32:41 UTC |
8c2f099 | Vadim B. Mikheev | 21 November 1996, 06:13:43 UTC | Fix memory overhelding while forming index' result: memory allocation for ItemPointerData of heap' tuple is useless because of FormRetrieveIndexResult makes neccessary palloc. | 21 November 1996, 06:13:43 UTC |
5d7e44f | Vadim B. Mikheev | 21 November 1996, 06:06:52 UTC | Fix memory overhelding while forming index' result: memory allocation for ItemPointerData of heap' tuple is useless because of FormRetrieveIndexResult makes neccessary palloc. | 21 November 1996, 06:06:52 UTC |
05b3b86 | Vadim B. Mikheev | 21 November 1996, 06:02:56 UTC | Fix memory overhelding while forming index' result: memory allocation for ItemPointerData of heap' tuple is useless because of FormRetrieveIndexResult makes neccessary palloc. | 21 November 1996, 06:02:56 UTC |
58802bf | Bruce Momjian | 20 November 1996, 22:58:22 UTC | Can't add a keyword without making it a keyword. :-) D'Arcy J.M. Cain | Democracy is three wolves | 20 November 1996, 22:58:22 UTC |
cd743f8 | Bruce Momjian | 20 November 1996, 22:53:49 UTC | Otherwise "gmake install" fails. D'Arcy J.M. Cain | Democracy is three wolves | 20 November 1996, 22:53:49 UTC |
c4d6bda | Bruce Momjian | 20 November 1996, 22:53:10 UTC | There is a bug in aclinsert3 in the code which update the acl arrays. When an acl item is added or updated the new entry is deleted if it has no permissions and the acl array is shrinked. This is is done by decrementing the number of items without updating the corresponding array size. The array with the incorrect size is later read by pg_aclcheck and the entry count is used to allocate a new array while the array size is used to copy the old one. This causes a memory corruption and a backend crash. This happens only to normal user as the administrator bypasses acl checks. Massimo Dal Zotto | 20 November 1996, 22:53:10 UTC |
8299e75 | Bruce Momjian | 20 November 1996, 22:35:19 UTC | following is a little fix for libpq. PQexec handles the possibility of multiple results from one query by simply submitting an empty query after the first result and waiting for an 'I' message. Rules can generate errors with transaction abort after the first 'C' message was recieved (e.g. if a C-language function used in a rule calls elog(WARN, ...)). Thus we have to look for. Jan(wieck@sapserv.debis.de) | 20 November 1996, 22:35:19 UTC |
6399c74 | Bruce Momjian | 20 November 1996, 22:34:36 UTC | Fix \g filename. Free allocated memory and don't use memory that has been freed. | 20 November 1996, 22:34:36 UTC |