Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1

    Unanswered: What Causes This

    I've noticed back in 8.4 and now 9.0.2 that at times, I lose the database menu from time to time and I've only been able to fix it by logging completely out from the psql client and then right back in. I don't know what you call "it" but I'll show you below:

    Code:
    onesaf=# \l
     cpm       | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     ctia      | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     lt2portal | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     onesaf    | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                 : postgres=CTc/postgres
     template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                 : postgres=CTc/postgres
    And after I log out and back in again, it magically re-appears. Is this a PG bug?

    Code:
    onesaf=# \l
                                      List of databases
       Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges  
    -----------+----------+----------+-------------+-------------+----------------------- 
     cpm       | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     ctia      | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     lt2portal | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     onesaf    | it       | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
     template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                 : postgres=CTc/postgres
     template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                                 : postgres=CTc/postgres
    (7 rows)
    As you can see it now again cleanly labels 'Name', 'Owner, 'Encoding', etc etc etc.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    You apparently issued the \t command which (quote from the manual): "Toggles the display of output column name headings and row count footer"

  3. #3
    Join Date
    Oct 2010
    Location
    Orlando, FL
    Posts
    311
    Provided Answers: 1
    Quote Originally Posted by shammat View Post
    You apparently issued the \t command which (quote from the manual): "Toggles the display of output column name headings and row count footer"
    As usual...Shammat to the rescue! I checked my pg_history and I indeed did issue the \t when I was trying to issue \dt. It makes sense and I appreciate your knowledge.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •