Hi,
Here , we have first tried with .BAK backups. For, 43GB database-> the
backup size was ~86GB.
Then, I configured backup with .sql file. Here it was ~70GB for the same
database size.
Next, now our database size keeps increasing. As well as backup size is
also increasing. Now, backup size is
On Sun, Aug 11, 2019 at 05:31:13PM -0400, stan wrote:
> I trimmed this thread quite a bit.
>
> Thanks to the help I have received, I am making progress. I have looked a the
> recommended documentation, and I believe I am close. I have utilized the
> "debugging printf" capability here. Here is wher
I trimmed this thread quite a bit.
Thanks to the help I have received, I am making progress. I have looked a the
recommended documentation, and I believe I am close. I have utilized the
"debugging printf" capability here. Here is where I am. I have the following
function create.
DROP TRIGGER val
On 2019-08-08 10:47:47 -0700, Rich Shepard wrote:
> On Thu, 8 Aug 2019, Adrian Klaver wrote:
> > Unfortunately it does not:
> > https://code.djangoproject.com/wiki/MultipleColumnPrimaryKeys
> >
> > Given that the issue:
> > https://code.djangoproject.com/ticket/373
> > is 14 years old does not ins
On 8/10/19 7:47 PM, Souvik Bhattacherjee wrote:
Hi Adrian,
Thanks for the response.
> Yes, but you will some code via client or function that batches the
> inserts for you.
Could you please elaborate a bit on how EXP 1 could be performed such
that it uses bulk inserts?
I guess it comes do
Sorry. I thought I had cut most of the redundancy
> On Aug 11, 2019, at 2:26 AM, Peter J. Holzer wrote:
>
>> On 2019-08-10 21:01:50 -0600, Rob Sargent wrote:
>>On Aug 10, 2019, at 8:47 PM, Souvik Bhattacherjee
>>wrote:
>>
>>Hi Adrian,
>>
>>Thanks for the response.
>>
>>> Ye
Hi
> BTW, here is what I Ave tried.
>
> CREATE OR REPLACE FUNCTION check_permission()
> RETURNS trigger AS
> $BODY$
> BEGIN
> SELECT
> permit
> FROM
> permitted_work
> WHERE
> NEW.employee_key = OLD.employee_key
> A
On Sun, Aug 11, 2019 at 08:56:13AM -0400, stan wrote:
> Good morning (at least is is morning East Coast USA time).
>
> I am trying to create a function to validate an attempted record
> insert, and I am having a hard time coming up with syntax that
> is acceptable.
>
> Here is the scenario I hav
Good morning (at least is is morning East Coast USA time).
I am trying to create a function to validate an attempted record
insert, and I am having a hard time coming up with syntax that
is acceptable.
Here is the scenario I have a table that has (among other items) employee_key
and work_type_ke
On Sat, Aug 10, 2019 at 02:57:14PM -0400, stan wrote:
> Sorry, I got the list address wrong the first time, and when I corrected it,
> I forget to fix the subject line.
>
> I apologize for asking, what I suspect will turn out to be a newbie
> question, but I have managed to get myself quite confus
On 2019-08-10 21:01:50 -0600, Rob Sargent wrote:
> On Aug 10, 2019, at 8:47 PM, Souvik Bhattacherjee
> wrote:
>
> Hi Adrian,
>
> Thanks for the response.
>
> > Yes, but you will some code via client or function that batches the
> > inserts for you.
>
> Could you pl
On Sun, 11 Aug 2019 at 06:53, stan wrote:
>
> I apologize for asking, what I suspect will turn out to be a newbie
> question, but I have managed to get myself quite confused on this.
>
> I am defining a view as follows
>
>
> CREATE OR REPLACE view purchase_view as
> select
> project.proj_n
12 matches
Mail list logo
