[BUGS] BUG #6726: pg_dump - ftell mismatch when using -Fc and split

2012-07-11 Thread andy . gumbrecht
The following bug has been logged on the website: Bug reference: 6726 Logged by: Andy Gumbrecht Email address: andy.gumbre...@orprovision.com PostgreSQL version: 9.1.4 Operating system: Windows 7 32 or 64 bit Description: Using: "D:\pg\bin\pg_dump.exe" -F

Re: [BUGS] BUG #6412: psql & fe-connect truncate passwords

2012-02-14 Thread Andy Grimm
On Sat, Jan 28, 2012 at 7:47 PM, Euler Taveira de Oliveira wrote: > On 28-01-2012 18:55, Andy Grimm wrote: >> It's not uniform between the client and the server, though. >> > The server doesn't impose a hard limit for password length and AFAICS it > should

Re: [BUGS] BUG #6412: psql & fe-connect truncate passwords

2012-01-30 Thread Andy Grimm
On Sat, Jan 28, 2012 at 5:48 PM, Alvaro Herrera wrote: > > Excerpts from Andy Grimm's message of sáb ene 28 14:32:24 -0300 2012: > >> Perhaps I should just submit the patch to pgsql-hackers ?  I'm new to >> the pgsql bug interaction process, so my apologies

Re: [BUGS] BUG #6412: psql & fe-connect truncate passwords

2012-01-28 Thread Andy Grimm
On Sat, Jan 28, 2012 at 1:50 PM, Euler Taveira de Oliveira wrote: > On 28-01-2012 14:32, Andy Grimm wrote: >> IMHO, there is a subtle difference here.  If psql raised an error >> message on passwords exceeding 100 characters, I would understand your >> perspective, bu

Re: [BUGS] BUG #6412: psql & fe-connect truncate passwords

2012-01-28 Thread Andy Grimm
e appropriate way to present the issue. I get Internal Server Error messages when I attempt to subscribe to any of the pgsql mailing lists, so this makes communication with the lists difficult. --Andy > -- >   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/ >   Postg

