Re: [BUGS] Known issues for PostgreSQL server 8.1.19

Dashputre, Anurag (GE Healthcare) wrote on 20.09.2013 08:39: Thanks for your reply. We can't upgrade to newer version as of now. We just want to know list of known issues on 8.1.19. We will just note them down and do some impact analysis. You will need to go through the release notes for every

Re: [BUGS] Cant start PostgreSQL Using command prompt

John R Pierce, 11.09.2013 19:19: > btw, afaik Windows command prompt has no idea what & means. No, that's not true. See here for example: -- Sent via pgsql-bugs mailing list

Re: [BUGS] BUG #8394: SQL command REINDEX doesn't work

yzh...@trinityusa.com wrote on 23.08.2013 18:00: The following bug has been logged on the website: Bug reference: 8394 Logged by: Yz Primus Email address: yzh...@trinityusa.com PostgreSQL version: 9.1.3 Operating system: Windows 7 64-bit Description: I always received error

Re: [BUGS] Inconsistency between TO_CHAR() and TO_NUMBER()

Tom Lane wrote on 10.05.2013 17:49: I looked into this, and find that the reason it misbehaves is that NUM_numpart_from_char() will treat a '.' as being a decimal point *without any regard to locale considerations*. So even if we have a locale-dependent format string and a locale that says '.' i

[BUGS] Re: BUG #8132: Not Null column should set default value when inserting or setting null

h...@lemcke.com wrote on 02.05.2013 10:18: I would like to have the default value replace a given null value if the column is specified with not null and default. The SQL specification only requires to set the default value when the column is omitted on insert or update. I think this is a flaw

Re: [BUGS] BUG #7967: Wrong week number in extract function

no...@noose.pl wrote on 18.03.2013 09:23: The following bug has been logged on the website: Bug reference: 7967 Logged by: Pawel Kobylak Email address: no...@noose.pl PostgreSQL version: 9.1.3 Operating system: Debian Description: Hi, I'm running that query and result is ..

Re: [BUGS] BUG #7885: postmaster panic on startup does not release shared memory

postmaster will still shut down normally and thus release the > shmem segment.) > Yup, if I attempt to start the cluster normally, it cleans up after itself, so this is specific to --single mode. -- David Thomas System Engineer EnterpriseDB - The Enterprise PostgreSQL Company -- Sent via

[BUGS] BUG #7885: postmaster panic on startup does not release shared memory

The following bug has been logged on the website: Bug reference: 7885 Logged by: David Thomas Email address: david.tho...@enterprisedb.com PostgreSQL version: 9.2.3 Operating system: CentOS 6.3 Description: It seems that if the postmaster encounters a PANIC condition

[BUGS] Re: BUG #7851: Installer crash with message: An error occured executing the Microsoft VC++ runtimeinstaller

ot;. You'll get more or less the same dialog that is used to control file-system security. Then give the Administrator the priviliges to delete/change those keys and you should be fine. (Not sure if this still works the same under Windows 7 though). Regards Thomas -- Sent via pgsql-bugs

[BUGS] Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"

Tom Lane wrote on 09.12.2012 17:43: spam_ea...@gmx.net writes: postgres=# create user testuser with password 'secret'; CREATE ROLE postgres=# create database testdb owner testuser; CREATE DATABASE testdb=> drop owned by testuser; ERROR: unrecognized object class: 1262 I can reproduce this in

[BUGS] Re: BUG #7748: "drop owned by" fails with error message: "unrecognized object class: 1262"

st all objects that are created by that user (tables, schemas, ...) (In my example I first create a table) And this has definitely worked before, otherwise my unit tests would have failed all the time. Regards Thomas -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make chang

Re: [BUGS] BUG #7634: Missing files in global/ after a lot of CREATE DATABASE / DROP DATABASE

.5 (upgraded to 9.1.6 just a few days ago). Sorry for the version confusion. I will monitor global/ and try to trigger the bug and get back to you next week. Regards, Thomas

[BUGS] BUG #7634: Missing files in global/ after a lot of CREATE DATABASE / DROP DATABASE

