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
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 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
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 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
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
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
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
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
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 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
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
12 matches
Mail list logo
