Index: openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-postgresql.xql,v diff -u -r1.4 -r1.5 --- openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-postgresql.xql 9 May 2018 10:11:45 -0000 1.4 +++ openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-postgresql.xql 14 Jun 2018 16:43:50 -0000 1.5 @@ -1,51 +1,12 @@ -postgresql7.1 + postgresql7.1 + + + select acs_sc_binding__exists_p(:contract,:impl) + + - - -select acs_sc_binding__exists_p(:contract,:impl) - - - - - - select impl_alias, impl_pl - from acs_sc_impl_aliases - where impl_contract_name = :contract - and impl_operation_name = :operation - and impl_name = :impl - - - - - - select - operation_desc, - coalesce(operation_iscachable_p,'f') as operation_iscachable_p, - operation_nargs, - operation_inputtype_id, - operation_outputtype_id - from acs_sc_operations - where contract_name = :contract - and operation_name = :operation - - - - - - select - element_name, - acs_sc_msg_type__get_name(element_msg_type_id) as element_msg_type_name, - element_msg_type_isset_p, - element_pos - from acs_sc_msg_type_elements - where msg_type_id = :msg_type_id - order by element_pos asc - - - -