mirror of
https://github.com/zitadel/zitadel.git
synced 2025-08-11 20:47:32 +00:00
20 lines
458 B
SQL
20 lines
458 B
SQL
INSERT INTO projections.current_states (
|
|
instance_id
|
|
, projection_name
|
|
, last_updated
|
|
, sequence
|
|
, event_date
|
|
, position
|
|
, filter_offset
|
|
)
|
|
SELECT instance_id
|
|
, 'projections.notifications_back_channel_logout'
|
|
, now()
|
|
, $1
|
|
, $2
|
|
, $3
|
|
, 0
|
|
FROM eventstore.events2
|
|
WHERE aggregate_type = 'instance'
|
|
AND event_type = 'instance.added'
|
|
ON CONFLICT DO NOTHING; |