What does Natvie Posgres mean?

2018-06-12 Thread bto...@computer.org
When someone, e.g., as appeared in a recent and some older pgsql-jobs messages, says "Native Postgres", what do you suppose that means? Does it mean something different than just "PostgreSQL"? Is the word "Native" just noise, or does it actually refer to something specific? A quick google s

Re: Enforce primary key on every table during dev?

2018-03-01 Thread bto...@computer.org
- Original Message - > From: "Tim Cross" > Sent: Wednesday, February 28, 2018 4:07:43 PM > > Jeremy Finzel writes: > > > We want to enforce a policy, partly just to protect those who might forget, > > for every table in a particular schema to have a primary key. This can't > > be done

Re: Alter view with dependence without drop view!

2018-01-30 Thread bto...@computer.org
One way I have approached this problem is: 1) Use PgAdmin attempt the change. 2) Examine the error report PgAdmin displays that identifies which dependent views are preventing your progress. 3) Wrap your original DDL from step 1 within the DROP and CREATE DDL associated with the closest dep