[GENERAL] How to prevent modifications in a tree of rows, based on a condition?

resql? Does anyone have an idea maybe? The rule system? Thanks for your ideas. Philippe Lang --- CREATE TABLE public.orders ( idint4 PRIMARY KEY, value int4 ) WITHOUT OIDS; CREATE TABLE public.order_lines ( idint4 PRIMARY KEY, value int4,

[GENERAL] ERROR: must be superuser to alter superusers

engine anymore, what option do I have? I tried: CREATE ROLE pgsql2 SUPERUSER; ... But I get: ERROR: must be superuser to create superusers SQL state: 42501 Thanks, Philippe Lang ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Execution plan caching

Hi, I have recently used the MS SQL Server 2005 database, and found out that there is no mecanism where an execution plan can be reused between two successive calls to a view. This is only true with stored procedures. Is that also true with the Postgresql engine? Philippe --

[GENERAL] contrib/xml2 with 7.4

Hi, Is there any chance I can use the contrib/xml2 package with a 7.4 database, or does it need features only available with version 8 and later? I'd prefer not upgrading the database for the moment, and would like to use XSLT functions in Postgresql. Thanks Philippe -- Sent via pgsql-general

[GENERAL] Role attribute for user email?

to add new attributes... Is that possible? Thanks, Philippe Lang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Start With... Connect By?

Hi, Now that Postgresql 8.4 has a "WITH RECURSIVE" operator (thanks! :)), is there a chance we can see one day "START WITH... CONNECT BY" in Postgresql, or is that something 100% oracle-specific? Best regards, Philippe Lang -- Sent via pgsql-general mailing list (pgsql-ge

Re: [GENERAL] Avoiding surrogate keys

web : http://www.attiksystem.ch Philippe Lang phone: +41 26 422 13 75 rte de la Fonderie 2 gsm : +41 79 351 49 94 1700 Fribourg pgp : http://keyserver.pgp.com > -Message d'origine- > De : pgsql-general-ow...@postgresql.org [mailto:pgsql-ge

[GENERAL] Sanity check on view

Thanks! ----- Attik System web : http://www.attiksystem.ch Philippe Lang phone: +41 26 422 13 75 rte de la Fonderie 2 gsm : +41 79 351 49 94 1700 Fribourg pgp : http://keyserver.pgp.com PGP.sig Description: PGP signature

[GENERAL] Non-reentrant plperlu function & concurrent access

web : http://www.attiksystem.ch Philippe Lang phone: +41 26 422 13 75 rte de la Fonderie 2 gsm : +41 79 351 49 94 1700 Fribourg pgp : http://keyserver.pgp.com PGP.sig Description: PGP signature

Re: [GENERAL] Non-reentrant plperlu function & concurrent access

. Maybe Postgresql functions "pg_try_advisory_lock_shared" and "pg_advisory_unlock_shared" are the solution? ----- Attik System web : http://www.attiksystem.ch Philippe Lang phone: +41 26 422 13 75 rte

[GENERAL] Dependency tracking tool

ist maybe? Best regards, Philippe --- Philippe Lang Web: www.attiksystem.ch Attik SystemEmail : philippe.l...@attiksystem.ch rte de la Fonderie 2Phone : +41 26 422 13 75 1700 Fribourg

Re: [GENERAL] Dependency tracking tool

more than a simple pattern search inside the function definition in order to be distinguished... Best regards, --- Philippe Lang Web: www.attiksystem.ch Attik SystemEmail : philippe.l...@attiksystem.ch rte d

[GENERAL] Index on immutable function call

ons of Postgresql 8.3.7. Best regards, --- Philippe Lang Web: www.attiksystem.ch Attik SystemEmail : philippe.l...@attiksystem.ch rte de la Fonderie 2Phone :

Re: [GENERAL] Index on immutable function call

data2)) Total runtime: 5513.676 ms - --- Philippe Lang Web: www.attiksystem.ch Attik SystemEmail : philippe.l...@attiksystem.ch rte de la Fonderie 2

Re: [GENERAL] Index on immutable function call

creating a slighly more "generic" index? If I change the ">" with a "<" in the query, index cannot of course be used. According to documentation, answer seems to be "no"... Thanks, and best regards. --

Re: [GENERAL] Index on immutable function call

