]> granicus.if.org Git - postgresql/log
postgresql
21 years agoThis is a bug in python interface module,
Bruce Momjian [Wed, 25 Jun 2003 01:09:24 +0000 (01:09 +0000)]
This is a bug in python interface module,
postgresql-7.3.3/src/interfaces/python/pg.py.

_quote() function fails due to integer overflow if input d is larger
than max integer.

In the case where the column type is "BIGINT", the input d may very well
be larger than max integer while its type, t, is labeled 'int'.
The conversion on line 19, return "%d" % int(d), will fail due to
"OverflowError: long int too large to convert to int".

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

[1] create a table with a column type 'BIGINT'.
[2] use pg.DB.insert() to insert a value that is larger than max integer

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

Just changing the conversion at line 19 of pg.py to long(d) instead of
int(d) should fix it. The following is a patch:

Chih-Hao Huang

21 years ago>> If a transaction marks a tuple for update and later commits without
Bruce Momjian [Wed, 25 Jun 2003 01:08:13 +0000 (01:08 +0000)]
>> If a transaction marks a tuple for update and later commits without
>> actually having updated the tuple, [...] can we simply
>> set the HEAP_XMAX_INVALID hint bit of the tuple?
>
>AFAICS this is a reasonable thing to do.

Thanks for the confirmation.  Here's a patch which also contains some
more noncritical changes to tqual.c:
 .  make code more readable by introducing local variables for xvac
 .  no longer two separate branches for aborted and crashed.
    The actions were the same in all cases.

Manfred Koizar

21 years agoMost of the synopsis areas for DROP commands use "name" as the
Bruce Momjian [Tue, 24 Jun 2003 23:29:25 +0000 (23:29 +0000)]
Most of the synopsis areas for DROP commands use "name" as the
identifier, while some areas do not.

The attached converts be below to "name":
conversion_name
index_name

The below have an existing, initdb supplied, entity named "name".  As
such, it could be confusing for the reader to see that identifier used
in the example.

domainname
typename

Rod Taylor

21 years agoRevert ORDBMS change, per Peter.
Bruce Momjian [Tue, 24 Jun 2003 23:27:24 +0000 (23:27 +0000)]
Revert ORDBMS change, per Peter.

21 years agoAlter query.sgml to mention PostgreSQL as an ORDBMS. This falls in line
Bruce Momjian [Tue, 24 Jun 2003 23:26:46 +0000 (23:26 +0000)]
Alter query.sgml to mention PostgreSQL as an ORDBMS.  This falls in line
with advocacy and 'portal' websites.

Link to createdb / dropdb from the tutorial page about create / dropdb.
A pair of notes were asking about more info...

Rod Taylor

21 years agoIn an attempt to simplify my life I'm submitting this patch that
Bruce Momjian [Tue, 24 Jun 2003 23:25:44 +0000 (23:25 +0000)]
In an attempt to simplify my life I'm submitting this patch that
restructures the deferred trigger queue.  The fundamental change is to
put all the static variables to hold the deferred triggers in a single
structure.

Alvaro Herrera

21 years agoAdd x86_64 support for spinlocks.
Bruce Momjian [Tue, 24 Jun 2003 23:20:08 +0000 (23:20 +0000)]
Add x86_64 support for spinlocks.

Jeffrey W. Baker

21 years agoSmall patch to link to the proper place in the "runtime" file,
Bruce Momjian [Tue, 24 Jun 2003 23:19:11 +0000 (23:19 +0000)]
Small patch to link to the proper place in the "runtime" file,
and to add the "schemaname" column to the description of the
pg_stats view.

Greg Sabino Mullane

21 years agoArray mega-patch.
Bruce Momjian [Tue, 24 Jun 2003 23:14:49 +0000 (23:14 +0000)]
Array mega-patch.

Joe Conway

21 years agoDone:
Bruce Momjian [Tue, 24 Jun 2003 23:05:20 +0000 (23:05 +0000)]
Done:

> * -Add IPv6 capability to INET/CIDR types

