aboutsummaryrefslogtreecommitdiffstats
path: root/README.md
diff options
context:
space:
mode:
authorAsbjørn Sloth Tønnesen <ast@fiberby.net>2019-09-07 13:15:52 +0000
committerAsbjørn Sloth Tønnesen <ast@fiberby.net>2019-09-07 13:15:52 +0000
commitc59f1d55b8942e41f96f868e39edff67c47434e2 (patch)
tree2d15d7f4c8a1e98f8cc2a4a022914f4227cc3988 /README.md
parenteb381cff50bc45d3072cf005aac07c91e79dcfc6 (diff)
downloadpeeringdb-simplesync-c59f1d55b8942e41f96f868e39edff67c47434e2.tar.gz
peeringdb-simplesync-c59f1d55b8942e41f96f868e39edff67c47434e2.tar.xz
peeringdb-simplesync-c59f1d55b8942e41f96f868e39edff67c47434e2.zip
handle deleted objects
Signed-off-by: Asbjørn Sloth Tønnesen <ast@fiberby.net>
Diffstat (limited to 'README.md')
-rw-r--r--README.md9
1 files changed, 3 insertions, 6 deletions
diff --git a/README.md b/README.md
index 814d561..4d613c8 100644
--- a/README.md
+++ b/README.md
@@ -43,17 +43,14 @@ SELECT
data->>'irr_as_set',
(data->>'info_prefixes4')::int pfx4,
(data->>'info_prefixes6')::int pfx6
-FROM peeringdb.net ORDER BY asn;
+FROM peeringdb.net
+WHERE deleted IS NULL
+ORDER BY asn;
```
Note: if you add an `info_prefixes4` column to the schema,
then it will automatically be used, just like the `asn` column.
-Known issues
-------------
-
-* Objects are not deleted when they are deleted from PeeringDB.
-
Disclaimer
----------