[SQL] Can CREATE TYPE be used to create a synonym?
Eg: 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? -- Dean ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [SQL] Can CREATE TYPE be used to create a synonym?
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 Message-Id: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] [127.0.0.1] - The following addresses had permanent fatal errors - <[EMAIL PROTECTED]> (reason: 550 : 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 : Client host rejected: Mail to a list member must be sent via the list 550 5.1.1 <[EMAIL PROTECTED]>... 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; [EMAIL PROTECTED] Action: failed Status: 5.1.1 Remote-MTA: DNS; mail.mailpen.net Diagnostic-Code: SMTP; 550 : 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: <[EMAIL PROTECTED]> Received: from sss2.sss.pgh.pa.us ([EMAIL PROTECTED] [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)" <[EMAIL PROTECTED]> cc: pgsql-sql@postgresql.org Subject: Re: [SQL] Can CREATE TYPE be used to create a synonym? In-reply-to: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Comments: In-reply-to "Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> message dated "Sun, 10 Feb 2008 17:38:11 -0800" Date: Sun, 10 Feb 2008 21:57:53 -0500 Message-ID: <[EMAIL PROTECTED]> From: Tom Lane <[EMAIL PROTECTED]> "Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [SQL] Can CREATE TYPE be used to create a synonym?
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [SQL] Bouncing replies
I'm open to suggestions. I've been a member of this list for several years, but every time I post here, some scumbag harvests my eMail address from it and I get hundreds of spam (most gets filtered by postfix). I've gone through a half-dozen eMail addresses on this list alone, and it's been a significant discouragement to posting questions, let alone answering other people. I finally came up with the solution below: If mail to my list address doesn't come from one of your list servers (and those seems to change much more often than any other list I belong to), it gets rejected. And boy, does that catch a lot of spam! I'm curious as to why the list server defaults to using a sender's address as the "Reply-to" address, rather than using the list address. That means that, unless the user is careful to "reply all" (or even better, just reply to the list address), any discussion immediately goes private. In fact, I don't understand why the sender's eMail address is visible at all. Yahoo! is one of the stupidest Internet companies on the face of the planet, and they seem to have been able to figure it out, as has most of the free message board software. And yes, I've read http://www.unicom.com/pw/reply-to-harmful.html -- a very long web page that repeats the same fallacious arguments over and over. They had some validity before spam became a problem, but not now. Anyway, this list is not the place for that discussion. I appreciate the support you give to not only me, but the entire mailing list. I've white-listed you, and I'm open to other suggestions. Sincerely, Dean On 2008-02-10 19:11, Tom Lane wrote: BTW, bouncing mail sent to your advertised reply address is a good way to discourage people from ever answering you again. regards, tom lane - The following addresses had permanent fatal errors - [postgresql.ultimeth.com] (reason: 550 : Client host rejected: Mail to a list member must be sent via the list) ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
