Postgres Pro
Downloads
Home   >   mailing lists

Thread: Arrays in system tables

Arrays in system tables

From
"Rod Taylor"
Date:
Just exactly how does one get an array into a system table?

Of course, _int2 and int2[] aren't normal C constructs so using it
within CATALOG won't work.

I suppose thats why the vector types were invented?
--
Rod

Re: Arrays in system tables

From
Bruce Momjian
Date:
Rod Taylor wrote:
> Just exactly how does one get an array into a system table?
> 
> Of course, _int2 and int2[] aren't normal C constructs so using it
> within CATALOG won't work.
> 
> I suppose thats why the vector types were invented?

Well, pg_shadow had pg_class has:
 relacl         | aclitem[] | 

and pg_shadow has:
 useconfig   | text[]  | 

so I would use those as guides.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

Re: Arrays in system tables

From
"Rod Taylor"
Date:
Ahh.. no wonder my aimless greps couldn't find anything.

I should just have read the BKI stuff ;)

Thanks
--
Rod
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Rod Taylor" <rbt@zort.ca>
Cc: "Hackers List" <pgsql-hackers@postgresql.org>
Sent: Saturday, April 27, 2002 2:06 AM
Subject: Re: [HACKERS] Arrays in system tables


> Rod Taylor wrote:
> > Just exactly how does one get an array into a system table?
> >
> > Of course, _int2 and int2[] aren't normal C constructs so using it
> > within CATALOG won't work.
> >
> > I suppose thats why the vector types were invented?
>
> Well, pg_shadow had pg_class has:
>
> relacl         | aclitem[] |
>
> and pg_shadow has:
>
> useconfig   | text[]  |
>
> so I would use those as guides.
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania
19026
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>