The following bug has been logged on the website: Bug reference: 7634 Logged by: Thomas Email address: thomas.eckes...@gmail.com PostgreSQL version: 9.1.6 Operating system: Linux Description: Hi, We are using a Postgres server dedicated for unit testing, i.e. for

Re: [BUGS] BUG #7505: Backslash escaping not necessary

ovad...@gmail.com wrote on 24.08.2012 21:59: The following bug has been logged on the website: Bug reference: 7505 Logged by: Jeff Ovadya Email address: ovad...@gmail.com PostgreSQL version: 9.1.4 Operating system: PostgreSQL 9.1.4, compiled by Visual C++ build 150 Descripti

[BUGS] Small bug in psqlodbc-09.01 prevents interoperability with LISTSERV

Because we have customers who think Excel is an RDBMS, our product LISTSERV religiously queries ODBC capabilities at startup and prints warnings as appropriate. A customer tried to use PostgreSQL on Windows and got the following (these are our messages not yours, I am pasting them to show all th

Re: [BUGS] BUG #6761: unexpected behaviour of 'now'::timestamp

Thanks Tom and Pavel! -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding

(where dump is done with the Windows 1251 encoding (OS Encoding for Russian locale)) everything is right. Did you check the dump file using an editor that can handle UTF-8? The Windows console is not known for properly handling that encoding. Thomas -- Sent via pgsql-bugs mailing list (pgsql-bugs

[BUGS] BUG #6501: postgresql-9.1.3-1-linux.run does not install on 64bit system

The following bug has been logged on the website: Bug reference: 6501 Logged by: Thomas Pasch Email address: thomas.pa...@nuclos.de PostgreSQL version: 9.1.3 Operating system: Linux 64 (Ubuntu 11.10/oneiric) Description: When I try to install postgresql-9.1.3-1

[BUGS] BUG #6500: Installer does not honour --serverport

The following bug has been logged on the website: Bug reference: 6500 Logged by: Thomas Pasch Email address: thomas.pa...@nuclos.de PostgreSQL version: 9.1.3 Operating system: Linux 64 (Ubuntu 11.10/oneiric) Description: When I try to install ./postgresql-9.1.3-1

[BUGS] Documentation bug regarding collations

true with 9.1 as it is possible to define the collation on a per-column basis or as part of the ORDER BY clause. I think a link to the collation chapter and a description on the "precedence" of the definitions should be added to that part. Regards Thomas -- Sent via pgsql-bugs mail

Re: [BUGS] Weird message when creating PK constraint named like table

Kevin Grittner, 11.01.2012 21:16: When I do this CREATE TABLE "*T1*" ( "T1_ID" bigint NOT NULL, CONSTRAINT "*T1*" PRIMARY KEY ("T1_ID" ) ); I get the following message: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "T1" for table "T1" ERROR: relation "T1" already exist

Re: [BUGS] BUG #6308: Problem w. encoding in client

. We are now setting up another set of 32/64-bit (virtual) Windows 7 machines to verify that the problem occurs only on 64 bit windows. I will keep you informed. Regards Thomas === click:ware Informationstechnik GmbH Thomas Goerner Geschäftsführer fon

Re: [BUGS] BUG #6308: Problem w. encoding in client

o me they are closely related. Regards Thomas === click:ware Informationstechnik GmbH Thomas Goerner Geschäftsführer fon: 0221 - 13 99 88-0 fax: 0221 - 13 99 88-79 Kamekestraße 19 50672 Köln t...@clickware.de www.clickware.de

[BUGS] BUG #6308: Problem w. encoding in client

The following bug has been logged online: Bug reference: 6308 Logged by: Thomas Goerner Email address: t...@clickware.de PostgreSQL version: 9.1.1 Operating system: Windows 7 64-bit Description:Problem w. encoding in client Details: Hi, we have a problem regarding

Re: [BUGS] char(0)

ing CHAR(0). This is a little bit annoying on migration topics. While not move on to a cleaner approach during the migration and use a "boolean not null"? Thomas -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresq

Re: [BUGS] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

test builds publicly, I will be happy to test them and see if that behaves differently on my system. Regards Thomas -- 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] [GENERAL] One-click installer, Windows 7 32-bit, and icacls.exe

es applied) UAC is turned off, I was logged in as a local administrator (*not* a domain administrator). I have a ProcessMonitor trace that shows the behaviour of what icacls is doing when started by the installer. It is available here: http://www.sql-workbench.net/icacls_trace.zip Regards Thomas

