Updating history

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

  • 2003.02.210: pgbash-7.3
    1. Fix a bug of CVS form in the (pgbash original)copy command.
    2. Update 'pgbashrc' for PostgreSQL-7.3.
    3. Pgbash version number was changed into the same number as PostgreSQL.

  • 2002.07.22 : 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. Add the functionality of describing the '#' comment in SQL.

  • 2002.02.10 : pgbash-2.4a
    1. Adjust 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.
    4. Fix a bug of parsing ';' between left and right parenthesis in SQL. (reported by Dias Badekas)
    5. Change TRUE/FALSE to ON/OFF value at the 'set OPTION' statement.
    6. Add 'set OPTION_HEADERTR/HEADERTH/BODYTAG/INPUTTAG/INPUTSIZE' commands.
    7. Add the functionality of 'EXEC_SQL_PREPARE' shell variable.
    8. Add the functionality of 'SELECT INTO :host_var' clause.
    9. Add the functionality of reading the /etc/pgbashrc file if ~/.pgbashrc 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).
    15. Adjust to bash-2.05a.

    (pgbashrc-2.4)
    1. Adjust for PostgreSQL-7.2.
    2. Add the OPTION_HEADERTR/HEADERTH/BODTTAG/INPUTTAG/INPUTSIZE tag.
    3. Change TRUE/FALSE to ON/OFF value at the 'set OPTION' statement.
    4. Add _lo_list function.

    (pgbash-2.3 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 [=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.