]> granicus.if.org Git - postgresql/log
postgresql
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.

27 years agoThis file has not been part of the regression test for many releases.
Bryan Henderson [Tue, 19 Nov 1996 02:57:10 +0000 (02:57 +0000)]
This file has not been part of the regression test for many releases.

27 years agoThe routines in magic.c have moved to the more accessible version.c.
Bryan Henderson [Tue, 19 Nov 1996 02:55:37 +0000 (02:55 +0000)]
The routines in magic.c have moved to the more accessible version.c.

27 years agoEliminate mk/ directory. The tyranny of the included make file templates is
Bryan Henderson [Tue, 19 Nov 1996 02:52:21 +0000 (02:52 +0000)]
Eliminate mk/ directory.  The tyranny of the included make file templates is
ended!

27 years agoBuild man/ instead of ../doc. Man pages have moved there.
Bryan Henderson [Tue, 19 Nov 1996 02:43:46 +0000 (02:43 +0000)]
Build man/ instead of ../doc.  Man pages have moved there.

27 years agoAdded DLSUFFIX to bsdi.
Bruce Momjian [Mon, 18 Nov 1996 16:32:53 +0000 (16:32 +0000)]
Added DLSUFFIX to bsdi.

27 years agoRename SLSUFF to DLSUFFIX
Bruce Momjian [Mon, 18 Nov 1996 06:07:56 +0000 (06:07 +0000)]
Rename SLSUFF to DLSUFFIX

27 years agoInclude some macros that used to be -D options in Makefile.global.
Bryan Henderson [Mon, 18 Nov 1996 02:27:27 +0000 (02:27 +0000)]
Include some macros that used to be -D options in Makefile.global.

27 years agoRemove linux define of __USE_POSIX, which doesn't appear to do anything.
Bryan Henderson [Mon, 18 Nov 1996 02:26:57 +0000 (02:26 +0000)]
Remove linux define of __USE_POSIX, which doesn't appear to do anything.

27 years agoAdd comments about the diversity of signal functionality. Came from
Bryan Henderson [Mon, 18 Nov 1996 02:25:09 +0000 (02:25 +0000)]
Add comments about the diversity of signal functionality.  Came from
Makefile.global.

27 years agoMake port-specific link libraries defined for linking backend more global
Bryan Henderson [Mon, 18 Nov 1996 02:23:41 +0000 (02:23 +0000)]
Make port-specific link libraries defined for linking backend more global
so you can also link pgtclsh.

27 years agoQuiet compiler warnings about missing prototypes in Linux's bitops.h.
Bryan Henderson [Mon, 18 Nov 1996 01:45:44 +0000 (01:45 +0000)]
Quiet compiler warnings about missing prototypes in Linux's bitops.h.

27 years agoQuiet compiler warnings, ignore the ones we can't.
Bryan Henderson [Mon, 18 Nov 1996 01:44:28 +0000 (01:44 +0000)]
Quiet compiler warnings, ignore the ones we can't.

27 years agoIgnore compiler warnings, because we can't escape "abstract declarator used
Bryan Henderson [Mon, 18 Nov 1996 01:43:55 +0000 (01:43 +0000)]
Ignore compiler warnings, because we can't escape "abstract declarator used
as declaration".

27 years agoRenamed file. Restored SLSUFF to .so.
Bruce Momjian [Sun, 17 Nov 1996 20:30:32 +0000 (20:30 +0000)]
Renamed file.  Restored SLSUFF to .so.

27 years agoEnable manual pages to be installed.
Bruce Momjian [Sun, 17 Nov 1996 19:40:15 +0000 (19:40 +0000)]
Enable manual pages to be installed.

27 years agoCopy needed include files into standard directory.
Bruce Momjian [Sun, 17 Nov 1996 19:27:38 +0000 (19:27 +0000)]
Copy needed include files into standard directory.

27 years agoChange SLSUFF from .so to .o as default.
Bruce Momjian [Sun, 17 Nov 1996 19:26:44 +0000 (19:26 +0000)]
Change SLSUFF from .so to .o as default.

