On 12 February 2016 at 17:56, Oliver Stöneberg wrote:
> A few weeks ago we already had a data corruption when the disk was
> full. There are other services running on the same machine that could
> cause the disk to fill up (e.g. local chaching when the network is
> acting up). It happened a few
Hi Dan,
2016-02-16 20:43 GMT+09:00 Daniel Pocock :
> Is this the place to ask questions about pgDay Asia[1] or is there
> another mailing list for it? The mailing list link on the pgDay Asia
> web site just takes me to a marketing list[2]. The seasiapug list[3]
> looks very quiet.
> 2.
> http:
On Tue, Feb 16, 2016 at 8:43 PM, Daniel Pocock wrote:
> I was looking at the pgDay Asia schedule and I notice some gaps and you
> don't have details of the lightning talks yet. Do you still need
> speakers for full talks or lightning talks?
You may be looking for that:
http://2016.pgday.asia/ind
Steve Crawford writes:
> I would like to roll a number of steps into a transaction. What happens to
> the stats data generated by ANALYZE if the transaction is rolled back?
> This message says the stats are reverted:
> http://postgresql.nabble.com/Analyze-during-a-transaction-td5775069.html
That
We have certain processes that import data then process and distribute the
data. Since the processing looks primarily, but not exclusively, at the new
records an ANALYZE prior to processing yields better plans. Although the
table changes will trigger autovacuum to analyze the table this happens too
On Fri, Feb 12, 2016 at 5:20 AM, Lesley Kimmel
wrote:
> Thanks for the reply Laurenz. Of course the first thing that I thought of to
> prevent man-in-the-middle was SSL. However, I also like to try to address
> the issue in a way that seems to get at what they are intending. It seemed
> to me that
El mar, 16-02-2016 a las 12:30 +, TROY Didier escribió:
> Hi,
>
> I am looking for a way to get ora2pg on HP-UX11i23 with PG 9.3.2.
>
> Thanks in advance,
> Didier TROY
> AP-HP/DSI/ATI/PACT
> 01 40 27 37 68
>
I think you should create an issue here
https://github.com/darold/ora2pg/issues
On 02/15/2016 11:44 PM, subhan alimy wrote:
Hello Everyone,
Here I have got and error of concurrent update,
Transaction Rollback Error: deadlock detected
process 4801 waits for sharelock on transaction 944461 blocked by process
4700.
process 4700 waits for sharelock on transaction 9444665 block
Hi,
I am looking for a way to get ora2pg on HP-UX11i23 with PG 9.3.2.
Thanks in advance,
Didier TROY
AP-HP/DSI/ATI/PACT
01 40 27 37 68
Hello Everyone,
Here I have got and error of concurrent update,
Transaction Rollback Error: deadlock detected
process 4801 waits for sharelock on transaction 944461 blocked by process
4700.
process 4700 waits for sharelock on transaction 9444665 blocked by process
4801.
by default PostgreSQL serv
On Tue, Feb 16, 2016 at 6:04 PM, Tom Lane wrote:
> I wrote:
> > Chris Travers writes:
> >> Unless there is a sense that this is a bad idea I will submit a doc
> patch.
>
> > I was already working on it ... I think what we want is something along
> > this line in the "Building Indexes Concurrentl
I wrote:
> Chris Travers writes:
>> Unless there is a sense that this is a bad idea I will submit a doc patch.
> I was already working on it ... I think what we want is something along
> this line in the "Building Indexes Concurrently" section of the CREATE
> INDEX ref page:
After further perusa
On Tue, 16 Feb 2016 09:14:30 -0500
Melvin Davidson wrote:
> The problem is TRUNCATE is more of an administrative privilege. Also, it is
> not captured in a DELETE trigger, so you have a security issue with that.
Ha, well, learn something new every day
> Also, REFERENCES & TRIGGER are schema ch
On Tue, Feb 16, 2016 at 09:41:18AM -0600, Suresh Raja wrote:
> I use the function name in the body of pgsql code of the same function. Is
> the function name set to any variable that i can easily reference. Now I'm
> hard coding the function name in the code.
> In the above Raise info i use selec
Chris Travers writes:
> Unless there is a sense that this is a bad idea I will submit a doc patch.
I was already working on it ... I think what we want is something along
this line in the "Building Indexes Concurrently" section of the CREATE
INDEX ref page:
*** create_index.sgml.orig Tue Feb
Hi All:
I use the function name in the body of pgsql code of the same function. Is
the function name set to any variable that i can easily reference. Now I'm
hard coding the function name in the code.
create or replace function compute_X(a1 text) returns text as
.
...
Begin
.
selec
The problem is TRUNCATE is more of an administrative privilege. Also, it is
not captured in a DELETE trigger, so you have a security issue with that.
Also, REFERENCES & TRIGGER are schema changes which should never be done by
a normal user.
On Tue, Feb 16, 2016 at 5:39 AM, Vincent Veyron wrote:
Hi,
Is this the place to ask questions about pgDay Asia[1] or is there
another mailing list for it? The mailing list link on the pgDay Asia
web site just takes me to a marketing list[2]. The seasiapug list[3]
looks very quiet.
I was looking at the pgDay Asia schedule and I notice some gaps an
On Mon, 15 Feb 2016 12:06:28 -0500
Melvin Davidson wrote:
> I wrote a short article to explain the proper use of Group and Userss in the
> database.
Hi Melvin,
Thanks for the explanation, it makes things easy to understand.
One question :
> Although GRANT ALL, at first appears to simplify g
Unless there is a sense that this is a bad idea I will submit a doc patch.
On Mon, Feb 15, 2016 at 8:22 PM, Chris Travers
wrote:
> Hi;
>
> Today I ran into a question from a client as to why an index was not
> used. The index had been freshly created and was on a relatively small
> table (16k l
20 matches
Mail list logo
