OSDN Git Service

pg-rex/syncrep.git
26 years agoFix for psort temp file names, from Vadim.
Bruce Momjian [Fri, 26 Sep 1997 20:05:47 +0000 (20:05 +0000)]
Fix for psort temp file names, from Vadim.

26 years agoInclude information on new DEFAULT and CONSTRAINT clauses.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:21:27 +0000 (15:21 +0000)]
Include information on new DEFAULT and CONSTRAINT clauses.

26 years agoInclude references to other "drop" man pages.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:20:12 +0000 (15:20 +0000)]
Include references to other "drop" man pages.

26 years agoInitial docs for Vadim's new trigger capabilities.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:13:09 +0000 (15:13 +0000)]
Initial docs for Vadim's new trigger capabilities.

26 years agoFix SUBSTRING(str FROM int TO int) parsing.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:09:11 +0000 (15:09 +0000)]
Fix SUBSTRING(str FROM int TO int) parsing.

26 years agoScripts to run queries and data.
Vadim B. Mikheev [Fri, 26 Sep 1997 14:57:36 +0000 (14:57 +0000)]
Scripts to run queries and data.

26 years agoSome results.
Vadim B. Mikheev [Fri, 26 Sep 1997 14:55:44 +0000 (14:55 +0000)]
Some results.

26 years agoStart with performance suite.
Vadim B. Mikheev [Fri, 26 Sep 1997 14:55:21 +0000 (14:55 +0000)]
Start with performance suite.

26 years agoReturn error if char *query is null in SPI_prepare()
Vadim B. Mikheev [Fri, 26 Sep 1997 13:57:39 +0000 (13:57 +0000)]
Return error if char *query is null in SPI_prepare()

26 years agoGet these two files finally committed for Peter...sorry for delay :(
Marc G. Fournier [Fri, 26 Sep 1997 08:22:21 +0000 (08:22 +0000)]
Get these two files finally committed for Peter...sorry for delay :(

26 years ago*** empty log message ***
Edmund Mergl [Thu, 25 Sep 1997 21:15:04 +0000 (21:15 +0000)]
*** empty log message ***

26 years agoBack out inclusion of postgres.h.
Bruce Momjian [Thu, 25 Sep 1997 16:52:23 +0000 (16:52 +0000)]
Back out inclusion of postgres.h.

26 years agoMassive examples fix from Nicola Bernardelli
Bruce Momjian [Thu, 25 Sep 1997 16:35:52 +0000 (16:35 +0000)]
Massive examples fix from Nicola Bernardelli

26 years agoFix for libpgtcl from Constantin Teodorescu.
Bruce Momjian [Thu, 25 Sep 1997 15:48:51 +0000 (15:48 +0000)]
Fix for libpgtcl from Constantin Teodorescu.

26 years agoTatsuo's patch to fix alignment problems in structure for RISC machines.
Thomas G. Lockhart [Thu, 25 Sep 1997 14:11:42 +0000 (14:11 +0000)]
Tatsuo's patch to fix alignment problems in structure for RISC machines.

26 years agoOne more change to recover v6.1.1 escaped-text input behavior.
Thomas G. Lockhart [Thu, 25 Sep 1997 14:10:23 +0000 (14:10 +0000)]
One more change to recover v6.1.1 escaped-text input behavior.
Should be changed for v6.3!

26 years agoDisable checking for zero or one points with deeper parens on input.
Thomas G. Lockhart [Thu, 25 Sep 1997 14:09:04 +0000 (14:09 +0000)]
Disable checking for zero or one points with deeper parens on input.
 Polygon input would not accept single-point polygon output and dump.

26 years agoFix handling of functions with non-attribute first argument in WHERE
Vadim B. Mikheev [Thu, 25 Sep 1997 12:48:15 +0000 (12:48 +0000)]
Fix handling of functions with non-attribute first argument in WHERE
clauses.

26 years agoFix GROUP BY when order of entries is different from order in target list.
Vadim B. Mikheev [Thu, 25 Sep 1997 12:21:15 +0000 (12:21 +0000)]
Fix GROUP BY when order of entries is different from order in target list.

26 years agoFix handling of SPI_tuptable.
Vadim B. Mikheev [Thu, 25 Sep 1997 12:16:05 +0000 (12:16 +0000)]
Fix handling  of SPI_tuptable.

26 years agoS_LOCK_FREE fix.
Bruce Momjian [Thu, 25 Sep 1997 01:48:58 +0000 (01:48 +0000)]
S_LOCK_FREE fix.

26 years agoFix for S_FREE_LOCK.
Bruce Momjian [Wed, 24 Sep 1997 23:37:26 +0000 (23:37 +0000)]
Fix for S_FREE_LOCK.

26 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.

26 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.

26 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.

26 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.

26 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.

26 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.

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

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

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

26 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.

26 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.

26 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

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

26 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.

26 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()

26 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

26 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.

26 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

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

26 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.

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

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

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

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

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

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

26 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.

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

26 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)

26 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.

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

26 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.

26 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.

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

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

26 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.

26 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.

26 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.

26 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.

26 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.

26 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.

26 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.

26 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.

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

26 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.

26 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.

26 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).

26 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.

26 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.

26 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.

26 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.

26 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.

26 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 :(

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

26 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.

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

26 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.

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

26 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.

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

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

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

26 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

26 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)

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

26 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!

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

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

26 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.

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

26 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()

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

26 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!

26 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)

26 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)

26 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.

26 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.

26 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.