RE: [GENERAL] Updating pg_attribute - Permission denied

Looks like I have turned off usecatupd in pg_shadow. Doh! Was mucking around with permissions some time ago but not had any trouble up till now. Any ideas how to switch it back? Update pg_shadow SET usecatupd . gives me Permission denied!!! Ben. -Original Message- From: Tom

[GENERAL] blobs dont rollback ?

I recently ran into a big problems regarding blobs and rollback with postgreSQL 6.5.3 A table contains many entries and each entry includes a single blob-oid. In a databaseprocessing perlscript I need to delete such a blob and perform the lo_unlink and later I rollback the session without

Re: [GENERAL] Weird effects using BLOBs from libpq

At 17:52 22.10.00 -0400, you wrote: [...] First effect I have noticed is that when I write more than a certain amount of data at once using lo_write(), my application hangs indefinitely (10K work perfect, 100K not). Is there a well-known limit? On what does it depend? Or is it an

Re: [GENERAL] Weird effects using BLOBs from libpq

Hi! Just as a follow-up to my last posting - disregard my complaints ;-) I've just checked under Linux - works fine. Then i went back to my WIN NT box, and double checked libraries. See what i found: i actually used a WIN32 build of the libpq - not the cygwin build. When using that, everything

[GENERAL] Strange query results with dates

Hi! Help me please to resolve my problem. I cann't understand why my query returns very strange results. select datop from mytable where date_trunc('month',datop) =date_trunc('month',abstime '22.05.00') it returns a strings with operations which were made in May, but similar query

Re: [GENERAL] Strange query results with dates

Igor Khanjine [EMAIL PROTECTED] writes: select datop from mytable where date_trunc('month',datop) =date_trunc('month',abstime '02.05.00') it returns operations which were made in february ! I'm running PGSQL 7.0 , SET DATESTYLE ='GERMAN' SET TIME ZONE 'EUROPE/MOSCOW' FWIW, I do not

Re: [GENERAL] Out of memory errors with mod_perl

Hi, I've got this very bad message with Apache 1.3.6 running mod_perl and postgresql 6.3.2 with a site hosted by an ISP. They just allocate a max of 10 Mo of memory for each user. For me this was a message coming from server resources. Not enougth memory. At home with the same configuration I

[GENERAL] What release date for PostgreSQL 7.1?

Hello, I would like to know if there is a release date fixed for the 7.1 version of the postgresql server... I've compiled the 7.1 on cygnus and the new vacuum is a must for o project I'm working in (especially because presumably the reindex thing is coreected now : that bug that

[GENERAL] How to config pgsql to support big5

Hi all, Do I need to enable the locale support or --enable_multibyte=EUC_TW is good enough, I would like to be able to do sorting and issue LIKE command. Anyone can share your experience? TIA Douglas

Re: [GENERAL] plpgsql, insert with wariables in function triggered

Marcin Mazurek wrote: [Charset iso-8859-2 unsupported, filtering to ASCII...] Hi, why I can't use tabb variable in INSERT ? The error message I get is: ERROR: parser: parse error at or near "$1" DECLARE ids1 INTEGER;ids2 INTEGER; tab

Re: [GENERAL] Stumped on PlPgSql

Tom Lane wrote: AGRE Enterprises [EMAIL PROTECTED] writes: I have a Plpsgsql function that I have been using in 6.5.1 and it works fine. The same function on 7.0.2 gives me an error. I have looked in the doc and haven't seen any change in syntax but maybe Im blind. The error is ERROR: