Ron, thanks for the feedback and for teaching me a new word (bog-standard).
Tom, thanks for the feedback and extra info about pg_depend. I've tested
simple queries on all of the tables and it seems to be fine. Hopefully
nothing will turn up when we start running the more advanced queries.
Either w
er
wrote:
>
>
> On 5/27/25 7:27 AM, Richard Zetterberg wrote:
> > Hello,
> >
> > I have a read-only table that contains a set of never changing
> > categories. Each category has a unique alpha numerical ID and a
> > description. The purpose of this table is so
ext_oid
, typtypmod = -1
FROM oids AS o
WHERE oid = o.target_oid;
```
After running that query, my domain had the type text instead of varchar(7)
and all the
fkeys to my category table seems to be working.
Could this be a viable option to solve my problem? Or will I face serious
problems later down the line that I haven't discovered/considered yet?
Thanks for any insight,
Richard Zetterberg
