In Informix, the instance is everything. Buffer pools, transaction logging,
backup and restores and all monitoring is done at the instance level
databases are just logical collections of tables in an instance.
In DB2 there is some instance configuration, but most everything is at the
database l
I've created the ltree extensioncreated a table with an ltree column called
ltree_path
In php I can access the table, insert, update, delete.but ltree operators don't
work.
select count() from schema.table
where 'A.B.C' @> ltree_path;
gives me a "could not determine polymorphic type anyrange bec
in a postgres table, thought it was
something I didn't understand yet.
On Thursday, December 24, 2020, 12:25:29 PM EST, Tom Lane
wrote:
Open _ writes:
> CREATE TYPE staffadmin.staff_roll
> as ENUM ('Not yet defined', 'Everything', &#
I'm using I have psql (PostgreSQL) 13.1 on centOS 7.1I do everything through
layers of bash scripts and bash script functions.
So posting all the code would be huge.
The scripts run as postgres
Each script step tests if that object already exists before creating
Each statement is a separate call
