structured omega

23 May

SQL::Translator::Producer::PostgreSQL problems

written by Andreas Marienborg

So, I'm getting pretty close to having deployable SQL apps now. One of the last stumbeling blocks now is the SQL producer for Pg. Firstly, it quotes tablenames with "". And that results in pg barfing later on.

Cause, in PG, "SchemaVersions" and SchemaVersions are two different things. So I go hunting in PostgreSQL.pm to track it down, and while there, I notice that timestamp columns arent allowed default values. Thats certainly strange, as I have several apps that need just that.. Guess that will also have to be fixed somehow :)

Your captcha is:






Only the comment itself is required, but if you supply your email we'll gladly load your gravatar. We won't use your email for any other purpose or sell it to nigerian business men. Promise.
A live preview of your comment will appear in this box.