Mercurial > libervia-pubsub
annotate db/gateway.sql @ 456:b52ebc45b8e3
psql: fix RSM requests handling:
the sub-query to get row number to filter on for `before` and `after` was missing some
filters and thus incorrect. This has been fixed by re-using `_appendSourcesAndFilters`.
rel: 399
author | Goffi <goffi@goffi.org> |
---|---|
date | Thu, 30 Sep 2021 16:55:05 +0200 |
parents | 274a45d2a5ab |
children |
rev | line source |
---|---|
206
274a45d2a5ab
Implement root collection that includes all leaf nodes.
Ralph Meijer <ralphm@ik.nu>
parents:
diff
changeset
|
1 create table callbacks ( |
274a45d2a5ab
Implement root collection that includes all leaf nodes.
Ralph Meijer <ralphm@ik.nu>
parents:
diff
changeset
|
2 service text not null, |
274a45d2a5ab
Implement root collection that includes all leaf nodes.
Ralph Meijer <ralphm@ik.nu>
parents:
diff
changeset
|
3 node text not null, |
274a45d2a5ab
Implement root collection that includes all leaf nodes.
Ralph Meijer <ralphm@ik.nu>
parents:
diff
changeset
|
4 uri text not null, |
274a45d2a5ab
Implement root collection that includes all leaf nodes.
Ralph Meijer <ralphm@ik.nu>
parents:
diff
changeset
|
5 PRIMARY KEY (service, node, uri) |
274a45d2a5ab
Implement root collection that includes all leaf nodes.
Ralph Meijer <ralphm@ik.nu>
parents:
diff
changeset
|
6 ); |
274a45d2a5ab
Implement root collection that includes all leaf nodes.
Ralph Meijer <ralphm@ik.nu>
parents:
diff
changeset
|
7 |