ERROR: XX000: function 60821C60 returned NULL

From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: ERROR: XX000: function 60821C60 returned NULL
Date: 2007-01-02 17:35:43
Message-ID: 53F9CF533E1AA14EA1F8C5C08ABC08D201521210@ZDND.DND.boston.cob
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I have an SQL job on SQL Server that dumps data to a table in
PostGreSQL. This job worked fine when it was going against a PG 8.1.3
server, but since my upgrade to PG 8.3, it has been working
intermittently. Mostly not working and erroring out with

ERROR: XX000: function 60821C60 returned NULL

I have other jobs doing similar feeds to other tables, and they still
work fine. So I can't quite figure out what is wrong with this one.
The only difference with this table is that the copy is done hourly
where as the other ones are done daily.

The table being inserted into looks like the below. If I drop the table
and recreate it, the routine starts working again. My SQL Server DTS
job uses the ODBC driver, but I tried a .NET script that uses the npgsql
driver and had the same issues. All fields are inserted into except the
the_point and gid fields. I'm going to reduce the frequency of
uploading and take out the OID to see if that makes a difference.

CREATE TABLE hbasessionsremaining
(
sessioncode character varying(17) NOT NULL,
remainingslots integer,
meetstarttime timestamp without time zone,
meetendtime timestamp without time zone,
number smallint NOT NULL,
date timestamp without time zone,
course character varying(5) NOT NULL,
classcode character varying(8) NOT NULL,
numberwaitlisted integer,
sessiongroup character varying(17),
"location" character varying(50),
locparcelid character(10),
descrip character varying(50),
locationcode character varying(3) NOT NULL,
the_point geometry,
address character varying(500),
gid serial NOT NULL,
CONSTRAINT pk_hbasessionsremaining PRIMARY KEY (sessioncode),
CONSTRAINT udx_hbasessionsremaining_gid UNIQUE (gid)
)
WITHOUT OIDS;
ALTER TABLE hbasessionsremaining OWNER TO robedev;
GRANT ALL ON TABLE hbasessionsremaining TO robedev;
GRANT ALL ON TABLE hbasessionsremaining TO dnddtsadmins WITH GRANT
OPTION;

Thanks,
Regina





-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.

Browse pgsql-bugs by date

  From Date Subject
Next Message Obe, Regina 2007-01-02 17:38:22 Re: ERROR: XX000: function 60821C60 returned NULL
Previous Message Tom Lane 2007-01-02 16:09:57 Re: BUG #2869: COALESCE in criteria and multiple joins behavior