Re: alter column appears to work, but doesn't?

Поиск
Список
Период
Сортировка
От Ron Peterson
Тема Re: alter column appears to work, but doesn't?
Дата
Msg-id 20110905200015.GB3061@mtholyoke.edu
обсуждение исходный текст
Ответ на Re: alter column appears to work, but doesn't?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: alter column appears to work, but doesn't?
Список pgsql-general
2011-09-05_15:03:00-0400 Tom Lane <tgl@sss.pgh.pa.us>:
> Ron Peterson <rpeterso@mtholyoke.edu> writes:
> > I just updated a table to have a larger column size as follows.
>
> > alter table attributes_log alter column attribute_name type varchar(48);
>
> How come this refers to "attributes_log" while your failing command is
> an insert into "attributes"?

That was a typo, sorry.  Did do the same thing on original table.  I did
the same thing to attributes_log because I have rules that log data
there from my original table on insert/update/delete.

I just dropped my logging rules, stopped the database and restarted it,
put my rules back in place, and now it works.  Not sure why.  Cached
query plan?

--
Ron Peterson
Network & Systems Administrator
Mount Holyoke College
http://www.mtholyoke.edu/~rpeterso

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: alter column appears to work, but doesn't?
Следующее
От: Alan Hodgson
Дата:
Сообщение: Re: warm standby - apply wal archives