[BUGS] BUG #6121: error msg feature request for initial server tasks

The following bug has been logged online: Bug reference: 6121 Logged by: Thomas Pitschel Email address: th.pitsc...@web.de PostgreSQL version: pgAdmin 1.12.3 Operating system: Windows Description:error msg feature request for initial server tasks Details: Hello

[BUGS] BUG #5780: Case insensitive regular expressions

The following bug has been logged online: Bug reference: 5780 Logged by: Thomas Bakketun Email address: thom...@copyleft.no PostgreSQL version: 8.4.5 Operating system: Ubuntu 10.04.1 LTS Description:Case insensitive regular expressions Details: Apparently case

Re: [BUGS] BUG #5657: wrong entry in sql_features

Tom Lane schrieb am 14.09.2010 18:34: Heikki Linnakangas writes: On 14/09/10 17:08, thommy wrote: -[ RECORD 2 ]+--- feature_id | B032 feature_name | Extended dynamic SQL sub_feature_id | 01 sub_feature_name | is_supported | NO is_verified_by

Re: [BUGS] BUG #5348: Postgres crashes with index on xpath_string

Thanks for the feedback. Is the problem specific to 8.4.2 or to the Windows platform (or both)? Regards Thomas Bruce Momjian, 27.02.2010 18:42: Yes, we have received a few reports about this and are working on a fix

[BUGS] BUG #5348: Postgres crashes with index on xpath_string

The following bug has been logged online: Bug reference: 5348 Logged by: Thomas Kellerer Email address: tho...@kellerer.name PostgreSQL version: 8.4.2 Operating system: Windows XP Description:Postgres crashes with index on xpath_string Details: With the contrib

Re: [BUGS] Failed to run initdb - not resolved bug 5130

