Re: Typed tables
Tatsuo Ishii <ishii@postgresql.org>
From: Tatsuo Ishii <ishii@postgresql.org>
To: simon@2ndQuadrant.com
Cc: peter_e@gmx.net, pgsql-hackers@postgresql.org
Date: 2009-11-09T02:42:09Z
Lists: pgsql-hackers
> > This is useful in conjunction with PL/Proxy and similar RPC-type > > setups. On the frontend/proxy instances you only create the type, and > > the backend instances you create the storage for the type, and the > > database system would give you a little support keeping them in sync. > > Think interface and implementation. > > Not sure I see why this is good. Why is issuing CREATE TYPE so much > easier than using CREATE TABLE? Is it worth the extra syntax and code to > support it? Can we do anything additional as a result of this? Is this > required by the standard or are we going past the standard? +1. I'd like to hear from Peter why this is neccessary in the first place. -- Tatsuo Ishii SRA OSS, Inc. Japan