From: | frank_lupo <frank_lupo(at)email(dot)it> |
---|---|
To: | dpage <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: rule on view in pgschema |
Date: | 2003-04-08 09:55:44 |
Message-ID: | HD0RKW$19938D897627E5A3FE3849F916BABD84@email.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
>
>
> > -----Original Message-----
> > From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> > Sent: 08 April 2003 09:37
> > To: pgadmin-hackers
> > Subject: [pgadmin-hackers] rule on view in pgschema
> >
> >
> > Hi dave,
> >
> > I am developing the rules on the view in the pgschema.
> >
> > It is perhaps better to create one new class or to re-use
> > those of the table?
>
> Hi Frank,
>
> Reuse if possible. There seems little point in rewriting it. You should
> check for places that expect the rule to be under a table of course,
> both in pgAdmin and pgSchema.
>
> > What of tasks?
>
> What do you mean?
>
> Regards, Dave.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
In pgschema.pgview is present this routine.
Friend Property Let Name(ByVal vData As String)
If inIDE Then: On Error GoTo 0: Else: On Error GoTo Err_Handler
objServer.iLogEvent "Entering " & App.Title & ":pgView.Property Let Name(" & vData & ")", etFullDebug
Dim szSQL As String
szSQL = "ALTER TABLE " & FormattedID & " RENAME TO " & QUOTE & vData & QUOTE
objServer.ExecSQL szSQL, cnDatabase
szName = vData
Identifier = vData
Exit Property
Err_Handler: objServer.iLogError Err.Number, Err.Description
End Property
This is a error?
Bye !!
Frank Lupo (Wolf) !!
/\_ _/\
\ o o /
--ooo-----ooo---
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Natsabe.it la più grande erboristeria multimarca online.
Solo prodotti di altissima qualità.
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=1308&d=8-4
From | Date | Subject | |
---|---|---|---|
Next Message | frank_lupo | 2003-04-08 10:08:20 | Re: rule on view in pgschema |
Previous Message | Dave Page | 2003-04-08 09:15:29 | Re: rule on view in pgschema |