]> granicus.if.org Git - postgresql/log
postgresql
22 years agoPleas apply it for 7.2.1 and current CVS.
Bruce Momjian [Mon, 11 Mar 2002 16:54:27 +0000 (16:54 +0000)]
Pleas apply it for 7.2.1 and current CVS.

Patch fixes using lc.lang instead of lc.lc_ctype.

Teodor Sigaev

22 years agoMention time() and interval() are also changed in 7.2.
Bruce Momjian [Mon, 11 Mar 2002 16:41:44 +0000 (16:41 +0000)]
Mention time() and interval() are also changed in 7.2.

22 years agoInlined a patch to add the libpq setNoticeProcessor capability to
Bruce Momjian [Mon, 11 Mar 2002 15:08:18 +0000 (15:08 +0000)]
Inlined a patch to add the libpq setNoticeProcessor capability to
libpq++.

Ofir Reichenberg

22 years agoChanged the version numbers, but did not commit the Makefiles.
Michael Meskes [Mon, 11 Mar 2002 12:56:02 +0000 (12:56 +0000)]
Changed the version numbers, but did not commit the Makefiles.

22 years agoBug fixes for the 2002-03-08 change.
Hiroshi Inoue [Mon, 11 Mar 2002 10:25:57 +0000 (10:25 +0000)]
Bug fixes for the 2002-03-08 change.
1) Put back the error message for SQLError().
2) Change Disallow premature to handle the SELECTed
   result.
3) Put back the behavior of AUTUCOMMIT mode change.
4) Fix SQLColumns for ODBC3.0.

5) Improve the handling of variable bookmark in ODBC3.0.
6) Enable Recognize Unique Index Button.

22 years agoFix markup
Peter Eisentraut [Mon, 11 Mar 2002 05:03:52 +0000 (05:03 +0000)]
Fix markup

22 years agoUppercase class selectors, to work with browsers that follow the standards.
Peter Eisentraut [Mon, 11 Mar 2002 05:02:04 +0000 (05:02 +0000)]
Uppercase class selectors, to work with browsers that follow the standards.

22 years agoBack out this for Peter:
Bruce Momjian [Mon, 11 Mar 2002 04:39:14 +0000 (04:39 +0000)]
Back out this for Peter:

>       This simple patch fixes broken Makefile, broken ApplySnapshot and
>       makes all utilities honour --verbose command line option.
>
>       --
>       Yours, Alexey V. Borzov, Webmaster of RDW.ru
>

22 years agoFixed two bugs in define command in pgc.l
Michael Meskes [Sun, 10 Mar 2002 12:09:54 +0000 (12:09 +0000)]
Fixed two bugs in define command in pgc.l

22 years agoUpdate and remove items:
Bruce Momjian [Sun, 10 Mar 2002 06:12:23 +0000 (06:12 +0000)]
Update and remove items:

< * Remove brackets as multi-statement rule grouping, must use parens (Bruce)
> * -Remove brackets as multi-statement rule grouping, must use parens (Bruce)
458d457
< * Remove USING clause from pg_get_indexdef() if index is btree (Bruce)

22 years agoAdd DEFAULT_INDEX_TYPE == "btree", for clarity.
Bruce Momjian [Sun, 10 Mar 2002 06:02:24 +0000 (06:02 +0000)]
Add DEFAULT_INDEX_TYPE == "btree", for clarity.

22 years agoDisable brackets in multi-statement rules, as discussed.
Bruce Momjian [Sun, 10 Mar 2002 06:00:15 +0000 (06:00 +0000)]
Disable brackets in multi-statement rules, as discussed.

22 years agoGuard against NULL strings in SET key=val constructs.
Thomas G. Lockhart [Sat, 9 Mar 2002 17:37:16 +0000 (17:37 +0000)]
Guard against NULL strings in SET key=val constructs.
 Problem noted by Fernando Nasser.

22 years agoAdded a check for not calling next() before getting objects from the result set,
Dave Cramer [Sat, 9 Mar 2002 17:36:14 +0000 (17:36 +0000)]
Added a check for not calling next() before getting objects from the result set,
moved the check for columnIndex into same call
check at the top of all getXXX
added appropriate error

22 years agoCode review for improved-hashing patch. Fix some portability issues
Tom Lane [Sat, 9 Mar 2002 17:35:37 +0000 (17:35 +0000)]
Code review for improved-hashing patch.  Fix some portability issues
(char != unsigned char, Datum != uint32); make use of new hash code in
dynahash hash tables and hash joins.

