Hi,
I am trying to install auto_explain on PostgreSQL-9.3.11
OS X EI Capitan - 10.11
I am getting following error:
--
$ pwd
/Users/sachin/postgres_git/postgres/contrib/auto_explain
$ make
gcc -g -O0 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wm
2016-04-19 5:41 GMT+02:00 Jinhua Luo :
> > Does that mean a VOLATILE function runs in a different transaction?
>
> No, all statements triggered by the outer statement is within the same
> transaction. If the trigger fails (without trapping the error), all
> affects including changes by outer state
Hello,
What do you see on each node's log after enablibg interfaces?
Regards,
Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.
Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103 | RPC: (+51)
954183248
Website: www.ocs.pe
Sent from my Sony Xperia™ smartphone
Nikhil wr
Hello,
I have a 2 node BDR group and replication is happening properly. if i bring
down one of the node's interface, after sometime the replication slots are
becoming inactive (pg_replication_slots view). Then if i bring back
interface slots are not turning active automatically and replication sto
> Does that mean a VOLATILE function runs in a different transaction?
No, all statements triggered by the outer statement is within the same
transaction. If the trigger fails (without trapping the error), all
affects including changes by outer statement would be rollback.
> And does that mean it
On 4/18/2016 5:41 PM, da...@andl.org wrote:
Are you sure you meant it like that? I already have BEGIN/COMMIT inside a
function and it works perfectly. If it did not, then it would be impossible to
use BEGIN/COMMIT in any language handler, since every call to a language
handler is a call to a f
> From: Albe Laurenz [mailto:laurenz.a...@wien.gv.at]
>
> > I am attempting to create a new language implementation. The language
> > is Andl (andl.org), so the handler is plandl.
> > This is a question about executing SPI queries from inside plandl.
> >
> > The documentation makes it clear that S
+1
We should be "open" to include various languages, dialect & colloquialisms in
documentation... the measure is whether the meaning is clear - foobar has a
long history, as do foo & bar, in the communication of ideas.
That would mean no jargon, abbreviations, humour, sarcasm, acronyms, etc...
OK, got it.
I really wasn't expecting to have to deal with TOASTs in what looks like a
rather ordinary query -- perhaps there might be a note in the documentation?
But thanks, that works just fine. Problem solved.
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org
> -O
Partition tables are empty in backup while using pg_dump to take backup, but
those tables having data in database. Below is the command i am using to
take backup.
./pg_dump -i -h localhost -p 5432 -U postgres -F c -b -v -f /tmp/dump.sql
db_mydb
--
View this message in context:
http://postgr
Tom Lane schrieb am 18.04.2016 um 17:16:
For trigger, e.g. written in pl/pgsql, each sql command within the
function may see more new data beyond the (entry) snapshot of outer
command.
No it will not see "more data")
It runs in the same _transaction_ as the "firing" command and thus sees
**
Thomas Kellerer writes:
> Jinhua Luo schrieb am 18.04.2016 um 16:47:
>> For trigger, e.g. written in pl/pgsql, each sql command within the
>> function may see more new data beyond the (entry) snapshot of outer
>> command.
> No it will not see "more data")
> It runs in the same _transaction_ as t
Jinhua Luo schrieb am 18.04.2016 um 16:47:
> For trigger, e.g. written in pl/pgsql, each sql command within the
> function may see more new data beyond the (entry) snapshot of outer
> command.
No it will not see "more data")
It runs in the same _transaction_ as the "firing" command and thus sees
Let me clarify my question a bit more (I don't know why nobody raises
such question):
For trigger, e.g. written in pl/pgsql, each sql command within the
function may see more new data beyond the (entry) snapshot of outer
command.
So if the "command" term in the read committed isolation level only
da...@andl.org wrote:
> I am attempting to create a new language implementation. The language is Andl
> (andl.org), so the
> handler is plandl.
> This is a question about executing SPI queries from inside plandl.
>
> The documentation makes it clear that SPI allows nested queries; that in some
>
On 04/17/2016 05:50 PM, Sergei Agalakov wrote:
Nobody asks for pg_dump to be a schema comparison tool. As you tell
yourself
it is a most reliable schema capturing tool. All I am asking is that if
pg_dump is executed
on two databases with the identical schemas and security it should be
able to pro
On 04/17/2016 12:13 PM, Andrej Vanek wrote:
Hello Adrian,
I tried to use -U without "su"- launched directly by root: same behaviour.
Finally I reverted my script to use standard backup (pg_start_backup;
rsync; pg_stop_backup)- this works- the only downside is possible
collisions with on-line bac
On 04/17/2016 06:10 PM, Sergei Agalakov wrote:
Thank you, I know this place.
I just wanted to check that my request will have the peoples support.
So far it doesn't. It looks like that or people never need to compare
two PG databases to find the differences in the schemas or security,
or happy to
Hi Jony,
First of all thank for considering the matter.
Although the overall database has many tables, the relations/objects accessed
by high RAM usage connections is rather limited. ( < 10 )
There are essentially a couple of “selects” (2-4) dependent on options that are
enabled and then the
OK, got it.
I really wasn't expecting to have to deal with TOASTs in what looks like a
rather ordinary query -- perhaps there might be a note in the documentation?
But thanks, that works just fine. Problem solved.
Regards
David M Bennett FACS
Andl - A New Database Language - andl.org
> -O
I am attempting to create a new language implementation. The language is Andl
(andl.org), so the handler is plandl.
This is a question about executing SPI queries from inside plandl.
The documentation makes it clear that SPI allows nested queries; that in some
instances it will be necessary to c
Hi,
Thank you for your response.
On 17.04.2016 15:30, Craig Ringer wrote:
I intend to make the same split in pglogical its self - a receiver and
apply worker split. Though my intent is to have them communicate via a
shared memory segment until/unless the apply worker gets too far
behind and sp
Jinhua Luo wrote:
> The document said, "Read Committed mode starts each command with a new
> snapshot that includes all transactions committed up to that instant".
>
> But what about the embedded commands within the outer command itself?
> Do they share the same snapshot with the outer command?
>
da...@andl.org wrote:
> I am attempting to create a new language implementation. The language is
> Andl (andl.org), so the handler is plandl.
> I am having a bit of trouble executing SPI queries from inside plandl.
>
> The particular problem arises after calling SPI_cursor_fetch() and then
> SPI_g
24 matches
Mail list logo
