psql bug or feature? 
Author Message
 psql bug or feature?

I don't understand following behavior of psql:-)
This is PostgreSQL 7.1.2 on Linux.
--
Tatsuo Ishii

$ psql pgimage
Welcome to psql, 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

pgimage=# \lo
       List of databases
 Database  |  Owner  | Encoding
-----------+---------+----------
 ascii     | t-ishii | EUC_JP
 foo       | t-ishii | EUC_JP
 foo1      | t-ishii | EUC_JP
 latin1    | t-ishii | LATIN2
 pgimage   | t-ishii | EUC_JP
 template0 | t-ishii | EUC_JP
 template1 | t-ishii | EUC_JP
 test      | t-ishii | EUC_JP
 testdb2   | t-ishii | EUC_JP
(9 rows)

\l: extra argument 'o' ignored
pgimage-# \lo_list
     Large objects
   ID    | Description
---------+-------------
 2401715 |
 2401723 |
 2401726 |
 2401739 |
 2401742 |
 2401754 |
 2401757 |
(7 rows)

pgimage-# select * from pg_database;
ERROR:  parser: parse error at or near "m"
pgimage=#

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 23 Nov 2003 22:37:05 GMT
 psql bug or feature?

Quote:
Tatsuo Ishii writes:
> I don't understand following behavior of psql:-)
> This is PostgreSQL 7.1.2 on Linux.

I think you're still running the 7.1.1 version of psql, because this is
one bug fixed in 7.1.2.  Try 'psql --version'.

--

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Sun, 23 Nov 2003 22:53:07 GMT
 psql bug or feature?

Quote:

> I don't understand following behavior of psql:-)

I can't replicate that misbehavior.  I'm not using MULTIBYTE though,
maybe it depends on that ...

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Sun, 23 Nov 2003 23:59:05 GMT
 psql bug or feature?

Quote:
> Tatsuo Ishii writes:

> > I don't understand following behavior of psql:-)
> > This is PostgreSQL 7.1.2 on Linux.

> I think you're still running the 7.1.1 version of psql, because this is
> one bug fixed in 7.1.2.  Try 'psql --version'.

You are right. I seem to mixed up 7.1.1 psql with 7.1.2 backend. Sorry
for the confusion.
--
Tatsuo Ishii

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl



Mon, 24 Nov 2003 09:06:26 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. IDS 7.24,7.30 Bug in data selection (Now it is a FEATURED BUG)

2. psql missing feature

3. Bug in psql tab completion

4. Possible Bug regarding temp tables (sql or psql?)

5. bug in psql

6. ISNUMERIC Bug or Feature?

7. Bug of feature?

8. undocumented feature/bug WITH CHECK CHECK

9. SQL Server 2000 sp1 Bug or Feature?

10. bug/feature with upper function?

11. Current JDBC Driver char encoding - Bug or feature?

12. privilege escalation bug or feature?


 
Powered by phpBB® Forum Software