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

Dennis Daupert ddaupert at sbcglobal.net
Mon Dec 31 03:22:01 GMT 2007


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


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20071230/106a3721/attachment.htm


More information about the DBIx-Class mailing list