Arghhhhh! Thanks, Jim! That was what I was missing...

This is driving me crazy! What am I doing wrong? :shock: dbadmin=> select to_date(20140613, 'YYYYMMDD'); ERROR 3457: Function to_date(int, unknown) does not exist, or permission is denied for to_date(int, unknown) HINT: No function matches the given name and argument types. You may need to add expli...

Hi, I know I can query the constraint_columns table to get a list of columns in my table constraint. However, there is no way to order the columns for each constraint in the position in which they were created. dbadmin=> create table c (c1 int, c2 int, c3 int, primary key (c1, c2, c3)); CREATE TABLE...

Thanks, norbertk, that is what I figured... But I wonder if showing that SQL file as part of the error is a bug? Shouldn't the error be similar to the one shown on a normal user table? dbadmin=> create table test (t varchar(1)); CREATE TABLE dbadmin=> insert into test values ('A'); OUTPUT -------- 1...

Anyone know why I might be getting this weird error?
I am using Vertica 7.0.1 on a DEV box...

Anyone know what the following errors mean when performing a backup? WARNING 4221: object_snapshot failed attempt=1: Projection test,emp_name_b0 checkpoint epoch lags snapshot epoch HINT: Tried snapshot epoch: 4221358. Retrying up to 4 times WARNING 4221: object_snapshot failed attempt=2: Projection...

it would take some 18,000 years before it overflows/explodes

Ok, I feel a lot safer now as I won't be around then