pg_dump case folding bug

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

Responses

Browse pgsql-bugs by date

  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

Browse pgsql-patches by date

  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