Jim Spath on Nostr: Adventures in DBA-ing. I found out if you rename a table in PostGreSQL that's ...
Adventures in DBA-ing. I found out if you rename a table in PostGreSQL that's referenced in a view, then create a new table with the old name, of course the view uses the old table data not the new data because that's not what I expected.
#PGSQL
Published at
2024-06-25 23:16:07Event JSON
{
"id": "5d31899079a0d994f928bef5eee2c9289f94f8abe6edf81c473b34f25a2c20b0",
"pubkey": "54295cb470d978a9d46c65a02c8a94f6eddf3f0a57bd536e72b18b557fff67c5",
"created_at": 1719357367,
"kind": 1,
"tags": [
[
"t",
"pgsql"
],
[
"proxy",
"https://chaos.social/users/jspath55/statuses/112679804467449732",
"activitypub"
]
],
"content": "Adventures in DBA-ing. I found out if you rename a table in PostGreSQL that's referenced in a view, then create a new table with the old name, of course the view uses the old table data not the new data because that's not what I expected.\n#PGSQL",
"sig": "4348fda66f97e4bb0962b107c0ca37f3f2e82b9a922d8336b65f949083cebd15d5118ea080aaaf9c0c091f3902f3bc37ce81e0eb8ee6575f0ae9f305acc01344"
}
