I would like to refresh the topic and add another report about the issue that
just happened to me.I'm sure it's the toast table that cannot be opened
inside the function.I have added following RAISE NOTICE clauses to it and
run analyze inside of the function:
analyze verbose temp_table;
On 01/19/2018 03:33 AM, Bjørn T Johansen wrote:
I found this, for RHEL 7:
https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/repoview/pgaudit_96.html
But I can not find the same package for PostgreSQL 10, is this an oversight or
intensional or am I just blind?
Well pgAudit supports 10:
htt
Robert McGehee writes:
> I frequently want to make views that repeat a calculation over and over
> again in lots of columns. In the example below, let’s say it’s (a+b), but
> we can imagine the calculation being much more complicated.
> For example:
> CREATE VIEW AS
> SELECT (a+b)*c as c1, (a+b)*
> [David G. Johnston]
> My $0.02
>
> Unless you have some need to generalize I'd say just brute-force it and be
> done.
>
> You could maybe play with arrays to get something that looks different but I
> don't think it would be much shorter to code or easier to understand.
My concern
Hello,
I have a general query optimization question involving repeated
calculations.
I frequently want to make views that repeat a calculation over and over
again in lots of columns. In the example below, let’s say it’s (a+b), but
we can imagine the calculation being much more complicated.
For ex
On Fri, Jan 19, 2018 at 8:46 AM, wrote:
> I’m trying to fill up columns containing NULL with the most recent NOT
> NULL value from left to right.
>
> Example:
>
> Select 2, 1, null, null, 3
>
> Should be converted into
>
> 2, 1, 1, 1, 3
>
>
>
> The following query works but I wonder if there is a
On Fri, Jan 19, 2018 at 8:47 AM, hmidi slim wrote:
> I need to be notified when the table is full to launch a script whis dumps
> this table.
>
Please don't top post.
You are going to need to explain the entire process is greater detail if
you want help. As Raymond said while I was writing, y
I need to be notified when the table is full to launch a script whis dumps
this table.
H.S
2018-01-19 16:44 GMT+01:00 David G. Johnston :
> On Fri, Jan 19, 2018 at 8:34 AM, hmidi slim wrote:
>
>> Hi,
>> I'm looking for a function in postgresql which notify the client if a
>> table was full or n
I'm trying to fill up columns containing NULL with the most recent NOT NULL
value from left to right.
Example:
Select 2, 1, null, null, 3
Should be converted into
2, 1, 1, 1, 3
The following query works but I wonder if there is an easier way for tables
with 50 or more columns:
with
On Fri, Jan 19, 2018 at 8:34 AM, hmidi slim wrote:
> Hi,
> I'm looking for a function in postgresql which notify the client if a
> table was full or not.So I found the function Notify
> https://www.postgresql.org/docs/9.0/static/sql-notify.html.
> This function send a notification when a new acti
On 19/01/18 15:34, hmidi slim wrote:
Hi,
I'm looking for a function in postgresql which notify the client if a
table was full or not.So I found the function Notify
https://www.postgresql.org/docs/9.0/static/sql-notify.html.
This function send a notification when a new action was done to the
ta
Hi,
I'm looking for a function in postgresql which notify the client if a table
was full or not.So I found the function Notify
https://www.postgresql.org/docs/9.0/static/sql-notify.html.
This function send a notification when a new action was done to the table.
Is there a way to send a notification
I found this, for RHEL 7:
https://yum.postgresql.org/9.6/redhat/rhel-7-x86_64/repoview/pgaudit_96.html
But I can not find the same package for PostgreSQL 10, is this an oversight or
intensional or am I just blind?
Regards,
BTJ
--
13 matches
Mail list logo
