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

Re: pgsql: Give a more user-friendly error message in situation

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)svr1(dot)postgresql(dot)org>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: Give a more user-friendly error message in situation
Date: 2004-10-18 03:28:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Open items list updated for this fix and previous tablespace fix, and
new TODO item added:

* Allow a database in tablespace t1 with tables created in tablespace t2
  to be used as a template for a new database created with default
  tablespace t2

  All objects in the default database tablespace must have default tablespace
  specifications.  This is because new databases are created by copying
  directories.  If you mix default tablespace tables and tablespace-specified
  tables in the same directory, creating a new database from such a mixed
  directory would create a new database with tables that had incorrect
  explicit tablespaces.  To fix this would require modifying pg_class in the
  newly copied database, which we don't currently do.


Tom Lane wrote:
> Log Message:
> -----------
> Give a more user-friendly error message in situation where CREATE DATABASE
> specifies a new default tablespace and the template database already has
> some tables in that tablespace.  There isn't any way to solve this fully
> without modifying the clone database's pg_class contents, so for now the
> best we can do is issue a better error message.
> Modified Files:
> --------------
>     pgsql/src/backend/commands:
>         dbcommands.c (r1.144 -> r1.145)
>         (
>         tablespace.c (r1.11 -> r1.12)
>         (
>     pgsql/src/include/commands:
>         tablespace.h (r1.5 -> r1.6)
>         (
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly

  Bruce Momjian                        |
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-committers by date

Next:From: Bruce MomjianDate: 2004-10-18 11:45:27
Subject: pgsql: Update Japanese FAQ.
Previous:From: Bruce MomjianDate: 2004-10-18 03:27:15
Subject: pgsql: Update wording: * Allow a database in tablespace t1 with tables

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