>
> 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 cre
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 n
> "hans" == hans 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 L. Sch
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(CAS
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
Actu
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 no
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
Peter Hopfgartner 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, I've modified the script
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
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
tc
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
trc_seq_
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 18:49
>Peter Hopfgartner writes:
>> Tom Lane wrote
>>> Peter Hopfgartner writes:
Now we had the error, but systemtap did not report a
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
>> )
>
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 d
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 cou
2010/9/16 Gissur Þórhallsson :
>> 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 still need
> 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 a
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 I'
Peter Hopfgartner writes:
> Tom Lane wrote
>> Peter Hopfgartner 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
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 (expt_no,subject,
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 I'
> 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 som
>
> 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.
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 17:37
>Peter Hopfgartner writes:
>> Now we had the error, but systemtap did not report any SIGTERM. Is it
>> possible to have this error without a SIGTERM b
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
Peter Hopfgartner 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, tom lane
--
Sent via pgsql-
Peter Hopfgartner wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 16.09.2010 16:56
>Tom Lane wrote
>
>Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
>administrator command
>
>Date: 15.09.
Tom Lane wrote
Subject: Re: [GENERAL] Getting FATAL: terminating connection due to
administrator command
Date: 15.09.2010 17:40
>Peter Hopfgartner writes:
>> Tom Lane wrote
>>> This is a result of something sending SIGTERM to the backend process.
>
>> Can I tra
"Utsav Turray" 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.
regards, tom lane
--
Se
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. The
2010/9/16 Louis-David Mitterrand :
> On Thu, Sep 16, 2010 at 10:12:57AM -0400, Tom Lane wrote:
>> Louis-David Mitterrand 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:
>> http://www
On Thu, Sep 16, 2010 at 10:12:57AM -0400, Tom Lane wrote:
> Louis-David Mitterrand 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:
> http://www.postgresql.org/docs/9.0/static/plpgsql-st
Louis-David Mitterrand 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:
http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-DIAGNOSTICS
Adding EXECUTE to the li
2010/9/16 Gissur Þórhallsson :
>> 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 pretty tricky thi
Hello
2010/9/16 Louis-David Mitterrand :
> 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 pgsql-general mailing list (pgsql-
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
Craig Ringer 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 instead. By and large y
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
On Wed, Sep 15, 2010 at 6:52 PM, Arjen Nienhuis wrote:
> On Thu, Sep 16, 2010 at 12:37 AM, Merlin Moncure wrote:
>> On Wed, Sep 15, 2010 at 6:18 PM, Arjen Nienhuis
>> wrote:
>> > Hi,
>> > Inserting many of rows is almost always IO bound. Converting ints and
>> > floats
>> > to text is CPU bound
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 fidd
>
> 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 or
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 na
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 6
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 sh
44 matches
Mail list logo
