[BUGS] BUG #6406: Included pgAdmin does not have .sql file extension mapped

2012-01-22 Thread aren
The following bug has been logged on the website: Bug reference: 6406 Logged by: Aren Cambre Email address: a...@arencambre.com PostgreSQL version: 9.1.2 Operating system: Windows 7 x64 Description: When I install Postgres, the included pgAdmin III is not set up

[BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-16 Thread aren
The following bug has been logged on the website: Bug reference: 6535 Logged by: Aren Cambre Email address: a...@arencambre.com PostgreSQL version: 9.1.3 Operating system: Windows 7 x64 Description: (Note that this issue is described fully at http://stackoverflow.com

[BUGS] BUG #5808: Remove PgOleDB from Stack Builder

2010-12-30 Thread Aren Cambre
The following bug has been logged online: Bug reference: 5808 Logged by: Aren Cambre Email address: a...@arencambre.com PostgreSQL version: 9.0.2 Operating system: Windows 7 32 bit Description:Remove PgOleDB from Stack Builder Details: Is it time to stop letting

[BUGS] BUG #5839: pgAdmin makes bad query for creating a table when default value specified

2011-01-14 Thread Aren Cambre
The following bug has been logged online: Bug reference: 5839 Logged by: Aren Cambre Email address: a...@arencambre.com PostgreSQL version: 9.0.2 Operating system: Windows 7 32 bit Description:pgAdmin makes bad query for creating a table when default value specified

Re: [BUGS] BUG #5839: pgAdmin makes bad query for creating a table when default value specified

2011-01-14 Thread Aren Cambre
This came from pgAdmin's *Default value* field. This field is supposed to accept anything other than a string? Aren On Fri, Jan 14, 2011 at 9:51 PM, Tom Lane wrote: > "Aren Cambre" writes: > > Using pgAdmin 1.12.2, I just tried to create a table with a character >

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
effect is to reduce the number of rows returned, could cause *more* rows to be returned. That seems buggy to me. Aren On Fri, Mar 16, 2012 at 12:56 PM, Tom Lane wrote: > a...@arencambre.com writes: > > (Note that this issue is described fully at > > > http://stackoverflow.com

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
bug, I may not be much help in nailing it down. The only thing I can help with is this appears to have happened at row # 583847 of just over 2 million rows, per a straight CSV dump of the table. Aren On Sun, Mar 18, 2012 at 3:22 PM, Kevin Grittner wrote: > Aren Cambre wrote: >

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
Kevin, Thanks. That was a direct copy/paste. It happened that the *UNION*ed queries spat out those results in the same order that the queries appeared. Just want to again emphasize that my database state has changed, so I am not sure this is remains a good case for finding a bug. Aren On Sun

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-18 Thread Aren Cambre
to 9.1 almost as soon as it came out, doing the requisite dumps and reloads. I have also reindexed a couple of times as diagnostic steps. So far, looks like only that one row has data corruption. Aren On Sun, Mar 18, 2012 at 9:33 PM, Tom Lane wrote: > Aren Cambre writes: > > Just want

Re: [BUGS] BUG #6535: LEFT JOIN on large table is altering data

2012-03-19 Thread Aren Cambre
a good > characteristic on a database administrator. > Which is why I could never be a DBA. :-) I am the only user. This is for my doctoral research project. Aren