Seq Scan on indexed_table (cost=0.00..26791.00 rows=3 width=12) (actual time=0.327..5805.199 rows=49959 loops=1) Filter: (data1 > this_is_a_long_transformation(data2)) Total runtime: 6340.772 ms --- --

Re: [GENERAL] Index on immutable function call

pgsql-general-ow...@postgresql.org wrote: > In response to Philippe Lang : >> >> My goal is to make query... >> >> select * from indexed_table WHERE data1 > >> this_is_a_long_transformation(data2); >> >> ... as fast as >> >> sele

Re: [GENERAL] Index on immutable function call

pgsql-general-ow...@postgresql.org wrote: > In response to Philippe Lang : >> >> My goal is to make query... >> >> select * from indexed_table WHERE data1 > >> this_is_a_long_transformation(data2); >> >> ... as fast as >> >> sele

Re: [GENERAL] Index on immutable function call

=7.339..7.339 rows=50101 loops=1)" "Total runtime: 459.657 ms" -- I guess it's because the partial index is smaller? --- Philippe Lang Web: www.attiksystem.ch Attik System

Re: [GENERAL] Index on immutable function call

pgsql-general-ow...@postgresql.org wrote: > On Tue, Jan 19, 2010 at 07:40:00AM +0100, Philippe Lang wrote: >> I'm trying to figure out how to use an index on an immutable function >> call in order to speed up queries. > [..] >> Unfortunately, Postgreql does not use t

[GENERAL] Convert string to UNICODE & migration FROM 7.4 to 9.1

be handled properly, and I'm unable to find out how to change that. UTF8 encoding is not good either. Any idea how to correct that? Thanks! Philippe - Attik System web: http://www.attiksystem.ch Philippe Lang

[GENERAL] Killing an offending process without restarting Postgresql safe?

r is it a good thing to restart the server in such cases? Best regards, Philippe Lang -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] tablelog

ning died short after. So I ask for removal of this (buggy) package." Is anyone using it with Postgresql 8.3? Or is there an alternative to this? While we are talking about this, is a development like Oracle "Flashback queries" planned maybe? -- Philippe Lang A

[GENERAL] Query 4-5 times slower after ANALYZE

this slowdown after the ANALYZE? Best regards, --- Philippe Lang Attik Syste, - Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Query 4-5 times slower after ANALYZE

pgsql-general-ow...@postgresql.org wrote: > In response to "Philippe Lang" : >> >> I'm using Postgresql 8.3.6 under Freebsd 7.1. >> >> After a fresh restore of a customer dump (running version 8.2.7 at >> the moment), a rather big query executes

[GENERAL] PL/PERL with composite return values & PGSQL 7.4?

Hi, Documentation mentions that PGSQL 8 supports a version of PL/PERL with composite return values. Is there a way to install this new version of PL/PERL on an old 7.4 database, or is it absolutely necessary to upgrade? Thanks Philippe Lang ---(end of broadcast

[GENERAL] PL/PERL: raise notice, exception ?

Hi, Is there in PL/PERL, under PG 8.01, an equivalent for the "raise notice, exception" commands of PL/PGSQL? Philippe ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] Adventures in Quest for GUI RAD

Hi, I'm testing Delphi 2005 at the moment, with ZEOS Lib (libpq), and I have to say it work fine, as Tony mentioned. I have a few questions: 1) I'm curious: are there a lot of big projects using ZEOS with PG or is that technology still relatively new? I would like to use it a replacement for OD

[GENERAL] Delphi 2005, Postgresql, ZEOS & optimistic locking

sfully moved their (production) database successfully to Postgres 8.0. Regards, Arthur On 5/9/05, Philippe Lang <[EMAIL PROTECTED]> wrote: > Hi, > > I'm testing Delphi 2005 at the moment, with ZEOS Lib (libpq), and I have to > say it work fine, as Tony mentioned. I ha

Re: [GENERAL] MS-Access and Stored procedures

_disponible_semaineError: MsgBox "Error in charge_disponible_semaine." Resume charge_disponible_semaineExit End Function I hope this helps. One or two utility function are needed: Public Function global_dsn_name() As String global_dsn_name = "you_dsn_

Re: [GENERAL] Delphi 2005, Postgresql, ZEOS & optimistic locking

sonnally. Is there a way to do the same with ZEOS? Or maybe is there another mecanism that could be used to do optimistic locking? Some kind of "long transactions", in the database server? Philippe Lang -Message d'origine- De : Tony Caduto [mailto:[EMAIL PROTECTED] En

