Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 67F3A2E011E
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 10 Feb 2008 23:16:21 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 07369-03-5 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 10 Feb 2008 23:16:08 -0400 (AST)
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 49BB12E02C1
	for <pgsql-sql@postgresql.org>; Sun, 10 Feb 2008 23:11:41 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1B3BdFm015506;
	Sun, 10 Feb 2008 22:11:39 -0500 (EST)
To: "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
cc: pgsql-sql@postgresql.org
Subject: Re: Can CREATE TYPE be used to create a synonym? 
In-reply-to: <15372.1202698673@sss.pgh.pa.us> 
References: <47AFA703.5060907@ultimeth.com> <15372.1202698673@sss.pgh.pa.us>
Comments: In-reply-to Tom Lane <tgl@sss.pgh.pa.us>
	message dated "Sun, 10 Feb 2008 21:57:53 -0500"
Date: Sun, 10 Feb 2008 22:11:39 -0500
Message-ID: <15505.1202699499@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/69
X-Sequence-Number: 30160

BTW, bouncing mail sent to your advertised reply address is a good way
to discourage people from ever answering you again.

			regards, tom lane

------- Forwarded Message

Return-Path: MAILER-DAEMON
Delivery-Date: Sun Feb 10 21:57:56 2008
Received: from localhost (localhost)
	by sss.pgh.pa.us (8.14.2/8.14.2) id m1B2vuOP015376;
	Sun, 10 Feb 2008 21:57:56 -0500 (EST)
Date: Sun, 10 Feb 2008 21:57:56 -0500 (EST)
From: Mail Delivery Subsystem <MAILER-DAEMON>
Message-Id: <200802110257.m1B2vuOP015376@sss.pgh.pa.us>
To: <tgl@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/report; report-type=delivery-status;
	boundary="m1B2vuOP015376.1202698676/sss.pgh.pa.us"
Subject: Returned mail: see transcript for details
Auto-Submitted: auto-generated (failure)

This is a MIME-encapsulated message

--m1B2vuOP015376.1202698676/sss.pgh.pa.us

The original message was received at Sun, 10 Feb 2008 21:57:54 -0500 (EST)
from tgl@localhost [127.0.0.1]

   ----- The following addresses had permanent fatal errors -----
<postgresql@ultimeth.com>
    (reason: 550 <sss.pgh.pa.us[66.207.139.130]>: Client host rejected: Mail to a list member must be sent via the list)

   ----- Transcript of session follows -----
... while talking to mail.mailpen.net.:
>>> DATA
<<< 550 <sss.pgh.pa.us[66.207.139.130]>: Client host rejected: Mail to a list member must be sent via the list
550 5.1.1 <postgresql@ultimeth.com>... User unknown
<<< 554 Error: no valid recipients

--m1B2vuOP015376.1202698676/sss.pgh.pa.us
Content-Type: message/delivery-status

Reporting-MTA: dns; sss.pgh.pa.us
Received-From-MTA: DNS; localhost
Arrival-Date: Sun, 10 Feb 2008 21:57:54 -0500 (EST)

Final-Recipient: RFC822; postgresql@ultimeth.com
Action: failed
Status: 5.1.1
Remote-MTA: DNS; mail.mailpen.net
Diagnostic-Code: SMTP; 550 <sss.pgh.pa.us[66.207.139.130]>: Client host rejected: Mail to a list member must be sent via the list
Last-Attempt-Date: Sun, 10 Feb 2008 21:57:56 -0500 (EST)

--m1B2vuOP015376.1202698676/sss.pgh.pa.us
Content-Type: message/rfc822

Return-Path: <tgl@sss.pgh.pa.us>
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m1B2vsOP015373;
	Sun, 10 Feb 2008 21:57:54 -0500 (EST)
To: "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Can CREATE TYPE be used to create a synonym? 
In-reply-to: <47AFA703.5060907@ultimeth.com> 
References: <47AFA703.5060907@ultimeth.com>
Comments: In-reply-to "Dean Gibson (DB Administrator)" <postgresql@ultimeth.com>
	message dated "Sun, 10 Feb 2008 17:38:11 -0800"
Date: Sun, 10 Feb 2008 21:57:53 -0500
Message-ID: <15372.1202698673@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>

"Dean Gibson (DB Administrator)" <postgresql@ultimeth.com> writes:
> CREATE TYPE DATETIME AS (dummy TIMESTAMP);

> I suspect not (syntax issues w/ input, output, etc).  Is there an 
> alternate way to declare a type synonym?

CREATE DOMAIN would serve a lot better.

			regards, tom lane

--m1B2vuOP015376.1202698676/sss.pgh.pa.us--

------- End of Forwarded Message