[BUGS] BUG #4425: cannot pg_restore from pg_dump --format=c

2008-09-18 Thread Kieran McCusker
The following bug has been logged online: Bug reference: 4425 Logged by: Kieran McCusker Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Linux (fc9) Description:cannot pg_restore from pg_dump --format=c Details: Hi I'm trying to copy a

[BUGS] BUG #4424: Change PostGreSQL Password Affects

2008-09-18 Thread Michael Ojukwu
The following bug has been logged online: Bug reference: 4424 Logged by: Michael Ojukwu Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows Server 2003 R2 Description:Change PostGreSQL Password Affects Details: Hello We are having an

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-18 Thread Tom Lane
Andreas Peer <[EMAIL PROTECTED]> writes: > Well, the use case is a strange one... I would like to use a varchar() > column for storing a variable-length vector of integers. The numbers are > represented by the codepoints. Therefore, I need to sort them as binary > data, not as characters. I woul

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-18 Thread Magnus Hagander
Heikki Linnakangas wrote: > ITAGAKI Takahiro wrote: >> Tom Lane <[EMAIL PROTECTED]> wrote: >> >>> ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: We probably need to add PG_BINARY when we open control files because 0x1A is an end-of-file marker on Windows. >>> Well, why is that a bug? If th

Re: [BUGS] [HACKERS] 0x1A in control file on Windows

2008-09-18 Thread Heikki Linnakangas
ITAGAKI Takahiro wrote: Tom Lane <[EMAIL PROTECTED]> wrote: ITAGAKI Takahiro <[EMAIL PROTECTED]> writes: We probably need to add PG_BINARY when we open control files because 0x1A is an end-of-file marker on Windows. Well, why is that a bug? If the platform is so silly as to define text files

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-18 Thread Peter Eisentraut
Andreas Peer wrote: Well, the use case is a strange one... I would like to use a varchar() column for storing a variable-length vector of integers. The numbers are represented by the codepoints. Therefore, I need to sort them as binary data, not as characters. I would often need to get all the

[BUGS] BUG #4423: Impementing replication via pgadmin

2008-09-18 Thread Abdul Rehman
The following bug has been logged online: Bug reference: 4423 Logged by: Abdul Rehman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Windows Xp Description:Impementing replication via pgadmin Details: I followed the steps in https://peopl

Re: [BUGS] BUG #4421: convert_to() should be immutable

2008-09-18 Thread Andreas Peer
Tom Lane wrote: Heikki Linnakangas <[EMAIL PROTECTED]> writes: [EMAIL PROTECTED] wrote: The function convert_to(string text, dest_encoding name) is not allowed to be used in a index expression, because it is not marked as "IMMUTABLE". You can change the way a conversion is d