]> granicus.if.org Git - postgresql/log
postgresql
27 years agoFix for S_FREE_LOCK.
Bruce Momjian [Wed, 24 Sep 1997 23:37:26 +0000 (23:37 +0000)]
Fix for S_FREE_LOCK.

27 years agoUse additional ORDER BY to cope with new sorting routines.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:55:38 +0000 (17:55 +0000)]
Use additional ORDER BY to cope with new sorting routines.

27 years agoAdd SQL/92 "constants" current_date, current_time, and current_timestamp.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:53:53 +0000 (17:53 +0000)]
Add SQL/92 "constants" current_date, current_time, and current_timestamp.
Add SQL/92 types decimal and numeric (temporary for syntax support).
 These types need more support in the backend to be really implemented,
 and the parser will need to be changed at that time.
Adjust limits on precision parameters for FLOAT(p) to match IEEE-compliant
 arithmetic. Perhaps these limits should be processor-specific or obtained
 from system include files instead.

27 years agoAdd SQL/92 types decimal and numeric.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:49:56 +0000 (17:49 +0000)]
Add SQL/92 types decimal and numeric.
Add SQL/92 "constants" current_date, current_time, and current_timestamp.

27 years agoRestore proper behavior for escaped quotes and for escaped literals
Thomas G. Lockhart [Wed, 24 Sep 1997 17:48:25 +0000 (17:48 +0000)]
Restore proper behavior for escaped quotes and for escaped literals
 like newline inside quoted strings.

27 years agoRemove debugging "puts" print statement.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:46:14 +0000 (17:46 +0000)]
Remove debugging "puts" print statement.

27 years agoCoerce type of NULL pointer return to suppress gcc compiler warnings.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:45:21 +0000 (17:45 +0000)]
Coerce type of NULL pointer return to suppress gcc compiler warnings.

27 years agoFix for pg_dump.
Bruce Momjian [Wed, 24 Sep 1997 16:20:04 +0000 (16:20 +0000)]
Fix for pg_dump.

27 years agoUpdate configure.
Bruce Momjian [Wed, 24 Sep 1997 15:57:28 +0000 (15:57 +0000)]
Update configure.

27 years agoRemove aix power pc.
Bruce Momjian [Wed, 24 Sep 1997 15:49:46 +0000 (15:49 +0000)]
Remove aix power pc.

27 years agoRemove extra float.h I added.
Bruce Momjian [Wed, 24 Sep 1997 15:40:59 +0000 (15:40 +0000)]
Remove extra float.h I added.

27 years agoCREATE FUNCTION fixup for types of functions.
Bruce Momjian [Wed, 24 Sep 1997 15:36:36 +0000 (15:36 +0000)]
CREATE FUNCTION fixup for types of functions.

27 years agoRollback changes to pg_dump.c
Bruce Momjian [Wed, 24 Sep 1997 15:14:02 +0000 (15:14 +0000)]
Rollback changes to pg_dump.c

27 years agoTimetravel tests.
Vadim B. Mikheev [Wed, 24 Sep 1997 08:36:47 +0000 (08:36 +0000)]
Timetravel tests.

27 years agoAdded: ttdummy() - variation of timetravel() function
Vadim B. Mikheev [Wed, 24 Sep 1997 08:35:10 +0000 (08:35 +0000)]
Added: ttdummy() - variation of timetravel() function
for regress test.

27 years ago+ SPI_palloc(), SPI_repalloc(), SPI_pfree()
Vadim B. Mikheev [Wed, 24 Sep 1997 08:32:09 +0000 (08:32 +0000)]
+ SPI_palloc(), SPI_repalloc(), SPI_pfree()

27 years agoAllow use functions with no arguments in DEFAULT
Vadim B. Mikheev [Wed, 24 Sep 1997 08:31:04 +0000 (08:31 +0000)]
Allow use functions with no arguments in DEFAULT
Allow use IDENT as arguments of trigger functions

27 years ago+ SPI_palloc(), SPI_repalloc(), SPI_pfree() - for allocations
Vadim B. Mikheev [Wed, 24 Sep 1997 08:28:37 +0000 (08:28 +0000)]
+ SPI_palloc(), SPI_repalloc(), SPI_pfree() - for allocations
in upper Executor memory context.

