]> granicus.if.org Git - postgresql/log
postgresql
27 years agoAvoiding
Vadim B. Mikheev [Sat, 14 Dec 1996 05:20:39 +0000 (05:20 +0000)]
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
...

27 years agoUnuseful tupDesc = CreateTupleDesc(attr_count, attr); in CopyFrom
Vadim B. Mikheev [Sat, 14 Dec 1996 04:58:20 +0000 (04:58 +0000)]
Unuseful tupDesc = CreateTupleDesc(attr_count, attr); in CopyFrom
is eliminated (now I can copy 2000000-table from file without memmory
exhausting).

27 years agoClean up. Get rid of tabs and overly long lines.
Bryan Henderson [Fri, 13 Dec 1996 09:25:08 +0000 (09:25 +0000)]
Clean up.  Get rid of tabs and overly long lines.

27 years agoSmall regression and doc patch
Bruce Momjian [Fri, 13 Dec 1996 02:39:00 +0000 (02:39 +0000)]
Small regression and doc patch

27 years agoPostgres95 to PostgreSQL.
Bruce Momjian [Wed, 11 Dec 1996 22:58:16 +0000 (22:58 +0000)]
Postgres95 to PostgreSQL.

27 years agoRequire seimcolons between statements.
Bruce Momjian [Wed, 11 Dec 1996 22:55:53 +0000 (22:55 +0000)]
Require seimcolons between statements.

27 years agoUse "Oid" type where applicable and %ud instead of %d. Thanks Darren King.
Bryan Henderson [Wed, 11 Dec 1996 03:18:12 +0000 (03:18 +0000)]
Use "Oid" type where applicable and %ud instead of %d.  Thanks Darren King.

27 years agoRename postgres95 to PostgreSQL. Add comment for SELECT NULL
Bruce Momjian [Wed, 11 Dec 1996 00:28:15 +0000 (00:28 +0000)]
Rename postgres95 to PostgreSQL.  Add comment for SELECT NULL

27 years agoFix bug: libpq clients (which include libpq-fe.h) won't compile.
Bryan Henderson [Tue, 10 Dec 1996 07:05:12 +0000 (07:05 +0000)]
Fix bug: libpq clients (which include libpq-fe.h) won't compile.

27 years agosigjmp_buf/jmp_buf is backwards, so backend doesn't compile.
Bryan Henderson [Tue, 10 Dec 1996 07:04:22 +0000 (07:04 +0000)]
sigjmp_buf/jmp_buf is backwards, so backend doesn't compile.

27 years agoFix bug: libpq clients (which include libpq-fe.h) won't compile.
Bryan Henderson [Tue, 10 Dec 1996 07:03:43 +0000 (07:03 +0000)]
Fix bug: libpq clients (which include libpq-fe.h) won't compile.
Plus: sigjmp_buf/jmp_buf is backwards, so backend doesn't compile.

27 years agoAdd empty "dep:" target.
Bryan Henderson [Tue, 10 Dec 1996 03:40:23 +0000 (03:40 +0000)]
Add empty "dep:" target.

27 years agoNo change...just a test to make sure I didn't screw anything up
Marc G. Fournier [Tue, 10 Dec 1996 03:03:36 +0000 (03:03 +0000)]
No change...just a test to make sure I didn't screw anything up

27 years agoMonitor has been obsoleted by psql.
Bryan Henderson [Mon, 9 Dec 1996 01:55:51 +0000 (01:55 +0000)]
Monitor has been obsoleted by psql.

27 years agoRemove include of libpq-fe.h. This file has nothing to do with libpq.
Bryan Henderson [Mon, 9 Dec 1996 01:24:53 +0000 (01:24 +0000)]
Remove include of libpq-fe.h.  This file has nothing to do with libpq.

27 years agoAdd comments defining "typelem" column of pg_type.
Bryan Henderson [Mon, 9 Dec 1996 01:23:51 +0000 (01:23 +0000)]
Add comments defining "typelem" column of pg_type.

