Re: [GENERAL] increase WAL_FILES

On Mon, 29 Jan 2001, Tom Lane wrote: > Date: Mon, 29 Jan 2001 02:04:47 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: Thomas T. Thai <[EMAIL PROTECTED]> > Cc: PostgreSQL General <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] increase WAL_FILES > > "Thomas T. Thai" <[EMAIL PROTECTED]> writes: >

Re: Re[4]: [GENERAL] SPI_getvalue problem

Alex Guryanow <[EMAIL PROTECTED]> writes: > DEBUG: tupdesc is NULL Hm. Well, I can assure you that rd_att will *never* be null in a valid relation cache entry. So there is something wrong with either CurrentTriggerData, the relation pointer, or your function's interpretation of the structures.

Re: [GENERAL] while vacuum: pq_flush: send() failed: Broken pipe

On Mon, 29 Jan 2001, Tom Lane wrote: > Date: Mon, 29 Jan 2001 01:57:29 -0500 > From: Tom Lane <[EMAIL PROTECTED]> > To: Thomas T. Thai <[EMAIL PROTECTED]> > Cc: PostgreSQL General <[EMAIL PROTECTED]> > Subject: Re: [GENERAL] while vacuum: pq_flush: send() failed: Broken pipe > > "Thomas T. Thai

Re: [GENERAL] while vacuum: pq_flush: send() failed: Broken pipe

"Thomas T. Thai" <[EMAIL PROTECTED]> writes: > pq_flush: send() failed: Broken pipe > pq_recvbuf: unexpected EOF on client connection >> >> Are you sure that's "while" doing the vacuum, and not "after"? >> In any case, what this indicates is ungraceful disconnection by the >> client. What client

Re: [GENERAL] while vacuum: pq_flush: send() failed: Broken pipe

"Thomas T. Thai" <[EMAIL PROTECTED]> writes: > while doing a vacuum, i got a 'broken pipe' error. is this serious? > ... > DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 2: Vac 0, > Keep/VTL 0/0, Crash 0, UnUsed > 2, MinLen 1206, MaxLen 1499; Re-using: Free/Avail. Space > 5444/0; EndEm

Re: [GENERAL] increase WAL_FILES

"Thomas T. Thai" <[EMAIL PROTECTED]> writes: > how do i increase WAL_FILES and why is it telling me to do that? See http://www.postgresql.org/devel-corner/docs/postgres/wal.htm particularly the part about configuration parameters. > DEBUG: XLogWrite: new log file created - try to increase WAL_F

[GENERAL] increase WAL_FILES

how do i increase WAL_FILES and why is it telling me to do that? DEBUG: Index url_url: Pages 30242; Tuples 457116: Deleted 0. CPU 3.98s/3.42u sec. DEBUG: Index url_crc: Pages 7874; Tuples 457116: Deleted 0. CPU 1.08s/3.15u sec. DEBUG: XLogWrite: new log file created - try to increase WAL_FILES

Re[4]: [GENERAL] SPI_getvalue problem

Monday, January 29, 2001, 9:33:06 AM Tom wrote: TL> Alex Guryanow <[EMAIL PROTECTED]> writes: >> You have right. One of the values passed to SPI_getvalue is NULL. This is second >parameter >> (tupdesc). But why on Linux it is not NULL, and on Solaris is? >> Here is part of my trigger-code: >>

Re: Re[2]: [GENERAL] SPI_getvalue problem

Alex Guryanow <[EMAIL PROTECTED]> writes: > You have right. One of the values passed to SPI_getvalue is NULL. This is second >parameter > (tupdesc). But why on Linux it is not NULL, and on Solaris is? > Here is part of my trigger-code: > rel = CurrentTriggerData->tg_relation; > trigtupl

[GENERAL] while vacuum: pq_flush: send() failed: Broken pipe

while doing a vacuum, i got a 'broken pipe' error. is this serious? ... DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 2: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 2, MinLen 1206, MaxLen 1499; Re-using: Free/Avail. Space 5444/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. DEBUG: Index

Re[2]: [GENERAL] SPI_getvalue problem

Sunday, January 28, 2001, 8:24:51 PM Tom wrote: TL> Alex Guryanow <[EMAIL PROTECTED]> writes: >> I have the following problem: the backend crashes on Solaris while >> executing the function SPI_getvalue. >> At the same time on Linux this trigger works fine. >> Is this a bug or my misconfuguration

[GENERAL] RE: jdbc, use of nested ResultSet loops.(longish, interesting I hope)

Hi Matthew(?), I think you're creating a headache for urself because of the nature of ResultSets. It doesn't look like you're in need of updatable, real time stuff -- which is the idea behind why a ResultSet is so hard to play with in the first place. Think about doing the following: running

RE: [GENERAL] GUI Interfaces

Check also gnomeDB on www.gnome.org go to office. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: [EMAIL PROTECTED] Web site: http://www.sopac.org/ Support FMaps: http://fmaps

Re: [GENERAL] Transactions inside plpgsql?

Basically, answer is: you can't do it, no matter how you slice it, for a simple reason: postgres doesn't support nested transactions [yet?]. On Sun, 28 Jan 2001, Alan Turner wrote: > Hi > > I've been searching the web/mailing lists/web boards for the answer to a > question I have regarding pos

Re: [GENERAL] varchar => int

Yes, Peter's suggestion does work and I was using the substring already.. This guy has some that have Xs in them too (lord knows why), so it's either function writing time as you suggest or time to beat a client :-) Thanks for the suggestions guys, I appreciate it.. -Mitch - Original Messa

Re: [GENERAL] SPI_getvalue problem

Alex Guryanow <[EMAIL PROTECTED]> writes: > I have the following problem: the backend crashes on Solaris while > executing the function SPI_getvalue. > At the same time on Linux this trigger works fine. > Is this a bug or my misconfuguration? Sounds like a bug to me, but you haven't demonstrated

Re: [GENERAL] GUI Interfaces

On Wed, 24 Jan 2001, wrote: > Are there any other GUI Interfaces with PostgreSQL other then Pgaccess? > GNUe Forms allows you to build entry/query forms against different databases. It provides both a GUI interface as well as a curses interface to created forms. My primary development db is

[GENERAL] SPI_getvalue problem

Hi, I have the following problem: the backend crashes on Solaris while executing the function SPI_getvalue. I have small database on Intel/Linux that works fine. Now I need to transfer them to Sparc/Solaris. This database contains a small trigger written in C++. After installing postgresql-7.0.

[GENERAL] jdbc, use of nested ResultSet loops.(longish, interesting I hope)

A few days ago I posted a query regarding a problem I had with errors I was incurring doing some nested queries with the jdbc driver. (having recently done a re-install my email history is in limbo for the moment) Found some of my problems were in messy ugly code, fixed some of the problems by