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

Dennis Daupert ddaupert at sbcglobal.net
Wed Jan 2 14:04:24 GMT 2008


John:
> I may be confused about what you are trying to do.

Dennis:
And I probably am not expressing my self unconfusingly
enough ;-) 

I am trying to get a Catalyst application running posted 
by another developer. He wrote the app to use mysql
database, but I'd rather not have to install mysql on
my box. I am using postgresql 8.1. The developer provided
an .sql file consisting of "CREATE TABLE foo" statements,
so I tried translating it into Pg-speak to set up the
app's database tables.

Although I've used Pg for a few months, I have a lot to 
learn. I used SQL::Translator to try to get the table
creation syntax right for Pg. I've seen the mysql blob
data type before, but up to now I hadn't run into
Pg's bytea. When I got the error message, I googled
around, and had a look through the Pg doco, but didn't
spot anything that helped me understand what the problem
is.

I am not at the point yet of worrying about the schema
classes. I am only worrying about setting up the tables
in the Pg database. 

Is the mud any clearer? 

/dennis

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20080102/653224d8/attachment.htm


More information about the DBIx-Class mailing list