Re: [HACKERS] ERROR: MemoryContextAlloc: invalid request size

2003-07-14 Thread Nikolay Kim
thanks! error is gone. On Пнд, 2003-07-14 at 20:36, Teodor Sigaev wrote: > Try > create index data_idx on testkw using gist(data gist__intbig_ops); > > > Default class gist__int_ops is usable for small arrays (with small number of > unique elements of all arrays) > > > Nikolay Kim wrote: > >

Re: [HACKERS] Transaction handling in extended query mode and Sync message issues

2003-07-14 Thread Tom Lane
Carlos Guzman Alvarez <[EMAIL PROTECTED]> writes: > In the extended query mode documentation i see this: > "Note: Sync does not cause a transaction block opened with BEGIN to be > closed. It is possible to detect this situation since the ReadyForQuery > message includes transaction status infor

Re: [HACKERS] duplicate define in elog.h

2003-07-14 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > I was looking through elog.h and noticed this at about line 36: > #define ERROR 20 /* user error - abort transaction; return >* to known state */ > #define ERROR 20 /* user error - abort transaction; return >

[HACKERS] duplicate define in elog.h

2003-07-14 Thread Joe Conway
I was looking through elog.h and noticed this at about line 36: #define ERROR 20 /* user error - abort transaction; return * to known state */ #define ERROR 20 /* user error - abort transaction; return * to known state */ Joe ---

Fwd: Re: [HACKERS] Possible psql bug

2003-07-14 Thread Kurt Roeckx
This mail didn't make it to the list, it seems. Kurt --- Begin Message --- On Thu, Jul 10, 2003 at 10:35:04AM +0800, Christopher Kings-Lynne wrote: > When I run psql on freebsd/alpha with latest CVS and no postmaster running, > I get this: > > bash-2.03$ psql test > psql: could not connect to s

Re: [HACKERS] Possible psql bug

2003-07-14 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > When I run psql on freebsd/alpha with latest CVS and no postmaster running, > I get this: > bash-2.03$ psql test > psql: could not connect to server: No such file or directory > Is the server running locally and accepting > co

Re: [HACKERS] Bad permissions bug in 7.3 dump (and 7.4)?

2003-07-14 Thread Tom Lane
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes: > Has anyone looked at this problem? I have delved into the source code, but > I can't for the life of me see where to make the change. I think there are > actually a few possible solutions: > * Dump all foreign key constraints as a superuser

Re: [HACKERS] cvs version compile error on AIX 4.3.3 using xlc (long)

2003-07-14 Thread Tom Lane
Weiping He <[EMAIL PROTECTED]> writes: > just try to compile newly updated 7.4-devl version on a AIX 4.4.3 box, > [ lots of problems ] > make[3]: Entering directory > `/home/postgres/pgsql-7.4/pgsql/src/backend/port' > xlc -O2 -qmaxmem=16384 -qsrcmsg -qlonglong -I../../../src/include -

Re: [HACKERS] [GENERAL] Backwards index scan

2003-07-14 Thread Tom Lane
[ reply redirected to a more appropriate list ] Dmitry Tkach <[EMAIL PROTECTED]> writes: > I am not sure if this is really a bug, but it certainly looks like one > to me... It's not a bug, but I agree that _bt_first can be inefficient if there are lots of matching keys. > This is because there

Re: [HACKERS] NLS: czech

2003-07-14 Thread Dave Page
> -Original Message- > From: Karel Zak [mailto:[EMAIL PROTECTED] > Sent: 14 July 2003 15:49 > To: Tom Lane > Cc: pgsql-hackers > Subject: Re: [HACKERS] NLS: czech > > Yes. I don't want to translate something for BE until beta version > will release. I have done pg_controldata, libpq,

Re: [HACKERS] NLS: czech

2003-07-14 Thread Karel Zak
On Mon, Jul 14, 2003 at 10:37:24AM -0400, Tom Lane wrote: > Karel Zak <[EMAIL PROTECTED]> writes: > > I start translate rest of all non-translated PostgreSQL's LC_MESSAGES > > from http://developer.postgresql.org/~petere/nls.php. > > Please, if someone other will do this work connect me first. >

Re: [HACKERS] NLS: czech

2003-07-14 Thread Tom Lane
Karel Zak <[EMAIL PROTECTED]> writes: > I start translate rest of all non-translated PostgreSQL's LC_MESSAGES > from http://developer.postgresql.org/~petere/nls.php. > Please, if someone other will do this work connect me first. The backend messages will be getting edited over the course of the

Re: [HACKERS] ERROR: MemoryContextAlloc: invalid request size (maybe

2003-07-14 Thread Teodor Sigaev
Try create index data_idx on testkw using gist(data gist__intbig_ops); Default class gist__int_ops is usable for small arrays (with small number of unique elements of all arrays) Nikolay Kim wrote: hi, i use _int contrib module and gist index here sample -

Re: [HACKERS] CVS notification (Path algorithms)

2003-07-14 Thread Dave Page
Hi Andreas, Just noticed this commit - thanks, I've been trying to work on it all day but keep getting sidetracked before I can get into it properly! One problem though - none of the helpfiles work for me still (none giving errors now), in my dev environment, or in a test 'real' installation - in

[HACKERS] ERROR: MemoryContextAlloc: invalid request size (maybe bug ingist index)

2003-07-14 Thread Nikolay Kim
hi, i use _int contrib module and gist index here sample t1.sql.gz Description: GNU Zip compressed data ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[HACKERS] NLS: czech

2003-07-14 Thread Karel Zak
Hi, I start translate rest of all non-translated PostgreSQL's LC_MESSAGES from http://developer.postgresql.org/~petere/nls.php. Please, if someone other will do this work connect me first. I want to prevent duplicated work... Karel -- Karel Zak <[EMAIL PROTECTED]> http://home.zf.j