  			Chage Logs
			==========

  This document details the changes between this version and the previous 
version.


2002.07.17 : pgbash-2.4a.2

  1. Add "REINDEX" as a SQL reserved word.     
  2. Fix a bug of the single/double quotaion surrounded by 
     the double/single quotation.                       
     ex.) insert into "test" values(123,'name"name');
          select code as "He's code" from test where  name='sanme"name';
  3. Add the functionality of processing the single quotation data
     surrounded by \'.   
     ex.) DATA="I can't"
          select * from test where mesg=\'$DATA\';

  # A bug of "REINDEX" was reported by ISHIDA akio.
  # A bug of single/double quotation was reported  by Tomoo Nomura.

2002.05.10 : pgbash-2.4a.1

  1. Allow the database user name as number(e.g. '00091').
  2. Fix   static variables bug in read_EXEC_SQL_token().
  3. Add the functionality of describing the '#' comment in SQL.

2002.02.12 : pgbash-2.4a  (Apply to bash-2.05a.)
2002.02.10 : pgbash-2.4 

  1. Apply to PostgreSQL-7.0/7.1/7.2.
  2. Fix a bug of Ctrl+C to cancell query.
  3. Fix a bug of Pgbash original copy command when using delimiter.
  3. Fix a bug of parsing ';' between left and right parenthesis in SQL.
    (Ploblem reported by Dias Badekas)
  4. Change TRUE/FALSE to ON/OFF value at the 'set OPTION' statement.
  5. Add 'set OPTION_HEADERTR/HEADERTH/BODYTAG/INPUTTAG/INPUTSIZE' commands.
  6. Add the functionality of 'EXEC_SQL_PREPARE' shell variable.
  7. Add the functionality of 'SELECT INTO :host_var' clause.
  8. Add the functionality of reading the /etc/pgbashrc file if ~/.pgbashrc 
  9  file does not exist.
 10. Add the functionality which displays line_feed/tab/carriage_return as 
     '\n'/'\t'/'\r'.
 11. Add 'pgbash_description' table for large_object functions.
 12. Modify output format for plain text table (like psql).
 13. Add "IDENTIFIED BY | USING | /" at the password syntax of the CONNECT statement.
 14. Add the client_encoding in the connection table list('?m' command).

 (pgbash-2.3 is not released)

2001.05.01 : pgbash-2.2

  1. Add the patches for bash-2.03, bash-2.04 and bash-2.05.
  2. Add the functionality of printing Database information into pgbashrc.
  3. Delete the exec_sql option '-l,-p,-r'.
  4. Modify the interactive help menu in pgbashrc.
  5. Add 'set <option_name>[=value];' statement.
  6. Add  option_name shell variables named 'OPTION_xxxx'.
  7. Add the functionality of lo_import,lo_export and lo_unlink.
  8. Add POSTGRESQL_VERSION shell variable.
  9. Change the SQL help version 7.0.x to version 7.1. 
 10. Fix a delimiter string bug of 'copy table()' statement. 

2000.05.10 : pgbash-2.1

  1.Apply to both of PostgreSQL 6.5 and 7.0. 
  2.Fix for the signal processing. 
  3.Fix the bug that the decision of SQL was only a small letter. 
  4.Improve that a COPY statement is executed as a new COPY statement of pgbash. 
  5.Fix for getting a error code in COPY statement. 
  6.Improved that it holds a client_encoding for every connection of the DB. 
  7.Change a handling of client_encoding in PSprint() in the same way as 7.0. 
  8.Delete "|more" in pgbashrc. 
  9.Improve that IP address can be used as host name. 
 10.Change a Database lists like version7.0 psql. 
 11.Add "u"(User name list) option in the Help menu. 
 12.Change "v" option to PostgreSQL and PGBASH version in the Help menu. 

2000.01.11 : pgbash-2.0.1 

  1.Change MULTIBYTE functions to static link. 
  2.Stop the system messages in a SHELL SCRIPT. 

1999.12.25 : pgbash-2.0 

  1.The patch is put for lexical analysis division of the bash-2.03
    main body, SQL statement would be able to be directly executed. 
  2.The declare,set,select command of bash will have been changed 
    as following, since priority was given to SQL statement. 
    declare ==> declares
    set     ==> sets
    select  ==> selects
  3.Pgbash-1.2.x executes a SQL by linking "libpgbash.so" library 
    dynamically. But, Pgbash-2.0 executes a SQL by linking statically.
    Therefore, it did not need to use the "enable -f" command. 
  4.The content of pgbashrc was changed. 
  5.The script for the test of the test directory was changed. 
  6."list table objects(exec_sql -p '*') was changed to display the
    table name. 

1999.11.30 : pgbash-1.2.3

  1.Add displaying of recent inserted OID (type "exec_sql -s")

1999.10.31 : pgbash-1.2.2 (pgbash-1.2.1 bug fix)

  1.Add __P definition.(UnixWare7, Solaris2.6x86 trouble)
  2.Change "pgbash"file.(tcsh or csh login shell troubl

1999.10.30 : pgbash-1.2.1

  1.The improvement of the interactive operational environment. 
  2.The addition of the original COPY (with -y option) function. 
  3.By originally making the include file of bash, the change of
    Makefile was made unnecessary. 