Re: [GENERAL] Delphi 2005, Postgresql, ZEOS & optimistic locking

h a MS SQL Database, though. I'll try doing something similar in a Delphi event-handler. Thanks, bye Philippe -Message d'origine- De : Tony Caduto [mailto:[EMAIL PROTECTED] Envoyé : jeudi, 12. mai 2005 21:07 À : Philippe Lang Cc : pgsql-general@postgresql.org Objet : Re: [

Re: [GENERAL] MS-Access and Stored procedures

ng DAO/ADO, I suggest you have a look a performances. The fastest way for me to call PG functions was to use DAO, which is a bit obsolete, I agree. But there was an initial overhead with ADO that made me use DAO instead. Since I put all the logic on the server, this is only "glue code"

[GENERAL] Postgresql .NET Data Provider for Visual Studio 2005 beta

Hi, Does anyone successfully use a .Net Data provider for Postgresql? I was able to find two of them: - npsgsql open-source driver - crlab provider (which does not install correctly for me) Any recommendation? Thanks -- Philippe Lang

Re: [GENERAL] Postgresql .NET Data Provider for Visual Studio 2005

2005 15:27 À : 'PgSql General' Objet : Re: [GENERAL] Postgresql .NET Data Provider for Visual Studio 2005 I have been using the npgsql driver on both .NET and Mono for over 6 months now with no problems. Howard Cole www.selestial.com Philippe Lang wrote: >Does anyone successful

[GENERAL] Visual Studio 2005 .Net -> Npgsql -> Postgresql

Hi, I'v been playing with Visual Studio 2005 beta 2 recently. I'm evaluating it as a RAD tool for developing GUI front-ends to Postgresql. RAD means for me something similar to Delphi: you configure a database connexion, drop a few objects on a form, controls, you bind the controls to the datasou

MD5 computation (was: RE: [GENERAL] For Tom Lane)

Hi, What is the best way to calculate an MD5 Sum for a set of rows in a table, on a Postgresql server? -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] De la part de Scott Marlowe Envoyé : mardi, 31. mai 2005 18:37 À : [EMAIL PROTECTED] Cc : pgsql-general Objet : Re:

[GENERAL] Trigger disactivation and SELECT WAITING

e end. (At least in 7.4.X database, this is the only solution, right?) Running "ps -afxu" show that the process that tries to insert data gets stuck in the "SELECT WAITING" state. Is there a solution to this? Thanks! ------ P

Re: [GENERAL] Trigger disactivation and SELECT WAITING

to be calculated), the insert function gets stuck in a SELECT WAITING state. So insertions are impossible in the database when views are being calculated. Regards, -Message d'origine- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : mardi, 26. juillet 2005 15:14 À : Philippe Lang Cc : pgs

Re: [GENERAL] Trigger disactivation and SELECT WAITING

this case, and make it smarter, so I don't have to disable it during duplication... I hope I was clear... Philippe -Message d'origine- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : mardi, 26. juillet 2005 19:57 À : Philippe Lang Cc : pgsql-general@postgresql.org Objet :

[GENERAL] PG 8.1 on Dual XEON with FreeBSD 6.0

to change that, and accelerate long queries (which are all CPU-bound) in giving them more processing time, like a full XEON? Both XEONS? Should I disable Hyperthreading for that? Thanks, -- Philippe Lang Attik System rte de la Fonderie 2 1700 Fribourg Switze

[GENERAL] XEON familiy 5000, 5100 or 5300?

processors, but can it be spread over multiple cores? If that's true, does that mean the best CPU would be the last one, although the clock is lower that the one of the other processors? Thanks for the infos, Cheers, --- Philippe Lang Attik System

Re: [GENERAL] XEON familiy 5000, 5100 or 5300?

Shane wrote: > No - a *core* is another cpu, basically you will have 2 or 4 cpu's in > the one physical package. > > HT creates 2 virtual cpu's sharing the same cpu resources but the > cores are seperate cpu's in themselves. > > The Quad-core will only benefit you more if you have more users >

[GENERAL] Postgresql 8.1: plperl code works with LATIN1, fails with UTF8

