Commits · 2a5b6a7c9bf40b0983e78d6027eba19b34cb90bd · Abuhujair Javed / Postgres FD Implementation

11 Sep, 2003 10 commits
- This patch fixes a few missed GUC variables that were still upper case, · 2a5b6a7c
  Bruce Momjian authored Sep 11, 2003
```
makes a few more small improvements to runtime.sgml, and makes some SGML
conventions more consistent.

Neil Conway
```
  2a5b6a7c
- > It quotes table names for vacuum and analyze, and uppercases the · 3d48045a
  Bruce Momjian authored Sep 11, 2003
```
> keywords for clarity.

Yeah, this is basically what I meant, sorry I didn't get to it quicker.

However, I tested it out a little and the patch you made doesn't work
because it produces commands like:

VACUUM ANALYZE "public.FooBar"

Which doesn't work, so I made my own patch that creates commands like:

VACUUM ANALYZE "public"."FooBar"

This allows for mixed case schema names as well as tables.

Adam, can you please give this a test as you are the person who caught
the bug in the first place.

Thanks,

Matthew T. O'Connor
```
  3d48045a
- Consistenly lowercase GUC variable names, in docs and error messages. · 188eda0d
  Bruce Momjian authored Sep 11, 2003
  
  188eda0d
- This patch makes a few minor improvements to the docs: make the · 8e27be43
  Bruce Momjian authored Sep 11, 2003
```
<varname> conventions more consistent, and improve the ANALYZE ref page.

Neil Conway
```
  8e27be43
- This patch makes a number of improvements to the runtime config · 64a7b58a
  Bruce Momjian authored Sep 11, 2003
```
documentation.

Neil Conway
```
  64a7b58a
- Mention that pg_type_is_visible is used for domains as well. · ab192546
  Bruce Momjian authored Sep 11, 2003
```
Christopher Kings-Lynne
```
  ab192546
- on my timetravel.c I find a bug: after the · a5e9e51f
  Bruce Momjian authored Sep 11, 2003
```
ALTER TABLE mytable drop column last_column_of_table;

the timetravel trigger say on UPDATE/DELETE:

ERROR:  parser: parse error at end of input


Here is the patch for this bug

B?jthe Zolt?n
```
  a5e9e51f
- Here is a patch that removes contrib/array, leaving only the README with · 92e100dd
  Bruce Momjian authored Sep 11, 2003
```
some examples of the new syntax and a reference to the documentation.

Joe Conway.
```
  92e100dd
- seemed like a typo in one of the appendix tables · d768cb26
  Bruce Momjian authored Sep 11, 2003
```
Robert Treat
```
  d768cb26
- Fix missed message update, per Alvaro Herrera. · fdd93470
  Tom Lane authored Sep 11, 2003
  
  fdd93470
10 Sep, 2003 12 commits
- Update row count for \? output, used by pager. · d6a9b4e0
  Bruce Momjian authored Sep 10, 2003
  
  d6a9b4e0
- Improve error message for cp or rm failur during create/drop database, · 9cb4a28f
  Tom Lane authored Sep 10, 2003
```
per recent discussions.
```
  9cb4a28f
- 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 1 commit
- Update URL. · 1a9a3467
  Bruce Momjian authored Sep 07, 2003
  
  1a9a3467