From: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org;, pgsql-patches(at)postgresql(dot)org |
Subject: | pg_dump case folding bug |
Date: | 2004-11-13 03:51:47 |
Message-ID: | 200411131451.47631.mr-russ@pws.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-patches |
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to pgsql-ports(at)postgresql(dot)org(dot)
To report any other bug, fill out the form below and e-mail it to
pgsql-bugs(at)postgresql(dot)org(dot)
If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches(at)postgresql(dot)org instead. Please use the
command "diff -c" to generate the patch.
You may also enter a bug report at http://www.postgresql.org/ instead of
e-mail-ing this form.
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Russell Smith
Your email address : As From address
System Configuration
---------------------
Architecture (example: Intel Pentium) : AMD 2000XP
Operating System (example: Linux 2.4.18) : Gentoo Linux 2.4.20-r9
PostgreSQL version (example: PostgreSQL-8.0): PostgreSQL-8.0-beta4
Compiler used (example: gcc 2.95.2) : gcc (GCC) 3.3.3 20040412 (Gentoo Linux 3.3.3-r6, ssp-3.3.2-2, pie-8.7.6)
Please enter a FULL description of your problem:
------------------------------------------------
pg_dump -i -h '10.0.0.5' -p '5432' -s 'test' -t '"Test"'
pg_dump does not fold case, and quote table and schema names correctly.
the above line will dump the table named "Test"
pg_dump -i -h '10.0.0.5' -p '5432' -s 'test' -t 'Test'
the above will dump the table named Test
I believe the correct output from 1 should be to dump the table named Test.
and correct output from 2 should dump the table named test
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Reproduction from commands in description.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
Attempted patches attached. Most code taken from libpq and modified for pg_dump.
Attachment | Content-Type | Size |
---|---|---|
fold_case.diff | text/x-diff | 2.9 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-11-13 05:05:12 | Re: pg_dump case folding bug |
Previous Message | Peter Eisentraut | 2004-11-12 19:57:50 | Re: BUG #1317: plPHP does not recgnize booleans |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-11-13 05:05:12 | Re: pg_dump case folding bug |
Previous Message | Bruce Momjian | 2004-11-13 03:18:47 | Re: Fix VC++/Borland libpq build - pqsignal |