Skip site navigation (1) Skip section navigation (2)

Re: BUG #1843: pg_restore -O restores lowercase schemanaam

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D(dot)J(dot) Kniep" <dick(at)kniep(dot)nl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1843: pg_restore -O restores lowercase schemanaam
Date: 2005-08-25 00:13:18
Message-ID: 22100.1124928798@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"D.J. Kniep" <dick(at)kniep(dot)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
  	{

In response to

pgsql-bugs by date

Next:From: vishal saberwalDate: 2005-08-25 00:35:25
Subject: Re: Ref: BUG#1321: SSL error: sslv3 alert handshake failure
Previous:From: Jim AlleyDate: 2005-08-25 00:02:05
Subject: BUG #1846: PostgreSQL oledb driver

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group