From: | Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pPL/pgSQL restriction on characters for copying types? |
Date: | 2024-02-26 16:02:56 |
Message-ID: | e9ff3134-4d87-435b-ad30-a0b273b70137@gelassene-pferde.biz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Oh, I totally forgot to mention that I ran the scripts with DbVisualizer
against a 16.1 (Debian 16.1-1.pgdg110+1) server using PostgreSQL JDBC
Driver 42.6.0 .
Am 26.02.2024 um 16:51 schrieb Thiemo Kellner:
> Hi
>
> My names can contain a special character (⠒), e.g. to separate the
> donator object from the name or the name from the type. Typically, I use
> this with foreign keys, e.g. table PARENT has the surrogate key ID, the
> table CHILD would then have the column PARENT⠒ID. That way, I can use
> the underscore to segment column names like yet_another_column_name. I
> do not like camel-case in that case because names do not have to be case
> sensitive.
>
> However, I want to create a (trigger) function to impose data
> consistency. For that purpose, I try to copy the data type of a PL/pgSQL
> variable from the base object, a view in that case. Trying so, I get the
> following error on installation of the function.
>
> V⠒NODE_TYPE⠒NAME NODE⠒V.NODE_TYPE⠒NAME%type := null;
>
> Syntax error at "%" … invalid type name. If I use the actual type of the
> column, all is fine.
>
> V⠒NODE_TYPE⠒NAME text;
>
> Please find attached script files of objects directly involved in the
> trigger function.
>
> Is there something, I am doing wrongly?
>
> Kind Regards
>
> Thiemo
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2024-02-26 16:10:06 | Re: Fastest way to clone schema ~1000x |
Previous Message | Markus Oley | 2024-02-26 15:53:35 | Postgres > 12 with Windows Server 2012 |