Re: [BUGS] BUG #7758: pg_dump does not correctly dump operators.

2012-12-19 Thread Tom Lane
I wrote: > I believe we've looked at this in the past, and not found any cure > that wasn't worse than the disease. BTW, the previous discussion that I was vaguely remembering is here: http://archives.postgresql.org/pgsql-hackers/2010-09/msg02035.php regards, tom lane --

Re: [BUGS] BUG #7758: pg_dump does not correctly dump operators.

2012-12-19 Thread Tom Lane
Daniel Migowski writes: > DROP OPERATOR IF EXISTS #<#(text,text) CASCADE; > CREATE OPERATOR #<#( > PROCEDURE = text_natsort_lt, > LEFTARG = text, > RIGHTARG = text, > COMMUTATOR = #>#, > RESTRICT = scalarltsel, > JOIN = scalarltjoinsel); > DROP OPERATOR IF EXISTS #>#(text,text) CAS

Re: [BUGS] BUG #7758: pg_dump does not correctly dump operators.

2012-12-19 Thread Daniel Migowski
The second mail just has the mailing list in CC, sorry for forgetting this before. -Ursprüngliche Nachricht- Von: Tom Lane [mailto:t...@sss.pgh.pa.us] Gesendet: Mittwoch, 19. Dezember 2012 20:09 An: Daniel Migowski Cc: pgsql-bugs@postgresql.org Betreff: Re: [BUGS] BUG #7758: pg_dump does not corr

Re: [BUGS] BUG #7758: pg_dump does not correctly dump operators.

2012-12-19 Thread Tom Lane
dmigow...@ikoffice.de writes: > When inserted into an empty DB on an 9.1.2 system, then pg_dump will > generate wrong CUMMUTATOR clauses, but only for the first operator: > ... > Sadly, when I use these operators in my real world database running on > 9.1.7, the problem is still there: Indeed, I d

[BUGS] BUG #7758: pg_dump does not correctly dump operators.

2012-12-19 Thread dmigowski
The following bug has been logged on the website: Bug reference: 7758 Logged by: Daniel Migowski Email address: dmigow...@ikoffice.de PostgreSQL version: 9.1.7 Operating system: Windows, bug Linux seems also affected Description: Hi, here is a small example of operat