| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Hartmut Goebel <h(dot)goebel(at)goebel-consult(dot)de> |
| Subject: | Re: pg_dump(all) --quote-all-identifiers |
| Date: | 2010-06-14 10:57:39 |
| Message-ID: | 201006141057.o5EAvd729441@momjian.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Robert Haas wrote:
> In response to a complaint from Hartmut Goebel:
>
> http://archives.postgresql.org/pgsql-bugs/2010-06/msg00018.php
>
> And per a design proposed by Tom Lane:
>
> http://archives.postgresql.org/pgsql-bugs/2010-06/msg00211.php
>
> PFA a patch to implement $SUBJECT. One interesting aspect of this
> patch is that types like "integer" and "double precision" don't get
> quoted in the output, whereas types like "text" do. But it turns out
> that types like "integer" and "double precision" don't *work* if
> they're quoted, so this is not a bad thing. It might possibly be
> judged to require documentation somewhere, however.
Uh, I thought this was about quoting the identifiers. I am confused
about why "integer" is an issue in this case. Can you show an example?
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2010-06-14 11:01:29 | Re: [v9.1] Add security hook on initialization of instance |
| Previous Message | Dimitri Fontaine | 2010-06-14 10:39:32 | pg_archive_bypass |