all indexes created for the following tables exceeds the maximum length for an index name

hotel_booking_room_occupancy_modifiers
hotel_booking_availability_calendars

resulting in failiur to create two index

      'hotel_booking_avail_cal_no_check_out_ix' => array('no_check_out'),
      'hotel_booking_avail_cal_min_occ_ix' => array(hotel_booking_availability_calendars'minimum_occupancy')

on table hotel_booking_availability_calendars.

warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "hotel_booking_availability_calendars_hotel_booking_avail_cal_no" already exists in .../includes/database.pgsql.inc on line 138.
user warning: query: CREATE INDEX hotel_booking_availability_calendars_hotel_booking_avail_cal_no_check_out_ix_idx ON hotel_booking_availability_calendars (no_check_out) in .../includes/database.inc on line 550.