27 years agoGeneral trigger functions for time-travel
Vadim B. Mikheev [Wed, 24 Sep 1997 08:17:14 +0000 (08:17 +0000)]
General trigger functions for time-travel

27 years agoHPUX 10 patch.
Bruce Momjian [Wed, 24 Sep 1997 04:20:29 +0000 (04:20 +0000)]
HPUX 10 patch.

27 years agoAdd -S to top of manual page.
Bruce Momjian [Wed, 24 Sep 1997 03:20:54 +0000 (03:20 +0000)]
Add -S to top of manual page.

27 years agoAIX fixes.
Bruce Momjian [Tue, 23 Sep 1997 22:53:47 +0000 (22:53 +0000)]
AIX fixes.

27 years agoFix for CREATE FUNCTION.
Bruce Momjian [Tue, 23 Sep 1997 21:44:07 +0000 (21:44 +0000)]
Fix for CREATE FUNCTION.

27 years agoFix for backslash quote.
Bruce Momjian [Tue, 23 Sep 1997 19:47:59 +0000 (19:47 +0000)]
Fix for backslash quote.

27 years agoAIx patch from Frank Dana.
Bruce Momjian [Tue, 23 Sep 1997 17:43:33 +0000 (17:43 +0000)]
AIx patch from Frank Dana.

27 years agoCleanup.
Bruce Momjian [Tue, 23 Sep 1997 00:02:44 +0000 (00:02 +0000)]
Cleanup.

27 years agoCleanup backslashes.
Bruce Momjian [Mon, 22 Sep 1997 18:14:25 +0000 (18:14 +0000)]
Cleanup backslashes.

27 years agoFix for missing tas on some platforms.
Bruce Momjian [Mon, 22 Sep 1997 15:59:19 +0000 (15:59 +0000)]
Fix for missing tas on some platforms.

27 years agoSmall lock cleanup for prototype.
Bruce Momjian [Mon, 22 Sep 1997 15:49:14 +0000 (15:49 +0000)]
Small lock cleanup for prototype.

27 years agoBlowaway relation buffers from buffer pool before truncation:
Vadim B. Mikheev [Mon, 22 Sep 1997 07:13:56 +0000 (07:13 +0000)]
Blowaway relation buffers from buffer pool before truncation:

+ BlowawayRelationBuffers(relation, blocknumber)

27 years agoBlowaway relation buffers from buffer pool before truncation.
Vadim B. Mikheev [Mon, 22 Sep 1997 07:12:33 +0000 (07:12 +0000)]
Blowaway relation buffers from buffer pool before truncation.

27 years agoTwo copies...
Vadim B. Mikheev [Mon, 22 Sep 1997 04:21:51 +0000 (04:21 +0000)]
Two copies...

27 years agoHave to PROC_INCR_SLOCK before return.
Vadim B. Mikheev [Mon, 22 Sep 1997 04:20:53 +0000 (04:20 +0000)]
Have to PROC_INCR_SLOCK before return.

27 years agoFix: Operand Order Affects OR.
Vadim B. Mikheev [Mon, 22 Sep 1997 04:19:36 +0000 (04:19 +0000)]
Fix: Operand Order Affects OR.
where x <> 1 or x isnull
didn't return tuples with x NULL.

27 years ago+#include <access/xact.h>
Vadim B. Mikheev [Mon, 22 Sep 1997 03:58:32 +0000 (03:58 +0000)]
+#include <access/xact.h>

27 years agoConfigure OS cleanup.
Bruce Momjian [Sun, 21 Sep 1997 22:54:19 +0000 (22:54 +0000)]
Configure OS cleanup.

27 years agoMake manual page for pg_passwd from README.
Bruce Momjian [Sun, 21 Sep 1997 04:54:36 +0000 (04:54 +0000)]
Make manual page for pg_passwd from README.

27 years agoOutput changed for new ORDER BY to cope with new sorting routines.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:37:02 +0000 (16:37 +0000)]
Output changed for new ORDER BY to cope with new sorting routines.

27 years agoOutput changed to reflect extra entries from new regression tests.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:35:34 +0000 (16:35 +0000)]
Output changed to reflect extra entries from new regression tests.

