Wow, I learn a lot about views now
Sorry for my confusion. You are right, my reasoning is very limited.
Thanks Heikki , Tom and Reece by yours answers.
Tom Lane wrote:
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
Luiz K. Matsumura wrote:
But, with the 'replace' command, this isn
On Tue, 2007-09-04 at 07:42 +, Luiz K. Matsumura wrote:
> When we do a command Create or Replace View that change columns of
> previous view we got a error.
Right. Many folks consider views to be a sort of API to the database.
Using views to provide an API substantially insulates client code
"Heikki Linnakangas" <[EMAIL PROTECTED]> writes:
> Luiz K. Matsumura wrote:
>> 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?)
> Replacing is not exactly the same thing as dr
Luiz K. Matsumura wrote:
> 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
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,
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.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
---
The following bug has been logged online:
Bug reference: 3597
Logged by: Luiz K. Matsumura
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: Fedora core 3
Description:CREATE OR REPLACE VIEW
Details:
scenario:
CREATE TABLE table1
(
id ser
