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
_______________________________________________ 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/[EMAIL PROTECTED]
