CREATE OR REPLACE FUNCTION get_asset_ids(
_enterprise text,
_site text DEFAULT '',
_area text DEFAULT '',
_line text DEFAULT '',
_workcell text DEFAULT '',
_origin_id text DEFAULT ''
)
RETURNS SETOF integer AS '
BEGIN
RETURN QUERY
SELECT id FROM asset
WHERE enterprise = _enterprise
AND (_site = '''' OR site = _site)
AND (_area = '''' OR area = _area)
AND (_line = '''' OR line = _line)
AND (_workcell = '''' OR workcell = _workcell)
AND (_origin_id = '''' OR origin_id = _origin_id);
END;
' LANGUAGE plpgsql;
Kafka-to-postgres neustarten
sudo $(which kubectl) rollout restart deployment united-manufacturing-hub-kafkatopostgresqlv2 -n
united-manufacturing-hub --kubeconfig /etc/rancher/k3s/k3s.yaml