22 years agoHere is a small patch that cleans up some error reporting in the JDBC driver. PSQLExc...
Dave Cramer [Sat, 9 Mar 2002 17:08:39 +0000 (17:08 +0000)]
Here is a small patch that cleans up some error reporting in the JDBC driver. PSQLExceptions are thrown instead of SQLExceptions and if a warning is received while waiting for the backend secret key, that warning is chained to the new Connection object instead of generating an exception. A couple new error messages have been added.

22 years agoWording improvements to runtime.sgml. Add mention in postgresql.conf
Bruce Momjian [Sat, 9 Mar 2002 05:11:38 +0000 (05:11 +0000)]
Wording improvements to runtime.sgml.  Add mention in postgresql.conf
file that SIGHUP or "pg_ctl reload" are required for changes to take
affect on a running server.

22 years agoImprove wording of pg_hba.conf file.
Bruce Momjian [Fri, 8 Mar 2002 20:36:58 +0000 (20:36 +0000)]
Improve wording of pg_hba.conf file.

22 years agoRemove compile errors.
Hiroshi Inoue [Fri, 8 Mar 2002 09:50:39 +0000 (09:50 +0000)]
Remove compile errors.

22 years ago1) Implement SQLParamOptions().
Hiroshi Inoue [Fri, 8 Mar 2002 08:52:55 +0000 (08:52 +0000)]
1) Implement SQLParamOptions().
2) Handle Multiple results and implement SQLMoreResult().
3) Improve multibyte handling thanks to Eiji Tokuya.
4) Add new options.
   LF <-> CR/LF converion.
   TRUE is -1 (for VB).
5) Introduce unicode(UCS-2) support.
6) Reduce the length of connection strings.
7) Improve SQLError, SQLGetDiagRec(ODBC 3.0).
8) Implement SQLTablePrivileges().
9) Miscellaneous changes for ODBC 3.0 support.

22 years agoanalyze.o need not depend on parser.h.
Tom Lane [Fri, 8 Mar 2002 07:12:11 +0000 (07:12 +0000)]
analyze.o need not depend on parser.h.

22 years agoRemove unnecessary inclusion.
Tom Lane [Fri, 8 Mar 2002 06:55:08 +0000 (06:55 +0000)]
Remove unnecessary inclusion.

22 years agoFix copying/equality-check bugs in GrantStmt and ConstraintsSetStmt,
Tom Lane [Fri, 8 Mar 2002 04:37:18 +0000 (04:37 +0000)]
Fix copying/equality-check bugs in GrantStmt and ConstraintsSetStmt,
per reports from Fernando Nasser.  Also, rearrange order of declarations
in parsenodes.h as suggested by Fernando.

22 years agoRemove async TODO.detail file.
Bruce Momjian [Fri, 8 Mar 2002 04:34:37 +0000 (04:34 +0000)]
Remove async TODO.detail file.

22 years agoUpdate TODO items that are completed.
Bruce Momjian [Fri, 8 Mar 2002 04:33:53 +0000 (04:33 +0000)]
Update TODO items that are completed.

22 years agoTODO item done:
Bruce Momjian [Fri, 8 Mar 2002 04:29:01 +0000 (04:29 +0000)]
TODO item done:

  * Change FIXED_CHAR_SEL to 0.20 from 0.04 to give better selectivity (Bruce)

22 years agoMark as done:
Bruce Momjian [Fri, 8 Mar 2002 04:03:32 +0000 (04:03 +0000)]
Mark as done:

> * -Change DEBUG startup tag to LOG (Bruce)

22 years agoAdd
Bruce Momjian [Fri, 8 Mar 2002 01:31:19 +0000 (01:31 +0000)]
Add

> * Prevent aggregates from being used in rule WHERE clauses

22 years agoAdd missing colon to getopt() arg.
Tom Lane [Fri, 8 Mar 2002 00:42:09 +0000 (00:42 +0000)]
Add missing colon to getopt() arg.

22 years agoAdd FULL in VACUUM psql completion.
Bruce Momjian [Thu, 7 Mar 2002 20:48:41 +0000 (20:48 +0000)]
Add FULL in VACUUM psql completion.

22 years agoAdjust elog() tags so source and regression tests match.
Bruce Momjian [Thu, 7 Mar 2002 20:18:15 +0000 (20:18 +0000)]
Adjust elog() tags so source and regression tests match.

