On Sun, 21 Dec 2003 12:05 am, Shridhar Daithankar wrote:
> Does it mean mysql got stored procedures? Wow..
>
> I would like to see details but since I don't know much details about
> either mysql or java, I can not describe it.
>
> Can anybody give a summary as in how much it takes mysql as far as
Hi Tom,
Thanks for the fast response. One learns something new everyday!
Cheers,
Jason
On Tue, 7 Oct 2003 12:14 am, Tom Lane wrote:
> Jason Godden <[EMAIL PROTECTED]> writes:
> > I'm in the process of moving a rather complicated plpgsql stored
> > procedure to a C mo
Hi David,
I'd say that if it is a new app develop it with 7.4 and use statement level
triggers otherwise you could use normal triggers and perform a count each
time but that will slow things down dramatically.
Other option is to use cron and write a daemon/script to periodically check
the size
A trigger is the right way. Rules rewrite a statement whereas triggers are at
row level.
so in plpgsql:
create or replace function trig_param_ins_upd() returns trigger as '
begin
new.ts = current_timestamp;
return new;
end;' language 'plpgsql';
create trigger trig_param_ins_upd
e
> query - first UPDATE when EXISTS, then INSERT when NOT EXISTS, to
> accomplist this in one go ?
>
> Regards
>
> Phil
>
> - Original Message -
> From: Jason Godden <[EMAIL PROTECTED]>
> To: Philip Boonzaaier <[EMAIL PROTECTED]>; <[EMAIL PROTEC
Hi Philip,
Pg is more ansi compliant than most (GoodThing (TM)). You can use the 'when'
conditional but not to do what you need. If I understand you correclty you
should be able to acheive the same result using two seperate queries and the
(NOT) EXISTS or (NOT) IN clause. Failing that have a
decoder info
and everything purrs.. sigh. Writing help requests to the list when you've
only exhausted half the possibilities are a bit silly.
Thanks for your time,
Jason
On Mon, 18 Aug 2003 11:41 pm, Jan Wieck wrote:
> Jason Godden wrote:
> > Hi Sean,
> >
> > Yeah - I
Hi Sean,
Yeah - It is declared VOLATILE. I think there must be something specific with
the way PL/PGSQL handles child processes of a called function. The child
process actually spawns mpg123 or ogg123 so it has to live beyond the life of
the parent. Not sure. What I might do is rewrite the
>E N9753
>
> Cheers,
> Murthy
>
> -----Original Message-
> From: Jason Godden
> To: [EMAIL PROTECTED]
> Sent: 8/15/2003 7:33 PM
> Subject: Re: [GENERAL] summary and request
>
> create table import_contact (
> id character(7) not null primary key,
> fm ch
122038 else start end,
case "end" when null then 122038 else "end" end
from import_contact;" | psql -dthedatabase
Rgds,
Jason
On Sat, 16 Aug 2003 01:10 pm, expect wrote:
> On Sat, 16 Aug 2003 09:33:51 +1000
> Jason Godden <[EMAIL PROTECTED]> wrote:
>
create table import_contact (
id character(7) not null primary key,
fm character(30),
ls character(30),
addr character(30),
city character(25),
st character(2),
c character(1),
start decimal(6),
end decimal(6),
) WITHOUT OIDS;
cat datafile.dat | psql -dthedatabase -c "copy import_contact from stdi
Whilst I agree with what Bruno said regarding adding a default option to the
copy syntax I think that the basic principles Stephan and I outlined in how
copy treats your import is correct and the developers did the right thing.
Now if the devs, you or I want to add a default option to copy in t
Hi Brice,
Thats very wrong...
Whilst changing conf settings will speed things up it still shouldn't affect
loading a 32mb dump file. Have you tried restarting PG with logging and then
piping the dump file through psql? You should find that you get a lot more
direct feedback from psql. This
tion and table / record locking)
> 4.If everything works well both changes (done by the client and the
> server) should commit or rollback now
>
> So both Postgres-Connections has to be @ the same TransAction-OID in
> Postgres.
>
> greets
>
> Daniel
>
> -----Ursp
Hi Daniel,
Maybe make procedural wrappers around all events undertaken and simulate it?
ie:
1. Client connects to MS SQL Server (Application Server) and PG Server
2. SQL Server connects to PG Server aswell
3. Client begins new record process
4. New record process starts by putting PG into serial
15 matches
Mail list logo
