uot;Server 8.2.3" , so I connect to 8.2.3 server by 8.1.2 psql.
--
--
TANIDA Yutaka <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
CTED] tmp]$ pgbench -p 54382 -n -f test_function.sql -c 10 -t 100
Client 8 aborted in state 1: ERROR: relation "history" does not exist
--
TANIDA Yutaka <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 9: In versions below 8.0, the planne
bug affect at least 7.4 or above. 7.3.x doesn't affect
because
TRUNCATE can't execute from a function. But I don't know whether other commands
such as CLUSTER have this bug.
--
TANIDA Yutaka <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
> beta4 will have the fix.
Are there any plan to backport this patch for 8.1/8.0 server ?
My customer has same problem in 8.1.5 , but this bug doesn't seems to
be fixed in 8.1.6 .
Backport patch for 8.1.6 attached.
Sorry for replying old mail.
--
TANIDA Yutaka <[EMAIL PROTECTED]
quot;create domain"), $3, $4, $5, $6);
+ $$ = cat_str(5, make_str("create domain"), $3, $4, $5, $6);
}
;
--
TANIDA Yutaka <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
ecpg on 8.0.x crashes while compiling "create table as" statements. For
example,
#include
int main(){
EXEC SQL create table a as select 1;
exit(0);
}
Here's a patch attached.
--
TANIDA Yutaka <[EMAIL PROTECTED]>
ecpg_createas.patch
Des
indxinfo->tablespace,
tbinfo->usename, false,
"INDEX", q->data, delq->data, NULL,
indxinfo->dobj.dependencies,
indxinfo->dobj.nDeps,
--
TANIDA Yutaka <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
