]> granicus.if.org Git - postgresql/log
postgresql
27 years ago+ ExecConstraints ()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:39:33 +0000 (14:39 +0000)]
+ ExecConstraints ()

27 years agoRestore CONSTRAINT keyword (was lost ... by unknown way)
Vadim B. Mikheev [Fri, 22 Aug 1997 14:33:21 +0000 (14:33 +0000)]
Restore CONSTRAINT keyword (was lost ... by unknown way)

27 years ago+ ExecConstraints()
Vadim B. Mikheev [Fri, 22 Aug 1997 14:28:20 +0000 (14:28 +0000)]
+ ExecConstraints()

27 years agoTurn constraints off for sequences & views
Vadim B. Mikheev [Fri, 22 Aug 1997 14:22:14 +0000 (14:22 +0000)]
Turn constraints off for sequences & views
elog(WARN,"ADD ATTRIBUTE: DEFAULT is not implemented, yet");
Call ExecConstraints in CopyFrom

27 years agoRemove DEFAULT/CHECK infos from catalog on DROP TABLE
Vadim B. Mikheev [Fri, 22 Aug 1997 14:10:26 +0000 (14:10 +0000)]
Remove DEFAULT/CHECK infos from catalog on DROP TABLE
Store CHECK infos on CREATE TABLE

27 years agoWe store Cash/money as int of size 4, so make it an int rather than a long.
Bruce Momjian [Fri, 22 Aug 1997 07:13:01 +0000 (07:13 +0000)]
We store Cash/money as int of size 4, so make it an int rather than a long.

27 years agoFix for psql pager when no tty, cleanup for vacuum attdisbursion type.
Bruce Momjian [Fri, 22 Aug 1997 04:13:18 +0000 (04:13 +0000)]
Fix for psql pager when no tty, cleanup for vacuum attdisbursion type.

27 years agoConstraintDef changed
Vadim B. Mikheev [Fri, 22 Aug 1997 04:05:27 +0000 (04:05 +0000)]
ConstraintDef changed

27 years agoSet attbyval for attdisbursion to FALSE
Vadim B. Mikheev [Fri, 22 Aug 1997 04:04:19 +0000 (04:04 +0000)]
Set attbyval for attdisbursion to FALSE
Set atttype for relchecks to 21 (int2)
Set relkind for pg_attrdef & pg_relcheck to 'n'

27 years ago+ CreateTupleDescCopyConstr
Vadim B. Mikheev [Fri, 22 Aug 1997 03:55:39 +0000 (03:55 +0000)]
+ CreateTupleDescCopyConstr
+ FreeTupleDesc

27 years agoFetch information about DEFAULT/CHECK while openning a relation.
Vadim B. Mikheev [Fri, 22 Aug 1997 03:35:44 +0000 (03:35 +0000)]
Fetch information about DEFAULT/CHECK while openning a relation.

27 years agoThere is no NULL constraint in CREATE TABLE - only NOT NULL one.
Vadim B. Mikheev [Fri, 22 Aug 1997 03:17:55 +0000 (03:17 +0000)]
There is no NULL constraint in CREATE TABLE - only NOT NULL one.

27 years agoDEFAULT handling
Vadim B. Mikheev [Fri, 22 Aug 1997 03:12:19 +0000 (03:12 +0000)]
DEFAULT handling
Use  for 'selct .. into ..' copy of TupleDesc (without constraints)
#ifdef NOT_USED for resetVarAttrLenForCreateTable (just free tupdesc copy)

27 years agoDefineRelation: DEFAULT/CHECK handling
Vadim B. Mikheev [Fri, 22 Aug 1997 03:03:56 +0000 (03:03 +0000)]
DefineRelation: DEFAULT/CHECK handling

27 years agoStore attr DEFAULT info in heap_create
Vadim B. Mikheev [Fri, 22 Aug 1997 02:58:51 +0000 (02:58 +0000)]
Store attr DEFAULT info in heap_create

