Re: About the CREATE TABLE LIKE indexes vs constraints issue

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: About the CREATE TABLE LIKE indexes vs constraints issue
Дата
Msg-id 88FF7F53-2AFA-4958-A60C-B06A5308A891@hi-media.com
обсуждение исходный текст
Ответ на Re: About the CREATE TABLE LIKE indexes vs constraints issue  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-hackers
Hi, sorry for posting style,

--
dim

Le 23 déc. 2009 à 23:58, Jeff Davis <pgsql@j-davis.com> a écrit :
> Honestly, I've never used LIKE in a table definition aside from one-
> off
> design experiments. For that kind of thing, what I want is to just get
> everything (except perhaps FKs if the above situation applies), and I
> adjust it from there. Are there people out there who use LIKE in their
> production schema files?

I do use LIKE in scripts for adding providers of federated data. In
some cases you want to INHERIT, in some other you want to move
incoming data to another set of tables.

Regards,

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Streaming Rep - 2-phase backups and reducing time to full replication
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: Backup history file should be replicated in Streaming Replication?