On Sat, 20 Oct 2001 12:36:16 -0400, Tom Lane wrote:
>That's what you showed us already. What I'd like to see is the
>original database contents, particularly
>
> select * from pg_operator where oid = 280343;
> select * from pg_operator where oid = 280344;
>
>so we can see why pg_dump
On Sun, 21 Oct 2001 12:42:57 -0400, Tom Lane wrote:
>>> select * from pg_operator where oid = 280343;
>>> select * from pg_operator where oid = 280344;
>> Attached you find the results of the above selects.
>
>Okay ... are there any rows in pg_operator with OID 280346 or 280347 ?
Yes, seems so.
On Sun, 21 Oct 2001 14:14:05 -0400, Tom Lane wrote:
>Looks like these are "shell" operator definitions left over from
>commutator or negator forward references that were never satisfied.
>pg_dump did the right thing to not dump them. I'd say that the backend
>should never have accepted a shell o
"Johann Zuschlag" <[EMAIL PROTECTED]> writes:
>> Okay ... are there any rows in pg_operator with OID 280346 or 280347 ?
> Yes, seems so. See the attachment. Again, the negator stuff
> never worked for numeric.
Looks like these are "shell" operator definitions left over from
commutator or negator
"Johann Zuschlag" <[EMAIL PROTECTED]> writes:
>> select * from pg_operator where oid = 280343;
>> select * from pg_operator where oid = 280344;
> Attached you find the results of the above selects.
Okay ... are there any rows in pg_operator with OID 280346 or 280347 ?
reg
"Johann Zuschlag" <[EMAIL PROTECTED]> writes:
> create function numeric_neq(numeric,float8) returns bool as '
> select $1 = $2::numeric;
> ' language 'sql';
> create operator <> (
> leftarg=numeric,
> rightarg=float8,
> procedure=numeric_neq,
> commutator='<>',
> negator='',
^
"Johann Zuschlag" <[EMAIL PROTECTED]> writes:
> Here is an excerpt of the original dump-file.
That's what you showed us already. What I'd like to see is the
original database contents, particularly
select * from pg_operator where oid = 280343;
select * from pg_operator where oid
"Johann Zuschlag" <[EMAIL PROTECTED]> writes:
> DEBUG: query: CREATE OPERATOR <> (PROCEDURE = numeric_neq ,
> LEFTARG = numeric ,
> RIGHTARG = double precision ,
> COMMUTATOR = <> ,
> NEGATOR = ,
> RESTRICT = eqsel ,
> JOIN = eqjoinsel );
> ERROR:
Hi,
Version 7.1.3, Linux 2.2.18
Following procedure:
1. pg_dump dbname > outfile
Everything is fine.
2. Recreating the database on another system (same Versions)
psql dbname < infile
I get once:
ERROR: parser: parse error at or near ","
The rest works fine.
Debug -d2 shows that recreating a
