Howdy!
Is there a way to tell when a sequence was created?
The \ds, sequences and vs_sequences and do not provide this info.
Thanks!
When was a sequence created?
Moderator: NorbertKrupa
Re: When was a sequence created?
HI!
I dont see any option:
Also looking for sequence OID in catalog (it must refer to some object if creation time is stored? ) didn't give a results.
I dont see any option:
Code: Select all
daniel@synapse:/tmp$ /opt/vertica/bin/vertica -D /vertica/test/v_test_node0001_catalog -E << EOF
> listdetails Sequence
> EOF
Catalog Editor v6.1.2-0
Sizes: 53KB chkpt, 7184KB log (42 files) [READ-ONLY]
> :Sequence
oid:45035996274075234
name:s
schema:45035996273704976
owner:45035996273704962
cache:250000
cycle:false
ordered:false
increment:1
minValue:1
maxValue:9223372036854775807
curValue:0
table:0
.
> daniel@synapse:/tmp$
Re: When was a sequence created?
Thanks. This is odd, huh? I wonder why it's not easy for us to determine when a sequence was created. Oh well. Maybe in the next release? They just have to add a create_time column to the sequences table
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: When was a sequence created?
#jbaskin, that's a great suggestion for Vertica. On a client site last week I was asked when the sequences in their database were created! I couldn't answer them because I couldn't find the information in the database!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.