Skip site navigation (1) Skip section navigation (2)

Re: Table modification

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Table modification
Date: 2001-10-02 14:51:13
Message-ID: 4.2.0.58.20011002163614.01420a00@pop.freesurf.fr (view raw or flat)
Thread:
Lists: pgadmin-hackers
>1) I don't want to retrieve source from logs. I want to analyse the database
>and generate the source from what is known to work and compile correctly.
>There is no better test for an object than to build it in PostgreSQL.

When an object is broken, its source code disappears or cannot be retrieved 
because PostgreSQL internals are based on OIDs.
Example: if you create a view based on a function and drop the function, 
you will not be able to read the view source code.

When several developers are working on the same database at the same time, 
you cannot guarantee consistency at PostgreSQL level.
Developer1 will be working in function1, while developer2 will be working 
no function2 based on function1. Developer circular dependency. Boom!

When an object is broken, with your system, you have to retrieve source 
code from revision logs.
I don't know if we can speak of ACID rules, but ... this is not a 
consistent and atomic choice.

>2) Yes, compilation must be in dependancy order (which Publishing is). I
>don't know how we could ever get over my circular dependency problem though.
>That *would* require logs to figure out the sequence of queries required to
>create the circular dependency in the first place. And yes, I do agree that
>that is nasty...
>A good heated debate does brighten up the day don't you think?!

Yes my friend. Indeed, we are discussing about the (future) schema features 
of PostgreSQL.
We need more input on PostgreSQL core team schema and dependency projects 
... or start our own project.

/Later, Jean-Michel

pgadmin-hackers by date

Next:From: Jean-Michel POUREDate: 2001-10-02 15:34:03
Subject: Column lenght
Previous:From: Hannu KrosingDate: 2001-10-02 14:44:22
Subject: Re: What about CREATE OR REPLACE FUNCTION?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group