777 Commits

Author SHA1 Message Date
676e3c735d 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>
1996-12-22 03:28:25 +00:00
e768c418b5 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>
1996-12-22 03:26:52 +00:00
502a6531b3 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>
1996-12-22 03:23:35 +00:00
b1c7cbadf2 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>
1996-12-22 03:20:00 +00:00
7441e1facb Fix over fix: JMP_BUF gone away and we have SIGJMP_BUF now.
Excuse me.
1996-12-14 08:26:08 +00:00
76fae39d02 if (settings->opt.fieldSep);
^ - deleted
                free(settings->opt.fieldSep);
1996-12-14 08:19:40 +00:00
8c68e07561 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 */
1996-12-14 07:54:22 +00:00
9ec39eb6e3 const register ... --> register const ... 1996-12-14 06:07:44 +00:00
a98d974edd 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
1996-12-14 05:54:36 +00:00
8696192aaa 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
...
1996-12-14 05:19:12 +00:00
bed4db7b7a Unuseful tupDesc = CreateTupleDesc(attr_count, attr); in CopyFrom
is eliminated (now I can copy 2000000-table from file without memmory
exhausting).
1996-12-14 04:55:52 +00:00
3cbebb47d4 remove that pesky 95 1996-12-13 02:51:20 +00:00
e606e4db0a Small regression and doc patch 1996-12-13 02:41:32 +00:00
a3f4ae0c3e Change postgres95 to PostgreSQL. 1996-12-11 23:08:08 +00:00
89348533b3 Require seimcolons between statements. 1996-12-11 23:06:40 +00:00
4cecf0b2d1 Rename postgres95 to PostgreSQL. Add comment for SELECT NULL 1996-12-11 00:32:08 +00:00
403e9c0d21 Test two...branch REL2_0B works...I think 1996-12-10 03:29:41 +00:00
14a3ecf57a 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
1996-12-09 01:24:54 +00:00
33edbdb59b Remove include of libpq-fe.h. This file has nothing to do with libpq. 1996-12-09 01:24:53 +00:00
79729c0e5e Add comments defining "typelem" column of pg_type. 1996-12-09 01:23:51 +00:00
b36e3042e7 Add comments describing interface to heap_getattr(). 1996-12-09 01:22:17 +00:00
6cfb12e0cf Add CUSTOM_CC variable for Makefile.custom. Thanks Kurt Lidl. 1996-12-09 01:16:51 +00:00
8cedf57eb1 Reduce printing from debug level 2 ande layout change. 1996-12-07 04:39:38 +00:00
2e20099e32 Reduce printing from deub level 2 ande layout change. 1996-12-07 04:38:40 +00:00
c0941ab7f0 Remove Dan's fix of SELECT NULL to fix INSERT NULL. 1996-12-07 04:38:11 +00:00
7f8b8b9e42 Fix for SELECT NULL. 1996-12-07 04:37:06 +00:00
c90c058bf0 Fix from Jan agreed with by Massimo. 1996-12-07 04:36:38 +00:00
4e064c0560 _bt_updateitem is returned in code, but works only if sizes of keys
are equal.
1996-12-06 09:45:30 +00:00
c3e10a4caf 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.
1996-12-06 09:41:45 +00:00
64397b758f Remove duplicate patch for COUNT fix. 1996-12-04 14:23:16 +00:00
9005a38bdb Change portname "sparc" to "sunos4" and change some portname dependencies to
feature dependencies.  Thanks Kurt J. Lidl.
1996-12-04 03:06:33 +00:00
071797f539 Change tests to lowercase for esthetics. 1996-12-03 17:01:35 +00:00
e5fbe3017c pname=NULL -> pname="" (stringinfo.c:appendStringInfo doesn't like NULL). 1996-12-03 05:50:11 +00:00
f2af019645 Make COUNT,SUM case insensitive. 1996-12-03 05:06:35 +00:00
514d69bdbf Remove #if defined(bsdi) define SIGJMP_BUF, per Kurt Lidl. 1996-12-03 00:11:07 +00:00
58193362bd Reduce regression diffs 1996-12-02 14:17:59 +00:00
5f9bdb7641 Reduce regression diff size with timezone changes and cleanup. 1996-12-02 06:31:20 +00:00
7980b8a5cc Fix for inclusion of new prompt output. 1996-12-01 20:28:39 +00:00
1eae8e1228 Fix compiler warning about unitialized variables. 1996-12-01 19:48:39 +00:00
63df35e249 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
1996-11-30 18:07:02 +00:00
f0a9e64afd 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
1996-11-30 17:49:02 +00:00
87352726b2 Change end-of-line comma to semicolon. 1996-11-30 17:47:07 +00:00
d3e0860d25 Aded mention that != maps to <>. 1996-11-30 04:56:18 +00:00
440279e803 Add indicator for in quote or in query to prompt. 1996-11-30 03:41:20 +00:00
2d7aacb052 Added BETWEEN and IN to grammar. Map != to <>. 1996-11-30 03:38:09 +00:00
a3d773a693 Allow select oid,* from table. Allow * anywhere in target list. 1996-11-29 15:56:18 +00:00
a962c6128f vrl_min_tlen added to VRelListData. 1996-11-29 10:29:45 +00:00
03659a262e Added: dynamic re-moving page from list of pages usable for shrinking
if its free-space < min_tuple_len.
1996-11-29 10:27:59 +00:00
7b4426eaea Throw some double quotes on the pile! 1996-11-29 06:24:14 +00:00
316e81cf22 Fix for BSDI compile. 1996-11-29 04:49:46 +00:00