[GENERAL] What would be a good way to append some text to the end of a text field?

Now I use php3 to read the text from the database then I append some text to it and finaly I do an update on the text field. Is it possible to use an SQL statement to do this directly in the database? Thanks Wim. I use: Posgresql 6.5.3 Linux 5.2 PHP3 begin:vcard n:Aarts;Wim tel;cell:06-2059

Re: [GENERAL] What would be a good way to append some text to the end of a text field?

more text' WHERE word_id = 1; Resulting in: test=> SELECT * FROM test_text; word_id|words ---+--- 1|some text some more text Hope this explains my question. Thanks. "Ross J. Reedstrom" wrote: > On Mon, Nov 22, 1999 at 02:45:04PM +0100, Wim Aarts wrote

Re: [GENERAL] What would be a good way to append some text to the end of a text field?

Sorry Ross, I replied to early, the second example covers it.Oops Wim. "Ross J. Reedstrom" wrote: > On Mon, Nov 22, 1999 at 02:45:04PM +0100, Wim Aarts wrote: > > > > Now I use php3 to read the text from the database then I append some > > text to it and fi

Re: [GENERAL] Re: "LockRelease: locktable lookup failed, no lock"

Hi Steve, Have you checked for inserts in the message field larger then 8k? Cheers Wim. Steve Wolfe wrote: > Grr > > Although I'm no longer getting lock releases on this table, a daily > vaccum analyze still shows: > > NOTICE: Rel reef: Uninitialized page 492 - fixing > NOTICE: Rel r

Re: [GENERAL] Index pg_proc_prosrc_index: NUMBER OF INDEX' TUPLES (1071)ISNOT THE SAME AS HEAP' (1070)

I'm a bit late with my reaction but I've seen the message below on a Cobalt system (kernel 2.0.34) with postgresql 6.5.3. The problem could be reproduced (the entire /var/lib/pgsql dir would be replaced after every crash). A PHP3 script revoking user rights on many tables and ending with a vacuum

I can crash my database in less than 2 minutes...

I'm getting futher in focussing on the problem. I can reproduce these messages I get when vacuuming a database. And by reproduce I mean on a different system a clean installed database It takes me less then a minute NOTICE: Rel pg_class: TID 294/3: InsertTransactionInProgress 20065 - can't s

Re: [GENERAL] Problem with beta2 and shapshot ???

Dit you do an initdb as postgres? i.e. you have a: /usr/local/pgsql/data dir? Cheers Wim. - Oorspronkelijk bericht - Van: Greg Brzezinski <[EMAIL PROTECTED]> Aan: <[EMAIL PROTECTED]> Verzonden: Saturday, March 18, 2000 4:53 PM Onderwerp: [GENERAL] Problem with beta2 and shapshot ???

Re: [GENERAL] safety of vacuum verbose analyze on active tables

> Andrew Snow wrote: > > > > > > > what is the relative safety of doing a vacuum verbose analyze > > > on a 24Gb > > > > > table while there are selects and updates/inserts happening on it? > > > > > > > > As far as I know, the table is locked completely during a Vacuum. Any > > > > transactions a