search

jonpryor / dblinq2007

Automatically exported from code.google.com/p/dblinq2007
0 stars 0 forks source link

Postgresql array type support #333

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.
With table defined:

Create table spectra (
    spectra_id integer primary key DEFAULT nextval('spectra_id_seq'),
    amplitude double precision[],
    wavelength double precision[],
    time_stamp timestamp);"

2.
sqlmetal gives:
sqlmetal: Don't know how to convert the SQL type 'array' into a managed type.

sqlmetal version is 0.2.

Is postgresql array support planned for the future? Should I code this with 
hand coded sql via npgsql and migrate to dblinq when supported, or change the 
table definitions to bytea and parse it myself?

Original issue reported on code.google.com by JamesMBo...@gmail.com on 29 Jul 2012 at 2:58