[Dbix-class] Help me understand and fix this Postgresql bytea error?

John Napiorkowski jjn1056 at yahoo.com
Mon Dec 31 04:00:38 GMT 2007


--- Dennis Daupert <ddaupert at sbcglobal.net> wrote:

> I've used SQL::Translator to translate a mysql
> schema file to postgresql schema file. He translates
> this:
> 
>         arg             MEDIUMBLOB,
> 
> into this:
> 
>   "arg" bytea (16777215),
> 
> But when I try to slurp the sql file into Pg, I get
> this error:
> 
> ERROR:  syntax error at or near "(" at character 93
> LINE 4:   "arg" bytea(16777215),
> 
> I do not understand this error, nor how to resolve
> it. Pg doco and googling have left me even more
> confused.
> 
> /dennis
> 

Dennis,

If you set the data_type attribute in your columns
definition, to 'btyea' everything should just work as
expected.  If not, please give me a shout.

--John


> 
> > _______________________________________________
> List:
>
http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN:
> http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive:
http://www.grokbase.com/group/dbix-class@lists.rawmode.org



      ____________________________________________________________________________________
Never miss a thing.  Make Yahoo your home page. 
http://www.yahoo.com/r/hs



More information about the DBIx-Class mailing list