Re: [BUGS] Column Name parameter problem

2005-09-28 Thread Tomas Zerolo
On Wed, Sep 28, 2005 at 12:25:54PM -0700, vishal saberwal wrote: > hi, > > I am trying to create a stored procedure that takes a column name as > parameter and then uses it to sort the table for result set. > > create or replace function ptest_Sort_Select(varchar) returns setof ptest1 > as $$ > D

Re: [BUGS] importing from 8.0.3 unicode problem

2005-10-30 Thread Tomas Zerolo
On Sun, Oct 30, 2005 at 12:23:00PM -0800, Theodore Petrosky wrote: > I don't know if this is a bug or my not understanding > something. [...] > I get an error: > ERROR: invalid UNICODE byte sequence detected near > byte 0x8e > CONTEXT: COPY ioinfo, line 177, column publication: > "Elle D?cor" > E

Re: [BUGS] BUG #2037: user function call unexpected "input out of range"

2005-11-12 Thread Tomas Zerolo
On Fri, Nov 11, 2005 at 09:26:47PM +, Tom wrote: > > The following bug has been logged online: > > Bug reference: 2037 > Logged by: Tom > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1-beta4 > Operating system: Windows XP > Description:user function ca

Re: [BUGS] Double sequence increase on single insert with RULE on targeted table

2005-11-15 Thread Tomas Zerolo
On Tue, Nov 15, 2005 at 11:39:37AM +0200, Sarunas Krisciukaitis wrote: > Dear All, > > A program produces the wrong output for any given input. > Here comes bug report: > 1. Database dump is attached. > 2. Input: "BEGIN; INSERT INTO test1(some_text) VALUES ('test1'); SELECT > lastval() as id; END

Re: [BUGS] Double sequence increase on single insert with RULE on targeted table

2005-11-15 Thread Tomas Zerolo
On Tue, Nov 15, 2005 at 10:51:10PM -0700, Michael Fuhr wrote: > On Wed, Nov 16, 2005 at 06:29:40AM +0100, Tomas Zerolo wrote: > > AFAIK, serials are not guaranteed to produce sequential values; tehy > > will produce unique values. That means that they can (and sometimes > >

Re: [BUGS] BUG #2071: ERROR: invalid multibyte character for locale

2005-11-25 Thread Tomas Zerolo
On Fri, Nov 25, 2005 at 11:55:44AM +, Prakash Nair wrote: > > The following bug has been logged online: > > Bug reference: 2071 > Logged by: Prakash Nair > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0.4 > Operating system: RHES > Description:ERROR:

Re: [BUGS] BUG #2175: 22021: invalid byte sequence for encoding \"UNICODE\":

2006-01-16 Thread Tomas Zerolo
On Mon, Jan 16, 2006 at 11:55:12PM +, Roberto wrote: > > The following bug has been logged online: > > Bug reference: 2175 > Logged by: Roberto > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating system: windows XP > Description:22021: invalid

Re: [BUGS] BUG #2318: language

2006-03-15 Thread Tomas Zerolo
On Tue, Mar 14, 2006 at 09:30:29AM +, Mete Akdogan wrote: > > The following bug has been logged online: > > Bug reference: 2318 [...] This is not a bug (and definitely not a PostgreSQL bug ;-) > hi, i am a teaching assistant in www.deu.edu.tr, in one of our db courses, > we are plannin

Re: [BUGS] BUG #2318: language

2006-03-16 Thread Tomas Zerolo
On Thu, Mar 16, 2006 at 01:02:57PM +0100, Andreas Pflug wrote: > Tomas Zerolo wrote: [...] > > export LANG=C pgadmin & > > This is a wrong advice. > Mete, use the option dialog to select your favourite language. Don't > touch the environment. OK, I assume

Re: [BUGS] BUG #2317: Wrong sorting order for (VW)

2006-03-16 Thread Tomas Zerolo
On Thu, Mar 16, 2006 at 11:03:59AM +0100, Tomas Klockar wrote: [...] > I would say that sorting V and W as the same character may work in a > dictionary [...] > Currently the sortingfunction in postgreSQL have disqualified itself > from beeing used, and I do the sorting in java which treat them

Re: [BUGS] BUG #2360: Backup produces "ERROR: could not convert UTF8 character to ISO8859-1"

2006-03-27 Thread Tomas Zerolo
On Mon, Mar 27, 2006 at 10:20:23AM +, JP Glutting wrote: > > The following bug has been logged online: > > Bug reference: 2360 > Logged by: JP Glutting > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 (8.0) > Operating system: Windows XP SP2 > Description:

Re: [BUGS] BUG #2400: 'Ã

2006-04-19 Thread Tomas Zerolo
On Tue, Apr 18, 2006 at 11:34:53PM +, Yusuf Siddiqui wrote: > > The following bug has been logged online: > > Bug reference: 2400 > Logged by: Yusuf Siddiqui > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1 > Operating system: Linux > Description:'Æ'