Commits · 2b56a9646a36c5df63a05ea22392a653bf3170cc · Abuhujair Javed / Postgres FD Implementation

10 Sep, 2003 10 commits
- Add: · 2b56a964
  Bruce Momjian authored Sep 10, 2003
```
> * Issue NOTICE if foreign key data type doesn't match primary key
```
  2b56a964
- Add: · e303be78
  Bruce Momjian authored Sep 10, 2003
```
> * Have EXPLAIN ANALYZE highlight poor optimizer estimates
```
  e303be78
- This patch fixes a trivial typo in the CREATE FUNCTION ref page. · 73cfa77e
  Bruce Momjian authored Sep 10, 2003
```
Neil Conway
```
  73cfa77e
- copydir() is supposed to return on failure, not elog(ERROR). Reduce · 336ebee2
  Tom Lane authored Sep 10, 2003
```
ERROR to WARNING so we keep control.
```
  336ebee2
- Add HINT if CREATE FUNCTION specifies a valid language, but the language · d16b8776
  Bruce Momjian authored Sep 10, 2003
```
isn't loaded into the database.
```
  d16b8776
- Add quotes to vacuum/analyze for upper/lowercase table names, per · a72fce03
  Bruce Momjian authored Sep 10, 2003
```
Matthew T. O'Connor.
```
  a72fce03
- Some uppercase type definitions were left. · 573f4500
  Michael Meskes authored Sep 10, 2003
  
  573f4500
- Here is a patch to make PostgreSQL use a full path in DT_SONAME for · 0f310ee7
  Bruce Momjian authored Sep 10, 2003
```
UnixWare.

Larry Rosenman
```
  0f310ee7
- Clean up printability test in dbase code. · a9953097
  Bruce Momjian authored Sep 10, 2003
  
  a9953097
- Add: · 22b305ad
  Bruce Momjian authored Sep 10, 2003
```
> * Have pg_dump -c clear the database using dependency information
```
  22b305ad
09 Sep, 2003 9 commits
- Some "feature not supported" errors are better syntax errors, because the · 33d4c828
  Peter Eisentraut authored Sep 09, 2003
```
feature they complain about isn't a feature or cannot be implemented without
definitional changes.
```
  33d4c828
- Improve wording of increasing page size. · 3610f083
  Bruce Momjian authored Sep 09, 2003
  
  3610f083
- Remove a bunch of content-free Diagnostics sections, as per previous · d4019b7c
  Tom Lane authored Sep 09, 2003
```
discussion.  (Still have some work to do editing the remainder.)
```
  d4019b7c
- Update max tasble size to 32TB. · 1815f617
  Bruce Momjian authored Sep 09, 2003
  
  1815f617
- Update comments about how locale settings are handled. · d0bfe7f1
  Tom Lane authored Sep 09, 2003
  
  d0bfe7f1
- Clean up some unused import warnings in the example jdbc code · 62b53acc
  Barry Lind authored Sep 09, 2003
  
  62b53acc
- Fixed a few bugs that came up on pgsql-interfaces. · 2fab6168
  Michael Meskes authored Sep 09, 2003
  
  2fab6168
- Additional SQLState work for JDBC - thanks to Kim Ho at Redhat for input on this · 5cdf771d
  Barry Lind authored Sep 09, 2003
```
 Modified Files:
 	jdbc/build.xml jdbc/org/postgresql/core/QueryExecutor.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1DatabaseMetaData.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
 	jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
 	jdbc/org/postgresql/util/PSQLState.java
```
  5cdf771d
- - Added Dave patch for Informix handling of numeric/int conversion. · fcdf0e22
  Michael Meskes authored Sep 09, 2003
```
- Changed all new datatypes to lowercase.
- Fixed rounding bug in numerical types.
```
  fcdf0e22
08 Sep, 2003 8 commits

Fix a couple minor typos. · fd65be4a
Tom Lane authored Sep 08, 2003

fd65be4a

Peter Eisentraut authored Sep 08, 2003

Use question marks rather than brackets to delimit optional elements in
Tcl synopses.

Fix stylesheet misfeature leading to excessively long cross-reference text
when linking to a different "part".

Remove <body> attributes -- CSS stylesheets should handle that.

Improve bibliography formatting.

Add fast-forward links for more convenient navigation.

6de93c05

Add: · e54965c0

Bruce Momjian authored Sep 08, 2003

       o Allow ALTER TABLE to change constraint deferrability and actions

e54965c0

"statenebt" ? · 44279693
Tom Lane authored Sep 08, 2003

44279693
Document a bunch of formerly-undocumented date/time operators, · f176e379
Tom Lane authored Sep 08, 2003
```
including the SQL-spec OVERLAPS construct.
```
f176e379
Opps, can't forget the new file. This is part of the last commit to apply · 05dddf40
Barry Lind authored Sep 08, 2003
```
the redhat patch for SQLState support.

 Added Files:
 	PSQLState.java
```
05dddf40

