Re: DROP/CREATE

2001-10-22 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 21 October 2001 15:27 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: DROP/CREATE > > > Hello Dave and all, > > Views are based on OIDs and there is not simple way to implement > DROP/CREATE

Views and OIDs

2001-10-22 Thread Jean-Michel POURE
Hi Dave, Views are based on OIDs and there is not simple way to implement view modification in pgAdmin II. I will post today a mail on pg-hackers to ask if someone could implement CREATE OR REPLACE VIEW directly in PostgreSQL. Cheers, Jean-Michel

Windows plug-in installer

2001-10-22 Thread Jean-Michel POURE
Hello Dave, I might have time this week to work on: - PostgreSQL plug-in installer, - pseudo DROP/CREATE VIEW/TRIGGER in pgSchema, - Show system objects. Are you working on it or shall I try? What are the guidelines for compiling pgSchema (are there registration problem)? Cheers, Jean-Michel

Help needed: CREATE OR REPLACE VIEW, CREATE OR REPLACE TRIGGER for pgAdmin II and phppgAdmin

2001-10-22 Thread Jean-Michel POURE
Dear all, Could someone implement CREATE OR REPLACE VIEW and CREATE OR REPLACE TRIGGER in PostgreSQL 7.2 before beta? - If not possible, we are planning to implement pseudo DROP/CREATE in pgAdmin II, which is a dirty solution. - If possible, I will also propose a patch for phppgAdmin so that bo

DROP/CREATE

2001-10-22 Thread Jean-Michel POURE
Hello Dave and all, Views are based on OIDs and there is not simple way to implement DROP/CREATE VIEW in pgAdmin II. Seems more easy for CREATE OR REPLACE TRIGGER. I posted today a mail on pg-hackers to ask if someone could implement CREATE OR REPLACE directly in PostgreSQL. Cheers, Jean-Mich

Windows plug-in installer

2001-10-22 Thread Jean-Michel POURE
Hello Dave, I might have time this week to work on: - PostgreSQL plug-in installer, - pseudo DROP/CREATE VIEW/TRIGGER in pgSchema, - Show system objects. Are you working on it or shall I try? What are the guidelines for compiling pgSchema (are there registration problem)? Cheers, Jean-Michel