Skip site navigation (1) Skip section navigation (2)

Re: need some help with pl-pgsql

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: justin <justin(at)emproshunts(dot)com>
Cc: "Adrian Klaver" <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: need some help with pl-pgsql
Date: 2008-12-24 16:54:59
Message-ID: dcc563d10812240854k632a57c1l804a9ee73d5dbda0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Wed, Dec 24, 2008 at 9:32 AM, justin <justin(at)emproshunts(dot)com> wrote:
>
>
> Found the problem at last.  it was what i thought early this morning, the
> database had some flaky data set to null.  so modified the the tables in
> question set defaults to zero and updated all the records  that has null to
> zero.  hopefully that fixes the problem going forward.
>
>  thanks to all for helping, pointing me in the right direction to figure out
> what is going on, as i was completely lost of what next to do.

Would it make sense to set that field to not null?

In response to

pgsql-general by date

Next:From: Erik JonesDate: 2008-12-24 17:12:27
Subject: Re: lack of consequence with domains and types
Previous:From: Scott MarloweDate: 2008-12-24 16:52:24
Subject: Re: Multi-tenant cluster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group