22 years agoBack out psql domain improvements until domain is applied.
Bruce Momjian [Thu, 7 Mar 2002 17:54:42 +0000 (17:54 +0000)]
Back out psql domain improvements until domain is applied.

22 years agoBack out domain patch until it works properly.
Bruce Momjian [Thu, 7 Mar 2002 16:35:41 +0000 (16:35 +0000)]
Back out domain patch until it works properly.

22 years agoAlso an small change to the tab-complete feature of psql which allows to
Bruce Momjian [Thu, 7 Mar 2002 04:45:53 +0000 (04:45 +0000)]
Also an small change to the tab-complete feature of psql which allows to
use tables and views interchangeably.

Manuel Sugawara

22 years agoFix syntax error introduced by patch.
Bruce Momjian [Wed, 6 Mar 2002 21:49:52 +0000 (21:49 +0000)]
Fix syntax error introduced by patch.

22 years agoI've attached a patch which implements Bob Jenkin's hash function for
Bruce Momjian [Wed, 6 Mar 2002 20:49:46 +0000 (20:49 +0000)]
I've attached a patch which implements Bob Jenkin's hash function for
PostgreSQL. This hash function replaces the one used by hash indexes and
the catalog cache. Hash joins use a different, relatively poor-quality
hash function, but I'll fix that later.

As suggested by Tom Lane, this patch also changes the size of the fixed
hash table used by the catalog cache to be a power-of-2 (instead of a
prime: I chose 256 instead of 257). This allows the catcache to lookup
hash buckets using a simple bitmask. This should improve the performance
of the catalog cache slightly, since the previous method (modulo a
prime) was slow.

In my tests, this improves the performance of hash indexes by between 4%
and 8%; the performance when using btree indexes or seqscans is
basically unchanged.

Neil Conway <neilconway@rogers.com>

22 years agoEnable ALTER TABLE ADD PRIMARY KEY for pg_dump, for performance reasons
Bruce Momjian [Wed, 6 Mar 2002 20:48:42 +0000 (20:48 +0000)]
Enable ALTER TABLE ADD PRIMARY KEY for pg_dump, for performance reasons
so index is not on table during COPY.

> > AFAICT, the patch I posted to -patches a little while to enable the
> > usage of ALTER TABLE ADD PRIMARY KEY by pg_dump hasn't been applied, nor
> > is it in the unapplied patches list. I was under the impression that
> > this was in the queue for application -- did it just get lost?

Neil Conway <neilconway@rogers.com>

22 years agoalter table doc cleanups.
Bruce Momjian [Wed, 6 Mar 2002 20:42:38 +0000 (20:42 +0000)]
alter table doc cleanups.

Neil Conway

22 years agoThis simple patch fixes broken Makefile, broken ApplySnapshot and
Bruce Momjian [Wed, 6 Mar 2002 20:41:36 +0000 (20:41 +0000)]
This simple patch fixes broken Makefile, broken ApplySnapshot and
makes all utilities honour --verbose command line option.

--
Yours, Alexey V. Borzov, Webmaster of RDW.ru

22 years agoHere is a diff of changes to the psql source code implementing a simple
Bruce Momjian [Wed, 6 Mar 2002 20:39:45 +0000 (20:39 +0000)]
Here is a diff of changes to the psql source code implementing a simple
'list domains' command '\dD'. This is the interface component of
rbt@zort.ca's domain backend modifications.

Jonathan Eisler

22 years agoOk. Updated patch attached.
Bruce Momjian [Wed, 6 Mar 2002 20:35:02 +0000 (20:35 +0000)]
Ok.  Updated patch attached.

- domain.patch -> source patch against pgsql in cvs
- drop_domain.sgml and create_domain.sgml -> New doc/src/sgml/ref docs

- dominfo.txt -> basic domain related queries I used for testing
[ ADDED TO /doc]

Enables domains of array elements -> CREATE DOMAIN dom int4[3][2];

Uses a typbasetype column to describe the origin of the domain.

Copies data to attnotnull rather than processing in execMain().

Some documentation differences from earlier.

If this is approved, I'll start working on pg_dump, and a \dD <domain>
option in psql, and regression tests.  I don't really feel like doing
those until the system table structure settles for pg_type.

CHECKS when added, will also be copied to to the table attributes.  FK
Constraints (if I ever figure out how) will be done similarly.  Both
will lbe handled by MergeDomainAttributes() which is called shortly
before MergeAttributes().

