pg_dump case folding bug - Mailing list pgsql-bugs

From Russell Smith
Subject pg_dump case folding bug
Date
Msg-id 200411131451.47631.mr-russ@pws.com.au
Whole thread Raw
Responses Re: pg_dump case folding bug
List pgsql-bugs
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@postgresql.org.

To report any other bug, fill out the form below and e-mail it to
pgsql-bugs@postgresql.org.

If you not only found the problem but solved it and generated a patch
then e-mail it to pgsql-patches@postgresql.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.

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: BUG #1317: plPHP does not recgnize booleans
Next
From: Tom Lane
Date:
Subject: Re: pg_dump case folding bug