Hi everybody,
my database is composed of multiple schemata, one for each customer, and
some global views which do UNION across schemata.
I create a new customer with a single transaction, with queries like:
CREATE TABLE table1 WITHOUT OIDS AS
TABLE base_template.table1 WITH NO DATA;
base_template
2016-07-05 16:01 GMT+02:00 Adrian Klaver :
>
> Does the server log have the details, per above?
No, it copies just the schema from base_template with a CREATE TABLE x AS
base_template.x WITH NO DATA.
2016-07-05 17:24 GMT+02:00 Tom Lane :
> I think it'd likely be enough to add the FKs one at a
lobal
views so how can I update these global views without interfering with other
processes?
Should I avoid using these views and build by myself the queries with code?
Is there another better approach for finding results with this type of
architecture?
Thanks.
2016-07-06 9:43 GMT+02:00 Chri
2016-07-08 20:58 GMT+02:00 John R Pierce :
> On 7/8/2016 11:52 AM, Paul Tilles - NOAA Federal wrote:
>
>> I am currently running Version 9.3.10 of postgres with RHEL 6. I am
>> going to upgrade my O/S soon to RHEL 7. Do I need to upgrade to version
>> 9.4.x of postgres?
>>
>
> was 9.3 installed f