Rod Taylor

22 years agoModify ALTER TABLE OWNER to change index ownership; code cleanup.
Bruce Momjian [Wed, 6 Mar 2002 19:58:26 +0000 (19:58 +0000)]
Modify ALTER TABLE OWNER to change index ownership;  code cleanup.

Neil Conway

22 years agoUpdate docs for new stored procedure error levels.
Bruce Momjian [Wed, 6 Mar 2002 19:05:58 +0000 (19:05 +0000)]
Update docs for new stored procedure error levels.

22 years agoAdd new elog() levels to stored procedure languages. plperl DEBUG hack
Bruce Momjian [Wed, 6 Mar 2002 18:50:33 +0000 (18:50 +0000)]
Add new elog() levels to stored procedure languages.  plperl DEBUG hack
still needed because only removed in 7.4.

22 years agoAdd libpgeasy example file.
Bruce Momjian [Wed, 6 Mar 2002 14:40:05 +0000 (14:40 +0000)]
Add libpgeasy example file.

22 years agoSynced parser with backend.
Michael Meskes [Wed, 6 Mar 2002 10:10:52 +0000 (10:10 +0000)]
Synced parser with backend.

22 years agoUpdate reference pages for new INFO, NOTICE, WARNING elog() levels.
Bruce Momjian [Wed, 6 Mar 2002 06:48:05 +0000 (06:48 +0000)]
Update reference pages for new INFO, NOTICE, WARNING elog() levels.

22 years agoUpdate docs for new INFO, NOTICE, WARNING elog() levels.
Bruce Momjian [Wed, 6 Mar 2002 06:44:33 +0000 (06:44 +0000)]
Update docs for new INFO, NOTICE, WARNING elog() levels.

22 years agoImprove elog descriptions.
Bruce Momjian [Wed, 6 Mar 2002 06:23:20 +0000 (06:23 +0000)]
Improve elog descriptions.

22 years agoAdd missing Unicode multibyte files.
Bruce Momjian [Wed, 6 Mar 2002 06:12:59 +0000 (06:12 +0000)]
Add missing Unicode multibyte files.

22 years agoChange made to elog:
Bruce Momjian [Wed, 6 Mar 2002 06:10:59 +0000 (06:10 +0000)]
Change made to elog:

o  Change all current CVS messages of NOTICE to WARNING.  We were going
to do this just before 7.3 beta but it has to be done now, as you will
see below.

o Change current INFO messages that should be controlled by
client_min_messages to NOTICE.

o Force remaining INFO messages, like from EXPLAIN, VACUUM VERBOSE, etc.
to always go to the client.

o Remove INFO from the client_min_messages options and add NOTICE.

Seems we do need three non-ERROR elog levels to handle the various
behaviors we need for these messages.

Regression passed.

22 years agoAdd name:
Bruce Momjian [Wed, 6 Mar 2002 03:37:16 +0000 (03:37 +0000)]
Add name:

> * Improve concurrency of hash indexes (Neil Conway)

22 years ago changed Cancel to cancel
Dave Cramer [Wed, 6 Mar 2002 03:07:45 +0000 (03:07 +0000)]
 changed Cancel to cancel

22 years agobacked out changes for cancel, no need to look for two 'Z' responses
Dave Cramer [Tue, 5 Mar 2002 20:11:57 +0000 (20:11 +0000)]
backed out changes for cancel, no need to look for two 'Z' responses

22 years agoPatch by Nicolas Verger to correctly propogate SQLWarning to the Statement and ResultSet
Dave Cramer [Tue, 5 Mar 2002 18:02:44 +0000 (18:02 +0000)]
Patch by Nicolas Verger to correctly propogate SQLWarning to the Statement and ResultSet

22 years agofixed cancel query bug introduced by patch
Dave Cramer [Tue, 5 Mar 2002 18:01:27 +0000 (18:01 +0000)]
fixed cancel query bug introduced by patch

22 years agoAutoconf for jdbc debug changes.
Bruce Momjian [Tue, 5 Mar 2002 17:55:45 +0000 (17:55 +0000)]
Autoconf for jdbc debug changes.

22 years agoAt this moment, --enable-debug adds debugging information to most of the
Bruce Momjian [Tue, 5 Mar 2002 17:55:23 +0000 (17:55 +0000)]
At this moment, --enable-debug adds debugging information to most of the
parts o f postgresql. The jdbc drivers are never compiled with debugging
support. This p atch make sure that debugging information is added to
the jdbc jar when the --en able-debug is added. This was usefull for me
for debugging some java jdbc poolin g objects but this might perhaps be
usefull for other people too?

