By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,240 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

7.5 features

P: n/a
Hello,
Can PostgreSQL resolve object dependencies automatic
If we delete any object then Postgresql automatic resolve status (valid or invalid objects)

regards

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi snpwhatever,

snpe wrote:
Hello,
Can PostgreSQL resolve object dependencies automatic
If we delete any object then Postgresql automatic resolve status (valid or invalid objects)


You mean plain old foreign keys?

Regards
Tino Wildenhain
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 12 '05 #2

P: n/a
Hi Harsi,

snpe schrieb:
On Sunday 14 December 2003 03:51 pm, Tino Wildenhain wrote:
Hi snpwhatever,

snpe wrote:
Hello,
Can PostgreSQL resolve object dependencies automatic
If we delete any object then Postgresql automatic resolve status (valid
or invalid objects)


You mean plain old foreign keys?

Hi Tino,
not only foreign key, for all objects - when I create view tabv for table tab
I can't delete table tab - I want that PostgreSQL delete tab and set tabv to invalid
When I create tab again, then view tabv become valid (maybe).
It is important for more objects (functions, procedures, views etc) and change offten.
I don't want delete all dependencies objects


I dont think its wise to change database structure that often.
And I got the impression its a job for case-tools and support
scripts rather then the database itself.
Database schould focus on data integrity (which it does)
and not pay too much attention to schema issues beside whats
needed for data integrity.

Regards
Tino Wildenhain

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 12 '05 #3

P: n/a
On Monday 15 December 2003 08:30 am, Tino Wildenhain wrote:
Hi Harsi,

snpe schrieb:
On Sunday 14 December 2003 03:51 pm, Tino Wildenhain wrote:
Hi snpwhatever,

snpe wrote:
Hello,
Can PostgreSQL resolve object dependencies automatic
If we delete any object then Postgresql automatic resolve status (valid
or invalid objects)

You mean plain old foreign keys?


Hi Tino,
not only foreign key, for all objects - when I create view tabv for table
tab I can't delete table tab - I want that PostgreSQL delete tab and set
tabv to invalid When I create tab again, then view tabv become valid
(maybe).
It is important for more objects (functions, procedures, views etc) and
change offten. I don't want delete all dependencies objects


I dont think its wise to change database structure that often.
And I got the impression its a job for case-tools and support
scripts rather then the database itself.
Database schould focus on data integrity (which it does)
and not pay too much attention to schema issues beside whats
needed for data integrity.

Hello,
If I have btw view with 10 dependent functions and 10 dependent table
I want change one column in view - I must delete all 20 objects for this.

regards
Haris Peco

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.