[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] was: Postgres method / expression help to delete rela
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] was: Postgres method / expression help to delete related records |
Date: |
Mon, 5 Sep 2011 08:57:06 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
On Sun, Sep 04, 2011 at 04:58:48PM -0700, Jim Busser wrote:
> works after I adjusted for the fact that I had created my table not in
> staging but as temporary:
>
> CREATE TEMP TABLE subs (
> description text,
> atc_code text,
> amount numeric,
> unit text
> );
>
> I saw it as an advantage that AFAICT the above would
> auto-drop (conserving disk space) at the end of the session.
> Is it your preference (and/or good practice) that temporary
> files for import be written into the staging schema, as
> opposed to the temporary schema?
No, that's fine.
Karsten
--
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346