The following bug has been logged online:
Bug reference: 5488
Logged by: Hartmut Goebel
Email address: h.goe...@goebel-consult.de
PostgreSQL version: 8.3 / 8.4
Operating system: all
Description:pg_dump does not quote column names -> pg_restore may
fail when upgrad
not allow accessing the 8.3 database, thus I needed to dump
using the 8.3 executable.
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consult.de
Monatliche Kolumne: http://
;). So I downgraded
to 8.3, pg_dump'ed there, upgraded and pg_restore'd.
Since 8.4 was not willed to work in the 8.3 database files, I expected
this being a correct upgrade path.
--
Schönen Gruß - Regards
Hartmut Goebel
smime.p7s
Description: S/MIME Cryptographic Signature
o not understand this.
I assume you mean readability for humans?!
So if readability is not important, what speaks against always quoting
the column names?
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komp
Am 03.06.2010 20:07, schrieb Tom Lane:
> "Kevin Grittner" writes:
>> Hartmut Goebel wrote:
>>> If upgraded the rpm-packages from 8.3 to 8.4. Then postgres failed
>>> starting (something like "Database version mismatch").
>
>> You need t
han a small decrees
of readability. At least pg_dump should get an option
"--quote-column-names", so this can be switcced on if necessary.
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebun
Am 04.06.2010 14:57, schrieb Stephen Frost:
> * Hartmut Goebel (h.goe...@goebel-consult.de) wrote:
>> Am 04.06.2010 13:56, schrieb Stephen Frost:
>>> Quoting all column names makes the dump script much more difficult for
>>> human consumption, which is important.
>&g
ne-head dogmatic tech-geeks, not willed to make the
administrators live easier.
> In a way, the fact that the restore fails can be seen as a feature ---
> they get the error before the go live on 8.4. (Yeah, I am serious.)
"Be happy that I shot you, you would have starved anyw
column names (and such) automatically.
Esp. this would solve the problem for *all other users* of this
application, too. And as I already wrote, too, most of these
users/administrators are not database gurus. They need as much support
as possible to make their live easier.
--
Schönen Gruß - Regard
Make life easier for others. Admins have a hard job
anyway.
BTW: mysql does a far better job here.
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consult.de
Monatli
tifiers. So it simply does not matter
when a keyword is added.
I wished, pg_dump could do the same and easy admins life :-\
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consul
gt; Eeh, I've had this happen to me on earlier releases, and it didn't
>> feel like a feature to me. YMMV, of course.
>
> Would you have preferred later application failure?
Yes! Since this would at least solve one issue: migrating the data. And
if the application is develop
suck,
> but people do these kinds of things, in real life, all the time.
+1
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consult.de
Monatliche Kolumne: http://www.ci
subscribe to five mailing lists, become a senior and then
upgrade? *Gnaa*
Com'on guy! Is it really that hard to understand that others are no
gurus and have to upgrade anyway?! Why are you fighting to make their
life harder?
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.
Am 10.06.2010 17:23, schrieb Heikki Linnakangas:
> Much easier to do a schema-only dump, edit that, and dump data separately.
I tries this in my very case. Did not work due sequences, triggers and
primary keys. I ended up editing a 500 MB file in vi.
--
Schönen Gruß - Regards
Hartmut Goe
3) the application is fixed already by somebody else (the vendor)
--
Schönen Gruß - Regards
Hartmut Goebel
Dipl.-Informatiker (univ.), CISSP, CSSLP
Goebel Consult
Spezialist für IT-Sicherheit in komplexen Umgebungen
http://www.goebel-consult.de
Monatliche Kolumne: http://www.cissp-geflues
16 matches
Mail list logo