27 years agoCreateTupleDescCopy don't copy constraints now!
Vadim B. Mikheev [Fri, 22 Aug 1997 02:55:39 +0000 (02:55 +0000)]
CreateTupleDescCopy don't copy constraints now!
+ CreateTupleDescCopyConstr to copy them too.
+ FreeTupleDesc

27 years agoMake psql use pager only when it has a tty.
Bruce Momjian [Fri, 22 Aug 1997 00:17:26 +0000 (00:17 +0000)]
Make psql use pager only when it has a tty.

27 years agoAllow functions and operators on internally-identical types to succeed.
Bruce Momjian [Fri, 22 Aug 1997 00:02:19 +0000 (00:02 +0000)]
Allow functions and operators on internally-identical types to succeed.

27 years agoChange time function names to be more consistent, and check for zero divides, from...
Bruce Momjian [Thu, 21 Aug 1997 23:57:00 +0000 (23:57 +0000)]
Change time function names to be more consistent, and check for zero divides, from Michael Reifenberg.

27 years agoName change cleanup.
Bruce Momjian [Thu, 21 Aug 1997 14:33:05 +0000 (14:33 +0000)]
Name change cleanup.

27 years agoRemove unused spin function when no spinlocks.
Bruce Momjian [Thu, 21 Aug 1997 13:43:46 +0000 (13:43 +0000)]
Remove unused spin function when no spinlocks.

27 years ago#definitions for pg_attrdef & pg_relcheck names
Vadim B. Mikheev [Thu, 21 Aug 1997 04:33:20 +0000 (04:33 +0000)]
#definitions for pg_attrdef & pg_relcheck names

27 years agoAttrConstr --> TupleConstr
Vadim B. Mikheev [Thu, 21 Aug 1997 04:10:25 +0000 (04:10 +0000)]
AttrConstr --> TupleConstr

27 years agoRename pg_attribute.attnvals to attdisbursion.
Bruce Momjian [Thu, 21 Aug 1997 03:02:13 +0000 (03:02 +0000)]
Rename pg_attribute.attnvals to attdisbursion.

27 years agoChange pg_attribute.attnvals to float4, change #ifdef 0 to #if 0, fix aix call to...
Bruce Momjian [Thu, 21 Aug 1997 02:28:55 +0000 (02:28 +0000)]
Change pg_attribute.attnvals to float4, change #ifdef 0 to #if 0, fix aix call to strNcpy, fix pg_super_user_id in pg_dumpall, change pg_database.dtadba from oid to int4.

27 years ago+ extern double *box_area(BOX *box);
Vadim B. Mikheev [Thu, 21 Aug 1997 01:40:30 +0000 (01:40 +0000)]
+ extern double *box_area(BOX *box);

27 years ago+ struct ConstaintDef - for constraints.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:39:25 +0000 (01:39 +0000)]
+ struct ConstaintDef - for constraints.

27 years agoNew system relations to store DEFAULT/CHECK expressions.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:37:55 +0000 (01:37 +0000)]
New system relations to store DEFAULT/CHECK expressions.

27 years agoRead info for DEFAULT from pg_attrdef.
Vadim B. Mikheev [Thu, 21 Aug 1997 01:36:09 +0000 (01:36 +0000)]
Read info for DEFAULT from pg_attrdef.

27 years agoSyntax for [CONSTRAINT name] CHECK ...
Vadim B. Mikheev [Thu, 21 Aug 1997 01:34:44 +0000 (01:34 +0000)]
Syntax for [CONSTRAINT name] CHECK ...

27 years agoGet rid of attproc, atttyparg, attcanindex, attdefrel, attbound
Vadim B. Mikheev [Thu, 21 Aug 1997 01:32:19 +0000 (01:32 +0000)]
Get rid of attproc, atttyparg, attcanindex, attdefrel, attbound
from pg_attribute. atthasdef added.

