Commits · d4d23852c17ea2f104a79fc0fdc6e02e8370cdc8 · Abuhujair Javed / Postgres FD Implementation

12 Nov, 2001 29 commits
- If the alternatives for a CASE construct all have the same typmod, · d4d23852
  Tom Lane authored Nov 12, 2001
```
use that typmod not -1 as the typmod of the CASE result.
Part of response to bug#513.
```
  d4d23852
- If the inputs of a UNION/INTERSECT/EXCEPT construct all agree on the · e433bf5a
  Tom Lane authored Nov 12, 2001
```
typmod of a particular column, mark the output with that same typmod,
not -1 as formerly.  -1 is still used if there is any disagreement.
Part of response to bug#513.
```
  e433bf5a
- fixed bug in ResultSet. Version 1.29 backed out two previous fixes (1.26 and... · 7a9ef7ee
  Barry Lind authored Nov 12, 2001
```
fixed bug in ResultSet.  Version 1.29 backed out two previous fixes (1.26 and 1.25).  This checkin add back those two previous fixes.  Problem reported by Daniel Germain
```
  7a9ef7ee
- Add some more index entries. · 3c879e37
  Peter Eisentraut authored Nov 12, 2001
  
  3c879e37
- Commit to support MD5 passwords as per the backend for 7.2. This patch was... · 3a306eef
  Barry Lind authored Nov 12, 2001
```
Commit to support MD5 passwords as per the backend for 7.2.  This patch was submitted by Jeremy Wohl jeremyw-pgjdbc@igmus.org
```
  3a306eef
- Add port number to pg_dumplo. · d7a343d5
  Bruce Momjian authored Nov 12, 2001
```
andrea gelmini
```
  d7a343d5
- Repair crash in EvalPlanQual of query involving nestloop with inner · 611afd9f
  Tom Lane authored Nov 12, 2001
```
index scan.  Problem was that link to outer tuple wasn't being stored
everyplace it needed to be.
```
  611afd9f
- Remove duplicate extern declaration. · 0f214ede
  Tom Lane authored Nov 12, 2001
  
  0f214ede
- psql's \do was going out of its way to lie about the result type of · 112bd6f0
  Tom Lane authored Nov 12, 2001
```
operators.  Should report the declared oprresult type, not the return type
of the underlying proc, which might be only binary-compatible (cf.
textcat entries).
```
  112bd6f0
- Update FAQ. · 905109f2
  Bruce Momjian authored Nov 12, 2001
  
  905109f2
- Update TODO list. · 0954ea17
  Bruce Momjian authored Nov 12, 2001
  
  0954ea17
- Tables without oids wouldn't be able to be · e506ca40
  Bruce Momjian authored Nov 12, 2001
```
used inside fk constraints, since some of the checks
in the trigger did a SELECT oid.  Since the oid wasn't
actually used, I changed this to SELECT 1.  My test
case with non-oid tables now works and fk regression
appears to run fine on my machine.

Stephan Szabo
```
  e506ca40
- Remove a bunch more no-longer-used stuff in libpq-be.h. · 93713250
  Tom Lane authored Nov 12, 2001
  
  93713250
- Update TODO list. · 26e34c9b
  Bruce Momjian authored Nov 12, 2001
  
  26e34c9b
- Suppress duplicate error messages in pq_flush. Write error messages to · 7be18072
  Tom Lane authored Nov 12, 2001
```
postmaster log with elog(DEBUG) so that they will be timestamped etc.
Once upon a time I think elog() was unsafe here, but it shouldn't be anymore.
```
  7be18072
- send() attempt for IDENT communication should retry on EINTR. · 1131ba31
  Tom Lane authored Nov 12, 2001
  
  1131ba31
- The PacketReceive/PacketSend routines aren't used anymore. · a7f6210d
  Tom Lane authored Nov 12, 2001
  
  a7f6210d
- Update MD5 documentation. · 215772ae
  Bruce Momjian authored Nov 12, 2001
  
  215772ae
- Add more MD5 documentation now that odbc/jdbc support it. · 53a4fa6b
  Bruce Momjian authored Nov 12, 2001
  
  53a4fa6b
- Sync up both files. · 67a56f22
  Bruce Momjian authored Nov 12, 2001
  
  67a56f22
- Add comments and remove CVS tag from md5.c so they remain identical. · 9937040a
  Bruce Momjian authored Nov 12, 2001
  
  9937040a
- Add comments and remove CVS tag from md5.c so they remain identical. · 36bbb249
  Bruce Momjian authored Nov 12, 2001
  
  36bbb249
- Update md5 to match. · 0611d398
  Bruce Momjian authored Nov 12, 2001
  
  0611d398
- Add comments of duplicate definitions in interfaces/odbc/md5.h. · e6e4c45a
  Bruce Momjian authored Nov 12, 2001
  
  e6e4c45a
- Add code to check that md5.c files are in sync. · 75bb1e6f
  Bruce Momjian authored Nov 12, 2001
  
  75bb1e6f
- Indent new rename.c for Tom Lane. · a83bd89d
  Bruce Momjian authored Nov 12, 2001
  
  a83bd89d
- Add md5 authentication support thanks to Bruce Momjian. · b52950cc
  Hiroshi Inoue authored Nov 12, 2001
  
  b52950cc
- Make ALTER TABLE RENAME update foreign-key trigger arguments correctly. · f14fdad8
  Tom Lane authored Nov 12, 2001
```
Brent Verner, with review and kibitzing from Tom Lane.
```
  f14fdad8
- Clean up a bunch of ScanKeyEntryInitialize calls that weren't bothering · 8bfc4373
  Tom Lane authored Nov 12, 2001
```
to apply the proper Datum conversion macros to search key values.
```
  8bfc4373
11 Nov, 2001 8 commits
- Test program needs to declare MaxBackends, per Bernd Tegge. · 801a1acc
  Tom Lane authored Nov 11, 2001
  
  801a1acc
- Defend against brain-dead QNX implementation of qsort(). · 69a59150
  Tom Lane authored Nov 11, 2001
```
Per report from Bernd Tegge, 10-Nov-01.
```
  69a59150
- In find_mergeclauses_for_pathkeys, it's okay to return multiple merge · c5c97318
  Tom Lane authored Nov 11, 2001
```
clauses per path key.  Indeed, we *must* do so or we will be unable to
form a valid plan for FULL JOIN with overlapping join conditions, eg
select * from a full join b on
a.v1 = b.v1 and a.v2 = b.v2 and a.v1 = b.v2.
```
  c5c97318
- Fix typo pointed out by bruno@wolff.to · c336b58f
  Bruce Momjian authored Nov 11, 2001
  
  c336b58f
- Fix for compiling libpq++ on Solaris with Sun SPRO6U2. · 4552ddd5
  Bruce Momjian authored Nov 11, 2001
```
Denis A Ustimenko
```
  4552ddd5
- sort_inner_and_outer needs a check to ensure that it's consumed all the · ad511a3f
  Tom Lane authored Nov 11, 2001
```
mergeclauses in RIGHT/FULL join cases, just like the other routines have.
I'm not quite sure why I thought it didn't need one --- but Nick
Fankhauser's recent bug report proves that it does.
```
  ad511a3f
- Use abbreviated connection string more widely. · 8bf1e098
  Hiroshi Inoue authored Nov 11, 2001
```
This seems to fix the trouble with PowerBuilder
reported by Magbus Weber.
```
  8bf1e098
- Defend against possibility that SSL error reporting mechanism returns · 15c21bf8
  Tom Lane authored Nov 11, 2001
```
a NULL pointer.  Per report from Stephen Pillinger 8-Nov-01.
```
  15c21bf8
10 Nov, 2001 3 commits
- Clean up usage-statistics display code (ShowUsage and friends). StatFp · f6ee99a0
  Tom Lane authored Nov 10, 2001
```
is gone, usage messages now go through elog(DEBUG).
```
  f6ee99a0
- Restructure child-exit logging messages for easier translation, · 0c1669c8
  Tom Lane authored Nov 10, 2001
```
per suggestion from Peter.
```
  0c1669c8
- Allow TIMESTAMP, VARCHAR, et al to be used as unquoted column names, · ec438886
  Tom Lane authored Nov 10, 2001
```
though alas not as unquoted function names.  De-reserve a bunch of
keywords that could have been in ColId rather than ColLabel all along.
Per recent proposal in pgsql-patches.
```
  ec438886