Hi All, Is setting default schema (via DB.default_schema=) supposed to work for any database? Or does it have to be supported by the adapter?
I'm connecting to a Progress v9 database via JDBC, queries work correctly when specifying schema explicitly, e.g. DB[:pub__system], but:: DB[:pub__system] => #<Sequel::JDBC::Dataset: "SELECT * FROM \"PUB\".\"SYSTEM\""> DB.default_schema = 'pub' DB[:system] => #<Sequel::JDBC::Dataset: "SELECT * FROM \"SYSTEM\""> DB.database_type is nil if that matters. Sorry if I'm misunderstanding how it's supposed to work. Thanks, Michael -- Michael Gliwinski Henderson Group Information Services 9-11 Hightown Avenue, Newtownabby, BT36 4RT Phone: 028 9034 3319 ********************************************************************************************** The information in this email is confidential and may be legally privileged. It is intended solely for the addressee and access to the email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients, any opinions or advice contained in this e-mail are subject to the terms and conditions expressed in the governing client engagement leter or contract. If you have received this email in error please notify [email protected] John Henderson (Holdings) Ltd Registered office: 9 Hightown Avenue, Mallusk, County Antrim, Northern Ireland, BT36 4RT. Registered in Northern Ireland Registration Number NI010588 Vat No.: 814 6399 12 ********************************************************************************* -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
