>> #17 0x7f26ea7438a3 in exec_simple_query (query_string=> out>) at
>> /opt/src/postgresql-9.1-9.1.6/build/../src/backend/tcop/postgres.c:1020
>> #18 0x7f26ea744965 in PostgresMain (argc=,
>> argv=, username=) at
>> /opt/src/postgresql-9.1-9.1.6/build/../src/backend/tcop/postgres.c:3968
>> #19 0x7f26ea702da3 in BackendRun (port=) at
>>
/opt/src/postgresql-9.1-9.1.6/build/../src/backend/postmaster/postmaster.c:
>> 3617 #20 BackendStartup (port=) at
>>
/opt/src/postgresql-9.1-9.1.6/build/../src/backend/postmaster/postmaster.c:
>> 3302 #21 ServerLoop () at
>>
/opt/src/postgresql-9.1-9.1.6/build/../src/backend/postmaster/postmaster.c:
>> 1466 #22 0x7f26ea705861 in PostmasterMain (argc=-345045536,
>> argv=0x7f26eb6cb200) at
>>
/opt/src/postgresql-9.1-9.1.6/build/../src/backend/postmaster/postmaster.c:
>> 1127 #23 0x7f26ea6a3dc3 in main (argc=5, argv=0x7f26eb6cb1e0) at
>> /opt/src/postgresql-9.1-9.1.6/build/../src/backend/main/main.c:199
>> (gdb) quit
>>
>>
>> We can see here that "return setof record" works fine, but "return
>> table()" crashes.
>>
>> Even if we can use the first syntax, I don't think we can accept that.
>
--
Sébastien Lardière
PostgreSQL DBA Team Manager
Hi-Media
0228082071 / 0626595833
ql-9.1-9.1.6/build/../src/backend/main/main.c:199
(gdb) quit
We can see here that "return setof record" works fine, but "return
table()" crashes.
Even if we can use the first syntax, I don't think we can accept that.
--
Sébastien Lardière
PostgreSQL DBA Team Manager
Hi-Med
On 11/05/2010 05:19 PM, Tom Lane wrote:
> and even if it does, the
> likely behavior would be that the serializable transaction would fail
> outright rather than give you a surprising view of the table.
thanks for your answer,
I have to say that I would prefer an error in the serializable
transac
On 11/05/2010 04:28 PM, Sébastien Lardière wrote:
> Hi,
>
> I've got a problem with a query run on production system. We've got some
> data export in a serializable transaction, and, 2 days ago, someone ran
> a DDL ( alter table foo add column ba test default 'blabla&
Hi,
I've got a problem with a query run on production system. We've got some
data export in a serializable transaction, and, 2 days ago, someone ran
a DDL ( alter table foo add column ba test default 'blabla'), and then,
the data export is empty. I try to reproduce the scenario below :
begin ;
dr
On 01/09/2009 05:14, Yaroslav Tykhiy wrote:
Thanks, I make a restore backup on the slave this morning, and It
works !
Could you detail your solution please, if any? I've seen frozen
pg_controldata output on my standby server for ages and attributed
that to the ancient version of pgsql (8.
On 28/08/2009 18:14, Simon Riggs wrote:
On Fri, 2009-08-28 at 17:54 +0200, Sébastien Lardière wrote:
Since this moment, the slave didn't make any checkpoint.
Now, we know why. Thanks a lot !
But how can i fix it ?
Current issue: Rebuild standby from base backup.
Cause: Locat
o index page in
"appels_entrants_arbo_key"
The cluster try to restart ( it fail ), i had to force to stop.
Since this moment, the slave didn't make any checkpoint.
Now, we know why. Thanks a lot !
But how can i fix it ?
--
Sébastien Lardière
--
Sent via pgsql-gener
t will take a lot of time,
more and more, and this point worried me a bit.
--
Sébastien Lardière
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 27/08/2009 00:18, Mark Kirkwood wrote:
Sébastien Lardière wrote:
On 26/08/2009 04:46, Mark Kirkwood wrote:
Sébastien Lardière wrote:
Hi All,
I've a cluster ( Pg 8.3.7 ) with WAL Shipping, and a few hours ago,
the master had to restart.
I use walmgr from Skytools, which works very
On 26/08/2009 04:46, Mark Kirkwood wrote:
Sébastien Lardière wrote:
Hi All,
I've a cluster ( Pg 8.3.7 ) with WAL Shipping, and a few hours ago,
the master had to restart.
I use walmgr from Skytools, which works very well.
I have already restart the master without any problem, but
value.
I don't know if it's important ( i think so ), and I can't fix it.
Is anybody have an idea ?
thanks,
--
Sébastien Lardière
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
12 matches
Mail list logo
