I was able to configure Postgres Version 8.4.4. Now when I execute the make
I get the following:
/usr/lib64/gcc/x86_64-suse-linux/4.3/../../../../x86_64-suse-linux/bin/ld:
/usr/local/openssl/lib64/libssl.a(t1_meth.o): relocation R_X86_64_32 against
`a local symbol' can not be used when making a
On 16/09/2010 4:35 PM, Peter Roethlisberger wrote:
I was able to configure Postgres Version 8.4.4. Now when I execute the make
I get the following:
It would be helpful if you provided a few basic details, like your OS,
compiler version, configure command line, etc.
You're clearly on some
On Thu, Sep 16, 2010 at 04:40:42AM +0200, Andreas wrote:
I need to clean up a lot of contact data because of a merge of customer
lists that used to be kept separate.
I allready know that there are double entries within the lists and they
do overlap, too.
Relevant fields could be name,
Yes. You're using RULEs where TRIGGERs would do. Change to TRIGGERs.
While this could possibly solve my problem in particular; it doesn't explain
why this is happening.
Is this somehow expected behavior on an INSERT rule?
PS. It seems that I forgot to create a meaningful subject in my
Am 16.09.2010 13:18, schrieb Sam Mason:
On Thu, Sep 16, 2010 at 04:40:42AM +0200, Andreas wrote:
I need to clean up a lot of contact data because of a merge of customer
lists that used to be kept separate.
What to do depends on how much data you have; a few thousand and you can
do lots of
On Wed, Sep 15, 2010 at 6:52 PM, Arjen Nienhuis a.g.nienh...@gmail.com wrote:
On Thu, Sep 16, 2010 at 12:37 AM, Merlin Moncure mmonc...@gmail.com wrote:
On Wed, Sep 15, 2010 at 6:18 PM, Arjen Nienhuis a.g.nienh...@gmail.com
wrote:
Hi,
Inserting many of rows is almost always IO bound.
On Thu, Sep 16, 2010 at 03:22:15PM +0200, Andreas wrote:
We are talking about nearly 500.000 records with considerable overlapping.
Other things to consider is whether each one contains unique entries and
hence can you do a best match between datasets--FULL OUTER JOIN is
your friend here, but
Craig Ringer cr...@postnewspapers.com.au writes:
On 16/09/2010 4:35 PM, Peter Roethlisberger wrote:
/usr/local/openssl/lib64/libssl.a: could not read symbols: Bad value
Bad build of OpenSSL? What does:
Well, the real question here is why it's not picking up a shared-library
version of libssl
Hi,
I noticed that in a pl/pgsql function FOUND is not set after an
EXECUTE ... into var;
Bug or feature?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello
2010/9/16 Louis-David Mitterrand vindex+lists-pgsql-gene...@apartia.org:
Hi,
I noticed that in a pl/pgsql function FOUND is not set after an
EXECUTE ... into var;
Bug or feature?
feature :(
use a GET DIAGNOSTICS statement instead
Regards
Pavel Stehule
--
Sent via
2010/9/16 Gissur Þórhallsson gis...@loftmyndir.is:
Yes. You're using RULEs where TRIGGERs would do. Change to TRIGGERs.
While this could possibly solve my problem in particular; it doesn't explain
why this is happening.
Is this somehow expected behavior on an INSERT rule?
Rules can be
Louis-David Mitterrand vindex+lists-pgsql-gene...@apartia.org writes:
I noticed that in a pl/pgsql function FOUND is not set after an
EXECUTE ... into var;
Bug or feature?
It's behaving as documented:
On Thu, Sep 16, 2010 at 10:12:57AM -0400, Tom Lane wrote:
Louis-David Mitterrand vindex+lists-pgsql-gene...@apartia.org writes:
I noticed that in a pl/pgsql function FOUND is not set after an
EXECUTE ... into var;
Bug or feature?
It's behaving as documented:
2010/9/16 Louis-David Mitterrand vindex+lists-pgsql-gene...@apartia.org:
On Thu, Sep 16, 2010 at 10:12:57AM -0400, Tom Lane wrote:
Louis-David Mitterrand vindex+lists-pgsql-gene...@apartia.org writes:
I noticed that in a pl/pgsql function FOUND is not set after an
EXECUTE ... into var;
Dear All ,
I am using postgres 7.3.2 on RHEL 4.0.
I know the version is too old but I have no option upgrading the postgres
version.
I have a table with a column type text. The column consists large data
ranging from 500 kb to 900 kb.
Total there are 5 records approximately.
Utsav Turray utsav.tur...@newgen.co.in writes:
I am using postgres 7.3.2 on RHEL 4.0.
Egad.
Secondly what are probable reasons behind corruption and what can we do to
prevent this error.
Update. Whatever reasons you might have for running 7.3.2 are bad ones.
Tom Lane t...@sss.pgh.pa.us wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 15.09.2010 17:40
Peter Hopfgartner peter.hopfgart...@r3-gis.com writes:
Tom Lane t...@sss.pgh.pa.us wrote
This is a result of
Peter Hopfgartner peter.hopfgart...@r3-gis.com wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 16:56
Tom Lane t...@sss.pgh.pa.us wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection
Peter Hopfgartner peter.hopfgart...@r3-gis.com writes:
Now we had the error, but systemtap did not report any SIGTERM. Is it
possible to have this error without a SIGTERM being involved?
Hmph. I would have said not, but ...
What PG version is this exactly?
regards,
I'm working with some people who live and breath Excel. I need to be able to
move data back and forth between formats which make sense for Excel and for
PostgreSQL. In some cases, this is just to accommodate what people are used
to. In other cases, like statistical clustering, it's something
Tom Lane t...@sss.pgh.pa.us wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 17:37
Peter Hopfgartner peter.hopfgart...@r3-gis.com writes:
Now we had the error, but systemtap did not report any SIGTERM. Is it
which is probably not what you might expect.
No, indeed it is not.
My solution - which seems to be working - is replacing:
new.my_table_id
with:
currval(pg_get_serial_sequence('my_table', 'my_table_id'))
in the on_insert rule
This does the trick.
Thanks,
Gissur Þórhallsson
Loftmyndir ehf.
I'm working with some people who live and breath Excel. I need to be able
to move data back and forth between formats which make sense for Excel and
for PostgreSQL. In some cases, this is just to accommodate what people are
used to. In other cases, like statistical clustering, it's
I have a query that joins 3 tables, TRAIN_MOD,TRAIN_COMP and TRAINING_COURSE,
There could be many training_course records for each of the other
tables. I want to get all records from the Train_mod and Train_comp
table even if there are no training course records available. This is
the query
On Thu, Sep 16, 2010 at 11:42:21AM -0400, Aram Fingal wrote:
create table results(
expt_no int references experiments(id),
subject int references subjects(id),
drug text references drugs(name),
dose numeric,
response numeric
)
What's the primary key? I presume it's
Peter Hopfgartner peter.hopfgart...@r3-gis.com writes:
Tom Lane t...@sss.pgh.pa.us wrote
Peter Hopfgartner peter.hopfgart...@r3-gis.com writes:
Now we had the error, but systemtap did not report any SIGTERM. Is it
possible to have this error without a SIGTERM being involved?
I have a query that joins 3 tables, TRAIN_MOD,TRAIN_COMP and TRAINING_COURSE,
There could be many training_course records for each of the other
tables. I want to get all records from the Train_mod and Train_comp
table even if there are no training course records available. This is
the query
On 9/16/2010 5:18 AM, Sam Mason wrote:
On Thu, Sep 16, 2010 at 04:40:42AM +0200, Andreas wrote:
I need to clean up a lot of contact data because of a merge of customer
lists that used to be kept separate.
I allready know that there are double entries within the lists and they
do
2010/9/16 Gissur Þórhallsson gis...@loftmyndir.is:
which is probably not what you might expect.
No, indeed it is not.
My solution - which seems to be working - is replacing:
new.my_table_id
with:
currval(pg_get_serial_sequence('my_table', 'my_table_id'))
in the on_insert rule
OK, but you
On 16/09/2010 16:05, Christine Penner wrote:
I have a query that joins 3 tables, TRAIN_MOD,TRAIN_COMP and
TRAINING_COURSE,
There could be many training_course records for each of the other
tables. I want to get all records from the Train_mod and Train_comp
table even if there are no training
Training Course
tc_seq_no (primary key)
tc_trm_seq (foreign key to train_mod table)
... and some other title, desc etc fields
train_mod
trm_seq_no (primary key)
trm_trc_seq (foreign key to train_comp table)
.. and title etc fields
train_comp
trc_seq_no (primary key)
.. and title etc fields
We
On Sep 16, 2010, at 12:28 PM, Sam Mason wrote:
On Thu, Sep 16, 2010 at 11:42:21AM -0400, Aram Fingal wrote:
create table results(
expt_no int references experiments(id),
subject int references subjects(id),
drug text references drugs(name),
dose numeric,
response numeric
)
What's the
Tom Lane t...@sss.pgh.pa.us wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 18:49
Peter Hopfgartner peter.hopfgart...@r3-gis.com writes:
Tom Lane t...@sss.pgh.pa.us wrote
Peter Hopfgartner
On 16/09/2010 18:33, Christine Penner wrote:
Training Course
tc_seq_no (primary key)
tc_trm_seq (foreign key to train_mod table)
... and some other title, desc etc fields
train_mod
trm_seq_no (primary key)
trm_trc_seq (foreign key to train_comp table)
.. and title etc fields
train_comp
I decided to approach this a different way. Not worth the time to
figure out. I get all records from all tables and put them together
in the program using this.
Thanks for your help.
Christine
At 12:20 PM 16/09/2010, you wrote:
On 16/09/2010 18:33, Christine Penner wrote:
Training Course
On 09/16/10 10:44 AM, Aram Fingal wrote:
I have thought about that but later on, when we do the full sized experiments,
there will be too many rows for Excel to handle.
if you insist on this transposing, won't that mean you'll end up with
more columns than SQL can/should handle?
--
Sent
Peter Hopfgartner peter.hopfgart...@r3-gis.com writes:
[...]
http://sourceware.org/systemtap/examples/process/sigmon.stp
Now we had the error, but systemtap did not report any SIGTERM. Is
it possible to have this error without a SIGTERM being involved? As
mentioned in a previous mail,
On Sep 16, 2010, at 4:37 PM, John R Pierce wrote:
On 09/16/10 10:44 AM, Aram Fingal wrote:
I have thought about that but later on, when we do the full sized
experiments, there will be too many rows for Excel to handle.
if you insist on this transposing, won't that mean you'll end up with
On 16 Sep 2010, at 18:23, Christine Penner wrote:
There could be many training_course records for each of the other tables. I
want to get all records from the Train_mod and Train_comp table even if there
are no training course records available. This is the query I'm trying and I
get
Hi,
I was looking for a simple diff program to compare two schemas, i found two
scripts out there but one compared everything and was too much for me, the
other was a ruby script i wasn't able to run, so i wrote a little perl script
that do the trick:
http://www.welinux.cl/hans/dbdiff.pl
On Thu, Sep 16, 2010 at 01:44:30PM -0400, Aram Fingal wrote:
On Sep 16, 2010, at 12:28 PM, Sam Mason wrote:
If you want to do the transformation in SQL, you'd be writing something
like:
SELECT drug, dose
MIN(CASE subject WHEN 1 THEN response END) AS resp_1,
MIN(CASE subject
hans == hans h...@welinux.cl writes:
hans Actually just compare tables and fields, for my current
hans requirements is ok, i plan to add the sequences, but no more.
I believe SQLFairy (aka SQL::Translator) can canonicalize schemas, and
even give DDL to turn one schema into another.
--
Randal
Hi,
Thanks for the quick response, i installed sqlfaiyr and guess that sqlt-diff
is what i'm loogin for, but i can't guess how to use it, do you have any call
samples, i found this:
sqlt-diff --to MySQL Schema1=MySQL Schema2=MySQL SchemaUpdate.mysql.sql
i can't guess where is the database
OK, but you still need to be careful. That trick will only work if you
insert rows one at a time into the table. If you have a single insert
that inserts multiple rows (as in my example), it would fail because
the currval() call would return the same value for each row in the
insert created
44 matches
Mail list logo