Re: BUG #1843: pg_restore -O restores lowercase schemanaam - Mailing list pgsql-bugs

"D.J. Kniep" <dick@kniep.nl> writes:
> Description:        pg_restore -O restores lowercase schemanaam

Thanks for the report.  This bug seems to exist only in the 7.4 branch.
Applied patch is attached if you need it right away.

            regards, tom lane

Index: src/bin/pg_dump/pg_backup_archiver.c
===================================================================
RCS file: /cvsroot/pgsql/src/bin/pg_dump/pg_backup_archiver.c,v
retrieving revision 1.79.2.5
diff -c -r1.79.2.5 pg_backup_archiver.c
*** pg_backup_archiver.c    17 May 2005 17:30:53 -0000    1.79.2.5
--- pg_backup_archiver.c    25 Aug 2005 00:09:55 -0000
***************
*** 2256,2262 ****
       */
      if (AH->ropt && AH->ropt->noOwner && strcmp(te->desc, "SCHEMA") == 0)
      {
!         ahprintf(AH, "CREATE SCHEMA %s;\n\n\n", te->tag);
      }
      else
      {
--- 2256,2262 ----
       */
      if (AH->ropt && AH->ropt->noOwner && strcmp(te->desc, "SCHEMA") == 0)
      {
!         ahprintf(AH, "CREATE SCHEMA %s;\n\n\n", fmtId(te->tag));
      }
      else
      {