Sanae Respecter on Nostr: Trying to run the psql command 'CREATE INDEX CONCURRENTLY tmp_apid_follower_address ...
Trying to run the psql command 'CREATE INDEX CONCURRENTLY tmp_apid_follower_address ON users USING btree (ap_id, COALESCE(follower_address, ''::character varying));' the FSE blog wrote about but I keep getting ERROR: relation "users" does not exist. What am I doing wrong?
CC:
pistolero (npub1ch8…sw60)Published at
2023-04-06 21:47:53Event JSON
{
"id": "b7dc6b8b1ad84f16873ca95022b0caf5818ae15ad8ded6020fd17d231ad9e7d8",
"pubkey": "9f2bea67957cf3726e1392d187b811d9e0a22d175c3b83357febbf330aff0990",
"created_at": 1680817673,
"kind": 1,
"tags": [
[
"p",
"c5cf39149caebda4cdd61771c51f6ba91ef5645919004e5c4998a4ea69f00512",
"wss://relay.mostr.pub"
],
[
"mostr",
"https://shrine.moe/objects/59decc8c-79f5-44f7-b9ad-753eefd071b9"
]
],
"content": "Trying to run the psql command 'CREATE INDEX CONCURRENTLY tmp_apid_follower_address ON users USING btree (ap_id, COALESCE(follower_address, ''::character varying));' the FSE blog wrote about but I keep getting ERROR: relation \"users\" does not exist. What am I doing wrong?\n\nCC: #[0]",
"sig": "9d440a91af52e4b920ee92c239ea1cfc25c6c6dc82914d0fd0a778b7b3f2a04142f0518064d816a3a560c9d9da239fe42d035e2044639dce4345ed2ce65386d0"
}