When was a sequence created?

[Jbaskin]

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!

[id10t]

HI!

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$ 

Also looking for sequence OID in catalog (it must refer to some object if creation time is stored? ) didn't give a results.

[Jbaskin]

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]

#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!