27 years agoChange ORDER BY to get consistant results with new sorting routines.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:34:08 +0000 (16:34 +0000)]
Change ORDER BY to get consistant results with new sorting routines.

27 years agoUpdate results count to reflect bad entries now being rejected by new decoder.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:33:24 +0000 (16:33 +0000)]
Update results count to reflect bad entries now being rejected by new decoder.

27 years agoChange ORDER BY to get more consistant results.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:31:44 +0000 (16:31 +0000)]
Change ORDER BY to get more consistant results.

27 years agoAdd tinterval comparison operators.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:29:38 +0000 (16:29 +0000)]
Add tinterval comparison operators.
Add integer/money arithmetic.

27 years agoAdd point_ne() comparison routine.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:25:28 +0000 (16:25 +0000)]
Add point_ne() comparison routine.

27 years agoAdd tinterval comparison routines.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:24:39 +0000 (16:24 +0000)]
Add tinterval comparison routines.

27 years agoAdd integer/money arithmetic from Darren King.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:23:47 +0000 (16:23 +0000)]
Add integer/money arithmetic from Darren King.

27 years agoAdd point_ne() function.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:22:31 +0000 (16:22 +0000)]
Add point_ne() function.
Fix up tabbing of most function declarations.

27 years agoFix typo for default units for timespan input.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:20:29 +0000 (16:20 +0000)]
Fix typo for default units for timespan input.
Place single-ticks around bad argument in elog messages.
Fix tabbing of large lookup tables (ugh).

27 years agoInclude tinterval comparison functions for span of interval.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:17:45 +0000 (16:17 +0000)]
Include tinterval comparison functions for span of interval.

27 years agoInclude functions for integer/money arithmetic.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:15:34 +0000 (16:15 +0000)]
Include functions for integer/money arithmetic.

27 years agoFix up elog warning messages.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:14:05 +0000 (16:14 +0000)]
Fix up elog warning messages.

27 years agoAdd support for FLOAT(p) SQL/92 data type.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:11:44 +0000 (16:11 +0000)]
Add support for FLOAT(p) SQL/92 data type.
Allow ALTER TABLE ADD ( column ) syntax.

27 years agoReplace missing directory delimiter for postmaster installation command.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:08:24 +0000 (16:08 +0000)]
Replace missing directory delimiter for postmaster installation command.

27 years agoBring in Peter's changes...finally :(
Marc G. Fournier [Sat, 20 Sep 1997 02:21:25 +0000 (02:21 +0000)]
Bring in Peter's changes...finally :(

27 years agoUpdate configure.
Bruce Momjian [Fri, 19 Sep 1997 22:02:26 +0000 (22:02 +0000)]
Update configure.

27 years ago1997-06-15 Paul Eggert <eggert@twinsun.com>
Marc G. Fournier [Fri, 19 Sep 1997 19:44:30 +0000 (19:44 +0000)]
1997-06-15  Paul Eggert  <eggert@twinsun.com>

        * (src/backend/Makefile): Use `ln', not `cd;ln' so that installers
        can wrap ln.

27 years ago+ _copyGroup(Group *from)
Vadim B. Mikheev [Fri, 19 Sep 1997 06:52:49 +0000 (06:52 +0000)]
+ _copyGroup(Group *from)

27 years agoFix \e and \p after query.
Bruce Momjian [Fri, 19 Sep 1997 03:42:39 +0000 (03:42 +0000)]
Fix \e and \p after query.

27 years agoInline memset() as MemSet().
Bruce Momjian [Thu, 18 Sep 1997 20:22:58 +0000 (20:22 +0000)]
Inline memset() as MemSet().

27 years agoHave to do [[ ]] in configure.in.
Bruce Momjian [Thu, 18 Sep 1997 19:57:31 +0000 (19:57 +0000)]
Have to do [[ ]] in configure.in.

27 years agoUPdate memset macro.
Bruce Momjian [Thu, 18 Sep 1997 18:48:32 +0000 (18:48 +0000)]
UPdate memset macro.

27 years agoUpdate HISTORY.
Bruce Momjian [Thu, 18 Sep 1997 17:17:19 +0000 (17:17 +0000)]
Update HISTORY.

27 years agoCleanup for memset macro.
Bruce Momjian [Thu, 18 Sep 1997 17:06:21 +0000 (17:06 +0000)]
Cleanup for memset macro.

