Dear Team,
I'm install postgres 8.2.5 in my server (operating system using Fedora Core 6),
instalation process is succes full.
I want to create table with data type txtidx, but i have error like this:
testing=# create table data (nama txtidx);
ERROR: type "txtidx" does not exist
LINE 1: create
Hi, why if I REINDEX a inherited table, all tables are locked?
Example:
[conn #1] REINDEX TABLE month_a;
[conn #2] PREPARE updt as update month_b set col_a=1 where col_b=$1;
The query on conn#2 waits.
regards,
Tiago
Tom Lane escreveu:
"Tiago Jacobs" <[EMAIL PROTECTED]> writes:
I tried a clean rebuild as Tom Lane suggested, but this didn't help.
Anyone offers commercial support for solving this problem?
M> Hello.
M> I have problems with Postgres core dumping on FreeBSD7 (RELENG_7)
M> Here is backtrace from gdb postgres postgres.core:
M> (gdb) bt
M> #0 0x485dc277 in ki
Michael <[EMAIL PROTECTED]> writes:
> M> (gdb) bt
> M> #0 0x485dc277 in kill () from /lib/libc.so.7
> M> #1 0x485dc1d6 in raise () from /lib/libc.so.7
> M> #2 0x485dadda in abort () from /lib/libc.so.7
> M> #3 0x0824c075 in errfinish ()
> M> #4 0x0824c8b1 in elog_finish ()
> M> #5 0x081c9184
TL> How repeatable is this --- does it happen on every connection attempt,
TL> or only sometimes? Can you start and stop the postmaster without
TL> any problems being logged?
Only sometimes, 1-4 times per day under high load. Postmaster starts
and stops without problems.
Backtraces are a bit diff
do you have a repeatable test case?
I have a FreeBSD 7/amd64 box that I can do the following:
1) make test runs
2) make available to a developer.
--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683E-Mail: [EMAIL PROTECTED]
US Mail: 430 Valon
Michael <[EMAIL PROTECTED]> writes:
> TL> How repeatable is this --- does it happen on every connection attempt,
> TL> or only sometimes? Can you start and stop the postmaster without
> TL> any problems being logged?
> Only sometimes, 1-4 times per day under high load. Postmaster starts
> and sto
