Re: [BUGS] postgres 9 streaming replication

2011-03-23 Thread Alex Lai
Khadtare, Sharad wrote: Hi, Problem solved after removing trigger entry from recovery.conf file Thx for help Regards, Sharad K -Original Message- From: Fujii Masao [mailto:masao.fu...@gmail.com] Sent: Tuesday, January 25, 2011 5:55 PM To: Khadtare, Sharad Cc: pgsql-bugs@postgresql

[BUGS] Index Ignored Due To Use Of View

2011-03-23 Thread Donald Fraser
PostgreSQL 8.3.14 OS: Linux Redhat 5.4 Note: I have used the same subject for this email taken from an email: Posted 2011-02-24 13:29:22-08 by "David Johnston", because this seems to be a very similar observation. Bug/Problem Summary: We are using a simple query based on a simple view and the q

Re: [BUGS] Index Ignored Due To Use Of View

2011-03-23 Thread Donald Fraser
- Original Message - Sent: Wednesday, March 23, 2011 12:50 PM Subject: Index Ignored Due To Use Of View PostgreSQL 8.3.14 OS: Linux Redhat 5.4 Note: I have used the same subject for this email taken from an email: Posted 2011-02-24 13:29:22-08 by "David Johnston", because thi

Re: [BUGS] Index Ignored Due To Use Of View

2011-03-23 Thread Merlin Moncure
On Wed, Mar 23, 2011 at 8:10 AM, Donald Fraser wrote: > - Original Message - > > Sent: Wednesday, March 23, 2011 12:50 PM > Subject: Index Ignored Due To Use Of View > PostgreSQL 8.3.14 > OS: Linux Redhat 5.4 > > Note: I have used the same subject for this email taken from an email: > Post

Re: [BUGS] TO_CHAR(timestamptz,datetimeformat) wrong after DST change

2011-03-23 Thread Susanne Ebrecht
Hello Jonathan, the problem might be solved after the upcoming weekend. Because on the upcoming weekend most other countries of the world switch time. Some years ago USA was conform here - but then USA changed the time switching date for USA (or just for some states). Maybe that is the reason.

Re: [BUGS] Warm Standby startup process unconditionally hangs

2011-03-23 Thread Simon Riggs
On Mon, Mar 21, 2011 at 4:44 PM, Bernd Helmle wrote: > PostgreSQL is 8.4.7, WAL-Logshipping is actually using SkyTools 2.1.12 (both > installed from PGDG rpms), running with CentOS 5.5 XEN-VM with Kernel > 2.6.18-194.26.1.el5xen. > > recovery.conf on the standby installed by walmgr is > > restore_

Re: [BUGS] Warm Standby startup process unconditionally hangs

2011-03-23 Thread Alvaro Herrera
Excerpts from Simon Riggs's message of mié mar 23 17:37:11 -0300 2011: > The answer looks clear from here. What I'm stunned about is that we've > not had a report about this before now. (You replied there had been one). I've actually seen reports that the recovery process seems stuck but I've nev

[BUGS] BUG #5942: pg_trgm.sql has cyclic dependency on type gtrgm creation

2011-03-23 Thread Arthur Nascimento
The following bug has been logged online: Bug reference: 5942 Logged by: Arthur Nascimento Email address: tur...@gmail.com PostgreSQL version: 9.0.3 Operating system: Linux Description:pg_trgm.sql has cyclic dependency on type gtrgm creation Details: When creating t

Re: [BUGS] BUG #5942: pg_trgm.sql has cyclic dependency on type gtrgm creation

2011-03-23 Thread Tom Lane
"Arthur Nascimento" writes: > When creating the gtrgm type, it depends on gtrgm_{in,out}. These functions > also depend on the type, so there is a cyclic dependency on creation of the > type. > The command psql -f sharedir/contrib/pg_trgm.sql crashes for me accusing > this error. Crashes how? T

[BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-23 Thread Nathan Davalos
The following bug has been logged online: Bug reference: 5944 Logged by: Nathan Davalos Email address: n.dava...@sharedmarketing.com PostgreSQL version: 9 Operating system: Windows XP/2003 Description:COPY FROM doesn't work with international characters Details: I'm

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-23 Thread John R Pierce
On 03/23/11 4:32 PM, Nathan Davalos wrote: ... SET CLIENT_ENCODING TO 'WIN1251'; copy tmpintermediate from 'thefile.txt'; Sample contents of thefile: 230002 Alto Desempeño, S.A. De C.V. When using WIN1251 or WIN1252 I get nothing in the second field, it just ignores the data. Same thing for L

Re: [BUGS] Index Ignored Due To Use Of View

2011-03-23 Thread Tom Lane
"Donald Fraser" writes: > I found the solution to the problem and it would therefore appear as though > this is not a bug! > If I change the function definition to be "STABLE" instead of "VOLATILE", > then the problem goes away. Yeah, that's intentional. If the planner flattens a view that has

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-23 Thread Nathan M. Davalos
32333030303209416C746F20446573656D7065F16F2C20532E412E20446520432E562E0D0A The character in question is F1 -Original Message- From: John R Pierce [mailto:pie...@hogranch.com] Sent: Wednesday, March 23, 2011 6:49 PM To: Nathan M. Davalos Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BU

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-23 Thread John R Pierce
On 03/23/11 5:42 PM, Nathan M. Davalos wrote: Just in case the reply didn't go through the character in question is F1. I replied to the message using pgsql-bugs@postgresql.org, but I'm a wee bit new to the bug reporting stuff using the mailing list. The hex of the file in total is 32.33.30.3

Re: [BUGS] BUG #5944: COPY FROM doesn't work with international characters

2011-03-23 Thread Nathan M. Davalos
AcNumber character varying(20), AcName character varying(50) The database itself is: ENCODING = 'UTF8' TABLESPACE = pg_default LC_COLLATE = 'English_United States.1252' LC_CTYPE = 'English_United States.1252' -Original Message- From: John R Pierce [mailto:pie

[BUGS] BUG #5943: jdbc client doesn't omit pg_toast_temp tables from schema views

2011-03-23 Thread Daniel Ceregatti
The following bug has been logged online: Bug reference: 5943 Logged by: Daniel Ceregatti Email address: dan...@ceregatti.org PostgreSQL version: N/A Operating system: N/A Description:jdbc client doesn't omit pg_toast_temp tables from schema views Details: In the fi