I have a JOIN error that is rather opaque...at least to me.
I've using other JOIN queries on this project, which seem very similar to
this one, which looks like:
SELECT S.subjectid,STY.studyabrv,labID,boxnumber,wellrow,wellcolumn
FROM DNASample D, IBG_Studies STY, Subjects S, ibg_projects P
LEF
Thanks Dim; I was not aware of pgloader. This, and the other suggestions,
have helped a lot; thanks everyone.
--rick
On Mon, Mar 29, 2010 at 7:41 AM, Dimitri Fontaine wrote:
> Rick Casey writes:
>
> > So, I am wondering if there is any to optimize this process? I have been
> usi
After careful research, I would to post the following problem I'm having
with the importing of a large (16Gb) CSV file. Here is brief synopsis:
- this is running on Postgres (PG) version: PostgreSQL 8.3.9 on
i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Ubuntu 4.3.2-1ubuntu11)
4.3.2
- it is runn
This will not answer you question, but documents some of the evidence
for you:
http://www.geocities.com/mailsoftware42/db/
Rick Casey, Research Associate
Institute for Behavioral Genetics
[EMAIL PROTECTED]
303.735.3518
Rick Schumeyer wrote:
I’m interested in comparing the performance of
Hey, thanks to everyone who replied to my questions: problem solved!
I needed to: 1) do BEFORE DELETE to see the OLD variables, and 2) use a
placeholder in my format string in the RAISE EXCEPTION/NOTICE statement.
Open source newsgroups rock!
--rick
Rick Casey, Research Associate
Institute for
test case I can
think of. Any suggestions would be appreciated!
Thanks,
Rick
> I think you have created a statement level trigger (If they existed in
> 7.4.7...) by not including FOR EACH ROW in your create statement. In
> statement level triggers, there is no OLD or NEW.
>
>
ig.sql:1: ERROR: OLD.famindid =
Regards,
rick
Tom Lane wrote:
Rick Casey <[EMAIL PROTECTED]> writes:
Here is the code that creates the delete trigger:
create trigger PEDIGREES_hist_del_trig
AFTER DELETE
on PEDIGREES
EXECUTE PROCEDURE logPedigreesDel();
I think you f
misleading if this
is not the case.
Regards,
Rick
Rick Casey, Research Associate
Institute for Behavioral Genetics
[EMAIL PROTECTED]
303.735.3518
Rick Casey wrote:
Hello all,
I am trying to a simple thing: create a log history of deletes, and
updates; but which I am having trouble getting to work in PG
Hello all,
I am trying to a simple thing: create a log history of deletes, and
updates; but which I am having trouble getting to work in PG 7.4.7
(under Debian Linux 2.6.8).
I have reduced my code to the following trivial case:
Here is the code that creates the delete trigger:
create trigger PED