s the path- and filenames written exactly, with upper and lower cases. Only pg_ctl.exe ?) Somme more results: - In windows, the createt datadirectorys belong to the windows-user "thomas", with permissions for "administrator" and "postgres", but not allways (I m

[BUGS] BUG #5231: SELECT DISTINCT poorly implemented vs SELECT ... GROUP BY

The following bug has been logged online: Bug reference: 5231 Logged by: Thomas Hamilton Email address: thomashamilto...@yahoo.com PostgreSQL version: 8.3.8 Operating system: Ubuntu 4.2.4 Description:SELECT DISTINCT poorly implemented vs SELECT ... GROUP BY Details

Re: [BUGS] BUG #5196: Excessive memory consumption when using csvlog

/postgres.log start so we have three logfiles : postgresql.log (always empty) postgresql--MM-DD.csv (big file if set to csvlog) postgresql--MM-DD.log (always empty if set to csvlog) Thanks. 2009/11/19 Tom Lane : > "Poindessous Thomas" writes: >> we have a weird bug. When u

[BUGS] BUG #5196: Excessive memory consumption when using csvlog

The following bug has been logged online: Bug reference: 5196 Logged by: Poindessous Thomas Email address: tho...@poindessous.com PostgreSQL version: 8.3.8 Operating system: Linux redhat 5.3 x86_64 Description:Excessive memory consumption when using csvlog Details

Re: [BUGS] BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior

Thanks Tom ... appreciate the clarification. Have a good day. thom Tom Lane wrote: "Thomas S. Chin" writes: Description:--disable-integer-datetimes changes timestamp comparison behavior This is not a bug. Float timestamps are inherently not infinitely precise, but your

[BUGS] BUG #5192: --disable-integer-datetimes changes timestamp comparison behavior

The following bug has been logged online: Bug reference: 5192 Logged by: Thomas S. Chin Email address: t...@photoshelter.com PostgreSQL version: 8.4.1 Operating system: Linux 2.6.28-hardened-r9-bitshelter #6 SMP x86_64 Intel(R) Xeon(R) Description:--disable-integer

[BUGS] BUG #5139: 2pc behaves differently on 8.3 and 8.4

The following bug has been logged online: Bug reference: 5139 Logged by: Thomas Kotzian Email address: thomas.kotz...@repromedia.at PostgreSQL version: 8.4.1 Operating system: Linux Description:2pc behaves differently on 8.3 and 8.4 Details: i upgraded from 8.3

[BUGS] BUG #5049: query crashing backend with TRAP: FailedAssertion

The following bug has been logged online: Bug reference: 5049 Logged by: Thomas Email address: m...@alternize.com PostgreSQL version: 8.4.0 Operating system: Debian lenny Description:query crashing backend with TRAP: FailedAssertion Details: while trying out the

Re: [BUGS] Is this the expected behaviour for DDL-query execution?

r now I will need to get this working on 8.2.x. Does this leave me with UPDATE triggers as the best viable (is it viable?) solution? Are there, as mentioned in previous post, some way to simulate the way the DB behaved when using rules for partitioning? Best Regards Thomas -- Sent via pgsql-

Re: [BUGS] Is this the expected behaviour for DDL-query execution?

he PG manual should mention something about this together with a proposed workaround? Best Regards, Thomas -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

[BUGS] Is this the expected behaviour for DDL-query execution?

on the partitioning column. Best Regards, Thomas -- 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 #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)

Ah, okay, found the documentation mentioning this (LIMIT). I was looking in the wrong place (ORDER BY clause). Thanks again for the help. Tom Lane wrote: "Thomas S. Chin" writes: I noticed that the behavior of queries that involve LIMIT/OFFSET no longer return results consisten

[BUGS] BUG #4779: LIMIT/OFFSET behavior change (possibly related to Top-n)

The following bug has been logged online: Bug reference: 4779 Logged by: Thomas S. Chin Email address: t...@genx.net PostgreSQL version: 8.3.7 Operating system: Linux tat 2.6.27-gentoo-r7 #1 SMP Fri Jan 2 08:50:09 EST 2009 i686 Intel(R) Core(TM)2 CPU 6700 @ 2.66GHz

Re: [BUGS] BUG #4661: Installation

Hello Greg, Hello Devrim, i will follow zour hints and answer back to you on it. I prefer to install SW like this via the source-code. Nevertheless thanks a lot Thomas Craig Ringer schrieb: Devrim GÜNDÜZ wrote: On Mon, 2009-02-16 at 12:11 +, Thomas Waelde wrote: i got the following

[BUGS] BUG #4661: Installation

The following bug has been logged online: Bug reference: 4661 Logged by: Thomas Waelde Email address: tho...@waelde.de PostgreSQL version: 8.3.5 Operating system: Linux (Ubuntu 8.10) Description:Installation Details: Configring the installation as ./configure

Re: [BUGS] BUG #4281: some types of errors do not log statements

thomas wrote: The following bug has been logged online: Bug reference: 4281 Logged by: thomas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Windows 2003 Description:some types of errors do not log statements Details: this isn&#

[BUGS] BUG #4281: some types of errors do not log statements

The following bug has been logged online: Bug reference: 4281 Logged by: thomas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.3 Operating system: Windows 2003 Description:some types of errors do not log statements Details: this isn't really a bu

Re: [BUGS] BUG #4186: set lc_messages does not work

From: Dave Page <[EMAIL PROTECTED]> On Thu, May 29, 2008 at 2:05 AM, Thomas H. <[EMAIL PROTECTED]> wrote: From: Thomas H. <[EMAIL PROTECTED]> i've just verified that the 8.3.1 msi version provided on postgres.org also does NOT contain the "locale" folder &

Re: [BUGS] BUG #4186: set lc_messages does not work

From: Thomas H. <[EMAIL PROTECTED]> what i noticed: if i delete the folder share/locale/de/ the system messages are back to english - but that can't be THE solution, can it? :) well, it actually was the solution, at least to the weird part of the problem: there are two versio

Re: [BUGS] BUG #4186: set lc_messages does not work

From: Tom Lane <[EMAIL PROTECTED]> "Thomas H." <[EMAIL PROTECTED]> writes: nevertheless the problem/bug exists: changing LC_MESSAGES has no effect on the windows boxes, while it works on the non-win32 systems. all i really would like is to get english system messages ba

Re: [BUGS] BUG #4186: set lc_messages does not work

ke is to get english system messages back on our non-english win32 servers - like they were pre 8.3.1. the main reason for this being: the german error messages have non-ascii special characters in the error text ('»' and '«') which mess with some of our application

Re: [BUGS] BUG #4186: set lc_messages does not work

d others, same problem, errors in german (excerpt above). [1] http://msdn.microsoft.com/en-us/library/ms776379(VS.85).aspx [2] http://msdn.microsoft.com/en-us/library/ms776388(VS.85).aspx [3] http://msdn.microsoft.com/en-us/library/ms776260.aspx regards, thomas -- 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 #4186: set lc_messages does not work

#x27;English_United_States' # locale for system error message # strings nevertheless, everything is outputted in german now, errors as well as logs. which seems to hint at 8.3.1 ignoring the LC_MESSAGES and always using the os'

[BUGS] BUG #4186: set lc_messages does not work

The following bug has been logged online: Bug reference: 4186 Logged by: Thomas H Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: Windows 2003 Description:set lc_messages does not work Details: the patch discussed here [1] that

[BUGS] BUG #3999: Panic with "invalid string enlargement request size" after a strange request from JDBC

The following bug has been logged online: Bug reference: 3999 Logged by: Thomas Poindessous Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.9 Operating system: RHEL 3ES.x86_64 Description:Panic with "invalid string enlargement request size" after

Re: [BUGS] BUG #3766: tsearch2 index creation error

Tom Lane wrote: "Thomas H." <[EMAIL PROTECTED]> writes: Tom Lane wrote: Can any Windows hackers check into whether the WIN32 coding in wchar2char() and char2wchar() in ts_locale.c is sane? has anyone had the chance to look into that problem? i'd be more than willi

[BUGS] BUG #3797: b4 msi installer fails when b3 is still installed

The following bug has been logged online: Bug reference: 3797 Logged by: thomas haegi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3b3/b4 Operating system: Windows 2003 Description:b4 msi installer fails when b3 is still installed Details: probably due to

Re: [BUGS] BUG #3766: tsearch2 index creation error

n provide me with a binary, i can test it. else i'll wait for the next official build. thanks, thomas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [BUGS] BUG #3766: tsearch2 index creation error

ated build if needed. thanks, thomas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

'rat':12 'sat':4 and doesn't contain stopwords like "a" and "and", which are included in the casted string... maybe an additional example that shows the usage of to_tsvector for any input string would help... thanks, thomas -

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

No such file or directory maybe win32 / file paths related? there are more problems with tsvectors. this also fails: SELECT ' just a test: 123 '::tsvector; ERROR: syntax error in tsvector: " just a test: 123 " ** Error ** ERROR: synt

Re: [BUGS] BUG #3767: tsearch2 index creation fatal crash

vector (which according to the documentation is equivalent) works just fine: SELECT 'a fat cat sat on a mat and ate a fat rat'::tsvector; gives the correct result. default configuration for text search is set to: default_text_search_config = 'pg_catalog.german' - th

[BUGS] BUG #3767: tsearch2 index creation fatal crash

The following bug has been logged online: Bug reference: 3767 Logged by: Thomas Haegi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3b3 Operating system: Windows 2003 Description:tsearch2 index creation fatal crash Details: the previously reported problem

[BUGS] BUG #3766: tsearch2 index creation error

The following bug has been logged online: Bug reference: 3766 Logged by: Thomas Haegi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3b3 Operating system: Windows 2003 Description:tsearch2 index creation error Details: when following the documentation (http

Re: [BUGS] 8.3b2: problem using "COPY ... TO/FROM .... BINARY"

tamp field: I'll bet a nickel that you built one version with float timestamps and the other with integer ... both versions are the official win32 builds from postgresl.org... - thomas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[BUGS] 8.3b2: problem using "COPY ... TO/FROM .... BINARY"

e to binary copy the remaining data without problems. is this a bug or a feature? :) - thomas ps: is there a way to convert the binary file to plain sql to directly check which record fails? i've tried to use pg_restore to read the file, but it said "does n

Re: [BUGS] BUG #3715: StackBuilder failing

Already fixed - theres an updated build at http://developer.pgadmin.org/~dpage/postgresql-8.3-beta2-2.zip Thanks for the report though. thanks, works fine now. maybe worth a short note in the download directory, so that others won't report the same thing? - t

Re: [BUGS] BUG #3715: StackBuilder failing

lled on your system. Source: SideBySide: Generate Activation Context failed for C:\Program Files\PostgreSQL\8.3-beta2\bin\StackBuilder.exe. Reference error message: The referenced assembly is not installed on your system. - thomas ---(end of broadcast)---

[BUGS] BUG #3715: StackBuilder failing

The following bug has been logged online: Bug reference: 3715 Logged by: Thomas Haegi Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3b2 Operating system: Windows 2003 Description:StackBuilder failing Details: This is on a vanilla 8.3b2 installation

[BUGS] BUG #3660: unused empty file is created with csvlog

The following bug has been logged online: Bug reference: 3660 Logged by: Thomas Reiss Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 beta 1 Operating system: Linux Description:unused empty file is created with csvlog Details: Hello, I just tried the

Re: [BUGS] BUG #3378: UTF-8 upper() and lower() don't work

hi kenneth these special characters work fine here: select lower('ÆØÅ'), upper('æøå'), lower('Æble, tørret'), upper('Æble, tørret'); result: æøå ÆØÅ æble, tørretÆBLE, TØRRET as pavel hinted, you probably aren't using the proper local

[BUGS] BUG #3329: Issue with INSERT INTO for japanese katakana characters.

The following bug has been logged online: Bug reference: 3329 Logged by: Thekkayil Joy Thomas Email address: [EMAIL PROTECTED] PostgreSQL version: 08.02.0100 Operating system: Windows 2000 Server Japanese Description:Issue with INSERT INTO for japanese katakana

Re: [BUGS] BUG #3259: Problem with automatic string cast

begin,(birthday+86399) as ending,1 as allday,cast('years' as char) as recurrence, 0 as until,1 as repeatinterval,0 as repeatcount,'' as repeatexcludes,0 as repeatbegin, 365 as repeatend from simple_contacts b where birthday!=0 ) p where ... bye Thomas Tom Lane wrote:

[BUGS] BUG #3259: Problem with automatic string cast

The following bug has been logged online: Bug reference: 3259 Logged by: Thomas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.1 Operating system: WinXP SP2 Description:Problem with automatic string cast Details: I have this SQL: select * from (select

Re: [BUGS] BUG #2973: Compile Error with MIPSpro compiler

Micheal, On Tuesday 20 February 2007 14:09, Michael Meskes wrote: > On Mon, Feb 19, 2007 at 03:46:38PM -0500, Bruce Momjian wrote: > > I see no one replied to this report. All I can say that many people > > Hmm, seems my filter didn't recognize this was about ecpg. > > > compile ecpg, and this is

[BUGS] BUG #2973: Compile Error with MIPSpro compiler

The following bug has been logged online: Bug reference: 2973 Logged by: Thomas Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.2 Operating system: IRIX 6.5 Description:Compile Error with MIPSpro compiler Details: During building the project with gmake I

Re: [BUGS] BUG #2838: Compile error "tab-complete.c" on Mac OS X

On Dec 19, 2006, at 7:29 AM, Tom Lane wrote: "Thomas Jahnsen" <[EMAIL PROTECTED]> writes: I try to compile PostgreSQL 8.2, but it fails in the file "tab- complete.c" (src/bin/psql/tab-complete.c). It reports an undeclared function call; 'rl_filename_c

Re: [BUGS] BUG #2853: Internal error XXOO Hangs while attempting to clear table after several successful iterations

upgrade to 8.2.0 that problem was fixed there (had it myself as well) - thomas - Original Message - From: "Terry Askew" <[EMAIL PROTECTED]> To: Sent: Thursday, December 21, 2006 6:13 PM Subject: [BUGS] BUG #2853: Internal error XXOO Hangs while attempting to c

Re: [BUGS] No error when FROM is missing in subquery

quot; = true for records with a ', ' in the name and "WHERE mov_id IN ()" = false for all others. - thomas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] No error when FROM is missing in subquery