This set of changes applies a patch from KHO at redhat to add some SQLState · 0378a269

Barry Lind authored Sep 08, 2003

support to the jdbc driver.
That patch needed some work: it assumed the sqlcode in a server message was
fixed in its position, the patch lost the ability to pass exceptions, and the
patch missed a couple of places where server errors where being received.
In addition to fixing the above, I also added full support for the V3 protocol
error message syntax, I reversed the order of arguments in the PSQLException
constructor to more closely follow the constructors for SQLException, I changed
the new constructors that take PSQLState to take Object for additional
parameters as the old ones did.
Still todo are to add SQLState values to all existing exceptions thrown in the
driver and add support for parsing the V3 protocol format for notices.

 Modified Files:
 	jdbc/build.xml jdbc/org/postgresql/Driver.java.in
 	jdbc/org/postgresql/errors.properties
 	jdbc/org/postgresql/core/Encoding.java
 	jdbc/org/postgresql/core/PGStream.java
 	jdbc/org/postgresql/core/QueryExecutor.java
 	jdbc/org/postgresql/fastpath/Fastpath.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Connection.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1ResultSet.java
 	jdbc/org/postgresql/jdbc1/AbstractJdbc1Statement.java
 	jdbc/org/postgresql/jdbc2/AbstractJdbc2ResultSet.java
 	jdbc/org/postgresql/jdbc2/AbstractJdbc2Statement.java
 	jdbc/org/postgresql/util/MessageTranslator.java
 	jdbc/org/postgresql/util/PSQLException.java

0378a269

Avoid using s_addr as a local variable name, to work around broken · e702b04c
Tom Lane authored Sep 08, 2003
```
system headers on Unixware.
```
e702b04c

07 Sep, 2003 10 commits

Update URL. · 1a9a3467
Bruce Momjian authored Sep 07, 2003

1a9a3467
Update URL to be momjian.postgresql.org. · b58bd87f
Bruce Momjian authored Sep 07, 2003

b58bd87f
autoconf run. · 01a0e973
Bruce Momjian authored Sep 07, 2003

01a0e973
Add $srcdir for Win32 builds, from Peter. · 96b4a9ac
Bruce Momjian authored Sep 07, 2003

96b4a9ac
Remove another useless, counterproductive srandom() call. · 2f606ed8
Tom Lane authored Sep 07, 2003

2f606ed8

Remove geqo_random_seed parameter. Having geqo reset the global random() · 48beecda

Tom Lane authored Sep 07, 2003

sequence every time it's called is bogus --- it interferes with user
control over the seed, and actually decreases randomness overall
(because a seed based on time(NULL) is pretty predictable).  If you really
want a reproducible result from geqo, do 'set seed = 0' before planning
a query.

48beecda

Remove check on source address of a statistics packet. Check was broken · 75c35e0f

Tom Lane authored Sep 07, 2003

by recent IPv6 changes, and since it's redundant with a kernel-level check
anyway, it seems not worth trying to fix it.  Per recent discussions.

75c35e0f

Changes for MinGW/WIN32: · 4b407f6c

Bruce Momjian authored Sep 07, 2003

        o allow configure to see include/port/win32 include files
        o add matching Win32 accept() prototype
        o allow pg_id to compile with native Win32 API
        o fix invalide mbvalidate() function calls (existing bug)
        o allow /scripts to compile with native Win32 API
        o add win32.c to Win32 compiles (already in *.mak files)

4b407f6c

Make the default pg_hba.conf include an entry for ::1 only if configure · 7703e55c
Tom Lane authored Sep 07, 2003
```
set HAVE_IPV6.  Per recent discussions.
```
7703e55c

load_file() has to remove pre-existing shlibs that match the new file · f4ed6509

Tom Lane authored Sep 07, 2003

on either name or inode; otherwise load_external_function() won't do
anything.  At least on Linux, it appears that recompiling a shlib leads
to a new file with a different inode, so the old code failed to detect
a match.

f4ed6509

06 Sep, 2003 2 commits
- Make all valid uses of the COLLATE clause yield the same result: a syntax · 3e20a726
  Peter Eisentraut authored Sep 06, 2003
```
error.  There is no point in providing some kind of forward compatibility
now, because no one can tell what a future implementation will look like.
```
  3e20a726
- Rename variables for clarity. · 4060f075
  Bruce Momjian authored Sep 06, 2003
  
  4060f075
05 Sep, 2003 1 commit
- Second try at IPv4-to-v6 mapping code; avoid assuming that the struct · 92aa4622
  Tom Lane authored Sep 05, 2003
```
returned by getaddrinfo_all will have enough room for an IPv6 address.
```
  92aa4622