27 years agoAdd comments describing interface to heap_getattr().
Bryan Henderson [Mon, 9 Dec 1996 01:22:17 +0000 (01:22 +0000)]
Add comments describing interface to heap_getattr().

27 years agoAdd CUSTOM_CC variable for Makefile.custom. Thanks Kurt Lidl.
Bryan Henderson [Mon, 9 Dec 1996 01:16:51 +0000 (01:16 +0000)]
Add CUSTOM_CC variable for Makefile.custom.  Thanks Kurt Lidl.

27 years agoReduce printing from debug level 2 ande layout change.
Bruce Momjian [Sat, 7 Dec 1996 04:39:38 +0000 (04:39 +0000)]
Reduce printing from debug level 2 ande layout change.

27 years agoReduce printing from deub level 2 ande layout change.
Bruce Momjian [Sat, 7 Dec 1996 04:38:40 +0000 (04:38 +0000)]
Reduce printing from deub level 2 ande layout change.

27 years agoRemove Dan's fix of SELECT NULL to fix INSERT NULL.
Bruce Momjian [Sat, 7 Dec 1996 04:38:11 +0000 (04:38 +0000)]
Remove Dan's fix of SELECT NULL to fix INSERT NULL.

27 years agoFix for SELECT NULL.
Bruce Momjian [Sat, 7 Dec 1996 04:37:06 +0000 (04:37 +0000)]
Fix for SELECT NULL.

27 years agoFix from Jan agreed with by Massimo.
Bruce Momjian [Sat, 7 Dec 1996 04:36:38 +0000 (04:36 +0000)]
Fix from Jan agreed with by Massimo.

27 years ago_bt_updateitem is returned in code, but works only if sizes of keys
Vadim B. Mikheev [Fri, 6 Dec 1996 09:45:30 +0000 (09:45 +0000)]
_bt_updateitem is returned in code, but works only if sizes of keys
are equal.

27 years ago1. _bt_compare fixed to work properly with new code in _bt_insertonpg
Vadim B. Mikheev [Fri, 6 Dec 1996 09:41:45 +0000 (09:41 +0000)]
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.

27 years agoRemove duplicate patch for COUNT fix.
Bruce Momjian [Wed, 4 Dec 1996 14:23:16 +0000 (14:23 +0000)]
Remove duplicate patch for COUNT fix.

27 years agoChange portname "sparc" to "sunos4" and change some portname dependencies to
Bryan Henderson [Wed, 4 Dec 1996 03:06:33 +0000 (03:06 +0000)]
Change portname "sparc" to "sunos4" and change some portname dependencies to
feature dependencies.  Thanks Kurt J. Lidl.

27 years agoChange tests to lowercase for esthetics.
Bruce Momjian [Tue, 3 Dec 1996 17:01:35 +0000 (17:01 +0000)]
Change tests to lowercase for esthetics.

