Hi all,
when trying to restore a dump I get the following error:
pg_restore: [archiver (db)] could not execute query: ERROR: argument of commutator
must be a name
Operator commutator is itself, and when reading the ascii version
of the dump (produced with -Fc) I see that this has been changed
Operator commutator is itself, and when reading the ascii version
of the dump (produced with -Fc) I see that this has been changed
with what was probably it's oid instead.
Can you paste that ascii from the dump?
Is this a bug in pg_dump ?
How do I tell which pg_dump version produced the dump ?
I'm
On Tue, Aug 03, 2004 at 04:49:48PM +0800, Christopher Kings-Lynne wrote:
Operator commutator is itself, and when reading the ascii version
of the dump (produced with -Fc) I see that this has been changed
with what was probably it's oid instead.
Can you paste that ascii from the dump?
--
--
--
-- TOC entry 537 (OID 2663955)
-- Name: ~=; Type: OPERATOR; Schema: public; Owner: strk
-- Data Pos: 0
--
CREATE OPERATOR ~= (
PROCEDURE = geometry_same,
LEFTARG = geometry,
RIGHTARG = geometry,
COMMUTATOR = 2663954,
RESTRICT = eqsel,
JOIN = eqjoinsel
);
How about:
\x
On Tue, Aug 03, 2004 at 05:17:27PM +0800, Christopher Kings-Lynne wrote:
--
-- TOC entry 537 (OID 2663955)
-- Name: ~=; Type: OPERATOR; Schema: public; Owner: strk
-- Data Pos: 0
--
CREATE OPERATOR ~= (
PROCEDURE = geometry_same,
LEFTARG = geometry,
RIGHTARG = geometry,