Skip to main content

Where are database comments stored?

  • December 9, 2014
  • 7 replies
  • 10 views

norbert_krupa
Forum|alt.badge.img+2
When creating a database, there is a field for comments in the admintools UI:
 Vertica Analytic Database 7.1.0-1 Administration Tools  +------------------------------------------------------+-  | Create Database                                      |  | +--------------------------------------------------+ |  | |Database name:                                    | |  | |Comments:                                         | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | +--------------------------------------------------+ |  +------------------------------------------------------+  |         <  OK  >    < Cancel >    < Help >           |  +------------------------------------------------------+
Where are these comments stored?

7 replies

Curtis_1
Forum|alt.badge.img
  • Participating Frequently
  • December 10, 2014
Seems like we had an internal conversation about this not too long. I'm not sure anyone actually found them. 

There is a table called "comments" but it seems it doesn't actually store the database comments. I was under the impression that it did at one time, but someone with an older version verified that it did not. 

So, apparently, database comments are getting filed away into the proverbial bit bucket, it would seem.


eli_revach
Forum|alt.badge.img+2
  • Participating Frequently
  • December 11, 2014
I have no test it  ! , did you try  look into the Comments.txt file ?  its located in /opt/vertica/bin/help

Mint_Notini
  • New Participant
  • December 11, 2014
I did some testing and found that the comment created during database creation does not get saved to any file in help.

norbert_krupa
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • December 11, 2014
I then have an enhancement request to make this field functional.

Bhawana
Forum|alt.badge.img
  • Participating Frequently
  • December 16, 2014
Hi Norbert,

I will try it on my database if needed I will file an enchantment request on this.


Regards

Bhawana

norbert_krupa
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • December 16, 2014

Thank you very much!


Bhawana
Forum|alt.badge.img
  • Participating Frequently
  • December 16, 2014
Hi Norbert,

Enchantment request has been filed.

Regards

Bhawana