diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-11-12 15:34:30 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 1998-11-12 15:34:30 +0000 |
| commit | 44ddb8cf4cdcef5c1d540babc2fc692ca8747183 (patch) | |
| tree | 8128809c1f4c9421ce99d4077c955b41e346e62b | |
| parent | 555eadc904a467023ac0b1c66e54f017eb3d472c (diff) | |
Fix test for table existance to allow mixed-case and whitespace in
the table name. Problem reported by Billy Allie.
| -rw-r--r-- | src/backend/catalog/heap.c | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/src/backend/catalog/heap.c b/src/backend/catalog/heap.c index bcac9479788..e3e7bade9fc 100644 --- a/src/backend/catalog/heap.c +++ b/src/backend/catalog/heap.c @@ -7,7 +7,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/catalog/heap.c,v 1.64 1998/09/01 04:27:29 momjian Exp $ + * $Header: /cvsroot/pgsql/src/backend/catalog/heap.c,v 1.64.2.1 1998/11/12 15:34:30 thomas Exp $ * * INTERFACE ROUTINES * heap_create() - Create an uncataloged heap relation @@ -1515,7 +1515,10 @@ StoreRelCheck(Relation rel, ConstrCheck *check) char nulls[4] = {' ', ' ', ' ', ' '}; extern GlobalMemory CacheCxt; - sprintf(str, "select 1 from %.*s where %s", + /* Check for table's existance. Surround table name with double-quotes + * to allow mixed-case and whitespace names. - thomas 1998-11-12 + */ + sprintf(str, "select 1 from \"%.*s\" where %s", NAMEDATALEN, rel->rd_rel->relname.data, check->ccsrc); setheapoverride(true); planTree_list = (List *) pg_parse_and_plan(str, NULL, 0, &queryTree_list, None, FALSE); |