Re: [SQL] Re: need urgent help

Tom,

We are fixing it now.

postgres-7.1.2
urldb=# \d urlinfo
Table "urlinfo"
Attribute | Type | Modifier
-----------+--------------------------+----------------------------------
url | text | not null
id | integer | not null
ratedby | character varying(32) |
ratedon | timestamp with time zone | default "timestamp"('now'::text)
comments | text |
list | smallint |
pidwsr | integer |
Index: urlinfo_pkey

the original schema includes another constraint which using a user defined
function to check whether url is validate or not.

we fixed input data at line 11419.

thanks.

Jie LIANG

St. Bernard Software

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang(at)ipinc(dot)com
www.stbernard.com
www.ipinc.com

On Sun, 17 Jun 2001, Tom Lane wrote:

> Jie Liang <jliang(at)ipinc(dot)com> writes:
> > when I reload my database from pg_dumpall:
> > COPY "urlinfo" FROM stdin;
> > ERROR: copy: line 11419, MemoryContextAlloc: invalid request size
> > 4294967271
> > PQendcopy: resetting connection
>
> Postgres version? Table schema? Input data?
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>