27 years agopname=NULL -> pname="" (stringinfo.c:appendStringInfo doesn't like NULL).
Vadim B. Mikheev [Tue, 3 Dec 1996 05:50:11 +0000 (05:50 +0000)]
pname=NULL -> pname="" (stringinfo.c:appendStringInfo doesn't like NULL).

27 years agoMake COUNT,SUM case insensitive.
Bruce Momjian [Tue, 3 Dec 1996 05:06:35 +0000 (05:06 +0000)]
Make COUNT,SUM case insensitive.

27 years agoRemove #if defined(bsdi) define SIGJMP_BUF, per Kurt Lidl.
Bryan Henderson [Tue, 3 Dec 1996 00:11:07 +0000 (00:11 +0000)]
Remove #if defined(bsdi) define SIGJMP_BUF, per Kurt Lidl.

27 years agoReduce regression diffs
Bruce Momjian [Mon, 2 Dec 1996 14:17:59 +0000 (14:17 +0000)]
Reduce regression diffs

27 years agoReduce regression diff size with timezone changes and cleanup.
Bruce Momjian [Mon, 2 Dec 1996 06:31:20 +0000 (06:31 +0000)]
Reduce regression diff size with timezone changes and cleanup.

27 years agoFix for inclusion of new prompt output.
Bruce Momjian [Sun, 1 Dec 1996 20:28:39 +0000 (20:28 +0000)]
Fix for inclusion of new prompt output.

27 years agoFix compiler warning about unitialized variables.
Bruce Momjian [Sun, 1 Dec 1996 19:48:39 +0000 (19:48 +0000)]
Fix compiler warning about unitialized variables.

27 years agoThis patch changes quite a few instances of references of Oid's
Bruce Momjian [Sat, 30 Nov 1996 18:07:02 +0000 (18:07 +0000)]
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

27 years agoAs someone asked for this feature - patch for 1.09 follows.
Bruce Momjian [Sat, 30 Nov 1996 17:49:02 +0000 (17:49 +0000)]
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

27 years agoChange end-of-line comma to semicolon.
Bruce Momjian [Sat, 30 Nov 1996 17:47:07 +0000 (17:47 +0000)]
Change end-of-line comma to semicolon.

27 years agoAded mention that != maps to <>.
Bruce Momjian [Sat, 30 Nov 1996 04:56:18 +0000 (04:56 +0000)]
Aded mention that != maps to <>.

27 years agoAdd indicator for in quote or in query to prompt.
Bruce Momjian [Sat, 30 Nov 1996 03:41:20 +0000 (03:41 +0000)]
Add indicator for in quote or in query to prompt.

27 years agoAdded BETWEEN and IN to grammar. Map != to <>.
Bruce Momjian [Sat, 30 Nov 1996 03:38:09 +0000 (03:38 +0000)]
Added BETWEEN and IN to grammar.  Map != to <>.

27 years agoAllow select oid,* from table. Allow * anywhere in target list.
Bruce Momjian [Fri, 29 Nov 1996 15:56:18 +0000 (15:56 +0000)]
Allow select oid,* from table.  Allow * anywhere in target list.

27 years agovrl_min_tlen added to VRelListData.
Vadim B. Mikheev [Fri, 29 Nov 1996 10:29:45 +0000 (10:29 +0000)]
vrl_min_tlen added to VRelListData.

27 years agoAdded: dynamic re-moving page from list of pages usable for shrinking
Vadim B. Mikheev [Fri, 29 Nov 1996 10:27:59 +0000 (10:27 +0000)]
Added: dynamic re-moving page from list of pages usable for shrinking
if its free-space < min_tuple_len.

27 years agoThrow some double quotes on the pile!
Bryan Henderson [Fri, 29 Nov 1996 06:24:14 +0000 (06:24 +0000)]
Throw some double quotes on the pile!

27 years agoFix for BSDI compile.
Bruce Momjian [Fri, 29 Nov 1996 04:49:46 +0000 (04:49 +0000)]
Fix for BSDI compile.

27 years agoChanged saved_relname size to save memory.
Bruce Momjian [Thu, 28 Nov 1996 05:46:08 +0000 (05:46 +0000)]
Changed saved_relname size to save memory.

27 years agoFix for "might be used uninitialized" warnings.
Vadim B. Mikheev [Thu, 28 Nov 1996 04:37:38 +0000 (04:37 +0000)]
Fix for "might be used uninitialized" warnings.

27 years agoMake strdup work for Ultrix. Thanks Erik Bertelsen
Bryan Henderson [Thu, 28 Nov 1996 03:32:18 +0000 (03:32 +0000)]
Make strdup work for Ultrix.  Thanks Erik Bertelsen

27 years agoTransactionIdIsInProgress is commented out
Vadim B. Mikheev [Wed, 27 Nov 1996 15:15:54 +0000 (15:15 +0000)]
TransactionIdIsInProgress is commented out

27 years agoConvert ' to " in dates. Update example code to show empty query as "".
Bruce Momjian [Wed, 27 Nov 1996 13:49:46 +0000 (13:49 +0000)]
Convert ' to " in dates.  Update example code to show empty query as "".

27 years agoRemove unused define's.
Bruce Momjian [Wed, 27 Nov 1996 13:48:58 +0000 (13:48 +0000)]
Remove unused define's.

27 years agono change
Bruce Momjian [Wed, 27 Nov 1996 13:48:23 +0000 (13:48 +0000)]
no change

27 years agoAllow all empty queries to return EMPTY.
Bruce Momjian [Wed, 27 Nov 1996 13:47:05 +0000 (13:47 +0000)]
Allow all empty queries to return EMPTY.

27 years agoMore stuff to make it compile on various ports.
Bryan Henderson [Wed, 27 Nov 1996 08:16:44 +0000 (08:16 +0000)]
More stuff to make it compile on various ports.

27 years agoNew structures for new vacuum.
Vadim B. Mikheev [Wed, 27 Nov 1996 07:35:06 +0000 (07:35 +0000)]
New structures for new vacuum.

27 years agoNew mdtruncate() & smgrtruncate() funcs.
Vadim B. Mikheev [Wed, 27 Nov 1996 07:33:42 +0000 (07:33 +0000)]
New mdtruncate() & smgrtruncate() funcs.

27 years agoTransactionIdIsInProgress moved to shmem.c
Vadim B. Mikheev [Wed, 27 Nov 1996 07:32:10 +0000 (07:32 +0000)]
TransactionIdIsInProgress moved to shmem.c

27 years agoShrinking and other things.
Vadim B. Mikheev [Wed, 27 Nov 1996 07:27:20 +0000 (07:27 +0000)]
Shrinking and other things.

27 years agoNew smgrtruncate smgr' interface func.
Vadim B. Mikheev [Wed, 27 Nov 1996 07:25:52 +0000 (07:25 +0000)]
New smgrtruncate smgr' interface func.

27 years agoNew mdtruncate() func for single segment relations (< 2Gb).
Vadim B. Mikheev [Wed, 27 Nov 1996 07:24:02 +0000 (07:24 +0000)]
New mdtruncate() func for single segment relations (< 2Gb).

27 years agoTransactionIdIsInProgress is here now and gives quality answer
Vadim B. Mikheev [Wed, 27 Nov 1996 07:20:07 +0000 (07:20 +0000)]
TransactionIdIsInProgress is here now and gives quality answer
by scanning PROC structures of all running backend.

27 years agoSetting MyProc->xid to InvalidTransactionId while creating
Vadim B. Mikheev [Wed, 27 Nov 1996 07:17:48 +0000 (07:17 +0000)]
Setting MyProc->xid to InvalidTransactionId while creating
PROC structure (it's for new TransactionIdIsInProgress func).

27 years agoSetting MyProc->xid to current transaction' id in StartTransaction
Vadim B. Mikheev [Wed, 27 Nov 1996 07:14:51 +0000 (07:14 +0000)]
Setting MyProc->xid to current transaction' id in StartTransaction
and to InvalidTransactionId in CommitTransaction & AbortTransaction
(it's for new TransactionIdIsInProgress func).

27 years agoTransactionIdIsInProgress moved to shmem.c
Vadim B. Mikheev [Wed, 27 Nov 1996 07:10:59 +0000 (07:10 +0000)]
TransactionIdIsInProgress moved to shmem.c

27 years agoForgot in yesterday's Ultrix compile work.
Bryan Henderson [Wed, 27 Nov 1996 01:46:52 +0000 (01:46 +0000)]
Forgot in yesterday's Ultrix compile work.

27 years agoOK, I think I've got the postconfig thing right now.
Bryan Henderson [Tue, 26 Nov 1996 08:12:39 +0000 (08:12 +0000)]
OK, I think I've got the postconfig thing right now.

27 years agoWhoops, redo Ultrix patch so the other ports still compile.
Bryan Henderson [Tue, 26 Nov 1996 07:39:11 +0000 (07:39 +0000)]
Whoops, redo Ultrix patch so the other ports still compile.

27 years agoFix double-colon syntax error on fe-lobj.o.
Bryan Henderson [Tue, 26 Nov 1996 06:33:18 +0000 (06:33 +0000)]
Fix double-colon syntax error on fe-lobj.o.

27 years agoMake it compile on Ultrix. Thanks Erik Bertelson.
Bryan Henderson [Tue, 26 Nov 1996 03:20:35 +0000 (03:20 +0000)]
Make it compile on Ultrix.  Thanks Erik Bertelson.

27 years agoProperly structure ProcedureNameIndexScan so it doesn't generate
Bryan Henderson [Tue, 26 Nov 1996 02:45:05 +0000 (02:45 +0000)]
Properly structure  ProcedureNameIndexScan so it doesn't generate
"may be used before being set" warnings.

27 years agoPut in #include <fcntl.h> for those systems that don't have it included by something...
Bryan Henderson [Tue, 26 Nov 1996 01:17:56 +0000 (01:17 +0000)]
Put in #include <fcntl.h> for those systems that don't have it included by something else.

27 years ago-Werror fixes from D'Arcy.
Bryan Henderson [Tue, 26 Nov 1996 01:14:38 +0000 (01:14 +0000)]
-Werror fixes from D'Arcy.

27 years agoInclude fcntl.h, which is not automatically included by sys/file.h on all systems.
Bryan Henderson [Mon, 25 Nov 1996 06:33:51 +0000 (06:33 +0000)]
Include fcntl.h, which is not automatically included by sys/file.h on all systems.

27 years agoGo back to $(postconfig...) from $(exec postconfig...) so it works on non-bash.
Bryan Henderson [Mon, 25 Nov 1996 05:51:50 +0000 (05:51 +0000)]
Go back to $(postconfig...) from $(exec postconfig...) so it works on non-bash.

27 years agoPrevent empty queries from crashing server.
Bruce Momjian [Mon, 25 Nov 1996 03:03:48 +0000 (03:03 +0000)]
Prevent empty queries from crashing server.

27 years agoFix access through null pointer info->rule_action. Thanks Darren King.
Bryan Henderson [Sun, 24 Nov 1996 05:58:57 +0000 (05:58 +0000)]
Fix access through null pointer info->rule_action.  Thanks Darren King.

27 years agoFix syntax error: missing argument to elog(). Thanks Darren King.
Bryan Henderson [Sun, 24 Nov 1996 05:46:12 +0000 (05:46 +0000)]
Fix syntax error: missing argument to elog().  Thanks Darren King.

27 years agoTypecasts, etc. to make compile work on AIX. Thanks Darren King..
Bryan Henderson [Sun, 24 Nov 1996 04:44:24 +0000 (04:44 +0000)]
Typecasts, etc. to make compile work on AIX.  Thanks Darren King..

27 years agoMove include of signal.h inside pqsignal.h so it's always where it's needed.
Bryan Henderson [Sun, 24 Nov 1996 04:07:17 +0000 (04:07 +0000)]
Move include of signal.h inside pqsignal.h so it's always where it's needed.

27 years agoAdd dep: rule.
Bryan Henderson [Sun, 24 Nov 1996 03:55:19 +0000 (03:55 +0000)]
Add dep: rule.

27 years agoFirst pass at getting shared libraries on AIX properly built.
Bryan Henderson [Sat, 23 Nov 1996 09:51:57 +0000 (09:51 +0000)]
First pass at getting shared libraries on AIX properly built.

27 years agoEliminate pesky "postconfig not found" message.
Bryan Henderson [Sat, 23 Nov 1996 09:42:51 +0000 (09:42 +0000)]
Eliminate pesky "postconfig not found" message.

27 years agoFix for \g strdup error.
Bruce Momjian [Fri, 22 Nov 1996 06:45:14 +0000 (06:45 +0000)]
Fix for \g strdup error.

27 years agoInclude ctype.h to fix Kurt Lidl's compile problem.
Bryan Henderson [Fri, 22 Nov 1996 04:43:48 +0000 (04:43 +0000)]
Include ctype.h to fix Kurt Lidl's compile problem.

27 years agoInclude stdio.h to fix Craig Anderson's compile problem.
Bryan Henderson [Fri, 22 Nov 1996 04:39:53 +0000 (04:39 +0000)]
Include stdio.h to fix Craig Anderson's compile problem.

27 years agoFix bug: No -D option to postgres
Bryan Henderson [Fri, 22 Nov 1996 04:33:34 +0000 (04:33 +0000)]
Fix bug: No -D option to postgres

27 years agoFix bug: -D options implies -d option.
Bryan Henderson [Fri, 22 Nov 1996 04:32:41 +0000 (04:32 +0000)]
Fix bug: -D options implies -d option.

27 years agoFix memory overhelding while forming index' result:
Vadim B. Mikheev [Thu, 21 Nov 1996 06:13:43 +0000 (06:13 +0000)]
Fix memory overhelding while forming index' result:
memory allocation for ItemPointerData of heap' tuple is useless
because of FormRetrieveIndexResult makes neccessary palloc.

27 years agoFix memory overhelding while forming index' result:
Vadim B. Mikheev [Thu, 21 Nov 1996 06:06:52 +0000 (06:06 +0000)]
Fix memory overhelding while forming index' result:

memory allocation for ItemPointerData of heap' tuple is useless

because of FormRetrieveIndexResult makes neccessary palloc.

27 years agoFix memory overhelding while forming index' result:
Vadim B. Mikheev [Thu, 21 Nov 1996 06:02:56 +0000 (06:02 +0000)]
Fix memory overhelding while forming index' result:
memory allocation for ItemPointerData of heap' tuple is useless
because of FormRetrieveIndexResult makes neccessary palloc.

27 years agoCan't add a keyword without making it a keyword. :-)
Bruce Momjian [Wed, 20 Nov 1996 22:58:22 +0000 (22:58 +0000)]
Can't add a keyword without making it a keyword.  :-)
D'Arcy J.M. Cain                           |  Democracy is three wolves

27 years agoOtherwise "gmake install" fails.
Bruce Momjian [Wed, 20 Nov 1996 22:53:49 +0000 (22:53 +0000)]
Otherwise "gmake install" fails.

D'Arcy J.M. Cain                           |  Democracy is three wolves

27 years agoThere is a bug in aclinsert3 in the code which update the acl arrays.
Bruce Momjian [Wed, 20 Nov 1996 22:53:10 +0000 (22:53 +0000)]
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

27 years ago following is a little fix for libpq.
Bruce Momjian [Wed, 20 Nov 1996 22:35:19 +0000 (22:35 +0000)]
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)

27 years agoFix \g filename. Free allocated memory and don't use memory that has
Bruce Momjian [Wed, 20 Nov 1996 22:34:36 +0000 (22:34 +0000)]
Fix \g filename.  Free allocated memory and don't use memory that has
been freed.

27 years agoHere is the patch for pg_dump not handling NULL values in 'insert'
Bruce Momjian [Wed, 20 Nov 1996 22:32:55 +0000 (22:32 +0000)]
Here is the patch for pg_dump not handling NULL values in 'insert'
mode properly.  This will apply correctly to 1.09 & 2.0 sources.
From David H. Bennett

27 years agoFix for man Makefile. Added 'all'.
Bruce Momjian [Wed, 20 Nov 1996 01:54:13 +0000 (01:54 +0000)]
Fix for man Makefile.  Added 'all'.

27 years agoMake install change for man files
Bruce Momjian [Tue, 19 Nov 1996 22:23:13 +0000 (22:23 +0000)]
Make install change for man files

27 years agoRemoved old Assert's used during development.
Bruce Momjian [Tue, 19 Nov 1996 05:06:39 +0000 (05:06 +0000)]
Removed old Assert's used during development.