>
> > Thanks. I am running this on 1 year old hardware on a wholly-encrypted C
> > drive, encrypted with TrueCrypt. I suspect that I would have been alerted
> > already with that or SMART if I had hardware issues?
>
> That sounds excessively optimistic -- not necessarily a good
> characteristic on
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
, Mar 18, 2012 at 3:33 PM, Kevin Grittner wrote:
> "Kevin Grittner" wrote:
> > Aren Cambre wrote:
> >
> >> SELECT COUNT(*)
> >> FROM consistent.master
> >> WHERE citation_id IS NOT NULL
> >> UNION
> >> SELECT COUNT(*)
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:
>
Thanks. While creating that very file, I discovered that 1 row had blanks
in every field despite a column having a *NOT NULL* constraint and another
column being a* *serial. Removing that column appears to fixed the problem.
Something about that column made Postgres unhappy, though. If I ran these
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
>
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
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