[BUGS] pltclu install problems

2012-05-21 Thread Szunomár Péter
Hello, i'm trying to install pltclu (or pltcl) language on my database on localhost. System: Windows 7 Ultimate Postgres: 8.3.5 or 9.1 (same error on both) Even if i start the createlang.exe pltclu or run the CREATE LANGUAGE pltclu sql command from PgAdmin, i receive the following error message:

[BUGS] BUG #6653: Service does not start in standby-mode

2012-05-21 Thread axw-sk
The following bug has been logged on the website: Bug reference: 6653 Logged by: Sebastian K. Email address: axw...@ipa.fhg.de PostgreSQL version: 9.0.7 Operating system: Windows 7 i386 Description: I want to set up a standby server for backup. The server has a new i

Re: [BUGS] 9.2beta1 regression: pg_restore --data-only does not set sequence values any more

2012-05-21 Thread Andrew Dunstan
On 05/16/2012 10:23 AM, Andrew Dunstan wrote: On Wed, May 16, 2012 at 9:08 AM, Tom Lane > wrote: Martin Pitt mailto:mp...@debian.org>> writes: > while packaging 9.2 beta 1 for Debian/Ubuntu the postgresql-common > test suite noticed a regression: It se

[BUGS] BUG #6656: Wrong timestamptz + interval calculation

2012-05-21 Thread mw
The following bug has been logged on the website: Bug reference: 6656 Logged by: Marcus Wirsing (Hesotech GmbH) Email address: m...@hesotech.de PostgreSQL version: 9.1.3 Operating system: Windows 7 64Bit Description: When I execute the statement select timestamptz '2

[BUGS] BUG #6655: restore backup

2012-05-21 Thread gloria_evelis
The following bug has been logged on the website: Bug reference: 6655 Logged by: Gloria Valladares Email address: gloria_eve...@hotmail.com PostgreSQL version: 8.4.0 Operating system: Ubuntu Description: /usr/bin/pg_restore --host localhost --port 5432 --username post

[BUGS] BUG #6657: Documentation bug for PQconnectdbParams

2012-05-21 Thread ediven
The following bug has been logged on the website: Bug reference: 6657 Logged by: Eric Diven Email address: edi...@edsiohio.com PostgreSQL version: 9.0.2 Operating system: Solaris Description: First off, I should thank you all for the generally excellent documentation.

[BUGS] BUG #6654: Full text search doesn't find europe

2012-05-21 Thread wbrana
The following bug has been logged on the website: Bug reference: 6654 Logged by: wbrana Email address: wbr...@gmail.com PostgreSQL version: 9.1.3 Operating system: Linux Description: CREATE INDEX idx_post_text ON posts USING gin (to_tsvector('english'::regconfig, post

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Edmund Horner
Hum. My first email sent to this list a few days ago still has not arrived, so these two are kind of orphaned. Should I resend it? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6654: Full text search doesn't find europe

2012-05-21 Thread Andres Freund
On Monday, May 21, 2012 07:26:38 PM wbr...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 6654 > Logged by: wbrana > Email address: wbr...@gmail.com > PostgreSQL version: 9.1.3 > Operating system: Linux > Description: > > CREATE INDEX

Re: [BUGS] BUG #6654: Full text search doesn't find europe

2012-05-21 Thread Tom Lane
Andres Freund writes: > On Monday, May 21, 2012 07:26:38 PM wbr...@gmail.com wrote: >> CREATE INDEX idx_post_text ON posts USING gin >> (to_tsvector('english'::regconfig, post_text::text)) >> select * from v_search WHERE to_tsvector('english', post_text) @@ 'europe' >> returns no rows, but >> sel

Re: [BUGS] BUG #6656: Wrong timestamptz + interval calculation

2012-05-21 Thread Tom Lane
m...@hesotech.de writes: > When I execute the statement > select timestamptz '2012-03-01 00:00:00+00' + interval '1 month' > I expect the result: > "2012-04-01 02:00:00+02" > but postgres returns: > "2012-04-01 01:00:00+02" This does not look like a bug to me. You did not say what time zone you a

Re: [BUGS] BUG #6655: restore backup

2012-05-21 Thread Tom Lane
gloria_eve...@hotmail.com writes: > PostgreSQL version: 8.4.0 > /usr/bin/pg_restore --host localhost --port 5432 --username postgres > --dbname "Mantenimiento" --verbose > "/media/GVALLADARES/20120521_backup.backup" > pg_restore: [archivador] versión no permitida (1.12) en el encabezado del > arc

Re: [BUGS] BUG #6657: Documentation bug for PQconnectdbParams

2012-05-21 Thread Tom Lane
edi...@edsiohio.com writes: > PostgreSQL version: 9.0.2 > ... > That said, I would humbly suggest that the documentation for the > PQconnectdbParams function omits certain details. Notably, the function > will return NULL if you pass in a keywords array with an unrecognized > keyword. This is a k

[BUGS] BUG #6658: Database do not push down static condition to subquery.

2012-05-21 Thread maxim . boguk
The following bug has been logged on the website: Bug reference: 6658 Logged by: Maxim Boguk Email address: maxim.bo...@gmail.com PostgreSQL version: 9.1.3 Operating system: Linux Description: Hi, I have 2 queries which have the same plan/same performance on 8.3 but

Re: [BUGS] pltclu install problems

2012-05-21 Thread Craig Ringer
On 05/21/2012 02:47 PM, Szunomár Péter wrote: Even if i start the createlang.exe pltclu or run the CREATE LANGUAGE pltclu sql command from PgAdmin, i receive the following error message: ERROR: could not load library "C:/Program Files/PostgreSQL/9.1/lib/pltcl.dll": unknown er

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Craig Ringer
On 05/22/2012 06:28 AM, Edmund Horner wrote: Hum. My first email sent to this list a few days ago still has not arrived, so these two are kind of orphaned. Should I resend it? You mean: "Just a note that pg_upgrade on Windows 7 64-bit did not have this error. However, it was a different dat

[BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Edmund Horner
(Sending this again to pgsql-bugs with no attachments; hopefully it'll be accepted. Apologies for any duplicates! I'll provide the attachments if you need them, though I suspect things may become clear without them.) Hello, I'm forwarding this to pgsql-bugs after sending it to pgsql-testers. I'

Re: [BUGS] PostgreSQL 9.2 beta1's pg_upgrade fails on Windows XP

2012-05-21 Thread Craig Ringer
First: Best. Bug. Report. Ever. Comments inline, though I don't know enough about the Windows side to help much. Checking for contrib/isn with bigint-passing mismatch ok Creating catalog dump The process cannot access the file because it i