Skip to content

P
Postgres FD Implementation
Switch branch/tag
  1. 22 Apr, 1997 2 commits
    • Marc G. Fournier's avatar
      Major patch from Thomas Lockhart <Thomas.G.Lockhart@jpl.nasa.gov> · 9e2a87b6
      Marc G. Fournier authored 
      OK, here are a passel of patches for the geometric data types.
These add a "circle" data type, new operators and functions
for the existing data types, and change the default formats
for some of the existing types to make them consistant with
each other. Current formatting conventions (e.g. compatible
with v6.0 to allow dump/reload) are supported, but the new
conventions should be an improvement and we can eventually
drop the old conventions entirely.

For example, there are two kinds of paths (connected line segments),
open and closed, and the old format was

'(1,2,1,2,3,4)' for a closed path with two points (1,2) and (3,4)
'(0,2,1,2,3,4)' for an open path with two points (1,2) and (3,4)

Pretty arcane, huh? The new format for paths is

'((1,2),(3,4))' for a closed path with two points (1,2) and (3,4)
'[(1,2),(3,4)]' for an open path with two points (1,2) and (3,4)

For polygons, the old convention is

'(0,4,2,0,4,3)' for a triangle with points at (0,0),(4,4), and (2,3)

and the new convention is

'((0,0),(4,4),(2,3))' for a triangle with points at (0,0),(4,4), and (2,3)

Other data types which are also represented as lists of points
(e.g. boxes, line segments, and polygons) have similar representations
(they surround each point with parens).

For v6.1, any format which can be interpreted as the old style format
is decoded as such; we can remove that backwards compatibility but ugly
convention for v7.0. This will allow dump/reloads from v6.0.

These include some updates to the regression test files to change the test
for creating a data type from "circle" to "widget" to keep the test from
trashing the new builtin circle type.
      9e2a87b6
    • Vadim B. Mikheev's avatar
      Fix for Hash and arrays · 051b4210
      Vadim B. Mikheev authored
      051b4210
  3. 21 Apr, 1997 4 commits
  5. 20 Apr, 1997 1 commit
  7. 18 Apr, 1997 9 commits
  9. 17 Apr, 1997 5 commits
    • Marc G. Fournier's avatar
      From: Raymond Toy <toy@rtp.ericsson.se> · cbaa9883
      Marc G. Fournier authored 
      Subject: [PATCHES] 970417:  some large object patches


Two patches here, made against 970417.  Both have to do with large
objects:

        1.  lobjfuncs was not initialized in PQconnectdb.  This causes
            failure later if large objects are used.  (Someone already
            caught this error in PQsetdb.)

        2.  Postgres functions lo_import and lo_export sometimes
            produce garbage for the file names because the filename
            strings aren't always terminated by \0.  (VARDATA isn't
            necessarily null terminated.)
      cbaa9883
    • Marc G. Fournier's avatar
      From: Raymond Toy <toy@rtp.ericsson.se> · 8834795e
      Marc G. Fournier authored 
      Subject: [PATCHES] 970417:  two more patches for large objects

Here are two more patches:

        1.  pg_getint doesn't properly set the status flag when
            calling pqGetShort or pqGetLong.  This is required when
            accessing large objects via libpq.  This, combined with
            problem 1 above causes postgres to crash when postgres
            tries to print out the message that the status was not
            good.

        2.  ExceptionalCondition crashes when called with detail =
            NULL.  This patch prevents dereferencing the NULL.
      8834795e
    • Marc G. Fournier's avatar
      From: "Martin J. Laubach" <mjl@CSlab.tuwien.ac.at> · a1f229b1
      Marc G. Fournier authored 
      Subject: [HACKERS] Patch: set date to euro/us postgres/iso/sql

  Here a patch that implements a SET date for use by the datetime
stuff. The syntax is

        SET date TO 'val[,val,...]'

  where val is us (us dates), euro (european dates), postgres,
iso or sql.

  Thomas is working on the integration in his datetime module.
I just needed to get the patch out before it went stale :)
      a1f229b1
    • Marc G. Fournier's avatar
      Some slight changes to the Wisconsin Benchmark tests since postgres requires · cfe0d67d
      Marc G. Fournier authored 
      a -D<datadir> option
      cfe0d67d
    • Vadim B. Mikheev's avatar
      The patch fixes a rare bug that may occur when one tries to vacuum a single · a0d63ac9
      Vadim B. Mikheev authored 
      table. The table name is de-allocated by the CommitTransactionCommand()
in vc_init() before it is copied in VacRel.data and sometimes this causes
a SIGSEGV. My patch simply moves the strcpy before vc_init.

Submitted by Massimo Dal Zotto <dz@cs.unitn.it>.
      a0d63ac9
  11. 16 Apr, 1997 5 commits
  13. 15 Apr, 1997 9 commits
  15. 13 Apr, 1997 1 commit
  17. 12 Apr, 1997 4 commits