Submitted by: darcy@druid.druid.com (D'Arcy J.M. Cain)

Submitted by: Bruce

Fix Submitted by: Bryan himself :)

Suggested/Submitted by: darcy@druid.druid.com
Cleaner Method Submitted by: Bryan Henderson <bryanh@giraffe.netgate.net>

To: Bryan Henderson <bryanh@giraffe.netgate.net>
Cc: Postgres95-development <pg95-dev@ki.net>
Subject: Re: [PG95-DEV] DELETE statement

>
> Does the man page for DELETE need to be corrected?  It gives as syntax
>
>   DELETE instance_variable [FROM fromlist] [WHERE qual]   .
>
> But the actual syntax appears to be
>
>   DELETE FROM classname WHERE qual   .
>
> --
> Bryan Henderson                                    Phone 408-227-6803
> San Jose, California
>

This patch fixes the delete manual page in 2.0:

To: Postgres95-development <pg95-dev@ki.net>
Subject: [PG95-DEV] postgres.h patch

This removes the parameters from the func_ptr prototype in postgres.h in
2.0.

To: Postgres95-development <pg95-dev@ki.net>
Subject: [PG95-DEV] Makefile.global patch

Can we apply the following patch to make EUROPEAN_DATES consistent with
other parameters?

From: Bruce Momjian <maillist@candle.pha.pa.us>
To: Postgres95-development <pg95-dev@ki.net>
Subject: [PG95-DEV] 2.0 patch for fastgetattr

./utils/adt/varlena.c
- --- ../../../orig/postgres95/src/backend/utils/adt/varlena.c    Mon Jul 22
23:56:04 1996
+++ ./utils/adt/varlena.c       Tue Sep 17 15:12:55 1996
@@ -166,7 +166,7 @@

     if (inputText == NULL)
        return(NULL);
- -    len = strlen(inputText) + VARHDRSZ;
+    len = strlen(inputText) + VARHDRSZ + 1 /* terminating 0 */;
     result = (struct varlena *) palloc(len);
     VARSIZE(result) = len;
     memmove(VARDATA(result), inputText, len - VARHDRSZ);


Submitted by: skimo@breughel.ufsia.ac.be (Sven Verdoolaege)

./libpq/be-fsstubs.c
- --- ../../../orig/postgres95/src/backend/libpq/be-fsstubs.c     Tue Jul  9
08:21:30 1996
+++ ./libpq/be-fsstubs.c        Tue Sep 17 15:30:09 1996
@@ -241,7 +241,7 @@
      */
     fd = open(VARDATA(filename), O_RDONLY, 0666);
     if (fd < 0)  {   /* error */
- -       elog(WARN, "lo_import: can't open unix file\"%s\"\n", filename);
+       elog(WARN, "lo_import: can't open unix file \"%s\"\n",
VARDATA(filename));
     }

     /*


Submited by: skimo@breughel.ufsia.ac.be (Sven Verdoolaege)

way one creates a database system.  Parts that were in "make install"
are not either in "make all" or initdb.  Nothing goes in the PGDATA
directory besides user data.  Creating multiple database systems is
easier.

In addition to applying the patch, it is necessary to move the file
libpq/pg_hba to backend/libpq/pg_hba.sample.

Submitted by: Bryan Henderson <bryanh@giraffe.netgate.net>

--- src/backend/storage/file/fd.c       Thu Sep 12 17:23:38 1996
***************
*** 262,268 ****
      Delete(file);

      /* save the seek position */
!     fileP->seekPos = lseek(fileP->fd, 0L, SEEK_CUR);
      Assert( fileP->seekPos != -1);

      /* if we have written to the file, sync it */
--- 262,268 ----
      Delete(file);

      /* save the seek position */
!     fileP->seekPos = (long) lseek(fileP->fd, 0L, SEEK_CUR);
      Assert( fileP->seekPos != -1);

      /* if we have written to the file, sync it */


Submitted by: Randy Terbush <randy@zyzzyva.com>

Pointed out by Bruce

|regex stuff on Linux.
|
|--
|Bryan Henderson                                    Phone 408-227-6803
|San Jose, California
|

|with gram.c and parser.h.
|
|--
|Bryan Henderson                                    Phone 408-227-6803
|San Jose, California
|

Originally submitted by: ernst.molitor@uni-bonn.de
resubmitted by: D'Arcy Cain

ppl are seeing with v2.0

In my cvs source tree, tihs directory existed, which is why it compiled
on my system, but nobody elses...

Submitted by:  Cees de Groot <C.deGroot@inter.nl.net>

Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>

Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>

Submitted by: Bruce Momjian <maillist@candle.pha.pa.us>

of the array constants and in one of the loadable modules I posted some time
ago.

Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>

Submitted by: darcy@druid.druid.com (D'Arcy J.M. Cain)

Submitted by: darcy@druid.druid.com (D'Arcy J.M. Cain)

  - Added the header access/heapam.h.
  - Changed all instances of "length" to "data_length" to quiet
    the compiler.
  - initialized a few variables.  The compiler couldn't see that
    the code guaranteed that these would be initialized before
    being dereferenced.  If anyone wants to check my work follow
    the usage of these variables and make sure that this true
    and wasn't actually a bug in the original code.
  - added a missing break statement to a default case.  This
    was a benign error but bad style.
  - layed out heap_sysattrlen differently.  I think this way
    makes the structure of the code crystal clear.  There should
    be no actual difference in the actual behaviour of the code.

Submitted by: darcy@druid.druid.com (D'Arcy J.M. Cain)

Submitted by:  darcy@druid.druid.com (D'Arcy J.M. Cain)

Submitted by:  Massimo Dal Zotto <dz@cs.unitn.it>

Submitted by: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>

Submitted by: D'Arcy Cain

NOTE: Makefile.custom is commented out, since it isn't there by default.
      If you read the section telling you about it to know to create it,
      you can uncomment it while you are there ...

current state of development...namely, we are on 2.0

NOTE:

BTW, the is also a check in postmaster which won't let you use an older
version of the database by checking the version number. The version number
of a database is in data/PG_VERSION (a plain ASCII file).

				- Andrew

all the calls with strdup.

Submitted by: darcy@druid.druid.com (D'Arcy J.M. Cain)

attributes as tcl arrays.  The previous code had problems with some chars
used as delimiter by Tcl.  The new code should be more robust.

By: Massimo Dal Zotto <dz@cs.unitn.it>

Async notifies received while a backend is in the middle of a begin/end
transaction block are lost by libpq when the final end command is issued.

The bug is in the routine PQexec of libpq. The routine throws away any
message from the backend when a message of type 'C' is received. This
type of message is sent when the result of a portal query command with
no tuples is returned. Unfortunately this is the case of the end command.
As all async notification are sent only when the transaction is finished,
if they are received in the middle of a transaction they are lost in the
libpq library. I added some tracing code to PQexec and this is the output:

Submitted by: Massimo Dal Zotto <dz@cs.unitn.it>