06) . " / " . ($vtxd - 106); } else { # Vantaux symétriques for ($j = 0; ($fab->{rows}[$j]->{'article'} ne 'Largeur de vantail') and ($j < $fab_nrows); $j = $j + 1) {}; if ($j < $fab_nrows) { $output{'vide_interieur'} = $fab->{rows}[$j]->{'larg'} - 106; } else { $output{'vide_interieur'} = ''; }; } # Type de volet $output{'typ'} = $lignes->{rows}[$lignes_rn]->{'typ'}; # Sortie &$ret(@_); } # #-- Fin de la fonction # &$end_sub(@_); $$ LANGUAGE 'plperl' VOLATILE; # When running: - select * from volets_fiche_fab_1(1) Database replies: - ERROR: error from Perl function: invalid input syntax for integer: "" at line 54. SQL state: XX000 Does anyone have a small idea where to search? Thanks Philippe Lang ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Postgresql 8.1: plperl code works with LATIN1, fails with UTF8

[EMAIL PROTECTED] wrote: > If you can't upgrade to 8.2 then you might be able to work around the > problem by creating the function as plperlu and adding 'use utf8;'. After upgrading to 8.2.1, everything runs just fine. Thanks a lot for your help, Re

[GENERAL] FKs and deadlocks

Hello, As the amount of simultaneous users of my database grows (25 users sometimes, PGSQL 7.4.5), deadlocks are unfortunately more and more frequent. I guess this is due to the FKs problem with Postgresql. I have tried to correct that by adding a "SET CONSTRAINTS ALL DEFERRED" in every trigger a

Re: [GENERAL] FKs and deadlocks

a look at the the pg_class table, and found a relfilenode with OID 33044, the OID mentionned in the locks. This refers to a table that has 4 FKs and 5 triggers. It's one of the cental tables in the database. Any idea how I could dig further? Philippe Lang -Message d'origine---

Re: [GENERAL] FKs and deadlocks

be the reason? Philippe -Message d'origine- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : lundi, 25. octobre 2004 16:16 À : Philippe Lang Cc : [EMAIL PROTECTED] Objet : Re: [GENERAL] FKs and deadlocks "Philippe Lang" <[EMAIL PROTECTED]> writes: > I got a deadlock i

Re: [GENERAL] ms access app ?

False Exit Function End If DoesTblExist = True End Function 4) your_global_dsn_name refers to your DNS project name With the table tblODBCDataSources, you can choose the local table name. I hope this helps. Philippe Lang -Message d'origine- De : [EMAIL PR

[GENERAL] PL/Ruby, INOUT parameters / SETOF record

s apprently the only documentation, and I find it quite hard to do the translation. Thanks! -- Philippe Lang, Ing. Dipl. EPFL Attik System rte de la Fonderie 2 1700 Fribourg Switzerland http://www.attiksystem.ch Tel: +41 (26) 422 13 75 Fax: +41 (26) 422 13 7

[GENERAL] Which RPM for RH Linux ES 4? PGDB or RH?

best to do? Thanks, ------ Philippe Lang, Ing. Dipl. EPFL Attik System rte de la Fonderie 2 1700 Fribourg Switzerland http://www.attiksystem.ch Tel: +41 (26) 422 13 75 Fax: +41 (26) 422 13 76 smime.p7s Description: S/MIME cryptographic signature

Re: [GENERAL] Which RPM for RH Linux ES 4? PGDB or RH?

ight, it's time maybe to try migrating from Postgresql 7 to 8. I'll try that... Thanks Philippe -Message d'origine- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : mercredi, 31. mai 2006 05:42 À : Philippe Lang Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] Which

[GENERAL] Problems posting messages in this mailing-list?

Hi, I'm desperately trying to post a message to this mailing-list since 10 o'clock this morning, although everything worked fine yesterday. I get no error indicated my message is rejected, but nothing appears in the list. Can anyone read this message? -

Re: [GENERAL] Problems posting messages in this mailing-list?

nvoyé : mercredi, 31. mai 2006 13:43 À : Philippe Lang; pgsql-general@postgresql.org Objet : RE: [GENERAL] Problems posting messages in this mailing-list? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Philippe Lang > Sent: 31 May 2006

[GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

Hi, For an unknown reason, I cannot post this message to the mailing-list! Here it is: http://www.attiksystem.ch/postgresql-general.txt Cheers, Philippe Lang smime.p7s Description: S/MIME cryptographic signature

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

52 À : Philippe Lang Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem Hi : Maybe you forget to run the "ANALYZE" command afterwards. ludwig. --- Philippe Lang <[EMAIL PROTECTED]> wrote: > Hi, > > For an un

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

credi, 31. mai 2006 16:13 À : Philippe Lang Cc : pgsql-general@postgresql.org Objet : Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem Hi: How about the postgresql.conf settings? Did you changed them? ludwig. --- Philippe Lang <[EMAIL PROTECTED]> wrote: > Hi, &

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

, has not been specifically tuned. I did recompile a kernel with a few things inside, but really, I did not spend hours on that two years ago. Thanks, Philippe -Message d'origine- De : Tom Lane [mailto:[EMAIL PROTECTED] Envoyé : mercredi, 31. mai 2006 16:39 À : Philippe Lang Cc :

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

de? I get only 20 % improvements with the new server with Linux, compared to the workstation with freebsd... Maybe my query is so CPU-bound that the most important thing is the CPU clock speed, and in both cases I have a single 3Ghz CPU to run the query? What do you think? Philippe -

Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem

rnaud Lesauvage Envoyé : mercredi, 31. mai 2006 16:20 À : pgsql-general@postgresql.org Objet : Re: [GENERAL] PGSQL 7.4 -> 8.1 migration & performance problem Philippe Lang a écrit : > Hardware is much more powerful: intel server motherboard, dual-xeon > 3GHz, SCSI disks (raid 1), 4GB RAM

[GENERAL] pgxml & xpath_table

val3 1 C1 L1 1 2 3 1 L2 11 22 33 I was expecting doc_num would receive twice the C1 value, just like with a normal sql join. Regards, -- Philippe Lang, Ing. Dipl. EPFL Attik Syste

[GENERAL] Set-returning function returning a set-returning function?

RD; BEGIN for rec in select * from srf_perl(1,2) loop return next rec; end loop; return; END; $$ LANGUAGE 'plpgsql' VOLATILE; -- I always get the following error: ERROR: a column definition list is required for functions returning "r

[GENERAL] cpan perl module - plperlu danger?

exactly is the danger using a cpan library under plperlu? How can I make sure it won't crash my system, even when run concurrently by a few people? Thanks! -- Philippe Lang, Ing. Dipl. EPFL Attik System rte de la Fonderie 2 1700 Fribourg Switzerland

[GENERAL] Plperl and my() lexical variables bug?

90 ms. Data retrieval runtime: 797 ms. 1 rows retrieved. Am I missing something maybe? It sounds like a bug with lexical variables to me... Cheers, -- Philippe Lang, Ing. Dipl. EPFL Attik System rte de la Fonderie 2 1700 Fribourg Switzerland htt

[GENERAL] Dynamic technical graphics generation inside plperl query?

Hi, Is there a way to use a graphics drawing library (like GD for example) inside a plperl function, and "stream" the result image (bytea column?) without storing anything to the disk or database? Has anyone done that before? Thanks, --- Philippe Lang Attik System

[GENERAL] Plperl return_next and bytea binary data?

outfile.gif") || die 'Cannot open output file'; binmode MYOUTFILE; print MYOUTFILE $im->gif(); close MYOUTFILE; I tried, and it works... Is there a trick in order to force binary mode with return_next too? Thanks for your help!

Re: [GENERAL] Plperl return_next and bytea binary data?

Martijn van Oosterhout wrote: > On Mon, Jul 24, 2006 at 11:43:39AM +0200, Philippe Lang wrote: >> The problem seems to come from the return_next, in conjunction with >> binary data: >> >> >> return_next >> (

Re: [GENERAL] Plperl return_next and bytea binary data?

[EMAIL PROTECTED] wrote: > Martijn van Oosterhout wrote: > >> On Mon, Jul 24, 2006 at 11:43:39AM +0200, Philippe Lang wrote: >>> The problem seems to come from the return_next, in conjunction with >>> binary data: >>> >>>

Re: [GENERAL] Plperl return_next and bytea binary data?

Alvaro Herrera wrote: > Philippe Lang wrote: > >> Juste one more question: what is the maximum size of a TEXT column in >> PG 8.1.4? > > A handful of bytes less than 1 GB. It should be ok then... :) --- Philippe Lang Attik System smime.p7s Descripti

[GENERAL] Intel commercial compiler

Hi, http://www.enterprisedb.com mentions they compile postgresql with the Intel commercial compiler, for optimal performances: http://www.intel.com/cd/software/products/asmo-na/eng/compilers/284132.htm Has anyone done comparison tests with a normal gcc compilation? --- Philippe

Re: [GENERAL] Migrating PostgreSQL database to MySQL/MS Access

[EMAIL PROTECTED] wrote: > How can I migrate a PostgreSQL database to MySQL or MS > Access? Are there any tools available? Hi, Can we know maybe why you want to do this? --- Philippe Lang Attik System smime.p7s Description: S/MIME cryptographic signature

[GENERAL] Plperl functions with OUT parameters crashing each other when used in the same connection

;article'} =~ /^(Montant|Traverse|Palette|Panneau|Baguette|Couvre-joint)/) && ($fab->{rows}[$j]->{'t'} eq 'E')) { $output{'pos'} = $lignes->{rows}[$lignes_rn]->{'pos'}; $output{'

Re: [GENERAL] Plperl functions with OUT parameters crashing each other when used in the same connection

value) = each %output) {if (!defined($value)) {elog(ERROR, 'Valeur indéfinie pour ' . $key)}}; return_next \%output; init(@_); } $$ LANGUAGE 'plperl' VOLATILE; -- FUNCTION TESTS select * from foo1(45,10); select * from foo2('45','10'); --- Philippe Lang Attik System smime.p7s Description: S/MIME cryptographic signature