Re: [BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-09-06 Thread Andy Lester
ng with the standard "What do you mean you're not running autovacuum?" -- Andy Lester => a...@petdance.com => www.petdance.com => AIM:petdance

Re: [BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-09-05 Thread Andy Lester
el()). Is this a bug? I can't imagine how it NOT be a bug to do something that gets rid of dead tuples and then tell the user there are dead tuples when there are actually no dead tuples. xoa -- Andy Lester => a...@petdance.com => www.petdance.com => AIM:petdance -- Sen

[BUGS] BUG #5932: CLUSTER doesn't update n_dead_tup

2011-03-15 Thread Andy Lester
The following bug has been logged online: Bug reference: 5932 Logged by: Andy Lester Email address: a...@petdance.com PostgreSQL version: 9.0 Operating system: Linux Description:CLUSTER doesn't update n_dead_tup Details: The CLUSTER command does not updat

Re: [BUGS] BUG #5490: INSERT doesn't force cast from text to timestamp

2010-06-07 Thread Andy Balholm
On Jun 7, 2010, at 7:53 AM, Tom Lane wrote: > Andy Balholm writes: >> Is there a way to make values of "undefined" type pass through the >> SELECT DISTINCT filter (getting checked for uniqueness) but remain >> "undefined" > > No. What is your crit

Re: [BUGS] BUG #5490: INSERT doesn't force cast from text to timestamp

2010-06-07 Thread Andy Balholm
Craig Ringer wrote: > showing that your issue isn't actually with DISTINCT at all, but with Pg's > unwillingness to *implicitly* cast a value of explict text type to another > type. Is there a way to make values of "undefined" type pass through the SELECT DISTINCT filter (getting checked for un

Re: [BUGS] bugs that have not been replied-to on list

2010-04-19 Thread Andy Balholm
had (and documented) a list for new features, it might reduce some of the triage needed on -bugs. Andy Balholm (509) 276-2065 a...@balholm.com -- 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] bugs that have not been replied-to on list

2010-04-09 Thread Andy Balholm
On Apr 9, 2010, at 5:08 AM, Robert Haas wrote: > Something is wrong with this > mailing list. In the week and a half that I've been subscribed to this mailing list, there have been several times that I received a reply to a message without receiving the original message. In most cases, I rece

Re: [BUGS] dividing money by money

2010-04-01 Thread Andy Balholm
On Apr 1, 2010, at 7:57 AM, Kevin Grittner wrote: > I'm inclined to think it's better to have an explicit cast from > money to numeric, as long as it is exact, and leave the division of > money by money as float8. It does sort of beg the question of > whether we should support a cast back in the o

Re: [BUGS] dividing money by money

2010-03-31 Thread Andy Balholm
> That's hardly an improvement if you're concerned about lack of > exactness. I know; I lose a couple of digits by using float8 instead of numeric, but it's much simpler and faster, and if it returned numeric people would _think_ it was exact. And if we have a cast to numeric, people who want t

Re: [BUGS] dividing money by money

2010-03-31 Thread Andy Balholm
> Or I guess we could leave this as you've written it and add support > for a cast from money to numeric. I tried rewriting my function to use numeric, but I discovered that numeric division is not exact. (Otherwise SELECT 1::numeric / 3::numeric would result in an infinite loop.) So I went back

Re: [BUGS] dividing money by money

2010-03-31 Thread Andy Balholm
On Mar 31, 2010, at 11:01 AM, Kevin Grittner wrote: > That was my first inclination, but the fact that two different > people talked about using division by '1'::money as a way to convert > money to another type has me nervous about using an approximate > type. Any chance you could rework it usin

Re: [BUGS] dividing money by money

2010-03-31 Thread Andy Balholm
On Mar 31, 2010, at 7:07 AM, Kevin Grittner wrote: > (I was going to mark the TODO as an easy one.) I thought it would be pretty simple, too, so I decided to go ahead and write and test it as an external module. I think the function definition could be pasted directly into an appropriate pl

[BUGS] dividing money by money

2010-03-29 Thread Andy Balholm
rcent one money value is of another. That is what I was wanting to use it for—finding out what percentage of a customer's original balance has been paid off. It would also provide a better way to convert money into numeric types than the regular expression in the documentation. You c

[BUGS] BUG #5355: locale incorrectly comma-separates "(null)"

2010-03-01 Thread Andy Lester
The following bug has been logged online: Bug reference: 5355 Logged by: Andy Lester Email address: a...@petdance.com PostgreSQL version: 8.3.6 Operating system: Linux Description:locale incorrectly comma-separates "(null)" Details: In my .psqlrc

[BUGS] lseg ?# (intersects) incorrect for lsegs whose intersection is another lseg

2008-03-11 Thread Andy Meyer
Using PostgreSQL 8.2.3, on linux (FC3): test=> select lseg'((0,0),(1,0))' ?# lseg'((0,0),(1,0))'; -[ RECORD 1 ] ?column? | f while avail=> select lseg'((0,0),(1,0))' ?# lseg'((0,0),(1,1))'; -[ RECORD 1 ] ?column? | t Looking over the geometric operations source it appears that the intersect o

[BUGS] BUG #3978: plperl configure / build process behavior wrt Universal Binaries

2008-02-21 Thread Andy Satori
The following bug has been logged online: Bug reference: 3978 Logged by: Andy Satori Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Mac OS X Description:plperl configure / build process behavior wrt Universal Binaries Details: It appears

[BUGS] BUG #2629: libpq - Cannot deallocate prepared statement created with PQprepare()

2006-09-16 Thread Andy McCurdy
The following bug has been logged online: Bug reference: 2629 Logged by: Andy McCurdy Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.4 Operating system: Windows XP Description:libpq - Cannot deallocate prepared statement created with PQprepare() Details

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-16 Thread Andy
always the same, is there some way we can view the data being stored in the memory, or look at what data was stored in the memory, and where, to see if the reference is valid?   Regards Andy     “Tom Lane writes: >> We've seen reports of intermittent permission failures on Wi

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-09 Thread Andy
ill have a production server on which I can’t run the database since I can’t debug the error.  Any suggestions?   Thank you for your assistance. Andy      

Re: [BUGS] BUG #2419: could not reattach to shared memory

2006-05-08 Thread Andy Male
in the database. Any help would be most appreciated. Thanks Andy ** LOG FILE SNIP ** 2006-05-07 23:44:19 10.10.12.100(4018)LOG: 0: statement: EXECUTE npgsqlportal1 [PREPARE: select * from fn_Driver_Session_Updated($1::int8,$2::bool)] 2006-05-07 23:44:19 10.10.12.100(4018)LOCATION: ex

[BUGS] BUG #2419: could not reattach to shared memory

2006-05-05 Thread Andy Male
The following bug has been logged online: Bug reference: 2419 Logged by: Andy Male Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Windows 2003 Server (standard) SP1 Description:could not reattach to shared memory Details: FULL ERROR IN

[BUGS] BUG #2246: Bad malloc interactions: ecpg, openssl

2006-02-08 Thread Andy Klosterman
The following bug has been logged online: Bug reference: 2246 Logged by: Andy Klosterman Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.0 Operating system: Debian testing: Linux nc3 2.4.27-2-386 #1 Wed Nov 30 21:38:51 JST 2005 i686 GNU/Linux Description:Bad

[BUGS] 8beta xp install freeze

2004-08-20 Thread Andy Tawse
entry in the event viewer is : Product: PostgreSQL 8.0-beta1 -- The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2755. The arguments are: 1601, C:\Documents and Settings\Andy T\My Documents\download

Re: [BUGS] Version 7.2.3 unrecoverable crash on missing pg_clog

2003-01-09 Thread Andy Osborne
Tom Lane wrote: Andy Osborne <[EMAIL PROTECTED]> writes: Tom Lane wrote: > But with no way to reproduce it it's hard to pin blame. Sad but true :-( You didn't happen to make a physical copy of the news table before dropping it, did you? It'd be interestin

Re: [BUGS] Version 7.2.3 unrecoverable crash on missing pg_clog

2003-01-09 Thread Andy Osborne
Tom Lane wrote: Andy Osborne <[EMAIL PROTECTED]> writes: One of our databases crashed yesterday with a bug that looks a lot like the non superuser vacuum issue that 7.2.3 was intended to fix, although we do our vacuum with a user that has usesuper=t in pg_user so I guess it's not

[BUGS] Version 7.2.3 unrecoverable crash on missing pg_clog

2003-01-09 Thread Andy Osborne
imilar problems with 7.2.3 ?. Any clues ? Andy -- Andy Osborne "Vertical B2B Communities" Senior Internet Engineer Sift Group100 Victoria Street, Bristol BS1 6HZ tel:+44 117 915 9600 fax:+44 117 915 9630 http://www.sift.co

[BUGS] select fails to return certain rows from table

2002-10-28 Thread Andy Dunlop
I am selecting rows from a table using "select * from gla where glacode = $glresult[0]" $glresult[0] comes from a previous query result. For the first three rows in the table I get the error "Warning: Unable to jump to row 0 on PostgreSQL result index 4 in /home/httpd/infocus/html/iris/ben_g

Re: [BUGS] Full bug list

2002-02-22 Thread Andy Marden
It would be useful to be able to search a list of known bugs for the version of postgresql that you're running. Upgrading to the latest version to see if it sorts out a problem isn't always a sensible option.. Andy - Original Message - From: "Justin" <[EMAIL PROTE

[BUGS] Full bug list

2002-02-21 Thread Andy Marden
Is there a repository on the web somewhere of all the bugs found, versions they are found against and what theire status is? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEm

Re: [BUGS] Dates and year 2000

2002-02-21 Thread Andy Marden
Just discovered that column::date works fine but to_date(column, 'DD.MM.YY') causes the problem. I was trying to write portable SQL, but never mind! Andy ""Andy Marden"" <[EMAIL PROTECTED]> wrote in message 007301c1baad$b60d7b90$010a@marden1">

Re: [BUGS] Dates and year 2000

2002-02-20 Thread Andy Marden
Do we have a workaround for 7.1.3? I don't really want to risk an upgrade at this stage in the system Cheers Andy - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Andy Marden" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: We

Re: [BUGS] Dates and year 2000

2002-02-20 Thread Andy Marden
Is this a bug? "Andy Marden" <[EMAIL PROTECTED]> wrote in message news:a4u6fh$orp$[EMAIL PROTECTED]... > Am loading date fields from text in one table to date in another. Format of > the text dates is 'DD.MM.YY', so that's the format mask I use. Dates for &