The following bug has been logged online:
Bug reference: 5054
Logged by: Yujin
Email address: aloudno...@mail.ru
PostgreSQL version: 8.3
Operating system: windows XP SP3
Description:PDO -> Query returns "" from Boolean type field, if it
has false value.
Details:
Wh
On Sun, Sep 13, 2009 at 10:28 PM, Tom Lane wrote:
> "Andrew Gierth" writes:
>> Domain NOT NULL constraints (and probably other constraints too) aren't
>> being enforced in some code paths. e.g.
>
> The example you give seems to tie really closely into the debate about
> whether a composite null i
On Wed, Sep 9, 2009 at 5:42 AM, mahmoud badr wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5046
> Logged by: mahmoud badr
> Email address: alien_...@yahoo.com
> PostgreSQL version: 8.4
> Operating system: windows
> Description: java developer
>
hi,
i got following error while selecting from my db
ERROR: invalid page header in block 502758 of relation base/16388/16403
i've found some solution in this thread
http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg101644.html
but my problem is, that there are multiple files with sim
i forgot the system informations
postgresql-server-8.4.0-1PGDG.rhel5
linux kernel 2.6.18-128.4.1.el5xen x86_64
centos release 5.3 (final)
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Robert Haas writes:
> It seems like regardless of this discussion you oughtn't to be able to
> store a NULL into that table column. But maybe I'm just confused.
The system is relying on the not-unreasonable assumption that if it
extracts a column of type X from someplace, what it has is a valid
"Yujin" writes:
> When i get query from table with bolean type fields, that have false value ,
> function PDO -> fetch return that fields with not "0" value , but empty
> string.
Are you sure the field is actually false, and not null?
If so, this is a PDO bug, not a Postgres bug.
fous velkej writes:
> i got following error while selecting from my db
> ERROR: invalid page header in block 502758 of relation base/16388/16403
> i've found some solution in this thread
> http://www.mail-archive.com/pgsql-gene...@postgresql.org/msg101644.html
> but my problem is, that there a
On Mon, Sep 14, 2009 at 11:16:23AM -0400, Robert Haas wrote:
> I haven't read the code in this area, but for what it's worth, I guess
> I lean toward the view that treating a row of NULLs as being the same
> thing as an undecorated NULL does not make very much sense.
I agree; when compared to most
Sam Mason wrote:
> the deeper problem seems to be that the table was created as:
>
> create table test (a tstdom);
>
> and not as:
>
> create table test (a tstdom not null);
Given that tstdom is declared as NOT NULL, is this difference
considered a *feature* or is it an implementation q
On Mon, Sep 14, 2009 at 10:22 AM, Tom Lane wrote:
> Robert Haas writes:
>> It seems like regardless of this discussion you oughtn't to be able to
>> store a NULL into that table column. But maybe I'm just confused.
>
> The system is relying on the not-unreasonable assumption that if it
> extract
On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote:
> Sam Mason wrote:
> > the deeper problem seems to be that the table was created as:
> >
> > create table test (a tstdom);
> >
> > and not as:
> >
> > create table test (a tstdom not null);
>
> Given that tstdom is declared a
On Mon, Sep 14, 2009 at 10:22:34AM -0400, Tom Lane wrote:
> Robert Haas writes:
> > It seems like regardless of this discussion you oughtn't to be able to
> > store a NULL into that table column. But maybe I'm just confused.
>
> The system is relying on the not-unreasonable assumption that if it
On Thu, Sep 10, 2009 at 7:17 AM, Rohan jamadagni
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5047
> Logged by: Rohan jamadagni
> Email address: rohan.jamada...@tcs.com
> PostgreSQL version: 8.3.7
> Operating system: Linux Rhel 5.0
> Description:
On Fri, Sep 4, 2009 at 6:02 PM, Rob Resendez wrote:
> The following bug has been logged online:
>
> Bug reference: 5037
> Logged by: Rob Resendez
> Email address: rob.resen...@cpsinet.com
> PostgreSQL version: 8.3.7
> Operating system: Linux
> Description: jdbc bug \uff
In recovery of GIN operations using CVS HEAD I see consistently
TRAP: FailedAssertion("!(((bool) ((spcNode) != ((Oid) 0", File:
"tablespace.c", Line: 116)
Looking at code, "new list page" WAL record is a GIN record type and at
line 115 in gin/ginfast.c I see that the value of the node is unse
The following bug has been logged online:
Bug reference: 5056
Logged by: the6campbells
Email address: the6campbe...@gmail.com
PostgreSQL version: 8.4.1
Operating system: windows
Description:SQLDescribeColW for function returning a result set
incorrectly setting sql_nu
On Mon, Sep 14, 2009 at 10:40 PM, the6campbells wrote:
>
> The following bug has been logged online:
>
> Bug reference: 5056
> Logged by: the6campbells
> Email address: the6campbe...@gmail.com
> PostgreSQL version: 8.4.1
> Operating system: windows
> Description: SQLDes
The following bug has been logged online:
Bug reference: 5055
Logged by: john martin
Email address: postgres_...@live.com
PostgreSQL version: 8.3.6
Operating system: Centos 5.2 32 bit
Description:Invalid page header error
Details:
All of a sudden we started seeing p
On Mon, 2009-09-14 at 23:17 +, john martin wrote:
> All of a sudden we started seeing page header errors in certain queries.
Was there any particular event that marked the onset of these issues?
Anything in the system logs (dmesg / syslog etc) around that time?
[for SATA disks]: does smartc
Craig Ringer wrote:
[for SATA disks]: does smartctl from the smartmontools package indicate
anything interesting about the disk(s)? (Ignore the "health status",
it's a foul lie, and rely on the error log plus the vendor attributes:
reallocated sector count, pending sector, uncorrectable sector co
Tom Lane wrote:
"Yujin" writes:
When i get query from table with bolean type fields, that have false value ,
function PDO -> fetch return that fields with not "0" value , but empty
string.
Are you sure the field is actually false, and not null?
If so, this is a PDO bug, not a Postgr
Mark Kirkwood wrote:
I guess it must be something funny with how PDO represents the bool
type...(will have a look at the PDO code). But this needs to be raised
on bugs.php.net.
FYI - a related bug is : http://bugs.php.net/bug.php?id=33876
--
Sent via pgsql-bugs mailing list (pgsql-bugs@po
On Mon, 2009-09-14 at 22:58 -0700, John R Pierce wrote:
> and, if you're doing RAID with desktop grade disks, its quite possible
> for the drive to spontaneously decide a sector error requires a data
> relocation but not have the 'good' data to relocate, and not return an
> error code in time f
Simon Riggs wrote:
> In recovery of GIN operations using CVS HEAD I see consistently
>
> TRAP: FailedAssertion("!(((bool) ((spcNode) != ((Oid) 0", File:
> "tablespace.c", Line: 116)
>
> Looking at code, "new list page" WAL record is a GIN record type and at
> line 115 in gin/ginfast.c I see t
25 matches
Mail list logo
