Commit Graph

820 Commits

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