27 years agoPortability fix for pg_dumpall.
Bruce Momjian [Wed, 20 Aug 1997 15:06:48 +0000 (15:06 +0000)]
Portability fix for pg_dumpall.

27 years agoMore NOT_USEDs
Bruce Momjian [Wed, 20 Aug 1997 14:54:35 +0000 (14:54 +0000)]
More NOT_USEDs

27 years agoAdd static finding script.
Bruce Momjian [Wed, 20 Aug 1997 02:10:47 +0000 (02:10 +0000)]
Add static finding script.

27 years agoHTNegate/HTCommute/HTNegateCommute are not used.
Vadim B. Mikheev [Wed, 20 Aug 1997 02:01:42 +0000 (02:01 +0000)]
HTNegate/HTCommute/HTNegateCommute are not used.

27 years agoCHECK/DEFAULT syntax (some tricks to get current scan position).
Vadim B. Mikheev [Wed, 20 Aug 1997 01:50:06 +0000 (01:50 +0000)]
CHECK/DEFAULT syntax (some tricks to get current scan position).

27 years agoCHECK/DEFAULT syntax
Vadim B. Mikheev [Wed, 20 Aug 1997 01:12:38 +0000 (01:12 +0000)]
CHECK/DEFAULT syntax

27 years agoChanges for Digital Unix
Marc G. Fournier [Wed, 20 Aug 1997 00:50:11 +0000 (00:50 +0000)]
Changes for Digital Unix

27 years agoFix for sunos4 difftime() call.
Bruce Momjian [Tue, 19 Aug 1997 21:47:07 +0000 (21:47 +0000)]
Fix for sunos4 difftime() call.

27 years agoMake functions static where possible, enclose unused functions in #ifdef NOT_USED.
Bruce Momjian [Tue, 19 Aug 1997 21:40:56 +0000 (21:40 +0000)]
Make functions static where possible, enclose unused functions in #ifdef NOT_USED.

27 years agoNOT NULL implementation (submitted by Robson Paniago de Miranda).
Vadim B. Mikheev [Tue, 19 Aug 1997 04:46:15 +0000 (04:46 +0000)]
NOT NULL implementation (submitted by Robson Paniago de Miranda).

27 years agoNow that names are null terminated, no need to do all that NAMEDATALEN stuff.
Bruce Momjian [Mon, 18 Aug 1997 20:53:48 +0000 (20:53 +0000)]
Now that names are null terminated, no need to do all that NAMEDATALEN stuff.

27 years agoReduce open() calls. Replace fopen() calls with calls to fd.c functions.
Bruce Momjian [Mon, 18 Aug 1997 02:15:04 +0000 (02:15 +0000)]
Reduce open() calls.  Replace fopen() calls with calls to fd.c functions.

27 years agoFixes for alphalinux port by abrams@philos.umass.edu
Marc G. Fournier [Sun, 17 Aug 1997 02:40:00 +0000 (02:40 +0000)]
Fixes for alphalinux port by abrams@philos.umass.edu

27 years agoChanges so that it actually checks for <readline/history.h>, instead
Marc G. Fournier [Sun, 17 Aug 1997 00:48:51 +0000 (00:48 +0000)]
Changes so that it actually checks for <readline/history.h>, instead
of assuming it does exist

27 years agoMake sure that LIBPQDIR points to the right directory
Marc G. Fournier [Sun, 17 Aug 1997 00:39:02 +0000 (00:39 +0000)]
Make sure that LIBPQDIR points to the right directory

27 years agoFix up paths to $(SRCDIR)
Marc G. Fournier [Sun, 17 Aug 1997 00:33:28 +0000 (00:33 +0000)]
Fix up paths to $(SRCDIR)

27 years agoAdd appropriate links into the interfaces directory, as well as a Makefile
Marc G. Fournier [Sat, 16 Aug 1997 20:56:28 +0000 (20:56 +0000)]
Add appropriate links into the interfaces directory, as well as a Makefile
covering the interfaces directory