with that subquery? did it return all records for which mov_name match '%, %'? - thomas ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] No error when FROM is missing in subquery

ike '%, %' LIMIT 2) the subselect is missing a FROM . in that case, pgsql seemed to also ignore the LIMIT 2 and returned 3706 records out of ~13... no clue which ones :-/ - thomas ---(end of broadcast)--- TIP 2: Don&#x

[BUGS] BUG #2838: Compile error "tab-complete.c" on Mac OS X

The following bug has been logged online: Bug reference: 2838 Logged by: Thomas Jahnsen Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2 Operating system: Mac OS X 10.4.8 PPC Description:Compile error "tab-complete.c" on Mac OS X Details: I try

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

exe!pg_queue_signal+0x120 - postgres.exe!shmctl+0x80 (i can get stacktraces for all of them if usefull) pid 3772 died at 05:55:22 (~20min after its last access to the file), and bgwriter could finally write, and the error messages are gone. - thomas ---(end of broadcast)

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

ore or less the same thing is happening every 2-3 seconds when the log errors appear. there was a short pause of ~30min when this error didn't appear, but for over 40min now it is logged every few seconds. the rc1 doesn't show this behaviour, i've just doublechecked. - thomas

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

ion is pending because another process (from the pgsql connection pool) is still keeping a handle open. as it is a connection pool process, it will be "recycled" after a while and release open handles: everytime the error messages disappear after some minutes... - thomas

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

was interrupted by a call to WSACancelBlockingCall. there is no pgstat.tmp file in global... - thomas ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-12-05 03:52:41 [736] ERROR: could not open relation 1663/16692/2361668: Permission denied ... and so on. - thomas ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail co

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

testing 8.2b1. but on the other hand, it might be that a hotfix is the cause for this error, as i haven't seen it before aug/sept 06. i sure would have noticed... - thomas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

n it appears 10 times a second everything seems "ok". but on the other side, in our case, we use the database as a web backend and have always around 20-30 concurrent connections, so its hard to debug. - thomas ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

2006-11-29 23:57:52 LOG: could not rename file "pg_xlog/00010019005E" to "pg_xlog/00010019007F", continuing to try i had this one as well. good news is: this bug is fixed in 8.2 - thomas ---(end of broadcast)-

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

Perhaps this should be #ifdef WIN32, although there's probably no harm in doing it on Unixen too. Can someone test this idea? if magnus/dave could provide me a patched rc1 exe, i could run it in our semi-productive environment for some tests. - thomas ---(e

Re: [BUGS] fsync and semctl errors with 8.1.5/win32

stion are locked by pgsql processes... under higher insert/update load, the errors appear more often here, do you experience the same finding when loading bulk data? - thomas ---(end of broadcast)--- TIP 1: if posting/reading through U

Re: [BUGS] BUG #2781: database dump/restore problems

x27;t affect backup size, should it? i'll restore one of the new backups later on to be sure all data is still there. - thomas ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [BUGS] BUG #2781: database dump/restore problems

esult, and no error messages. - thomas ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [BUGS] 8.2rc1: vacuum full fills up disk space

d that be the problem? the gin faq says a drop/create index would be much faster than a reindex. maybe this is also true when vacuuming a table with a gin-index? - thomas ---(end of broadcast)--- TIP 7: You can help support the Pos

Re: [BUGS] 8.2rc1: vacuum full fills up disk space

3332.000 ms statement: VACUUM FULL VERBOSE ANALYZE forum.posts thanks, - thomas ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[BUGS] 8.2rc1: vacuum full fills up disk space

tal diskspace fillup. what happens if i send a cancel signal to the process? b) .. gather some "evidence" if needed? c) .. check if the vacuum process is still alive? d) .. give the process in question a higher priority so it would finish sooner? thanks, thomas

[BUGS] BUG #2780: could not fsync segment 0

The following bug has been logged online: Bug reference: 2780 Logged by: Thomas H. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2rc1 Operating system: windows 2003 standard Description:could not fsync segment 0 Details: still seeing lots of these errors

  1   2   3   >