Heikki Linnakangas wrote:
Luiz K. Matsumura wrote:
When we do a command Create or Replace View that change columns of previous
view we got a error.
Right. You can't change the data types of an existing view. You'll have
to drop and recreate it.
But, with the 'replace' command, this isn't implicit ?
If they found a view, replace the existing view with the new one (on the
other words, drop and create again?)
--
Luiz K. Matsumura
Plan IT Tecnologia Informática Ltda.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
