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.



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to