Re: [BUGS] BUG #5971: NpgSql link doesnt work

2011-04-12 Thread Dave Page
On Mon, Apr 11, 2011 at 9:01 AM, John Taylor wrote: > > The following bug has been logged online: > > Bug reference:      5971 > Logged by:          John Taylor > Email address:      kakaoscsig...@gmail.com > PostgreSQL version: 9.0 > Operating system:   Windows 7 > Description:        NpgSql link

Re: [BUGS] BUG #5971: NpgSql link doesnt work

2011-04-12 Thread Magnus Hagander
On Tue, Apr 12, 2011 at 09:29, Dave Page wrote: > On Mon, Apr 11, 2011 at 9:01 AM, John Taylor wrote: >> >> The following bug has been logged online: >> >> Bug reference:      5971 >> Logged by:          John Taylor >> Email address:      kakaoscsig...@gmail.com >> PostgreSQL version: 9.0 >> Oper

[BUGS] BUG #5973: erreur SERIAL 4

2011-04-12 Thread
The following bug has been logged online: Bug reference: 5973 Logged by: Email address: poiretl...@gmail.com PostgreSQL version: 9.0.3 Operating system: windows 7 Description:erreur SERIAL 4 Details: Hello, I use PostgreSQL PgAdmin 9 and III. I am running Windows 7

[BUGS] BUG #5972: Update with subquery: erroneous results for foreign key field

2011-04-12 Thread Paul
The following bug has been logged online: Bug reference: 5972 Logged by: Paul Email address: paul.co...@punct.ro PostgreSQL version: 9.0.3 Operating system: CentOS 5.5 Description:Update with subquery: erroneous results for foreign key field Details: Hello. We foun

Re: [BUGS] BUG #5972: Update with subquery: erroneous results for foreign key field

2011-04-12 Thread Kevin Grittner
"Paul" wrote: > update cart set status = 1 where userid = (select userid from > users where email = 'exam...@example.com'); > > As you can see, the subquery is broken (users table doesn't have > the column userid). By standard, if the identifier isn't defined within the most local scope, each

Re: [BUGS] BUG #5972: Update with subquery: erroneous results for foreign key field

2011-04-12 Thread Paul Cocei
Thank you very much, i understand now :) Paul On Tue, Apr 12, 2011 at 4:42 PM, Kevin Grittner wrote: > "Paul" wrote: > > > update cart set status = 1 where userid = (select userid from > > users where email = 'exam...@example.com'); > > > > As you can see, the subquery is broken (users table d

Re: [BUGS] [GENERAL] PostgreSQL backend process high memory usage issue

2011-04-12 Thread Merlin Moncure
On Tue, Apr 12, 2011 at 12:48 PM, Shianmiin wrote: > > Merlin Moncure-2 wrote: >> >> >> I am not seeing your results.  I was able to run your test on a stock >> config (cut down to 50 schemas though) on a vm with 512mb of memory. >> What is your shared buffers set to? >> >> > > The shared buffers

Re: [BUGS] BUG #5970: intersect and collation on types

2011-04-12 Thread Tom Lane
"Rikard Pavelic" writes: > The following bug has been logged online: > Bug reference: 5970 > Logged by: Rikard Pavelic > Email address: rikard.pave...@zg.htnet.hr > PostgreSQL version: 9.1.alpha5 > Operating system: Windows XP SP3 > Description:intersect and collation

Re: [BUGS] BUG #5973: erreur SERIAL 4

2011-04-12 Thread Craig Ringer
On 12/04/2011 8:57 PM, poiretl...@gmail.com wrote: except that pgadmin III does not want ... I'm stuck .. Please show the exact text of any error messages. Read: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.c

[BUGS] BUG #5976: Corrupted pages on the production database

2011-04-12 Thread Vlad Arkhipov
The following bug has been logged online: Bug reference: 5976 Logged by: Vlad Arkhipov Email address: arhi...@dc.baikal.ru PostgreSQL version: 9.0.3 Operating system: Red Hat 4.1.2-48, 64-bit Description:Corrupted pages on the production database Details: I have rec

Re: [BUGS] [GENERAL] PostgreSQL backend process high memory usage issue

2011-04-12 Thread Tom Lane
Merlin Moncure writes: > I think you may have uncovered a leak (I stand corrected). > The number of schemas in your test is irrelevant -- the leak is > happening in proportion to the number of views (set via \setrandom > tidx 1 10). At 1 I don't think it exists at all -- at 100 memory use > grow

Re: [BUGS] BUG #5976: Corrupted pages on the production database

2011-04-12 Thread Heikki Linnakangas
On 13.04.2011 06:52, Vlad Arkhipov wrote: There is also a stand-by server (streaming replication) which does not have this error. I've elaborated on this issue a bit and found 2 corrupted pages in the file of relation. The first one is semi-corrupted, one half of it is correct, but another part c

[BUGS] BUG #5974: UNION construct type cast gives poor error message

2011-04-12 Thread Jeff Wu
The following bug has been logged online: Bug reference: 5974 Logged by: Jeff Wu Email address: j...@atlassian.com PostgreSQL version: 9.0 Operating system: Mac OS X Description:UNION construct type cast gives poor error message Details: The UNION construct (as note

[BUGS] BUG #5975: Incorrect result from mod function with cast

2011-04-12 Thread John Dickson
The following bug has been logged online: Bug reference: 5975 Logged by: John Dickson Email address: jdick...@tnsi.com PostgreSQL version: 8.3.11 Operating system: RedHat EL 5.6 Description:Incorrect result from mod function with cast Details: The mod function (and