OSDN Git Service
Bruce Momjian [Fri, 26 Sep 1997 20:05:47 +0000 (20:05 +0000)]
Fix for psort temp file names, from Vadim.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:21:27 +0000 (15:21 +0000)]
Include information on new DEFAULT and CONSTRAINT clauses.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:20:12 +0000 (15:20 +0000)]
Include references to other "drop" man pages.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:13:09 +0000 (15:13 +0000)]
Initial docs for Vadim's new trigger capabilities.
Thomas G. Lockhart [Fri, 26 Sep 1997 15:09:11 +0000 (15:09 +0000)]
Fix SUBSTRING(str FROM int TO int) parsing.
Vadim B. Mikheev [Fri, 26 Sep 1997 14:57:36 +0000 (14:57 +0000)]
Scripts to run queries and data.
Vadim B. Mikheev [Fri, 26 Sep 1997 14:55:44 +0000 (14:55 +0000)]
Some results.
Vadim B. Mikheev [Fri, 26 Sep 1997 14:55:21 +0000 (14:55 +0000)]
Start with performance suite.
Vadim B. Mikheev [Fri, 26 Sep 1997 13:57:39 +0000 (13:57 +0000)]
Return error if char *query is null in SPI_prepare()
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 :(
Edmund Mergl [Thu, 25 Sep 1997 21:15:04 +0000 (21:15 +0000)]
*** empty log message ***
Bruce Momjian [Thu, 25 Sep 1997 16:52:23 +0000 (16:52 +0000)]
Back out inclusion of postgres.h.
Bruce Momjian [Thu, 25 Sep 1997 16:35:52 +0000 (16:35 +0000)]
Massive examples fix from Nicola Bernardelli
Bruce Momjian [Thu, 25 Sep 1997 15:48:51 +0000 (15:48 +0000)]
Fix for libpgtcl from Constantin Teodorescu.
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.
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!
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.
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.
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.
Vadim B. Mikheev [Thu, 25 Sep 1997 12:16:05 +0000 (12:16 +0000)]
Fix handling of SPI_tuptable.
Bruce Momjian [Thu, 25 Sep 1997 01:48:58 +0000 (01:48 +0000)]
S_LOCK_FREE fix.
Bruce Momjian [Wed, 24 Sep 1997 23:37:26 +0000 (23:37 +0000)]
Fix for S_FREE_LOCK.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:55:38 +0000 (17:55 +0000)]
Use additional ORDER BY to cope with new sorting routines.
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.
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.
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.
Thomas G. Lockhart [Wed, 24 Sep 1997 17:46:14 +0000 (17:46 +0000)]
Remove debugging "puts" print statement.
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.
Bruce Momjian [Wed, 24 Sep 1997 16:20:04 +0000 (16:20 +0000)]
Fix for pg_dump.
Bruce Momjian [Wed, 24 Sep 1997 15:57:28 +0000 (15:57 +0000)]
Update configure.
Bruce Momjian [Wed, 24 Sep 1997 15:49:46 +0000 (15:49 +0000)]
Remove aix power pc.
Bruce Momjian [Wed, 24 Sep 1997 15:40:59 +0000 (15:40 +0000)]
Remove extra float.h I added.
Bruce Momjian [Wed, 24 Sep 1997 15:36:36 +0000 (15:36 +0000)]
CREATE FUNCTION fixup for types of functions.
Bruce Momjian [Wed, 24 Sep 1997 15:14:02 +0000 (15:14 +0000)]
Rollback changes to pg_dump.c
Vadim B. Mikheev [Wed, 24 Sep 1997 08:36:47 +0000 (08:36 +0000)]
Timetravel tests.
Vadim B. Mikheev [Wed, 24 Sep 1997 08:35:10 +0000 (08:35 +0000)]
Added: ttdummy() - variation of timetravel() function
for regress test.
Vadim B. Mikheev [Wed, 24 Sep 1997 08:32:09 +0000 (08:32 +0000)]
+ SPI_palloc(), SPI_repalloc(), SPI_pfree()
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
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.
Vadim B. Mikheev [Wed, 24 Sep 1997 08:17:14 +0000 (08:17 +0000)]
General trigger functions for time-travel
Bruce Momjian [Wed, 24 Sep 1997 04:20:29 +0000 (04:20 +0000)]
HPUX 10 patch.
Bruce Momjian [Wed, 24 Sep 1997 03:20:54 +0000 (03:20 +0000)]
Add -S to top of manual page.
Bruce Momjian [Tue, 23 Sep 1997 22:53:47 +0000 (22:53 +0000)]
AIX fixes.
Bruce Momjian [Tue, 23 Sep 1997 21:44:07 +0000 (21:44 +0000)]
Fix for CREATE FUNCTION.
Bruce Momjian [Tue, 23 Sep 1997 19:47:59 +0000 (19:47 +0000)]
Fix for backslash quote.
Bruce Momjian [Tue, 23 Sep 1997 17:43:33 +0000 (17:43 +0000)]
AIx patch from Frank Dana.
Bruce Momjian [Tue, 23 Sep 1997 00:02:44 +0000 (00:02 +0000)]
Cleanup.
Bruce Momjian [Mon, 22 Sep 1997 18:14:25 +0000 (18:14 +0000)]
Cleanup backslashes.
Bruce Momjian [Mon, 22 Sep 1997 15:59:19 +0000 (15:59 +0000)]
Fix for missing tas on some platforms.
Bruce Momjian [Mon, 22 Sep 1997 15:49:14 +0000 (15:49 +0000)]
Small lock cleanup for prototype.
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)
Vadim B. Mikheev [Mon, 22 Sep 1997 07:12:33 +0000 (07:12 +0000)]
Blowaway relation buffers from buffer pool before truncation.
Vadim B. Mikheev [Mon, 22 Sep 1997 04:21:51 +0000 (04:21 +0000)]
Two copies...
Vadim B. Mikheev [Mon, 22 Sep 1997 04:20:53 +0000 (04:20 +0000)]
Have to PROC_INCR_SLOCK before return.
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.
Vadim B. Mikheev [Mon, 22 Sep 1997 03:58:32 +0000 (03:58 +0000)]
+#include <access/xact.h>
Bruce Momjian [Sun, 21 Sep 1997 22:54:19 +0000 (22:54 +0000)]
Configure OS cleanup.
Bruce Momjian [Sun, 21 Sep 1997 04:54:36 +0000 (04:54 +0000)]
Make manual page for pg_passwd from README.
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.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:35:34 +0000 (16:35 +0000)]
Output changed to reflect extra entries from new regression tests.
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.
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.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:31:44 +0000 (16:31 +0000)]
Change ORDER BY to get more consistant results.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:29:38 +0000 (16:29 +0000)]
Add tinterval comparison operators.
Add integer/money arithmetic.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:25:28 +0000 (16:25 +0000)]
Add point_ne() comparison routine.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:24:39 +0000 (16:24 +0000)]
Add tinterval comparison routines.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:23:47 +0000 (16:23 +0000)]
Add integer/money arithmetic from Darren King.
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.
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).
Thomas G. Lockhart [Sat, 20 Sep 1997 16:17:45 +0000 (16:17 +0000)]
Include tinterval comparison functions for span of interval.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:15:34 +0000 (16:15 +0000)]
Include functions for integer/money arithmetic.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:14:05 +0000 (16:14 +0000)]
Fix up elog warning messages.
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.
Thomas G. Lockhart [Sat, 20 Sep 1997 16:08:24 +0000 (16:08 +0000)]
Replace missing directory delimiter for postmaster installation command.
Marc G. Fournier [Sat, 20 Sep 1997 02:21:25 +0000 (02:21 +0000)]
Bring in Peter's changes...finally :(
Bruce Momjian [Fri, 19 Sep 1997 22:02:26 +0000 (22:02 +0000)]
Update configure.
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.
Vadim B. Mikheev [Fri, 19 Sep 1997 06:52:49 +0000 (06:52 +0000)]
+ _copyGroup(Group *from)
Bruce Momjian [Fri, 19 Sep 1997 03:42:39 +0000 (03:42 +0000)]
Fix \e and \p after query.
Bruce Momjian [Thu, 18 Sep 1997 20:22:58 +0000 (20:22 +0000)]
Inline memset() as MemSet().
Bruce Momjian [Thu, 18 Sep 1997 19:57:31 +0000 (19:57 +0000)]
Have to do [[ ]] in configure.in.
Bruce Momjian [Thu, 18 Sep 1997 18:48:32 +0000 (18:48 +0000)]
UPdate memset macro.
Bruce Momjian [Thu, 18 Sep 1997 17:17:19 +0000 (17:17 +0000)]
Update HISTORY.
Bruce Momjian [Thu, 18 Sep 1997 17:06:21 +0000 (17:06 +0000)]
Cleanup for memset macro.
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
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)
Vadim B. Mikheev [Thu, 18 Sep 1997 14:42:35 +0000 (14:42 +0000)]
No more SortTuplesInTree...
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!
Vadim B. Mikheev [Thu, 18 Sep 1997 14:33:46 +0000 (14:33 +0000)]
No more SortTuplesInTree...
Vadim B. Mikheev [Thu, 18 Sep 1997 14:32:15 +0000 (14:32 +0000)]
Convert sequence names tolower.
Vadim B. Mikheev [Thu, 18 Sep 1997 14:31:38 +0000 (14:31 +0000)]
ALTER TABLE ADD COLUMN: set atthasdef to FALSE.
Bruce Momjian [Thu, 18 Sep 1997 14:21:02 +0000 (14:21 +0000)]
Inline frequently called functions.
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()
Vadim B. Mikheev [Thu, 18 Sep 1997 05:38:09 +0000 (05:38 +0000)]
+ SortTuplesInTree
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!
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)
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)
Thomas G. Lockhart [Thu, 18 Sep 1997 03:54:19 +0000 (03:54 +0000)]
Add explicit test for various comment syntaxes.
Thomas G. Lockhart [Thu, 18 Sep 1997 03:52:43 +0000 (03:52 +0000)]
Explicitly test various comment syntaxes.
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.