Dries Verachtert

22 years ago Prevent failed passwords from being echoed to server logs, for security.
Bruce Momjian [Tue, 5 Mar 2002 07:57:45 +0000 (07:57 +0000)]
 Prevent failed passwords from being echoed to server logs, for security.

22 years agoPrevent failed passwords from being echoed to server logs, for security.
Bruce Momjian [Tue, 5 Mar 2002 06:52:05 +0000 (06:52 +0000)]
Prevent failed passwords from being echoed to server logs, for security.

22 years agoUpdate FAQ.
Bruce Momjian [Tue, 5 Mar 2002 06:28:26 +0000 (06:28 +0000)]
Update FAQ.

22 years agoThis version has been synchonized with English version at Mar 03.
Bruce Momjian [Tue, 5 Mar 2002 06:20:51 +0000 (06:20 +0000)]
This version has been synchonized with English version at Mar 03.

With best wishes,Victor Vislobokov
Perm, Russia

22 years agoThis trivial patch fixes a typo and improves the phrasing of a sentence
Bruce Momjian [Tue, 5 Mar 2002 06:14:45 +0000 (06:14 +0000)]
This trivial patch fixes a typo and improves the phrasing of a sentence
in the docs.

Neil Conway

22 years agoAdds \du documentation line for \? in psqls help.c
Bruce Momjian [Tue, 5 Mar 2002 06:13:19 +0000 (06:13 +0000)]
Adds \du documentation line for \? in psqls help.c

Thought I saw a patch earlier converting docs to use []s, so this uses
them.

Rod Taylor

22 years agoPlease, apply attached patch for contrib/tsearch to 7.2.1 and current
Bruce Momjian [Tue, 5 Mar 2002 06:10:28 +0000 (06:10 +0000)]
Please, apply attached patch for contrib/tsearch to 7.2.1 and current
CVS. It  fix english stemmer's problem with ending words like
'technology'.

We have found one more bug in english stemmer. The bug is with
'irregular'  english words like 'skies' -> 'sky'. Please, apply attached
cumulative patch to  7.2.1 and current CVS instead previous one.

Thank to Thomas T. Thai <tom@minnesota.com> for hard testing. This kind
of bug  has significance only for dump/reload database and viewing, but
searching/indexing works right.

Teodor Sigaev

22 years agoBack out old version and update with newer patch of:
Bruce Momjian [Tue, 5 Mar 2002 06:07:27 +0000 (06:07 +0000)]
Back out old version and update with newer patch of:

Fix for non-blocking connections in libpq

Bernhard Herzog

22 years agoCurrently, contrib/oid2name doesn't bother to free() the memory that it
Bruce Momjian [Tue, 5 Mar 2002 05:54:07 +0000 (05:54 +0000)]
Currently, contrib/oid2name doesn't bother to free() the memory that it
malloc()'s. This isn't too serious (because oid2name is a short-lived
utility, so the memory will soon be returned to the OS on process
termination), but I still think it's poor style.

This patch changes oid2name so that it allocates memory on the stack
where possible and free()s the remaining heap-allocated memory. The
patch also fixes a typo a comment and adds 'const' qualifiers to a few
'char *' function parameters.

Neil Conway

22 years ago> Tatsuo Ishii wrote:
Bruce Momjian [Tue, 5 Mar 2002 05:52:50 +0000 (05:52 +0000)]
> Tatsuo Ishii wrote:
> > > > It was made to cope with encoding such as an Asian bloc in 7.2Beta2.
> > > >
> > > > Added ServerEncoding
> > > >         Korean (JOHAB), Thai (WIN874),
> > > >         Vietnamese (TCVN), Arabic (WIN1256)
> > > >
> > > > Added ClientEncoding
> > > >         Simplified Chinese (GBK), Korean (UHC)
> > > >
> > > >
> > > >
> http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2b2.newencoding.diff.tar.gz
> > > > (608K)
> > >
> > > Looks good.  I need some people to review this for me.
> >
> > For me they look good too. The only missing part is a
> > documentation. I will ask him to write it up. If he couldn't, I will
> > do it for him.
> > > The diff is 3mb
> > > but appears to address only additions to multibyte.  I have attached a
> > > list of files it modifies.  Also, look at the sizes of the mb/
> > > directory.  It is getting large:
> > >
> > >   4       ./CVS
> > >   6       ./Unicode/CVS
> > >   3433    ./Unicode
> > >   6197    .
> >
> > Yes. We definitely need the on-the-fly encoding addition capability:
> > i.e. CREATE CHRACTER SET in the future...
> > --
> > Tatsuo Ishii
> >
> >

