Re: rule on view in pgschema

Поиск
Список
Период
Сортировка
От frank_lupo
Тема Re: rule on view in pgschema
Дата
Msg-id HD0RKW$19938D897627E5A3FE3849F916BABD84@email.it
обсуждение исходный текст
Список pgadmin-hackers
> 
> 
> > -----Original Message-----
> > From: frank_lupo [mailto:frank_lupo@email.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



В списке pgadmin-hackers по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: rule on view in pgschema
Следующее
От: "frank_lupo"
Дата:
Сообщение: Re: rule on view in pgschema