Tom Lane <> wrote the following on 22 June 2005 15:20: > "Sean Cardus" <postgres@xxxxxxxxxx> writes: >> For example, one of the CREATE VIEW statements contains: >> WHERE (u.username = "varchar"(u.customer_id)) > > If you can change "varchar" to "text" it should still work. Thanks for the advice Tom - I've tested this and the database does import correctly. I'm just concerned that the application might be expecting a varchar column type in the returned data. I've contacted the application developers and I'm still waiting for a reply... *crosses fingers* Thanks again, Sean ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