21 years agoJim C. Nasby wrote:
Bruce Momjian [Tue, 24 Jun 2003 22:59:46 +0000 (22:59 +0000)]
Jim C. Nasby wrote:
> Second argument to metaphone is suposed to set the limit on the
> number of characters to return, but it breaks on some phrases:
>
> usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from
> (select 'Hello world'::varchar AS a) a;
> HLW       | HLWR      | HLWRLT
>
> usps=# select metaphone(a,3),metaphone(a,4),metaphone(a,20) from
> (select 'A A COMEAUX MEMORIAL'::varchar AS a) a;
  > AKM       | AKMKS     | AKMKSMMRL
>
> In every case I've found that does this, the 4th and 5th letters are
> always 'KS'.

Nice catch.

There was a bug in the original metaphone algorithm from CPAN. Patch
attached (while I was at it I updated my email address, changed the
copyright to PGDG, and removed an unnecessary palloc). Here's how it
looks now:

regression=# select metaphone(a,4) from (select 'A A COMEAUX
MEMORIAL'::varchar AS a) a;
   metaphone
-----------
   AKMK
(1 row)

regression=# select metaphone(a,5) from (select 'A A COMEAUX
MEMORIAL'::varchar AS a) a;
   metaphone
-----------
   AKMKS
(1 row)

Joe Conway

21 years agoPrevent compiler warning from sprintf in recent ipv6 patch.
Bruce Momjian [Tue, 24 Jun 2003 22:42:42 +0000 (22:42 +0000)]
Prevent compiler warning from sprintf in recent ipv6 patch.

21 years ago Add ipv6 address parsing support to 'inet' and 'cidr' data types.
Bruce Momjian [Tue, 24 Jun 2003 22:21:24 +0000 (22:21 +0000)]
    Add ipv6 address parsing support to 'inet' and 'cidr' data types.

        Regression tests for IPv6 operations added.

        Documentation updated to document IPv6 bits.

        Stop treating IPv4 as an "unsigned int" and IPv6 as an array of
        characters.  Instead, always use the array of characters so we
        can have one function fits all.  This makes bitncmp(), addressOK(),
        and several other functions "just work" on both address families.

        add family() function which returns integer 4 or 6 for IPv4 or
        IPv6.  (See examples below)  Note that to add this new function
        you will need to dump/initdb/reload or find the correct magic
        to add the function to the postgresql function catalogs.

        IPv4 addresses always sort before IPv6.

        On disk we use AF_INET for IPv4, and AF_INET+1 for IPv6 addresses.
        This prevents the need for a dump and reload, but lets IPv6 parsing
        work on machines without AF_INET6.

        To select all IPv4 addresses from a table:

                select * from foo where family(addr) = 4 ...

        Order by and other bits should all work.

Michael Graff

21 years agoUpdate:
Bruce Momjian [Tue, 24 Jun 2003 18:45:38 +0000 (18:45 +0000)]
Update:

< * Have SELECT '13 minutes'::interval display zero seconds
> * Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle

21 years agoAdd -L../ecpglib -lecpg for Cygwin compile.
Bruce Momjian [Tue, 24 Jun 2003 14:45:46 +0000 (14:45 +0000)]
Add  -L../ecpglib -lecpg for Cygwin compile.

21 years agoAdd:
Bruce Momjian [Tue, 24 Jun 2003 03:42:44 +0000 (03:42 +0000)]
Add:

> * Have SELECT '13 minutes'::interval display zero seconds

21 years agoAdd:
Bruce Momjian [Tue, 24 Jun 2003 03:40:09 +0000 (03:40 +0000)]
Add:

> * Allow the regression tests to start postmaster with -i so the tests
>   can be run on systems that don't support unix-domain sockets

21 years agoAdd:
Bruce Momjian [Tue, 24 Jun 2003 02:54:23 +0000 (02:54 +0000)]
Add:

> * Rename /scripts directory because they are all C programs now

21 years agoAdd:
Bruce Momjian [Tue, 24 Jun 2003 02:53:36 +0000 (02:53 +0000)]
Add:

<
>  o Allow ALTER TABLE to modify column lengths and change to binary
>    compatible types

21 years agoAdd:
Bruce Momjian [Tue, 24 Jun 2003 02:39:49 +0000 (02:39 +0000)]
Add:

> * Modify pg_get_triggerdef() to take a boolean to pretty-print,
>  and use that as part of pg_dump along with psql
>

21 years agoUpdate:
Bruce Momjian [Tue, 24 Jun 2003 01:54:57 +0000 (01:54 +0000)]
Update:

