[EMAIL PROTECTED] writes:
> Take a scenario: you configure 2 servers as master and slave. You walk
> for a period of time during which a number failovers occur. You come
> back. Can I query a sl_ table to determine which server is the
> current master and which one is the current slave?
In
On Sunday 21 January 2007 15:56, gustavo halperin
<[EMAIL PROTECTED]> wrote:
> First, thank you for your answers about my problem with the function
> 'CREATE TRIGGER',
> I have another question about triggers, how can I pass arguments ?? I
> read about some struct TriggerData *CurrentTriggerData,
First, thank you for your answers about my problem with the function
'CREATE TRIGGER',
I have another question about triggers, how can I pass arguments ?? I
read about some struct TriggerData *CurrentTriggerData, but I didn't
found any explanation or example about how to use it in postgres SQL.
Firstly always cc the mailing list so others can offer suggestions about
the problem.
Thobiyas wrote:
Sir
*Postgresql isn't running on the server.*
*yes **
You need to start it before you can restore a database.*
*Unable to restart the Postgresql using Restart command
What is the command y
On Mon, Jan 22, 2007 at 12:21:48AM +0200, gustavo halperin wrote:
> I can't create triggers, when I call for example:
> ficha=> CREATE TRIGGER TRG_persons_id AFTER INSERT ON ficha_ofperson
> ficha-> EXECUTE PROCEDURE add_person_id ( 'family_id', 'person_id' );
>
> , the creation never finish and f
On 1/21/07, gustavo halperin <[EMAIL PROTECTED]> wrote:
Hello
I can't create triggers, when I call for example:
ficha=> CREATE TRIGGER TRG_persons_id AFTER INSERT ON ficha_ofperson
ficha-> EXECUTE PROCEDURE add_person_id ( 'family_id', 'person_id' );
, the creation never finish and finally, aft
On Mon, 22 Jan 2007, gustavo halperin wrote:
> I can't create triggers, when I call for example:
> ficha=> CREATE TRIGGER TRG_persons_id AFTER INSERT ON ficha_ofperson
> ficha-> EXECUTE PROCEDURE add_person_id ( 'family_id', 'person_id' );
>
> , the creation never finish and finally, after many m
Hello
I can't create triggers, when I call for example:
ficha=> CREATE TRIGGER TRG_persons_id AFTER INSERT ON ficha_ofperson
ficha-> EXECUTE PROCEDURE add_person_id ( 'family_id', 'person_id' );
, the creation never finish and finally, after many minutes, I kill the
creation with Ctrl+c.
I try
Shashank Tripathi wrote:
select something from othertable;
select * from table where table_id in (?, ?, ?, ?, ?, ?, ?, ...)
This is what MySQL's CEO Martin said in an interview on Slashdot. If
we can manage two queries as above through, say, a PHP application,
with each executing in 0.004 seco
"Shashank Tripathi" <[EMAIL PROTECTED]> writes:
>> select something from othertable;
>> select * from table where table_id in (?, ?, ?, ?, ?, ?, ?, ...)
> This is what MySQL's CEO Martin said in an interview on Slashdot. If
> we can manage two queries as above through, say, a PHP application,
> wi
Alvaro Herrera wrote:
> Bruce Momjian wrote:
>
> > For example, one could drop template1 and recreate it from
> > template0 without any ill effects. This course of action
> > might be advisable if one has carelessly added a bunch of junk in
> > ! template1. (To delete templa
select something from othertable;
select * from table where table_id in (?, ?, ?, ?, ?, ?, ?, ...)
This is what MySQL's CEO Martin said in an interview on Slashdot. If
we can manage two queries as above through, say, a PHP application,
with each executing in 0.004 seconds, then an optimized sub
Back on topic, I can confirm that MySQL does indeed have various problems
with optimizing sub-selects.
There are times where doing two seperate selects is orders of magnitude
faster than doing a single with a sub-select due to index selection
decisions.
Namely:
select * from table where table_i
On Sun, Jan 21, 2007 at 12:27:41PM -0500, Jaime Casanova wrote:
> On 1/21/07, mbneto <[EMAIL PROTECTED]> wrote:
> >Hi,
> >
> >I have a dumpall file generated from a 8.0 version that I need to import
> >back to a 7.4 server.
> >
> >Is there a way to do that?
> >
> >a psql -f db.out template1 gives m
On Sun, Jan 21, 2007 at 06:55:56AM -0800, brian stone wrote:
> Are there any built in tools or 3rd party tools for distributing a postgresql
> database? I need an active active configuration; master-master with fail
> over. The project I am working needs to support a very large number of
> tra
On Sat, Jan 20, 2007 at 11:19:50AM -0600, Kelly Burkhart wrote:
> On 1/20/07, Shoaib Mir <[EMAIL PROTECTED]> wrote:
> >Should help --> ALTER TABLE tablename ALTER columname TYPE text;
>
> I was looking for a way to alter a column from varchar(n) to text
> without using the alter command and conseq
Bruce Momjian wrote:
> For example, one could drop template1 and recreate it from
> template0 without any ill effects. This course of action
> might be advisable if one has carelessly added a bunch of junk in
> ! template1. (To delete template1,
> ! it must have datistem
On Sun, Jan 21, 2007 at 11:39:45AM +, Heikki Linnakangas wrote:
> Russell Smith wrote:
> >Strange idea that I haven't researched, Given Vacuum can't be run in a
> >transaction, it is possible at a certain point to quit the current
> >transaction and start another one. There has been much ch
On 2007-01-21, Ron Johnson <[EMAIL PROTECTED]> wrote:
>> And no BDB (at least last I checked is not GPL)
>
> It's BSD (for obvious reasons), no?
No, Sleepycat's licence is _NOT_ BSD.
--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services
-
Tom Lane wrote:
It looks like you have a stale plan for that ON DELETE SET NULL
constraint. Was there perhaps an index on operator_id that you removed?
Postgres is not very good about flushing cached plans when you change
table schemas (something I hope will be fixed in 8.3).
If that is the pro
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 01/21/07 10:20, Joshua D. Drake wrote:
> Shashank wrote:
[snip]
>> Where is this announcement? They don't need to drop either
>> engine, as both are GPL. MySQL as a group was never too hot
>> with BDB.
>
>
> http://www.linux.com/article.pl?sid=06/
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Shashank wrote:
>>> It seems MySQL just dropped the ball on
>>> the free version of their product, and it
>>
>> Not sure what you mean. I can download their latest versions without
>> any trouble.
> In contrast to the MySQL Enterprise Server, which
"imageguy" <[EMAIL PROTECTED]> writes:
> So... unless I am missing something, I would suggest you CANNOT us
> plpython (or perhaps any other pl language ??) to process transactions
I think the point you are missing is that every function already runs
within a transaction. You can't issue BEGIN/CO
"imageguy" <[EMAIL PROTECTED]> writes:
> In my testing so far, it seems that each call to plpy.execute('INSERT
> INTO ') is committed immediately.
On what do you base that (erroneous) conclusion?
The fact that a transaction can see its own updates does not mean they
are committed.
On 1/21/07, mbneto <[EMAIL PROTECTED]> wrote:
Hi,
I have a dumpall file generated from a 8.0 version that I need to import
back to a 7.4 server.
Is there a way to do that?
a psql -f db.out template1 gives me
psql:/tmp/db.out:687: ERROR: syntax error next "INDEX" at character 7
you must edit
On 21 Jan 2007 08:01:57 -0800, Shashank <[EMAIL PROTECTED]> wrote:
> It seems MySQL just dropped the ball on
> the free version of their product, and it
Not sure what you mean. I can download their latest versions without
any trouble.
The point was they are not going to the effort to roll bi
Shashank wrote:
>> It seems MySQL just dropped the ball on
>> the free version of their product, and it
>
> Not sure what you mean. I can download their latest versions without
> any trouble.
>
In contrast to the MySQL Enterprise Server, which receives both monthly
rapid updates and quarterly se
> It seems MySQL just dropped the ball on
> the free version of their product, and it
Not sure what you mean. I can download their latest versions without
any trouble.
> Additionally, they feel that Oracle is such a threat that they have dumped
> BDB (I believe this move was after Oracle acquire
Hi,
I have a dumpall file generated from a 8.0 version that I need to import
back to a 7.4 server.
Is there a way to do that?
a psql -f db.out template1 gives me
psql:/tmp/db.out:687: ERROR: syntax error next "INDEX" at character 7
ALTER TABLE
psql:/tmp/db.out:697: ERROR: syntax error next "
Shashank Tripathi wrote:
>> It's a valid discussion here (although better on -advocacy), because
>> it helps
>> me have the right facts to present to clients about whether they
>> should stay
>> with a legacy database in MySQL vs upgrading to a modern PostgreSQL.
>
>
> For all its flaws, MySQL is
21 Jan 2007 06:53:15 -0800, imageguy <[EMAIL PROTECTED]>:
> What happens if you do:
>
> plpy.execute("BEGIN");
>
> before and after
>
> plpy.execute("COMMIT");
>
> Have a nice day,
> --
Thanks for your reply Martin.
After making my post I decide not to be so lazy and set up a test
environment.
Af
Are there any built in tools or 3rd party tools for distributing a postgresql
database? I need an active active configuration; master-master with fail over.
The project I am working needs to support a very large number of transactions
a second. It will eventually require a main frame, or some
> What happens if you do:
>
> plpy.execute("BEGIN");
>
> before and after
>
> plpy.execute("COMMIT");
>
> Have a nice day,
> --
Thanks for your reply Martin.
After making my post I decide not to be so lazy and set up a test
environment.
After try exactly what you suggested, I got the following erro
Martijn van Oosterhout wrote:
> On Sun, Jan 21, 2007 at 04:56:23AM -0800, imageguy wrote:
> > Does anyone have an example of using transactions with plpythonu ?
> >
> > In my testing so far, it seems that each call to plpy.execute('INSERT
> > INTO ') is committed immediately.
>
> What happens
On 1/20/07, John Meyer <[EMAIL PROTECTED]> wrote:
What I think bothers me is this whole concept that if PostgreSQL is to
flourish, MySQL has to be beaten down. Folks, both products are free,
both can be used in the same shop (maybe not on the same computer if
your running them in production).
On Sun, Jan 21, 2007 at 04:56:23AM -0800, imageguy wrote:
> Does anyone have an example of using transactions with plpythonu ?
>
> In my testing so far, it seems that each call to plpy.execute('INSERT
> INTO ') is committed immediately.
What happens if you do:
plpy.execute("BEGIN");
before
On Sun, Jan 21, 2007 at 12:24:38PM +, Simon Riggs wrote:
> Partial vacuum would still be possible if you remembered where you got
> to in the VACUUM and then started from that same point next time. It
> could then go to the end of the table and wrap back around.
ISTM the Dead Space Map would g
Hello,
I have set up replication between a SQL 2000 server & a PG 8.2.0-1
server (both running on Windows 2003). To date, I've been replicating
four tables from a database with no problem whatsoever.
I'm attempting to replicate a fifth table, which isn't working so well.
The designer of the SQ
Does anyone have an example of using transactions with plpythonu ?
I want to create a function that receives data from a client app, and
then updates three different tables but I want to ensure they all get
updated before I commit.
In my testing so far, it seems that each call to plpy.execute('IN
On Sat, 2007-01-20 at 09:41 +1100, Russell Smith wrote:
> Darcy Buskermolen wrote:
> > [snip]
> >
> > Another thought, is it at all possible to do a partial vacuum? ie spend
> > the
> > next 30 minutes vacuuming foo table, and update the fsm with what hew have
> > learned over the 30 mins, e
Russell Smith wrote:
Strange idea that I haven't researched, Given Vacuum can't be run in a
transaction, it is possible at a certain point to quit the current
transaction and start another one. There has been much chat and now a
TODO item about allowing multiple vacuums to not starve small ta
2007/1/19, Paul Lambert <[EMAIL PROTECTED]>:
A number of months ago I was pointed towards Postgre as a reliable database
server
Please don't use the word Postgre:
http://stoned.homeunix.org/~itsme/postgre/>.
greetings,
Nicolas
--
Nicolas Barbier
http://www.gnu.org/philosophy/no-word-attachme
2007/1/21, Shashank Tripathi <[EMAIL PROTECTED]>:
For all its flaws, MySQL is catching on quick and has a very active
community of developments that several of us find rather handy -
http://forge.mysql.com/
Is there something similar for Pgsql?
http://pgfoundry.org/>
greetings,
Nicolas
--
N
43 matches
Mail list logo
