pg_dumpall problem in 7.1 and cvs 
Author Message
 pg_dumpall problem in 7.1 and cvs

If there is a comment on a view, pg_dumpall can put them in the wrong order:

--
-- pg_dumpall (7.2devel)
--
...
--
-- TOC Entry ID 363 (OID 31291)
--
-- Name: VIEW "all_persons" Type: COMMENT Owner:
--

COMMENT ON VIEW "all_persons" IS 'All persons - individuals or not';

--
-- TOC Entry ID 362 (OID 31308)
--
-- Name: all_persons Type: VIEW Owner: olly
--

CREATE VIEW "all_persons" as SELECT person.ptype, person.id, person.name,
person.address, person.salutation, person.envelope, person.email, person.www
FROM person;

This seems to have happened with every view in this dump.  I haven't managed
to work out why it happens.

--

Isle of Wight                               http://www.***.com/
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "All scripture is given by inspiration of God, and is
      profitable for doctrine, for reproof, for correction,
      for instruction in righteousness;"          
                                     II Timothy 3:16

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.***.com/



Tue, 20 Jan 2004 07:05:41 GMT
 pg_dumpall problem in 7.1 and cvs

Quote:

> If there is a comment on a view, pg_dumpall can put them in the wrong order:

Drat.  I fixed the identical problem for permissions a little while ago,
but didn't realize that it extended to comments too.  Thanks for the
report!

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Tue, 20 Jan 2004 07:43:09 GMT
 pg_dumpall problem in 7.1 and cvs

Quote:

> If there is a comment on a view, pg_dumpall can put them in the wrong order:

I've committed a fix for this in both CVS tip and REL7_1_STABLE.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly



Wed, 21 Jan 2004 05:15:58 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. pg_dumpall -c (7.1 beta 4 buglet)

2. HOWTO for pg 7.1 installation from cvs

3. HOWTO for pg 7.1 installation from cvs

4. DB2 PDE 7.1 on RedHat 7.1 problem

5. [brad@cvs.openbsd.org: CVS: cvs.openbsd.org: src]

6. 7.1 UC1 versus 7.1 UD1

7. RDBMS 7.1 on OpenVMS 7.1

8. DB2 7.1 PDE or DB2 7.1 EE

9. 7.1 UC1 versus 7.1 UD1

10. 7.1 on 7.1

11. Move Oracle 7.1 on OpenVMS 6.1 to 7.1 VAX

12. RDBMS 7.1 on OpenVMS 7.1


 
Powered by phpBB® Forum Software