Re: [BUGS] BUG #2272: stop

2006-02-21 Thread Richard Huxton
Mon wrote: The following bug has been logged online: Bug reference: 2272 Logged by: Mon Email address: [EMAIL PROTECTED] PostgreSQL version: no Operating system: sos Description:stop Details: The bug is that there is not an easy way to unsubscribe to all the maili

[BUGS] BUG #2276: Não consigo tirar backup/Select na tabela

2006-02-21 Thread Fernando Marques
The following bug has been logged online: Bug reference: 2276 Logged by: Fernando Marques Email address: [EMAIL PROTECTED] PostgreSQL version: psql 8.0.1 Operating system: GNU bash, version 3.00.15(1)-release (i686-redhat-linux-gnu) Description:Não consigo tirar back

Re: [BUGS] BUG #2261: ILIKE seems to be buggy on koi8 input

2006-02-21 Thread Evgeny Gridasov
postgresql server starts with environment: LC_COLLATE=en_US.UTF-8 LC_ALL=en_US.UTF-8 LANG=en_US.UTF-8 I've tried to set different LC_COLLATE/LC_ALL/LANG settings but it did not help. I've tried to change my psql input to unicode russian, but it did not help, too. 'show all' says I've got lc_col

[BUGS] BUG #2277: Can't Open Relation when returning data from a stored procedure

2006-02-21 Thread Andrew Nykolyn
The following bug has been logged online: Bug reference: 2277 Logged by: Andrew Nykolyn Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: OS Red Hat Enterprise Linux AS release 3 (Taroon Update 4) Kernel 2.4.21-27.0.4.EL.snaresmp on an i686 Descript

Re: [BUGS] BUG #2261: ILIKE seems to be buggy on koi8 input

2006-02-21 Thread Peter Eisentraut
Evgeny Gridasov wrote: > It cannot be modified setting it in postgresql.conf (creation db > constant?) Should I reinit database to get this working or what? Yes. > If I should reinit db, what locale should I choose? Something like ru_RU.utf8. -- Peter Eisentraut http://developer.postgresql.org

Re: [BUGS] BUG #2277: Can't Open Relation when returning data from a stored procedure

2006-02-21 Thread Tom Lane
"Andrew Nykolyn" <[EMAIL PROTECTED]> writes: > When running a stored procedure that loads data into a temporary table, the > following error occurs when returning the result set through a composite > data type. > Could not open relation with OID 443748 It looks to me like you're running into

Re: [BUGS] BUG #2274: Error in 'CREATE DOMAIN' SQL command in dump file

2006-02-21 Thread Tom Lane
Alexander Galler <[EMAIL PROTECTED]> writes: >>> psql:test.dump:415: ERROR: type "tsinterval" does not exist >> >> I can't duplicate this --- for me, pg_dump produces >> >> CREATE DOMAIN address_period_tsi AS public.tsinterval NOT NULL DEFAULT >> '(-infinity..infinity)'::public.tsinterval; >>

[BUGS] FATAL: semctl(1672698088, 12, SETVAL, 0) failed

2006-02-21 Thread Qingqing Zhou
I encountered an error when I fast shutdown 8.1.1 on Win2k: FATAL: semctl(1672698088, 12, SETVAL, 0) failed: A blocking operation was interrupted by a call to WSACancelBlockingCall. A similar error on 8.1/win2003 was reported on pgsql-general (sorry, I can't dig out the original post fr