TIME ZONE SUPPORT FOR POSTGRES
Hi,
I am trying Akiban SQL Parser to parse and extract table definition from our DDL file. It works perfectly except for one thing. We use Postgresql database which support the TIMESTAMP WITH TIME ZONE datatype. When I try to parse a DDL which contains this type of column I get the following error:
com.akiban.
Was expecting:
"default" ...
at com.akiban.
at com.centro.
at com.centro.
Caused by: com.akiban.
Was expecting:
"default" ...
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
at com.akiban.
... 2 more
Here is a sample DDL:
-------
create table my_sample_table(
MY_VARCHAR_COLUMN VARCHAR(10),
MY_INT_COLUMN INTEGER,
MY_TIMESTAMP_
I'd appreciate if you can provide a fix or a workaround. Thanks very much.
- Jay
Question information
- Language:
- English Edit question
- Status:
- Answered
- Assignee:
- No assignee Edit question
- Last query:
- Last reply:
Can you help with this problem?
Provide an answer of your own, or ask Jay Muthukumarasamy for more information if necessary.