Skip site navigation (1) Skip section navigation (2)

Re: CREATE SYNONYM ...

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Neil Conway" <neilc(at)samurai(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Stephan Szabo" <sszabo(at)megazone(dot)bigpanda(dot)com>, "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>, "Hans-J?rgen Sch?nig" <postgres(at)cybertec(dot)at>, "Michael Glaesemann" <grzm(at)myrealbox(dot)com>, pgsql-patches(at)postgresql(dot)org, eg(at)cybertec(dot)at
Subject: Re: CREATE SYNONYM ...
Date: 2006-03-08 14:18:15
Message-ID: 36e682920603080618v5eeaae82t885c47c8e1893853@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-patches
GRR, not enough coffee yet today :(

<action>Jonah now enjoys some Sumatra</action>

On 3/8/06, Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com> wrote:
>
> I agree wholeheartedly.
>

regarding "we should take a fresh look at the problem rather than just
blindly copying a construct from Oracle".

SELECT dblink('host=somehost dbname=remotedb ...', 'SELECT
> emp_id,first_name,last_name,middle_name,birth_dt,ssn,... FROM EMPLOYEE WHERE
> last_name = ''Blow''') AS t1(emp_id BIGINT, first_name VARCHAR, last_name
> VARCHAR, middle_name VARCHAR, birth_dt DATE, ssn NUMERIC, ...)
>

should be SELECT * FROM ...


--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

In response to

pgsql-patches by date

Next:From: Tom LaneDate: 2006-03-08 15:27:48
Subject: Re: pg_freespacemap question
Previous:From: Jonah H. HarrisDate: 2006-03-08 14:14:32
Subject: Re: CREATE SYNONYM ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group