* Allow UPDATE, DELETE to handle table aliases for self-joins [delete]

21 years agotypedef sa_family_t for cygwin.
Bruce Momjian [Tue, 24 Jun 2003 01:49:22 +0000 (01:49 +0000)]
typedef sa_family_t for cygwin.

21 years agoAdd:
Bruce Momjian [Tue, 24 Jun 2003 01:08:20 +0000 (01:08 +0000)]
Add:

>  o Allow columns to be reordered using ALTER ... POSITION i col1 [,col2];
>    have SELECT * and INSERT honor such ordering

21 years agoDo not include:
Bruce Momjian [Tue, 24 Jun 2003 00:44:29 +0000 (00:44 +0000)]
Do not include:

#include <pwd.h>
#include <netdb.h>

in MS CC/Borland builds.

21 years agoRemove references to sa_family_t, except when SOCKADDR_STORAGE requires
Bruce Momjian [Mon, 23 Jun 2003 23:52:00 +0000 (23:52 +0000)]
Remove references to sa_family_t, except when SOCKADDR_STORAGE requires
it.

Also handle __ss_family as a synonym for ss_family.

Kurt Roeckx

21 years agoAdd with '?':
Bruce Momjian [Mon, 23 Jun 2003 19:33:40 +0000 (19:33 +0000)]
Add with '?':

> * Have initdb set DateStyle based on locale?

21 years agoAdd mention that the grep's have to be adjusted in pgtest.
Bruce Momjian [Mon, 23 Jun 2003 19:33:25 +0000 (19:33 +0000)]
Add mention that the grep's have to be adjusted in pgtest.

21 years agoRemove '?':
Bruce Momjian [Mon, 23 Jun 2003 19:22:30 +0000 (19:22 +0000)]
Remove '?':

<   from making invalid dates valid?
>   from making invalid dates valid

21 years agoChange pqInternalNotice to accept a format string and args instead of
Tom Lane [Mon, 23 Jun 2003 19:20:25 +0000 (19:20 +0000)]
Change pqInternalNotice to accept a format string and args instead of
just a preformatted message; per suggestion by Sean Chittenden.

21 years agoRemove crypt.h from fe-connect.c --- not needed, and caused problems on
Bruce Momjian [Mon, 23 Jun 2003 17:03:19 +0000 (17:03 +0000)]
Remove crypt.h from fe-connect.c --- not needed, and caused problems on
Solaris with Open SSL version 0.9.7b

21 years agoUpdate Russian version of FAQ.
Bruce Momjian [Mon, 23 Jun 2003 16:58:21 +0000 (16:58 +0000)]
Update Russian version of FAQ.

21 years agoAdd:
Bruce Momjian [Mon, 23 Jun 2003 04:31:25 +0000 (04:31 +0000)]
Add:

> * Exit postmaster if postgresql.conf can not be opened

21 years agoAdd:
Bruce Momjian [Mon, 23 Jun 2003 04:00:10 +0000 (04:00 +0000)]
Add:

* Allow SSL-enabled clients to turn off SSL transfers

21 years agoAdd:
Bruce Momjian [Mon, 23 Jun 2003 03:52:24 +0000 (03:52 +0000)]
Add:

> * Change CVS $Id$ to $PostgreSQL$

21 years agoRevise hash join and hash aggregation code to use the same datatype-
Tom Lane [Sun, 22 Jun 2003 22:04:55 +0000 (22:04 +0000)]
Revise hash join and hash aggregation code to use the same datatype-
specific hash functions used by hash indexes, rather than the old
not-datatype-aware ComputeHashFunc routine.  This makes it safe to do
hash joining on several datatypes that previously couldn't use hashing.
The sets of datatypes that are hash indexable and hash joinable are now
exactly the same, whereas before each had some that weren't in the other.

21 years agoFix some index entries.
Tom Lane [Sun, 22 Jun 2003 16:17:01 +0000 (16:17 +0000)]
Fix some index entries.

21 years agoAdjust chapter ordering in Internals part to something that seems more
Tom Lane [Sun, 22 Jun 2003 16:16:44 +0000 (16:16 +0000)]
Adjust chapter ordering in Internals part to something that seems more
reasonable.

21 years agoAdded missing terminating '\0' char for data put into char *.
Michael Meskes [Sun, 22 Jun 2003 11:00:48 +0000 (11:00 +0000)]
Added missing terminating '\0' char for data put into char *.

