" bug when used in
function
1.INSTALL
https://github.com/dvarrazzo/interdbconnect/downloads
mv pgsql_fdw $PG_SRC/contrib/
cd $PG_SRC/contrib/pgsql_fdw
. /home/postgres/.bash_profile
USE_PGXS=1 make
USE_PGXS=1 make install
2.TEST
digoal=# create extension pgsql_fdw;
CREATE EXTENSION
CREATE SE
The following bug has been logged on the website:
Bug reference: 7840
Logged by: digoal
Email address: dig...@126.com
PostgreSQL version: Unsupported/Unknown
Operating system: CentOS 5.7 x64
Description:
I think there is a bug in PostgreSQL 9.3 devel version about
The following bug has been logged on the website:
Bug reference: 8294
Logged by: digoal.zhou
Email address: dig...@126.com
PostgreSQL version: Unsupported/Unknown
Operating system: CentOS 5.8 x64
Description:
PostgreSQL 9.3 beta2 stream replication primary and standby
wrong
pg94@db-172-16-3-33-> pgbench -M prepared -n -r -f ./test.sql -T 10 -c 800
-j 100 digoal
transaction type: Custom query
scaling factor: 1
query mode: prepared
number of clients: 800
number of threads: 100
duration: 10 s
number of transactions actually processed: 2037960
tps = 199534.267
t;connections and as many server processes must be created, and the time for
>that must be quite significant as well against the 10 second run.
>
>So I would mostly classify that as a feature rather than a bug, because
>the run is so short.
YES, I agree with you.
When testing time
synchronous_transfer=data_flush # or all, but fail-back also not success.
2. standby config
3. test sql
digoal=# create table test (id int primary key, info text, crt_time
timestamp);
CREATE TABLE
digoal=# create or replace function func() returns void as $$
digoal$# declare
digoal$# v_id int
