Re: Pseudo modification of views and triggers ( again)

2002-02-20 Thread Jean-Michel POURE
Le Mercredi 20 Février 2002 09:17, Dave Page a écrit : > BTW, have you been following the discussion on pgsql-hackers about the > ongoing pl/pgSQL drop column code? Yes, sounds interesting but the code will probably be very close to ours. But, didn't we say no PL/pgSQL in our previous discussion

Re: ALTER VIEW

2002-02-20 Thread Jean-Michel POURE
Le Mercredi 20 Février 2002 10:27, Dave Page a écrit : > I just noticed in your update you forgot to alter the pgView.SQL function > entry iLogEvent call to log the new parameters; It should look like: > > Public Property Get SQL(Optional PseudoAlter As Boolean) As String > On Error GoTo Err_Handl

Re: To-Do List

2002-02-20 Thread Jean-Michel POURE
Hi Dave, Altering view definition is still broken. Can you help me understand why? This is not a question of .dll as I recompiled everything a restarted the computer. > 1) Rollback in case of failure is not yet enabled (or tested?) The code is commented. I will uncomment after 2) is fixes. >

Re: plpgsql_call_handler

2002-02-20 Thread Jean-Michel POURE
Le Mercredi 20 Février 2002 11:51, Dave Page a écrit : > No, it's user defined because the user/sysadmin adds it himself. plpgsql_call_handler is a sys object added by user input. It does not necassary mean it is a user object.. Users may think it is allowed to drop this object ***because*** it

plpgsql_call_handler

2002-02-20 Thread Jean-Michel POURE
Hi Dave, I see plpgsql_call_handler is part of user objects in function list. Shouldn't it be part of system objects? Cheers, Jean-Michel

Trigger display bug

2002-02-20 Thread Jean-Michel POURE
Dear Dave, CREATE TRIGGER "tg_term_source_iu" BEFORE DELETEINSERT OR UPDATE ON "translationforge_term_source" FOR EACH ROW EXECUTE PROCEDURE tg_term_source_iu(); The properties of the trigger appear to be OK. Only the SQL definition does not display well. I tried to understand the bug but di

Re: To-Do List

2002-02-20 Thread Jean-Michel POURE
Le Mercredi 20 Février 2002 10:23, Dave Page a écrit : > If there's anything I've missed, please let me > know. IMHO, PostgreSQL installer under Cygwin is ***essential***. This is the next thing after table alter column. By the way, when do you think you will be ablt to fix view definition, jus

Re: PgAdmin II

2002-02-20 Thread Jean-Michel POURE
> A fine upgrade to an already good product. It still has exactly the right features for DB admin, and no extraneous fluff.  Thanks. Dave, Chris likes your pgAdmin2 very much. > Is there an option that would simulate the old Security Window from PgAdmin (1) ? I found the security wizard, but it

Re: ALTER VIEW

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 09:37 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: ALTER VIEW > > > Le Mercredi 20 Février 2002 10:27, Dave Page a écrit : > > I just noticed in your update you forgot to alter

Re: plpgsql_call_handler

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 10:57 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] plpgsql_call_handler > > > Le Mercredi 20 Février 2002 11:51, Dave Page a écrit : > > No, it's user defined beca

Re: To-Do List

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 13:23 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] To-Do List > > > Hi Dave, > > Altering view definition is still broken. Can you help me > understand why?

Re: Changes committed

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 15:55 > To: Dave Page > Subject: Changes committed > > > Dear Dave, > > Changes are commited to CVS : bugfix, view OID retrieval, > view rollback. > Definitely looks like it's headin

Re: To-Do List

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 10:05 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] To-Do List > > > Le Mercredi 20 Février 2002 10:23, Dave Page a écrit : > > If there's anything I've missed, ple

Re: Trigger display bug

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 11:44 > To: [EMAIL PROTECTED] > Cc: Dave Page > Subject: [pgadmin-hackers] Trigger display bug > > > Dear Dave, > > CREATE TRIGGER "tg_term_source_iu" BEFORE DELETEINSERT OR UPDATE ON

Re: plpgsql_call_handler

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 10:36 > To: Dave Page; [EMAIL PROTECTED] > Subject: [pgadmin-hackers] plpgsql_call_handler > > > Hi Dave, > > I see plpgsql_call_handler is part of user objects in function list. > Sho

To-Do List

2002-02-20 Thread Dave Page
I've just updated and re-organised the pgAdmin To-Do list. It's checked into CVS & updated on the website. If there's anything I've missed, please let me know. Regards, Dave.

Re: To-Do List

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 10:20 > To: Dave Page > Subject: Re: [pgadmin-hackers] To-Do List > > > Le Mercredi 20 Février 2002 11:13, Dave Page a écrit : > > Fixed that (you forgot to reset the tag on txtPropertie

Re: Pseudo modification of views and triggers (

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 20 February 2002 09:21 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Pseudo modification of views > and triggers ( again) > > > Le Mercredi 20 Février 2002 09:17, Dave Page a

Re: Pseudo modification of views and triggers (

2002-02-20 Thread Dave Page
> -Original Message- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 19 February 2002 21:19 > To: Dave Page > Cc: [EMAIL PROTECTED] > Subject: Re: [pgadmin-hackers] Pseudo modification of views > and triggers (again) > > > > I've just found out that views can be renamed