Re: Custom types and arrays

From: "mlunnon (at) RWA" <mlunnon(at)rwa-net(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Custom types and arrays
Date: 2003-11-02 21:02:42
Message-ID: 3FA570F2.30604@rwa-net.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
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.<br>
<br>
Cheers<br>
Matthew<br>
<br>
Tom Lane wrote:<br>
<blockquote type="cite" cite="mid19718(dot)1067633975(at)sss(dot)pgh(dot)pa(dot)us">
<pre wrap="">"mlunnon @ RWA" <a class="moz-txt-link-rfc2396E" href="mailto:mlunnon(at)rwa-net(dot)co(dot)uk">&lt;mlunnon(at)rwa-net(dot)co(dot)uk&gt;</a> writes:
</pre>
<blockquote type="cite">
<pre wrap="">I get:&lt;br&gt;
psql:Supplements.sql:34: ERROR:&amp;nbsp; Type "test_type[]" does not exist&lt;br&gt;
psql:Supplements.sql:41: ERROR:&amp;nbsp; Type "_test_type" does not exist&lt;br&gt;
</pre>
</blockquote>
<pre wrap=""><!---->
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 <a class="moz-txt-link-freetext" href="http://www.mci.com">http://www.mci.com</a>
</pre>
</blockquote>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 1.4 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2003-11-02 21:10:27 Re: AS operator and subselect result names: PostgreSQL
Previous Message Marc G. Fournier 2003-11-02 20:59:48 Re: PostgreSQL License Question