27 years agoBring in Adrian's JDBC driver as an interface
Marc G. Fournier [Sat, 16 Aug 1997 20:51:53 +0000 (20:51 +0000)]
Bring in Adrian's JDBC driver as an interface

27 years agoCleanup global variables, remove stable memory stuff.
Bruce Momjian [Thu, 14 Aug 1997 16:11:41 +0000 (16:11 +0000)]
Cleanup global variables, remove stable memory stuff.

27 years agosprintf "...%d...", ... (int)getpid(), ...
Vadim B. Mikheev [Thu, 14 Aug 1997 05:04:38 +0000 (05:04 +0000)]
sprintf "...%d...", ... (int)getpid(), ...
                        ^^^^^

27 years ago_hash_checkpage: cleanup for CASSERT
Vadim B. Mikheev [Thu, 14 Aug 1997 05:01:32 +0000 (05:01 +0000)]
_hash_checkpage: cleanup for CASSERT

27 years agoThese changes allow the module to compile quietly when assert checking is
Bruce Momjian [Tue, 12 Aug 1997 23:03:50 +0000 (23:03 +0000)]
These changes allow the module to compile quietly when assert checking is
not being done.

27 years agoRemove more (void) and fix -Wall warnings.
Bruce Momjian [Tue, 12 Aug 1997 22:55:25 +0000 (22:55 +0000)]
Remove more (void) and fix -Wall warnings.

27 years agocleanup of patch
Bruce Momjian [Tue, 12 Aug 1997 20:39:16 +0000 (20:39 +0000)]
cleanup of patch

27 years agoFix pgproc names over 15 chars in output. Add strNcpy() function. remove some ...
Bruce Momjian [Tue, 12 Aug 1997 20:16:25 +0000 (20:16 +0000)]
Fix pgproc names over 15 chars in output.  Add strNcpy() function.  remove some (void) casts that are unnecessary.

27 years agoAdd bsdi gcc2 options.
Bruce Momjian [Fri, 8 Aug 1997 03:51:33 +0000 (03:51 +0000)]
Add bsdi gcc2 options.

27 years agoFix for psort again.
Bruce Momjian [Wed, 6 Aug 1997 17:11:20 +0000 (17:11 +0000)]
Fix for psort again.

27 years agoAnother psort fix.
Bruce Momjian [Wed, 6 Aug 1997 07:39:20 +0000 (07:39 +0000)]
Another psort fix.

27 years agoI think I finally got psort working for all cases.
Bruce Momjian [Wed, 6 Aug 1997 07:02:49 +0000 (07:02 +0000)]
I think I finally got psort working for all cases.

27 years agopsort cleanups.
Bruce Momjian [Wed, 6 Aug 1997 05:38:46 +0000 (05:38 +0000)]
psort cleanups.

27 years agoAnother fix.
Bruce Momjian [Wed, 6 Aug 1997 05:08:37 +0000 (05:08 +0000)]
Another fix.

27 years agoFix for palloc(0) in new code
Bruce Momjian [Wed, 6 Aug 1997 04:45:39 +0000 (04:45 +0000)]
Fix for palloc(0) in new code

27 years agoAllow internal sorts to be stored in memory rather than in files.
Bruce Momjian [Wed, 6 Aug 1997 03:42:21 +0000 (03:42 +0000)]
Allow internal sorts to be stored in memory rather than in files.

27 years agoAdd developers help file.
Bruce Momjian [Wed, 6 Aug 1997 03:37:34 +0000 (03:37 +0000)]
Add developers help file.

27 years agoFix for os version handling.
Bruce Momjian [Wed, 6 Aug 1997 03:33:45 +0000 (03:33 +0000)]
Fix for os version handling.

27 years agoCatch non-functional delete attempts.
Vadim B. Mikheev [Wed, 6 Aug 1997 02:08:39 +0000 (02:08 +0000)]
Catch non-functional delete attempts.