Re: [GENERAL] Plperl functions with OUT parameters crashing each other when used in the same connection

Tom Lane wrote: > "Philippe Lang" <[EMAIL PROTECTED]> writes: >> Here is a reduced example that shows the problem. > > Hm, I'm no Perl guru, but isn't the second script to be > loaded going to redefine those subroutines that the first > scrip

Re: [GENERAL] Plperl functions with OUT parameters crashing each other when used in the same connection

[EMAIL PROTECTED] wrote: > Tom Lane wrote: >> "Philippe Lang" <[EMAIL PROTECTED]> writes: >>> Here is a reduced example that shows the problem. >> >> Hm, I'm no Perl guru, but isn't the second script to be loaded going >> to

Re: [GENERAL] Shell access & send email from PLPGSQL?

! Except this, that's fine. Thanks. - Philippe Lang Attik System http://www.attiksystem.ch -Message d'origine- De : Pavel Stehule [mailto:[EMAIL PROTECTED] Envoyé : mardi, 9. décembre 2003 11:33 À : Philippe Lang Cc : [EMAIL PROTECTED] Objet : Re: [GENE

[GENERAL] Idle connections - Too many clients connected already

Hello, After using Postgresql for a while, through ODBC / MS Access, I'm not able to connect to the server anymore. The server reports "Too many clients connected already". With a "ps -afx", I can see a lot of idle postgresql connections, which correspond for sure to ODBC connections that haven't

[GENERAL] DROP TRIGGER permission

again (after locking the tables for which I drop triggers), but unfortunately this not possible with a different user login, since they are not the owner of the table. What could I do in this situation? Thanks Philippe Lang ---(end of broadcast)--- TIP

Re: [GENERAL] RAD with postgreSQL

ed to "client-server fat client". Philippe Lang ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] Postgresql <--> webservices?

Hello, Does anyone have experience in interfacing a Postgresql database (tables? plpgsql functions? perl functions?) with the outside world through webservices? (XML-RPC, SOAP, UDDI, WSDL...) Philippe ---(end of broadcast)--- TIP 3: if posting/read

[GENERAL] Dynamic expression evaluation

Hello, Imagine we have the following kind of table, with two values (a and b), and a varchar (f) representing an expression. -- CREATE TABLE public.test ( id serial NOT NULL, a int4, b int4, f varchar(50), CONSTRAINT id PRIMARY KEY (id) ) WITHOUT OIDS;

[GENERAL] Restore-point?

Hello, Is it possible to restore a database previously backed-up with "dump", and then recover some of the changes made after the backup, until a specific timestamp, by using some sort of "journal"? Is there such a feature in Postgresql? Thanks -----

[GENERAL] Shell access & send email from PLPGSQL?

Hello, How can open a unix shell from a PLPGSQL function / trigger? I would like to send an email from a postgres database, and also send some unix commands to the server, through the database... Thanks - Philippe Lang Attik System http://www.attiksystem.ch