27 years agoAdd in srandom() check to configure
Marc G. Fournier [Thu, 18 Sep 1997 16:09:41 +0000 (16:09 +0000)]
Add in srandom() check to configure
Add appropriate HAVE_{RANDOM,SRANDOM} values to config.h
Add approrpiate #ifdef's to sparc_solaris port files for Solaris v2.6

27 years agoQUERY: SELECT p.name, p.age FROM person* p ORDER BY age using >;
Vadim B. Mikheev [Thu, 18 Sep 1997 14:45:33 +0000 (14:45 +0000)]
QUERY: SELECT p.name, p.age FROM person* p ORDER BY age using >;
              ^^^^^^ - new order of tuples (due to psort changes)

27 years agoNo more SortTuplesInTree...
Vadim B. Mikheev [Thu, 18 Sep 1997 14:42:35 +0000 (14:42 +0000)]
No more SortTuplesInTree...

27 years agoDon't limit number of tuples in leftist trees!
Vadim B. Mikheev [Thu, 18 Sep 1997 14:41:56 +0000 (14:41 +0000)]
Don't limit number of tuples in leftist trees!
Use qsort to sort array of tuples for nextrun when current
run is done and put into leftist tree from sorted array!
It's much faster and creates non-bushy tree - this is ve-e-ery good
for perfomance!

27 years agoNo more SortTuplesInTree...
Vadim B. Mikheev [Thu, 18 Sep 1997 14:33:46 +0000 (14:33 +0000)]
No more SortTuplesInTree...

27 years agoConvert sequence names tolower.
Vadim B. Mikheev [Thu, 18 Sep 1997 14:32:15 +0000 (14:32 +0000)]
Convert sequence names tolower.

27 years agoALTER TABLE ADD COLUMN: set atthasdef to FALSE.
Vadim B. Mikheev [Thu, 18 Sep 1997 14:31:38 +0000 (14:31 +0000)]
ALTER TABLE ADD COLUMN: set atthasdef to FALSE.

27 years agoInline frequently called functions.
Bruce Momjian [Thu, 18 Sep 1997 14:21:02 +0000 (14:21 +0000)]
Inline frequently called functions.

27 years agoAddded to Psortstate:
Vadim B. Mikheev [Thu, 18 Sep 1997 05:42:01 +0000 (05:42 +0000)]
Addded to Psortstate:
lt_tupcount - number of tuples in struct leftist *Tuples
lasttuple   - last tuple put to disk by createfirstrun()

27 years ago+ SortTuplesInTree
Vadim B. Mikheev [Thu, 18 Sep 1997 05:38:09 +0000 (05:38 +0000)]
+ SortTuplesInTree

27 years ago1. Use qsort for first run
Vadim B. Mikheev [Thu, 18 Sep 1997 05:37:31 +0000 (05:37 +0000)]
1. Use qsort for first run
2. Limit number of tuples in leftist trees:
- put one tuple from current tree to disk if limit reached;
- end run creation if limit reached by nextrun.
3. Avoid mergeruns() if first run is single one!

27 years ago+ int SortTuplesInTree = 2560;
Vadim B. Mikheev [Thu, 18 Sep 1997 05:23:58 +0000 (05:23 +0000)]
+ int SortTuplesInTree = 2560;
(default value for max number of tuples in leftist tree)

27 years agoAllow set max number of tuples in leftist tree for sorts
Vadim B. Mikheev [Thu, 18 Sep 1997 05:19:17 +0000 (05:19 +0000)]
Allow set max number of tuples in leftist tree for sorts
(-S memory,tuples)

27 years agoAdd explicit test for various comment syntaxes.
Thomas G. Lockhart [Thu, 18 Sep 1997 03:54:19 +0000 (03:54 +0000)]
Add explicit test for various comment syntaxes.

27 years agoExplicitly test various comment syntaxes.
Thomas G. Lockhart [Thu, 18 Sep 1997 03:52:43 +0000 (03:52 +0000)]
Explicitly test various comment syntaxes.

27 years agoAdd syntax and warnings for unsupported ALTER TABLE commands
Thomas G. Lockhart [Thu, 18 Sep 1997 03:46:18 +0000 (03:46 +0000)]
Add syntax and warnings for unsupported ALTER TABLE commands
 including DROP COLUMN, SET CONSTRAINT, etc.

