> I am working around by having separate insert statements one with and one without the auto increment column.

I think this is your best bet, yes. I don't think postgres supports what you wanted to do. If you find a way (in raw sql) let me know.