Arrays in system tables

Started by Rod Taylorover 23 years ago3 messages
#1Rod Taylor
rbt@zort.ca

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

#2Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Rod Taylor (#1)
Re: 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
#3Rod Taylor
rbt@zort.ca
In reply to: Bruce Momjian (#2)
Re: Arrays in system tables

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)---------------------------

Show quoted text

TIP 6: Have you searched our list archives?

http://archives.postgresql.org