Address chainge.

http://www.sankyo-unyu.co.jp/Pool/postgresql-7.2.newencoding.diff.gz

Add PsqlODBC and document ...etc patch.

Eiji Tokuya

22 years agoI attach a version of my toast-slicing patch, against current CVS
Bruce Momjian [Tue, 5 Mar 2002 05:33:31 +0000 (05:33 +0000)]
I attach a version of my toast-slicing patch, against current CVS
(current as of a few hours ago.)

This patch:

1. Adds PG_GETARG_xxx_P_SLICE() macros and associated support routines.

2. Adds routines in src/backend/access/tuptoaster.c for fetching only
necessary chunks of a toasted value. (Modelled on latest changes to
assume chunks are returned in order).

3. Amends text_substr and bytea_substr to use new methods. It now
handles multibyte cases -and should still lead to a performance
improvement in the multibyte case where the substring is near the
beginning of the string.

4. Added new command: ALTER TABLE tabname ALTER COLUMN colname SET
STORAGE {PLAIN | EXTERNAL | EXTENDED | MAIN} to parser and documented in
alter-table.sgml. (NB I used ColId as the item type for the storage
mode string, rather than a new production - I hope this makes sense!).
All this does is sets attstorage for the specified column.

4. AlterTableAlterColumnStatistics is now AlterTableAlterColumnFlags and
handles both statistics and storage (it uses the subtype code to
distinguish). The previous version of my patch also re-arranged other
code in backend/commands/command.c but I have dropped that from this
patch.(I plan to return to it separately).

5. Documented new macros (and also the PG_GETARG_xxx_P_COPY macros) in
xfunc.sgml. ref/alter_table.sgml also contains documentation for ALTER
COLUMN SET STORAGE.

John Gray

22 years agoI was digging through the GiST code, and figured I'd fix up some of the
Bruce Momjian [Tue, 5 Mar 2002 05:30:40 +0000 (05:30 +0000)]
I was digging through the GiST code, and figured I'd fix up some of the
"bad smell" in that code. Stuff like function parameters that aren't
used, typos in the comments, comparison between signed and unsigned
ints, etc.

Attached is a pretty trivial patch; it compiles, but beyond that
completely untested. Unless anyone sees any problems, please apply for
7.3.

Neil Conway

22 years agoHere's a patch against 7.1.3 that fixes a problem with sending larger
Bruce Momjian [Tue, 5 Mar 2002 05:20:12 +0000 (05:20 +0000)]
Here's a patch against 7.1.3 that fixes a problem with sending larger
queries over non-blocking connections with libpq. "Larger" here
basically means that it doesn't fit into the output buffer.

The basic strategy is to fix pqFlush and pqPutBytes.

The problem with pqFlush as it stands now is that it returns EOF when an
error occurs or when not all data could be sent. The latter case is
clearly not an error for a non-blocking connection but the caller can't
distringuish it from an error very well.

The first part of the fix is therefore to fix pqFlush. This is done by
to renaming it to pqSendSome which only differs from pqFlush in its
return values to allow the caller to make the above distinction and a
new pqFlush which is implemented in terms of pqSendSome and behaves
exactly like the old pqFlush.

The second part of the fix modifies pqPutBytes to use pqSendSome instead
of pqFlush and to either send all the data or if not all data can be
sent on a non-blocking connection to at least put all data into the
output buffer, enlarging it if necessary. The callers of pqPutBytes
don't have to be changed because from their point of view pqPutBytes
behaves like before. It either succeeds in queueing all output data or
fails with an error.

I've also added a new API function PQsendSome which analogously to
PQflush just calls pqSendSome. Programs using non-blocking queries
should use this new function. The main difference is that this function
will have to be called repeatedly (calling select() properly in between)
until all data has been written.

AFAICT, the code in CVS HEAD hasn't changed with respect to non-blocking
queries and this fix should work there, too, but I haven't tested that
yet.

Bernhard Herzog

