Re: rule on view in pgschema

> -----Original Message-----
> From: frank_lupo [mailto:frank_lupo(at)email(dot)it]
> Sent: 08 April 2003 10:56
> To: Dave Page
> Cc: pgadmin-hackers
> Subject: Re: [pgadmin-hackers] rule on view in pgschema
>
>
>
>
> 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?

No, ALTER TABLE will rename anything in pg_class. It works with
sequences as well.

Regards, Dave