1
0
mirror of https://github.com/postgres/postgres.git synced 2025-08-08 06:02:22 +03:00

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
REL2_0
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