22 years agoPrevious patch to mark UNION outputs with common typmod (if any) breaks
Tom Lane [Tue, 5 Mar 2002 05:10:24 +0000 (05:10 +0000)]
Previous patch to mark UNION outputs with common typmod (if any) breaks
three-or-more-way UNIONs, as per example from Josh Berkus.  Cause is a
fragile assumption that one tlist's entries will exactly match another.
Restructure code to make that assumption a little less fragile.

22 years agoDoug Fields patch to prevent exception being thrown on zero length arrays
Dave Cramer [Tue, 5 Mar 2002 03:46:03 +0000 (03:46 +0000)]
Doug Fields patch to prevent exception being thrown on zero length arrays

22 years agopatch from Zhenbang Wei
Dave Cramer [Tue, 5 Mar 2002 03:33:29 +0000 (03:33 +0000)]
patch from Zhenbang Wei
The errors_zh_TW.properties must be translated using native2ascii or it
will raise an exception. Please replace the old file.

22 years agoAdd:
Bruce Momjian [Tue, 5 Mar 2002 03:32:11 +0000 (03:32 +0000)]
Add:

>  o allow replication over unreliable or non-persistent links

22 years agoPatch from Ryouichi Matsuda
Dave Cramer [Tue, 5 Mar 2002 03:29:30 +0000 (03:29 +0000)]
Patch from Ryouichi Matsuda
 An attached patch corrects problem of this bug and fractional second.

 The handling of time zone was as follows:

   (a) with time zone
       using  SimpleDateFormat("yyyy-MM-dd HH:mm:ss z")
   (b) without time zone
       using  SimpleDateFormat("yyyy-MM-dd HH:mm:ss")

 About problem of fractional second,
 Fractional second was changed from milli-second to nano-second

22 years ago patch from Mitchel Friedman to fix getTables
Dave Cramer [Tue, 5 Mar 2002 03:02:52 +0000 (03:02 +0000)]
 patch from Mitchel Friedman to fix getTables

22 years agoShowing index details with \d on psql.
Bruce Momjian [Tue, 5 Mar 2002 02:42:56 +0000 (02:42 +0000)]
Showing index details with \d on psql.

Greg Sabino Mullane

22 years ago patch from Vicktor to fix Numeric decimal digits in getColumns
Dave Cramer [Tue, 5 Mar 2002 02:14:08 +0000 (02:14 +0000)]
 patch from Vicktor to fix Numeric decimal digits in getColumns

22 years agoBack out python patch:
Bruce Momjian [Tue, 5 Mar 2002 02:01:44 +0000 (02:01 +0000)]
Back out python patch:

Elliot Lee wrote:
> This patch to the python bindings adds C versions of the often-used
query
> args quoting routines, as well as support for quoting lists e.g.
> dbc.execute("SELECT * FROM foo WHERE blah IN %s", ([1,2,3],))

22 years agoThis patch to the python bindings adds C versions of the often-used
Bruce Momjian [Tue, 5 Mar 2002 00:23:13 +0000 (00:23 +0000)]
This patch to the python bindings adds C versions of the often-used
query args quoting routines, as well as support for quoting lists e.g.
dbc.execute("SELECT * FROM foo WHERE blah IN %s", ([1,2,3],))

Elliot Lee

22 years agoAdd \timing patch to psql. Times all queries.
Bruce Momjian [Tue, 5 Mar 2002 00:01:03 +0000 (00:01 +0000)]
Add \timing patch to psql.  Times all queries.

Greg Sabino Mullane

22 years agoAdd PQunescapeBytea libpq function.
Bruce Momjian [Mon, 4 Mar 2002 23:59:14 +0000 (23:59 +0000)]
Add PQunescapeBytea libpq function.

Everyone using libpq and bytea is probably having to invent this wheel..

Patrick Welche

22 years agoImprove libpgeasy API for multiple result sets, add example.
Bruce Momjian [Mon, 4 Mar 2002 18:50:21 +0000 (18:50 +0000)]
Improve libpgeasy API for multiple result sets, add example.