21 years agoRemove a lot of desperately obsolete material (which was all out of sight,
Tom Lane [Sun, 22 Jun 2003 05:48:26 +0000 (05:48 +0000)]
Remove a lot of desperately obsolete material (which was all out of sight,
out of mind, because it'd been commented out years ago).  Try to bring the
remains up to a reasonable level of currency, and give it all approximately
the same high level of abstraction.

21 years agoAdd question mark to item:
Bruce Momjian [Sun, 22 Jun 2003 05:04:52 +0000 (05:04 +0000)]
Add question mark to item:

<   from making invalid dates valid
>   from making invalid dates valid?

21 years agoAdd:
Bruce Momjian [Sun, 22 Jun 2003 05:01:17 +0000 (05:01 +0000)]
Add:

> * Allow current datestyle to restrict dates;  prevent month/day swapping
>   from making invalid dates valid
> * Prevent month/day swapping of ISO dates to make invalid dates valid

21 years agoAdd pgtest script.
Bruce Momjian [Sun, 22 Jun 2003 04:22:57 +0000 (04:22 +0000)]
Add pgtest script.

21 years agoUse libpq's new logic to get the server version, instead of doing it ourselves.
Tom Lane [Sun, 22 Jun 2003 00:56:58 +0000 (00:56 +0000)]
Use libpq's new logic to get the server version, instead of doing it ourselves.

21 years agoBring the libpq example programs into the 21st century.
Tom Lane [Sun, 22 Jun 2003 00:29:29 +0000 (00:29 +0000)]
Bring the libpq example programs into the 21st century.

21 years agoGet rid of extraneous newline in PQendcopy error output (was causing
Tom Lane [Sat, 21 Jun 2003 23:25:38 +0000 (23:25 +0000)]
Get rid of extraneous newline in PQendcopy error output (was causing
regression test diffs...).

21 years agoUpdate libpq to make new features of FE/BE protocol available to
Tom Lane [Sat, 21 Jun 2003 21:51:35 +0000 (21:51 +0000)]
Update libpq to make new features of FE/BE protocol available to
client applications.  Some editorial work on libpq.sgml, too.

21 years agoFix some markup problems.
Tom Lane [Sat, 21 Jun 2003 19:33:36 +0000 (19:33 +0000)]
Fix some markup problems.

21 years agoFix for extended-query protocol: in event of error, backend was issuing
Tom Lane [Fri, 20 Jun 2003 21:58:02 +0000 (21:58 +0000)]
Fix for extended-query protocol: in event of error, backend was issuing
a ReadyForQuery (Z message) immediately and then another one after the
Sync message arrives.  Suppress the first one to make it work per spec.

21 years agoSynced with backend.
Michael Meskes [Fri, 20 Jun 2003 15:16:06 +0000 (15:16 +0000)]
Synced with backend.

21 years agoJust another Informix compatibility change. They uses "free" for cursors as wellafter...
Michael Meskes [Fri, 20 Jun 2003 13:36:34 +0000 (13:36 +0000)]
Just another Informix compatibility change. They uses "free" for cursors as wellafter closing them.

21 years agoJust another ecpg todo done.
Michael Meskes [Fri, 20 Jun 2003 13:20:09 +0000 (13:20 +0000)]
Just another ecpg todo done.

21 years agoSorry, missed a file.
Michael Meskes [Fri, 20 Jun 2003 12:01:46 +0000 (12:01 +0000)]
Sorry, missed a file.

21 years agoAllow constants in using clauses.
Michael Meskes [Fri, 20 Jun 2003 12:00:59 +0000 (12:00 +0000)]
Allow constants in using clauses.

21 years agoWe neglected to set conn->raddr.salen, leading to breakage of CANCEL
Tom Lane [Fri, 20 Jun 2003 04:09:12 +0000 (04:09 +0000)]
We neglected to set conn->raddr.salen, leading to breakage of CANCEL
and probably other stuff.

21 years agoDisallow dollar sign in operator names, instead allow it as a non-first
Tom Lane [Thu, 19 Jun 2003 23:22:40 +0000 (23:22 +0000)]
Disallow dollar sign in operator names, instead allow it as a non-first
character in identifiers.  The first change eliminates the current need
to put spaces around parameter references, as in "x<=$2".  The second
change improves compatibility with Oracle and some other RDBMSes.  This
was discussed and agreed to back in January, but did not get done.

21 years agoFixed fetch into char * and added missing prototype for an Informix function.
Michael Meskes [Thu, 19 Jun 2003 09:52:11 +0000 (09:52 +0000)]
Fixed fetch into char * and added missing prototype for an Informix function.

21 years agoMove thread checking code farther down in conflgure.
Bruce Momjian [Wed, 18 Jun 2003 16:04:15 +0000 (16:04 +0000)]
Move thread checking code farther down in conflgure.

21 years agoChange clusterdb and vacuumdb into C programs.
Peter Eisentraut [Wed, 18 Jun 2003 12:19:11 +0000 (12:19 +0000)]
Change clusterdb and vacuumdb into C programs.

21 years agoMake FLOAT(p) measure the precision p in bits, not decimal digits, to
Tom Lane [Tue, 17 Jun 2003 23:12:36 +0000 (23:12 +0000)]
Make FLOAT(p) measure the precision p in bits, not decimal digits, to
match the SQL standard.  Document FLOAT and FLOAT(p) notations in
datatype.sgml.  Per recent pghackers discussion.

21 years agoMore information schema views.
Peter Eisentraut [Tue, 17 Jun 2003 18:00:48 +0000 (18:00 +0000)]
More information schema views.

21 years agoAdd missing file to clean target.
Peter Eisentraut [Tue, 17 Jun 2003 17:58:54 +0000 (17:58 +0000)]
Add missing file to clean target.

21 years agoFixed several more parsing bugs.
Michael Meskes [Tue, 17 Jun 2003 07:28:22 +0000 (07:28 +0000)]
Fixed several more parsing bugs.

21 years agoFix error line numbers reported for errors in plpgsql_parse_word and
Tom Lane [Tue, 17 Jun 2003 04:35:03 +0000 (04:35 +0000)]
Fix error line numbers reported for errors in plpgsql_parse_word and
siblings.

21 years agoFix bugs in interval-to-time conversion: HAVE_INT64_TIMESTAMP case did not
Tom Lane [Mon, 16 Jun 2003 18:56:45 +0000 (18:56 +0000)]
Fix bugs in interval-to-time conversion: HAVE_INT64_TIMESTAMP case did not
work at all, and neither case behaved sanely for negative intervals.

21 years agoFixed two small bugs.
Michael Meskes [Mon, 16 Jun 2003 16:58:11 +0000 (16:58 +0000)]
Fixed two small bugs.

21 years agoAllow GROUP BY, ORDER BY, DISTINCT targets to be unknown literals,
Tom Lane [Mon, 16 Jun 2003 02:03:38 +0000 (02:03 +0000)]
Allow GROUP BY, ORDER BY, DISTINCT targets to be unknown literals,
silently resolving them to type TEXT.  This is comparable to what we
do when faced with UNKNOWN in CASE, UNION, and other contexts.  It gets
rid of this and related annoyances:
select distinct f1, '' from int4_tbl;
ERROR:  Unable to identify an ordering operator '<' for type unknown
This was discussed many moons ago, but no one got round to fixing it.

21 years agoAdjust nestloop-with-inner-indexscan plan generation so that we catch
Tom Lane [Sun, 15 Jun 2003 22:51:45 +0000 (22:51 +0000)]
Adjust nestloop-with-inner-indexscan plan generation so that we catch
some cases of redundant clauses that were formerly not caught.  We have
to special-case this because the clauses involved never get attached to
the same join restrictlist and so the existing logic does not notice
that they are redundant.

21 years agoReplace cryptic 'Unknown kind of return type' messages with something
Tom Lane [Sun, 15 Jun 2003 17:59:10 +0000 (17:59 +0000)]
Replace cryptic 'Unknown kind of return type' messages with something
hopefully a little more useful.

21 years agoCause GROUP BY clause to adopt ordering operators from ORDER BY when
Tom Lane [Sun, 15 Jun 2003 16:42:08 +0000 (16:42 +0000)]
Cause GROUP BY clause to adopt ordering operators from ORDER BY when
both clauses specify the same targets, rather than always using the
default ordering operator.  This allows 'GROUP BY foo ORDER BY foo DESC'
to be done with only one sort step.

21 years agoindex() -> strchr().
Tom Lane [Sun, 15 Jun 2003 16:21:39 +0000 (16:21 +0000)]
index() -> strchr().

21 years agoTypo in version number.
Michael Meskes [Sun, 15 Jun 2003 12:06:50 +0000 (12:06 +0000)]
Typo in version number.

21 years agoSome minor changes for new version numbering.
Michael Meskes [Sun, 15 Jun 2003 11:10:09 +0000 (11:10 +0000)]
Some minor changes for new version numbering.

21 years agoUpdating ECPG todo items.
Michael Meskes [Sun, 15 Jun 2003 10:34:10 +0000 (10:34 +0000)]
Updating ECPG todo items.

21 years agoEcpg cleanups for prototypes.
Bruce Momjian [Sun, 15 Jun 2003 04:56:45 +0000 (04:56 +0000)]
Ecpg cleanups for prototypes.

21 years agoRun autoconf/autoheader for ecpg change.
Bruce Momjian [Sun, 15 Jun 2003 04:09:18 +0000 (04:09 +0000)]
Run autoconf/autoheader for ecpg change.

21 years agoMake ecpg thread safe.
Bruce Momjian [Sun, 15 Jun 2003 04:07:58 +0000 (04:07 +0000)]
Make ecpg thread safe.

Lee Kindness

21 years agoMove thread os defines into template files.
Bruce Momjian [Sat, 14 Jun 2003 19:21:42 +0000 (19:21 +0000)]
Move thread os defines into template files.

21 years agoHandle threading in two more gethostbyname calls.
Bruce Momjian [Sat, 14 Jun 2003 18:20:33 +0000 (18:20 +0000)]
Handle threading in two more gethostbyname calls.

21 years agoMake libpq thread-safe with configure --with-threads option.
Bruce Momjian [Sat, 14 Jun 2003 17:49:54 +0000 (17:49 +0000)]
Make libpq thread-safe with configure --with-threads option.

Lee Kindness

21 years agoAdd thread.c for libpq threading, and hook it into libpq/configure.
Bruce Momjian [Sat, 14 Jun 2003 14:35:42 +0000 (14:35 +0000)]
Add thread.c for libpq threading, and hook it into libpq/configure.

21 years agoAdd --with-threads configure option to control threaded libpq.
Bruce Momjian [Fri, 13 Jun 2003 23:10:08 +0000 (23:10 +0000)]
Add --with-threads configure option to control threaded libpq.

21 years ago- Enable FETCH without INTO.
Michael Meskes [Fri, 13 Jun 2003 10:50:58 +0000 (10:50 +0000)]
- Enable FETCH without INTO.
- Compatibility functions for INFORMIX handling of DECLARE statement.

21 years agoOkay, recognize freebsd 2.* and 3.* too.
Tom Lane [Fri, 13 Jun 2003 02:21:03 +0000 (02:21 +0000)]
Okay, recognize freebsd 2.* and 3.* too.

21 years agoExpect FreeBSD 5.* to have standard float arithmetic.
Tom Lane [Fri, 13 Jun 2003 01:50:50 +0000 (01:50 +0000)]
Expect FreeBSD 5.* to have standard float arithmetic.

21 years agoFix broken markup.
Tom Lane [Thu, 12 Jun 2003 18:34:06 +0000 (18:34 +0000)]
Fix broken markup.

21 years agoAdd thread-enable compile variables into libpq.
Bruce Momjian [Thu, 12 Jun 2003 17:31:50 +0000 (17:31 +0000)]
Add thread-enable compile variables into libpq.

21 years agoFix SQL function executor for case where last command of a function is
Tom Lane [Thu, 12 Jun 2003 17:29:26 +0000 (17:29 +0000)]
Fix SQL function executor for case where last command of a function is
not a SELECT.  We didn't use to allow that, but we do now.

21 years ago<sys/socket.h> requires <sys/types.h> to already have been included
Tom Lane [Thu, 12 Jun 2003 16:05:10 +0000 (16:05 +0000)]
<sys/socket.h> requires <sys/types.h> to already have been included
on some platforms.

21 years agoMention need for swap on Linux, and kill -9.
Bruce Momjian [Thu, 12 Jun 2003 15:58:19 +0000 (15:58 +0000)]
Mention need for swap on Linux, and kill -9.

21 years agoDocument default Linux autocommit behavior, and show workaround.
Bruce Momjian [Thu, 12 Jun 2003 15:31:02 +0000 (15:31 +0000)]
Document default Linux autocommit behavior, and show workaround.

21 years agoInstall all header files.
Michael Meskes [Thu, 12 Jun 2003 12:52:24 +0000 (12:52 +0000)]
Install all header files.

21 years agoAttached is the complete diff against current CVS.
Bruce Momjian [Thu, 12 Jun 2003 08:15:29 +0000 (08:15 +0000)]
Attached is the complete diff against current CVS.
Compiles on BCC 5.5 and VC++ 6.0 (with warnings).

Karl Waclawek

21 years agoBack out patch that got bundled into another patch.
Bruce Momjian [Thu, 12 Jun 2003 08:11:07 +0000 (08:11 +0000)]
Back out patch that got bundled into another patch.

21 years agoNew patch with corrected README attached.
Bruce Momjian [Thu, 12 Jun 2003 08:02:57 +0000 (08:02 +0000)]
New patch with corrected README attached.

Also quickly added mention that it may be a qualified schema name.

Rod Taylor

21 years agoAttached is a patch that enhances the output of psql's HTML mode.
Bruce Momjian [Thu, 12 Jun 2003 07:52:51 +0000 (07:52 +0000)]
Attached is a patch that enhances the output of psql's HTML mode.
The output now validates as HTML 4.01 Strict, XHTML 1.0 strict,
and XHTML 1.1 (assuming you wrap it in a valid html/body document).

It also wraps the output of PGRES_COMMAND_OK if the HTML tag is on,
for full compliance: this is why html_escaped_print has to be
externalized.

Greg Sabino Mullane greg@turnstep.com

21 years agoBrief note about sequence cache not being cleared in other backends.
Bruce Momjian [Thu, 12 Jun 2003 07:49:43 +0000 (07:49 +0000)]
Brief note about sequence cache not being cleared in other backends.

Actually clear the cache in the backend making the alteration.  This
follows in the footsteps of setval().

Rod Taylor

21 years agoIPv6 cleanups.
Bruce Momjian [Thu, 12 Jun 2003 07:36:51 +0000 (07:36 +0000)]
IPv6 cleanups.

Kurt Roeckx
Andrew Dunstan

21 years agoBack out this patch because it is patched inside a later patch.
Bruce Momjian [Thu, 12 Jun 2003 07:00:57 +0000 (07:00 +0000)]
Back out this patch because it is patched inside a later patch.

---------------------------------------------------------------------------

here is a patch that allows CIDR netmasks in pg_hba.conf. It allows two
address/mask forms:

. address/maskbits, or
. address netmask (as now)

If the patch is accepted I will submit a documentation patch to cover
it.

This is submitted by agreement with Kurt Roeckx, who has worked on a
patch that covers this and other IPv6 issues.

21 years agoI succeeded by fixing up setup.py:
Bruce Momjian [Thu, 12 Jun 2003 02:15:09 +0000 (02:15 +0000)]
I succeeded by fixing up setup.py:
vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv
--- setup.py~   Tue Mar 19 08:21:14 2002
+++ setup.py    Wed May 14 15:10:30 2003
@@ -30,8 +30,8 @@
        optional_libs=[ 'libpqdll', 'wsock32', 'advapi32' ]
        data_files = [ 'libpq.dll' ]
 else:
-       include_dirs=['/usr/include/pgsql']
-       library_dirs=['usr/lib/pgsql']
+       include_dirs=['../../include','../libpq','/usr/include/pgsql']
+       library_dirs=['../libpq','/usr/lib/pgsql']
        optional_libs=['pq']
        data_files = []
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

George Young

21 years agoHere is a patch that allows CIDR netmasks in pg_hba.conf. It allows two
Bruce Momjian [Thu, 12 Jun 2003 02:12:58 +0000 (02:12 +0000)]
Here is a patch that allows CIDR netmasks in pg_hba.conf. It allows two
address/mask forms:

. address/maskbits, or
. address netmask (as now)

If the patch is accepted I will submit a documentation patch to cover
it.

This is submitted by agreement with Kurt Roeckx, who has worked on a
patch that covers this and other IPv6 issues.

Andrew Dunstan