SuSE Linux 8.2 (i586)
PostgreSQL REL7_4_STABLE (cvs), 7.4
compiled with:
gcc (GCC) 3.3 20030226 (prerelease) (SuSE Linux)
flex version 2.5.4
bison (GNU Bison) 1.875
PostgreSQL config.status 7.4
configured by ./configure, generated by GNU Autoconf 2.53,
  with options "'--prefix=/opt/pgsql' '--enable-integer-datetimes'
'--enable-thread-safety' '--disable-largefile' '--with-java'
'--with-pam' '--with-openss' '--with-gnu-ld'"

To repeat:

$ /opt/pgsql/bin/psql
Welcome to psql 7.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

olleg=# \set
VERSION = 'PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.3 20030226 (prerelease) (SuSE Linux)'
AUTOCOMMIT = 'on'
VERBOSITY = 'default'
DBNAME = 'olleg'
USER = 'olleg'
PORT = '5432'
ENCODING = 'KOI8'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
HISTSIZE = '500'
olleg=# \set AUTOCOMMIT OFF
olleg=# \set
VERSION = 'PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc
(GCC) 3.3 20030226 (prerelease) (SuSE Linux)'
AUTOCOMMIT = 'OFF'
VERBOSITY = 'default'
DBNAME = 'olleg'
USER = 'olleg'
PORT = '5432'
ENCODING = 'KOI8'
PROMPT1 = '%/%R%# '
PROMPT2 = '%/%R%# '
PROMPT3 = '>> '
HISTSIZE = '500'
olleg=# begin;
BEGIN
olleg=# select now();
              now
-------------------------------
 2003-11-28 18:15:59.063438+03
(1 row)

olleg=# select now();
              now
-------------------------------
 2003-11-28 18:15:59.063438+03
(1 row)
olleg=# commit;
COMMIT
olleg=# select now();
              now
-------------------------------
 2003-11-28 18:16:42.484651+03
(1 row)

olleg=# select now();
              now
-------------------------------
 2003-11-28 18:16:43.085406+03
(1 row)
olleg=# commit;
WARNING:  there is no transaction in progress
COMMIT

--
Olleg




---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to