Re: Domains versus arrays versus typmods

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Domains versus arrays versus typmods
Дата
Msg-id 4CBFE2E0.3000500@archonet.com
обсуждение исходный текст
Ответ на Re: Domains versus arrays versus typmods  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On 20/10/10 01:47, Robert Haas wrote:
> On Tue, Oct 19, 2010 at 6:14 PM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> Comments?
>
> It might be reasonable to back-patch whatever we decide on into 9.0,
> because it is so new, but I would be reluctant to go back further
> unless we have some evidence that it's bothering people.  It seems to
> me that this can could have a lot of worms in it, and I fear that
> there could be several rounds of fixes, which I would rather not
> inflict on users of supposedly-stable branches.

The work-around I applied when I stumbled across this was just to apply 
an explicit cast before my function's RETURN. That neatly solves my 
particular problem (which I at first thought was a formatting issue 
somewhere in my app).

The real danger with this is the opportunity to end up with occasional 
bad data in tables, quite possibly unnoticed. If I'd come across this in 
an existing system rather than a new app I'm pretty sure it would have 
confused me for a lot longer than it did.
--   Richard Huxton  Archonet Ltd


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

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: Re: UNION ALL has higher cost than inheritance
Следующее
От: "Stephen R. van den Berg"
Дата:
Сообщение: Re: pg_rawdump