Thanks for your reply tom. I'm sure it is not a mistype, I included the definition that I used in my script. Perhaps it is something to do with the cygwin installation of Postgres that I have i will try it on a Linux box.

Cheers
Matthew

Tom Lane wrote:

"mlunnon @ RWA" <mlunnon@rwa-net.co.uk> writes:

I get:<br>
psql:Supplements.sql:34: ERROR:&nbsp; Type "test_type[]" does not exist<br>
psql:Supplements.sql:41: ERROR:&nbsp; Type "_test_type" does not exist<br>


It works for me ... are you sure it's not something silly like mistyping
the type name, or adding/omitting double quotes?

			regards, tom lane

_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed Scanning Services - powered by MessageLabs. For further information visit http://www.mci.com