Re: rule on view in pgschema

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

Browse pgadmin-hackers by date

  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