22 years agoAdd Assert check to catch vsnprintf overrunning its buffer. (Seen to
Tom Lane [Mon, 4 Mar 2002 18:34:02 +0000 (18:34 +0000)]
Add Assert check to catch vsnprintf overrunning its buffer.  (Seen to
occur on Solaris 7 in 64-bit mode, for one.)

22 years agoUpdate FAQ_Solaris with info about gcc 2.95.1 problems and how to work
Tom Lane [Mon, 4 Mar 2002 17:47:11 +0000 (17:47 +0000)]
Update FAQ_Solaris with info about gcc 2.95.1 problems and how to work
around 64-bit vsnprintf bug.

22 years agoMake port makefile slightly less crufty.
Tom Lane [Mon, 4 Mar 2002 17:43:32 +0000 (17:43 +0000)]
Make port makefile slightly less crufty.

22 years agoModify:
Bruce Momjian [Mon, 4 Mar 2002 16:50:36 +0000 (16:50 +0000)]
Modify:

< * Add GUC parameter for eurodates
> * Add GUC parameter for DATESTYLE

22 years agoAdd:
Bruce Momjian [Mon, 4 Mar 2002 16:20:31 +0000 (16:20 +0000)]
Add:

> * Add GUC parameter for eurodates

22 years agoFix very ancient breakage in alter-table tests: apparently, there was a
Tom Lane [Mon, 4 Mar 2002 05:17:55 +0000 (05:17 +0000)]
Fix very ancient breakage in alter-table tests: apparently, there was a
type named 'dt' back in Postgres 4.2, and the regression test wasn't
updated when it was removed.  Per report from Patricia Holben of Great
Bridge.

22 years agoIf presented db path has a trailing slash, remove it to avoid generating
Tom Lane [Mon, 4 Mar 2002 04:45:27 +0000 (04:45 +0000)]
If presented db path has a trailing slash, remove it to avoid generating
double slashes in generated filenames.  This is not strictly necessary
on standard Unixen, but I'm being a neatnik...

22 years agoFix bug in extract/date_part for milliseconds/miscroseconds and
Tatsuo Ishii [Mon, 4 Mar 2002 03:55:50 +0000 (03:55 +0000)]
Fix bug in extract/date_part for milliseconds/miscroseconds and
timestamp/timestamptz combo. Now extract/date_part returns
seconds*1000 or 1000000 + fraction part as the manual stats.
regression test are also fixed.

See the thread in pgsql-hackers:

Subject: Re: [HACKERS] timestamp_part() bug?
Date: Sat, 02 Mar 2002 11:29:53 +0900

22 years agoFix bogus error check in pg_execute, per report from lbayuk@mindspring.com.
Tom Lane [Mon, 4 Mar 2002 02:41:49 +0000 (02:41 +0000)]
Fix bogus error check in pg_execute, per report from lbayuk@mindspring.com.

22 years agoFurther work on elog cleanup: fix some bogosities in elog's logic about
Tom Lane [Mon, 4 Mar 2002 01:46:04 +0000 (01:46 +0000)]
Further work on elog cleanup: fix some bogosities in elog's logic about
when to send what to which, prevent recursion by introducing new COMMERROR
elog level for client-communication problems, get rid of direct writes
to stderr in backend/libpq files, prevent non-error elogs from going to
client during the authentication cycle.

22 years agoUpdate FAQ.
Bruce Momjian [Sun, 3 Mar 2002 18:35:46 +0000 (18:35 +0000)]
Update FAQ.

22 years agoCatcaches can now store negative entries as well as positive ones, to
Tom Lane [Sun, 3 Mar 2002 17:47:56 +0000 (17:47 +0000)]
Catcaches can now store negative entries as well as positive ones, to
speed up repetitive failed searches; per pghackers discussion in late
January.  inval.c logic substantially simplified, since we can now treat
inserts and deletes alike as far as inval events are concerned.  Some
repair work needed in heap_create_with_catalog, which turns out to have
been doing CommandCounterIncrement at a point where the new relation has
non-self-consistent catalog entries.  With the new inval code, that
resulted in assert failures during a relcache entry rebuild.

22 years agoUpdate FAQ.
Bruce Momjian [Sun, 3 Mar 2002 16:02:31 +0000 (16:02 +0000)]
Update FAQ.

22 years agoDefault server_min_messages is NOTICE.
Bruce Momjian [Sun, 3 Mar 2002 02:11:09 +0000 (02:11 +0000)]
Default server_min_messages is NOTICE.

22 years agoCause regression tests to pass again after elog changes.
Tom Lane [Sun, 3 Mar 2002 01:05:22 +0000 (01:05 +0000)]
Cause regression tests to pass again after elog changes.

22 years agoSome kibitzing about appropriate elog levels for sinval messages.
Tom Lane [Sat, 2 Mar 2002 23:35:57 +0000 (23:35 +0000)]
Some kibitzing about appropriate elog levels for sinval messages.