Re: Better support for whole-row operations and composite types

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Better support for whole-row operations and composite types
Дата
Msg-id 200403301000.51098.josh@agliodbs.com
обсуждение исходный текст
Ответ на Better support for whole-row operations and composite types  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom,

> We have a number of issues revolving around the fact that composite types
> (row types) aren't first-class objects.  I think it's past time to fix
> that.  Here are some notes about doing it.  I am not sure all these ideas
> are fully-baked ... comments appreciated.

I'll want to add to the documentation on composite types, then.   We'll need a
stern warning to users not to abuse them.  Easily done, I think.

Composite types are frequently abused by OO and Windows programmers to break
the relational model.    I used to be an MSDN member (thank you, I've
recovered) and frequently ran into, on the mailing list, users getting
themselves into some unresolvable mess becuase they'd used composite types in
SQL server to combine several rows ... or even effectively an entire child
table ... into one field.

Othewise, looks good to me.   I don't think I'm qualified to second-guess you
on the implementation.

--
-Josh BerkusAglio Database SolutionsSan Francisco



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

Предыдущее
От: Dennis Haney
Дата:
Сообщение: Hash cost
Следующее
От: kkim3@ncsu.edu
Дата:
Сообщение: Transaction question