Peter Eisentraut wrote:
>You don't need to create any tables, just schemas.
>
Thanks for the help Peter, i've since resolved the problem.
The production install was in fact, 7.2.3, not 7.3.2 as I stated
earlier, my bad.
It appears that PG only started supporting schemas since 7.3.x.
I was assumming that schema names were stored in a system table
somewhere, which, upon further research, are not. My bad.
Never make assumptions :)
Been messing around with 7.4.1 since (as said i'm due an update). Its
long overdue.
Now to find a JDBC driver that lets me set Auto Commit off without
raising exceptions.
But that, as they say, is a different story.....
Cheers,
James.