27 years agoAck, I missed a template file here :(
Marc G. Fournier [Thu, 18 Sep 1997 01:32:14 +0000 (01:32 +0000)]
Ack, I missed a template file here :(

27 years ago*** empty log message ***
Edmund Mergl [Wed, 17 Sep 1997 20:53:35 +0000 (20:53 +0000)]
*** empty log message ***

27 years ago*** empty log message ***
Edmund Mergl [Wed, 17 Sep 1997 20:51:36 +0000 (20:51 +0000)]
*** empty log message ***

27 years agoadapted to pgsql-v6.2
Edmund Mergl [Wed, 17 Sep 1997 20:48:15 +0000 (20:48 +0000)]
adapted to pgsql-v6.2

27 years ago*** empty log message ***
Edmund Mergl [Wed, 17 Sep 1997 20:46:29 +0000 (20:46 +0000)]
*** empty log message ***

27 years agoRemove extra backets in tr test.
Bruce Momjian [Wed, 17 Sep 1997 20:14:16 +0000 (20:14 +0000)]
Remove extra backets in tr test.

27 years agoLinux seems to have 3/4/5/686.
Bruce Momjian [Tue, 16 Sep 1997 18:51:49 +0000 (18:51 +0000)]
Linux seems to have 3/4/5/686.

27 years agoMakefile cleanup.
Bruce Momjian [Tue, 16 Sep 1997 18:47:36 +0000 (18:47 +0000)]
Makefile cleanup.

27 years agoMklinux patch from Tatsuo.
Bruce Momjian [Tue, 16 Sep 1997 16:25:28 +0000 (16:25 +0000)]
Mklinux patch from Tatsuo.

27 years agoModify to match current expected output
Thomas G. Lockhart [Tue, 16 Sep 1997 16:17:19 +0000 (16:17 +0000)]
Modify to match current expected output
 after adding separate sections for DEFAULT and CHECK.

27 years agoAdd explicit, separate test sections for DEFAULT and CHECK.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:15:52 +0000 (16:15 +0000)]
Add explicit, separate test sections for DEFAULT and CHECK.
Use conventions common to other regression test input files.
Leave non-temporary files at end of test.

27 years agoRemove extraneous blank lines from error messages.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:13:58 +0000 (16:13 +0000)]
Remove extraneous blank lines from error messages.

27 years agoRemove difftime() calls.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:12:55 +0000 (16:12 +0000)]
Remove difftime() calls.
 Still uses time_t declarations, but most code will be changed for next release.

27 years agoFix string conversions for operators in DEFAULT and CHECK clauses.
Thomas G. Lockhart [Tue, 16 Sep 1997 16:11:20 +0000 (16:11 +0000)]
Fix string conversions for operators in DEFAULT and CHECK clauses.

27 years agoRemove uint32 from inet_aton file.
Bruce Momjian [Tue, 16 Sep 1997 16:09:59 +0000 (16:09 +0000)]
Remove uint32 from inet_aton file.

27 years agoRemoved un-needed signal suff from pginterface.
Bruce Momjian [Tue, 16 Sep 1997 15:36:09 +0000 (15:36 +0000)]
Removed un-needed signal suff from pginterface.

27 years agoAdd .eo to pgbuiltin.
Bruce Momjian [Tue, 16 Sep 1997 03:01:43 +0000 (03:01 +0000)]
Add .eo to pgbuiltin.

27 years agoRemove NO_MK_LORDER from Solaris.
Bruce Momjian [Tue, 16 Sep 1997 02:53:24 +0000 (02:53 +0000)]
Remove NO_MK_LORDER from Solaris.

27 years agoManual cleanup for textcat.
Bruce Momjian [Tue, 16 Sep 1997 02:49:23 +0000 (02:49 +0000)]
Manual cleanup for textcat.

27 years agoFix pfree problem.
Vadim B. Mikheev [Mon, 15 Sep 1997 14:29:01 +0000 (14:29 +0000)]
Fix pfree problem.

27 years ago-S need in optarg...
Vadim B. Mikheev [Mon, 15 Sep 1997 14:28:16 +0000 (14:28 +0000)]
-S need in optarg...