From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Can CREATE TYPE be used to create a synonym? |
Date: | 2008-02-11 03:11:39 |
Message-ID: | 15505.1202699499@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(dot)m1B2vuOP015376(at)sss(dot)pgh(dot)pa(dot)us>
To: <tgl(at)sss(dot)pgh(dot)pa(dot)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(at)localhost [127.0.0.1]
----- The following addresses had permanent fatal errors -----
<postgresql(at)ultimeth(dot)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(at)ultimeth(dot)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(at)ultimeth(dot)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(at)sss(dot)pgh(dot)pa(dot)us>
Received: from sss2.sss.pgh.pa.us (tgl(at)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(at)ultimeth(dot)com>
cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] Can CREATE TYPE be used to create a synonym?
In-reply-to: <47AFA703(dot)5060907(at)ultimeth(dot)com>
References: <47AFA703(dot)5060907(at)ultimeth(dot)com>
Comments: In-reply-to "Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)com>
message dated "Sun, 10 Feb 2008 17:38:11 -0800"
Date: Sun, 10 Feb 2008 21:57:53 -0500
Message-ID: <15372(dot)1202698673(at)sss(dot)pgh(dot)pa(dot)us>
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
"Dean Gibson (DB Administrator)" <postgresql(at)ultimeth(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Dean Gibson (DB Administrator) | 2008-02-11 05:06:37 | Re: Bouncing replies |
Previous Message | Tom Lane | 2008-02-11 02:57:53 | Re: Can CREATE TYPE be used to create a synonym? |