ERROR 5287: Unsupported SHOW option SESSION_CHARACTERISTICS

Moderator: NorbertKrupa

Post Reply
billykopecki
Beginner
Beginner
Posts: 42
Joined: Thu Apr 19, 2012 9:03 pm

ERROR 5287: Unsupported SHOW option SESSION_CHARACTERISTICS

Post by billykopecki » Fri Jan 25, 2013 2:11 pm

Hi,

In vsql shouldn't the following command show me my session's transaction isolation level?

Code: Select all

dbadmin=> SHOW SESSION_CHARACTERISTICS;
ERROR 5287:  Unsupported SHOW option SESSION_CHARACTERISTICS
At least that's my understanding of what is listed on page 934 of the 6.1 SQL Reference Manual.pdf...

Am I not using the SHOW command correctly? I can show other settings okay:

Code: Select all

dbadmin=> SHOW STANDARD_CONFORMING_STRINGS;
            name             | setting
-----------------------------+---------
 standard_conforming_strings | on
(1 row)
Thanks.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: ERROR 5287: Unsupported SHOW option SESSION_CHARACTERIS

Post by JimKnicely » Mon Jan 28, 2013 1:06 pm

Hi,

If you do a SHOW ALL you'll see that session_characteristics isn't one of the valid settings that can be displayed.

These are the settings that can be shown:
  • locale
    autocommit
    standard_conforming_strings
    escape_string_warning
    datestyle
    intervalstyle
    timezone
    search_path
    transaction_isolation
    transaction_read_only
    resource_pool
    memorycap
    tempspacecap
    runtimecap
    enabled roles
    available roles
I think you'd be interested in the transaction_isolation setting!

Code: Select all

dbadmin=> SHOW transaction_isolation;
         name          |    setting
-----------------------+----------------
 transaction_isolation | READ COMMITTED
(1 row)
I hope this helps!
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

billykopecki
Beginner
Beginner
Posts: 42
Joined: Thu Apr 19, 2012 9:03 pm

Re: ERROR 5287: Unsupported SHOW option SESSION_CHARACTERIS

Post by billykopecki » Mon Jan 28, 2013 2:29 pm

Yup, that's what I needed! Thanks for the quick response!

Post Reply

Return to “vSQL”