27 years agoCleanup for NAMEDATALEN use.
Bruce Momjian [Sun, 3 Aug 1997 02:38:47 +0000 (02:38 +0000)]
Cleanup for NAMEDATALEN use.

27 years agoComment out code that makes no sense, and Purify complains about.
Bruce Momjian [Sun, 3 Aug 1997 02:28:10 +0000 (02:28 +0000)]
Comment out code that makes no sense, and Purify complains about.

27 years agoPrevent relname unallocated string length from being copied into database.
Bruce Momjian [Sat, 2 Aug 1997 19:09:33 +0000 (19:09 +0000)]
Prevent relname unallocated string length from being copied into database.

27 years agoMakei configure less os-version specific, were possible.
Bruce Momjian [Sat, 2 Aug 1997 16:32:51 +0000 (16:32 +0000)]
Makei configure less os-version specific, were possible.

27 years agoFix stout/stderr paging. Do not page \h select, but page \h *.
Bruce Momjian [Fri, 1 Aug 1997 04:07:55 +0000 (04:07 +0000)]
Fix stout/stderr paging.  Do not page \h select, but page \h *.

27 years agoFIx solaris template finding.
Bruce Momjian [Fri, 1 Aug 1997 03:49:22 +0000 (03:49 +0000)]
FIx solaris template finding.

27 years agoFix psql error output.
Bruce Momjian [Fri, 1 Aug 1997 03:33:02 +0000 (03:33 +0000)]
Fix psql error output.

27 years agoConfigure cleanup for /usr/ucb patch.
Bruce Momjian [Thu, 31 Jul 1997 01:37:56 +0000 (01:37 +0000)]
Configure cleanup for /usr/ucb patch.

27 years agoLook in /usr/ucb first for install.
Bruce Momjian [Wed, 30 Jul 1997 19:16:23 +0000 (19:16 +0000)]
Look in /usr/ucb first for install.

27 years agoconfigure.in cleanup for tr and strerror2.
Bruce Momjian [Wed, 30 Jul 1997 18:27:18 +0000 (18:27 +0000)]
configure.in cleanup for tr and strerror2.

27 years agoAdd -o to psql manual page.
Bruce Momjian [Wed, 30 Jul 1997 17:21:29 +0000 (17:21 +0000)]
Add -o to psql manual page.

27 years agoFix c++ copy example code.
Bruce Momjian [Wed, 30 Jul 1997 15:53:57 +0000 (15:53 +0000)]
Fix c++ copy example code.

27 years agoRemove restart instructions from INSTALL.
Bruce Momjian [Wed, 30 Jul 1997 14:55:20 +0000 (14:55 +0000)]
Remove restart instructions from INSTALL.

27 years agoDue to BIND 8.1.1, my Solaris 2.5.1 machine doesn't define MAXHOSTNAMELEN...
Marc G. Fournier [Wed, 30 Jul 1997 14:08:11 +0000 (14:08 +0000)]
Due to BIND 8.1.1, my Solaris 2.5.1 machine doesn't define MAXHOSTNAMELEN...
so, add a check that basically says if it isn't defined, set it to 256...

27 years agoCheck for and use <netdb.h> for postmaster.c, instead of checking if
Marc G. Fournier [Wed, 30 Jul 1997 14:03:33 +0000 (14:03 +0000)]
Check for and use <netdb.h> for postmaster.c, instead of checking if
MAXHOSTNAMELEN is defined.  For some reason, my 2.5.1 Solaris box at
work fails on that check...

27 years agoAllow use parameters in target list having aggregates in functions.
Vadim B. Mikheev [Wed, 30 Jul 1997 04:42:26 +0000 (04:42 +0000)]
Allow use parameters in target list having aggregates in functions.

27 years agoconfigure.in cleanup from sco install.
Bruce Momjian [Wed, 30 Jul 1997 01:32:44 +0000 (01:32 +0000)]
configure.in cleanup from sco install.

27 years agoRemove HAVE_USAGE because it is no longer used.
Bruce Momjian [Wed, 30 Jul 1997 00:09:42 +0000 (00:09 +0000)]
Remove HAVE_USAGE because it is no longer used.

27 years agoUpdate COPY manual page to remove unneeded warnings.
Bruce Momjian [Tue, 29 Jul 1997 21:43:40 +0000 (21:43 +0000)]
Update COPY manual page to remove unneeded warnings.

27 years agoUpdate configure after sunos4 update.
Bruce Momjian [Tue, 29 Jul 1997 21:16:52 +0000 (21:16 +0000)]
Update configure after sunos4 update.

27 years agoAdd strerror to pg_version for sunos4.
Bruce Momjian [Tue, 29 Jul 1997 16:36:43 +0000 (16:36 +0000)]
Add strerror to pg_version for sunos4.

27 years agoResults from initial changes to add new functions and for bug fixes.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:24:04 +0000 (16:24 +0000)]
Results from initial changes to add new functions and for bug fixes.
Not all cleaned up yet.

27 years agoStart adding tests for new geometry functions.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:22:48 +0000 (16:22 +0000)]
Start adding tests for new geometry functions.
Not all cleaned up yet.

27 years agoUse better routines from geometry library.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:21:12 +0000 (16:21 +0000)]
Use better routines from geometry library.

27 years agoChange call definition for isreltime().
Thomas G. Lockhart [Tue, 29 Jul 1997 16:19:26 +0000 (16:19 +0000)]
Change call definition for isreltime().

27 years agoAdd new operators and functions for geometric types.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:17:52 +0000 (16:17 +0000)]
Add new operators and functions for geometric types.
Add text concatenation operator and function.
Add text trim function for SQL92 support.

27 years agoAdd new routines.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:16:14 +0000 (16:16 +0000)]
Add new routines.
Change definition for isreltime().
Change some names of #define constants to avoid conflicts with the yacc parser.

27 years agoRemove some unnecessary include statements (comment out with #ifdef FALSE).
Thomas G. Lockhart [Tue, 29 Jul 1997 16:14:40 +0000 (16:14 +0000)]
Remove some unnecessary include statements (comment out with #ifdef FALSE).

27 years agoAdd routines for text trimming on both ends, substring, and string position.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:12:07 +0000 (16:12 +0000)]
Add routines for text trimming on both ends, substring, and string position.
Used to support SQL92 compatibility.

27 years agoFix bug to allow hh:mm:ss time entry for timespan/reltime types.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:09:38 +0000 (16:09 +0000)]
Fix bug to allow hh:mm:ss time entry for timespan/reltime types.

27 years agoRemove #ifdef'd support for old i/o styles.
Thomas G. Lockhart [Tue, 29 Jul 1997 16:08:18 +0000 (16:08 +0000)]
Remove #ifdef'd support for old i/o styles.
Change box terminology from "length" to "width".
 Use length terminology in common with other geometric types (usually perimeter).
Fix bugs in line arithmetic which resulted in bad intersection calculations.
Deprecate temporary unstored slope fields.
Check explicitly for intersections at endpoints to avoid rounding ugliness.
Add center() routines for lseg, path, polygon.
Add distance() routines for circle-polygon, polygon-polygon.
Check explicitly for points and polygons contained within polygons
 using an axis-crossing algorithm. (Old code just checked bounding boxes).
Add routine to convert circle-box.
*whew*

27 years agoUpdate some reltime code to use new common routines.
Thomas G. Lockhart [Tue, 29 Jul 1997 15:54:49 +0000 (15:54 +0000)]
Update some reltime code to use new common routines.
Use standard decoder for isreltime().

27 years agoAdd debugging statements.
Thomas G. Lockhart [Tue, 29 Jul 1997 15:51:33 +0000 (15:51 +0000)]
Add debugging statements.