27 years agoNew backend directory description file.
Bruce Momjian [Sun, 17 Nov 1996 05:26:57 +0000 (05:26 +0000)]
New backend directory description file.

27 years agoFix for -da option of pg_dump.
Bruce Momjian [Sun, 17 Nov 1996 04:56:16 +0000 (04:56 +0000)]
Fix for -da option of pg_dump.

27 years agoFix for return code of psql in manual.
Bruce Momjian [Sun, 17 Nov 1996 04:27:34 +0000 (04:27 +0000)]
Fix for return code of psql in manual.

27 years agoFix for error when viewing group access privs.
Bruce Momjian [Sun, 17 Nov 1996 04:26:59 +0000 (04:26 +0000)]
Fix for error when viewing group access privs.

27 years agoFix for Alter TABLE add column varchar(). Was causing zero length.
Bruce Momjian [Sun, 17 Nov 1996 04:23:10 +0000 (04:23 +0000)]
Fix for Alter TABLE add column varchar().  Was causing zero length.

27 years agoFix syntax errors so it runs without error messages.
Bryan Henderson [Sun, 17 Nov 1996 03:55:07 +0000 (03:55 +0000)]
Fix syntax errors so it runs without error messages.

27 years agoRemove old GetPGData reference that causes warning.
Bryan Henderson [Sat, 16 Nov 1996 09:03:44 +0000 (09:03 +0000)]
Remove old GetPGData reference that causes warning.

27 years agoAdd #include <sys/types.h> so it works with Ultrix's in.h
Bryan Henderson [Sat, 16 Nov 1996 08:09:16 +0000 (08:09 +0000)]
Add #include <sys/types.h> so it works with Ultrix's in.h

27 years agoAdded documentation on new unique index capability.
Bruce Momjian [Sat, 16 Nov 1996 05:45:56 +0000 (05:45 +0000)]
Added documentation on new unique index capability.

27 years agoAdded include file needed by memset().
Bruce Momjian [Sat, 16 Nov 1996 05:18:58 +0000 (05:18 +0000)]
Added include file needed by memset().

27 years agoAdd prototype for new datetime functions.
Bruce Momjian [Sat, 16 Nov 1996 04:59:10 +0000 (04:59 +0000)]
Add prototype for new datetime functions.

27 years agoRemove quote removal. Moved to parser.
Bruce Momjian [Fri, 15 Nov 1996 18:38:55 +0000 (18:38 +0000)]
Remove quote removal. Moved to parser.

27 years agoCorrect permissions on lo_export(). Open up permissions.
Bruce Momjian [Fri, 15 Nov 1996 18:38:20 +0000 (18:38 +0000)]
Correct permissions on lo_export(). Open up permissions.

27 years agoFix quote/doublequote handling.
Bruce Momjian [Fri, 15 Nov 1996 18:37:37 +0000 (18:37 +0000)]
Fix quote/doublequote handling.

27 years agoRemove PERFECT_MEM
Bruce Momjian [Fri, 15 Nov 1996 18:37:10 +0000 (18:37 +0000)]
Remove PERFECT_MEM
Unallocate opaque.

27 years agoUnallocate opaque.
Bruce Momjian [Fri, 15 Nov 1996 18:36:31 +0000 (18:36 +0000)]
Unallocate opaque.

27 years agoChanged " to '. Removed bug section from psql. added reminder for log call
Bruce Momjian [Fri, 15 Nov 1996 17:55:31 +0000 (17:55 +0000)]
Changed " to '.  Removed bug section from psql.  added reminder for log call
in built-in.  fixed backslases in source for libpq.

27 years agoMulitple inclusion of sys/socket.h
Marc G. Fournier [Fri, 15 Nov 1996 09:54:28 +0000 (09:54 +0000)]
Mulitple inclusion of sys/socket.h

Pointed out by: Erik Bertelsen <erik@sockdev.uni-c.dk>