I might get better results getting a
> referral than by contacting $random_legal_service.
>
I would try posting your question on one of the mailing lists at the OSI first
(probably License-discuss?)
http://opensource.org/lists
--
Salutations, Vincent Veyron
ht
# su - postgres
$ psql
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
X and channel = Y'
-run a cron job once a day that
-runs 'select * from B where checked = false' and stores results
somewhere
-resets B with 'update B set checked = false'
--
Salutations, Vincent Veyron
not so much performance optimization as query simplification, but
I agree it adds a maintenance problem.
I never heard of problems with cron not running though, is this really a
concern?
--
Salutations, Vincent Veyron
https://legalcase.libremen.com/
ocuments,
such as client_name, client_address, facturation_date, etc)
-zip the archive anew with a .docx extension
Voilà.
The code is about 40 lines long, I can post it if you care; the same process
also works with Libre/OpenOffice documents
--
Salu
ure : open any file (those are legal files/insurance claims), click on
the 'Contributors' tab (third tab from left; add a contributor if none is
present), and click on 'Templates'. Click on the template to generate a document
--
Salu
'exp?diteur ne renonce pas aux droits
> et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de
> ce message ou des renseignements qu'il contient par une personne autre que le
> (les) destinataire(s) d?sign?(s) est interdite. Si vous recevez ce courriel
>
.@gmail.com
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.pos
n.
I've been doing it almost every day for years, still learning every time.
--
Salutations, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql
ql.org/message-id/CANu8FixZ=-o3nybdma5pxjsyzxqy1n0t4kekg0-1kkvs7fe...@mail.gmail.com
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
--
Sent via pgsql-g
e year:
/var/backups/marica/marica.gz {
weekly
missingok
rotate 52
notifempty
}
And here is a naive bash script to send a dump file to a remote server; it's
launched by cron:
http://pastebin.com/Xg4wXdjy
--
Salutatio
te_debut_garantie AND
t1.date_fin_garantie AND t3.id_dossier = $1
6 $function$
--
Bien à vous, Vincent Veyron
https://legalcase.libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-g
news-spur.riddles.org.uk
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
not humanly noticeable as the tables are not huge.
I can resort to a denormalized field holding the value of id_contrat. I was
trying to avoid that, hence the calculated index, but it appears not to be much
better.
--
Bien à vous, Vincent Veyron
in case, I got this error when trying to use a
cluster copied from one machine to another one because they had different
processors.
It worked after I used a machine with the same processor.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestio
e_1 UNIQUE (product_id, tax_code_id));
Just a few lines less, but I find it pays in the long run for
development/maintenance purposes.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des sinistres assurances, des dossiers contentieux et des contrats p
#x27;t see how granting him TRUNCATE
makes that much of a difference? Same could be said of the other two, it's not
like they are going to cause more damage than the previous rights.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des conten
ER are schema changes which should never be done by
> a normal user.
Sure. I was thinking of the data changes.
Thanks.
--
Bien à vous, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
correlated to the appropriateness of the database
design (meaning that the better the database structure, the lesser code is
needed).
Knowing about the many fine functions Postgresql offers also helps, of course.
--
Bien à vous, Vincent Veyron
ht
t I
never tried them.
>
> > A pointer to a detailed tutorial would be great.
Read the doc, more.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ta. In your case maybe this could help :
http://ant.apache.org/antlibs/dotnet/
Can't help you more, as I only do Perl.
There is a learning curve, but you'll gain *a lot* of power.
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance
ints on the
destination table. However, it will not invoke rules.
http://www.postgresql.org/docs/9.0/static/sql-copy.html
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing list
part of an UNION. The use of the CASE WHEN
> could be an alternative?
>
SELECT 'tbl1',last_refresh_date FROM tbl1 UNION SELECT 'tbl2',
last_refresh_date FROM tbl2 UNION SELECT 'tbl3', last_refresh_date FROM
tbl3 ORDER BY 1 DESC;
--
Vincent Veyron
http://
Le jeudi 09 décembre 2010 à 03:58 +0100, Vincent Veyron a écrit :
>
> SELECT 'tbl1',last_refresh_date FROM tbl1 UNION SELECT 'tbl2',
> last_refresh_date FROM tbl2 UNION SELECT 'tbl3', last_refresh_date FROM
> tbl3 ORDER BY 1 DESC;
>
Argh... make t
[sent you a personal email by mistake - slightly corrected query posted
to the list]
Le dimanche 12 décembre 2010 à 10:55 -0500, Daniel Popowich a écrit :
> Hello all!
>
> I need to do moving averages over time series data and was hoping
> window functions could solve the problem for me, but it d
one line to process with all the information . So, from your
example :
create table logtable(
id_vehicle text,
date_purchased date,
voltage integer,
rpm integer);
the corresponding record being
vehicle123, now(), 13, 600
this will simplify your queries/code _a lot_. You can keep subclasses
for de
your vehicle table. You can
then have un unlimited number of records (again, each record having a
column for each of the parameters/characteristics measured) .
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
-
EW.stop_date,NEW.value);
Then have your app check if the new record went into bad, for instance.
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
EW.stop_date,NEW.value);
Then have your app check if the new record went into bad, for instance.
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n
> Windows and *ix).
I'm partial to Emacs, but I'm surprised nobody mentionned Abiword :
http://www.abisource.com/
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general maili
Le jeudi 30 décembre 2010 à 12:05 -0500, Andrew Sullivan a écrit :
[about Abiword]
> It's intended as a word processor rather than a text
> editor, isn't it?
It works with text files too. It's not a problem.
--
Vincent Veyron
http://marica.fr/
Progiciel de gestion des do
sts.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
v1.pdf
>
> regards,
> Yeb Havinga
>
Relational Databases and Knowledge Bases by Georges Gardarin has served
me well. It's 20 years old, but the rules still apply. Very clear and
thorough.
I haven't checked the English version.
--
Vincent Veyron
http://marica.fr/
Logi
5.nabble.com/Basic-Tutorials-for-9-0-td3259760.html
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
ent disks, and faster ones are needed.
Some study material here :
http://wiki.postgresql.org/wiki/Performance_Optimization
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing
27;s for 15 euros/month.
I built the machine myself with Debian, so I can't tell what their
support is like.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des dossiers de contentieux et d'assurance pour le service
juridique
--
Sent via pgsql-general mailing list (pgsq
want to avoid it.
>
I have no personal experience with this, but citing an answer to a
similar question by Vibhor Kumar from a couple days ago :
use following command:
ALTER TABLE DISABLE TRIGGER [ trigger_name | ALL | USER ]
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinis
etable.html#SQL-CREATETABLE-STORAGE-PARAMETERS
--
Regards, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
gne)
vv=>
vv=> select 'found sofia', name
vv-> from name_fulltext
vv-> where searchable_index_col@@to_tsquery('finnish','sofia:*');
?column? | name
-+---
found sofia | Sofia
(1 ligne)
--
Regards, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
all sorts of extensions (docx, xlxs, pdf...), it works very well.
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et des contrats
pour le service juridique
--
Sent via pgsql-general mai
e of new files just as
fast.
--
Salutations, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
, you'll have to study their
documentation/lists
--
Salutations, Vincent Veyron
https://libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
ce :
if a code value changes or is added/deleted, your python script needs updating.
SQL queries will also be a lot more complicated (union select on various
tables) and harder to optimize. Maintaining the coherence between the script
and the tables will get harder and harder.
--
uro'" litigios
#load the data (here a latin9 encoded pg_dump)
export PGCLIENTENCODING=LATIN9;
psql -f /path/to/dump/file litigios
--
Salutations, Vincent Veyron
https://marica.fr/
Gestion des contentieux, des dossiers de sinistres assurance et d
... INNER JOIN t1 using (grouping_field)
'Partition by grouping_field' may or may not be necessary in your case,
depending on what you want; see :
http://www.postgresql.org/docs/current/static/tutorial-window.html
--
Vincent Veyron
http://marica.fr
Logiciel pour département juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
have no formal training in server
administration. Debian stable certainly works.
--
Salutations, Vincent Veyron
http://gdlc.fr/logiciels
Applications de gestion des sinistres assurances et des contentieux
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make c
e I try to find a way out of the 'big corporation
only talking to the big corporation' paradigm.
(* : typically a linux nerd, with long hair, a beard and shorts, who
knows his stuff; not a corporate drone)
--
Salutations, Vincent Veyron
http://gdlc.fr/logiciels
Applications de gestion des
Le mardi 15 janvier 2013 à 12:54 +0100, Daniel Verite a écrit :
> Vincent Veyron wrote:
>
> >
> > > On Debian/Ubuntu, the default behavior is to have SSL enabled out
> > > of the box, including for TCP connections to localhost.
> >
> > It is i
Le mardi 15 janvier 2013 à 07:52 -0700, Scott Marlowe a écrit :
> On Tue, Jan 15, 2013 at 4:54 AM, Vincent Veyron wrote:
> > Le lundi 14 janvier 2013 à 16:35 -0600, Shaun Thomas a écrit :
> >
> >> My personal server is on Debian too, with a similar uptime. But we
> &g
etween RHEL, CentOS, and
> Ubuntu LTS, so I was wondering what everyone else thought.
>
A few interesting comments for you in this discussion, maybe :
http://linux.slashdot.org/story/13/01/17/160249/centos-59-released
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstratio
cess and privileges. I am free to discuss options in case you
> > already have a known solution that we can implement.
> >
Braintree uses Postgresql :
https://www.braintreepayments.com/braintrust/scaling-postgresql-at-braintree-four-years-of-evolution
--
Salutations, Vincent
> into the recipe. Actual runtime with about a million entries in tab1 and 800
> entries in tab2
> is about 40 seconds.
>
> Regards
> Wolfgang Hamann
>
>
>
>
>
>
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Logiciel de gestio
function computed?
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Logiciel de gestion des contentieux juridiques et des sinistres d'assurance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgre
Le jeudi 31 janvier 2013 à 11:06 +0100, Pavel Stehule a écrit :
> 2013/1/31 Vincent Veyron :
> >
> > Suppose I have a query of the form
> >
> > SELECT my_function(column_1), column_2
> > FROM my_table
> > GROUP BY my_function(column_1)
> > ORDER BY my_
> # insert into my_table (column1, column2) values ('value', 'key_value');
>
You might want to have a look at this page :
http://www.depesz.com/2012/06/10/why-is-upsert-so-complicated/
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Logiciel de
he last 2628 messages from the list, I
counted 70 posts without a follow-up; so 3% really
Also, seeing Tom Lane as a first poster seems rather strange; it's
certainly not the case in 'general'
?
--
Salutations, Vincent Veyron
http://gdlc.fr/logiciels
Applications de gestion d
Le lundi 11 février 2013 à 17:20 +0100, Vincent Veyron a écrit :
> Le lundi 11 février 2013 à 08:03 -0600, Merlin Moncure a écrit :
> > http://citusdata.com/blog/57-postgresql-full-text-search
> >
>
> I find it strange that
>
> 'Probability that a new thread g
field) = @_;
(where $data is a reference to %data)
...
}
and call it with
my $value = $get_value->(\%data, $1, $2, $3);
instead of
my $value = $get_value->($1, $2, $3);
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Progiciel de gestion des sinistres assurance et des
er and
> slaves.
>
>
> How do you guys go about designing such cluster.
>
There is this :
http://wiki.postgresql.org/wiki/Postgres-XC
[Disclaimer : I can't tell whether it's usable or not; I just know they
exist]
--
Salutations, Vincent Veyron
http://marica.fr/sit
ike having a machine in your facility, only better
protected. I use several of those for redundancy.
Is there something I'm missing?
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Logiciel de gestion des contentieux juridiques et des sinistres d'assurance
--
Se
o Windows, but this should get you
started :
http://www.postgresql.org/docs/9.2/interactive/install-windows.html
--
Salutations, Vincent Veyron
http://vincentveyron.com
Logiciels de gestion des sinistres assurance et des contentieux pour le service
juridique
--
Sent via pgsql-general maili
g for materialized views would be better off
simply using a proprer data structure (and taking a few SQL courses).
Am I misguided?
--
Salutations, Vincent Veyron
http://gdlc.fr/logiciels
Applications de gestion des sinistres assurance et des contentieux juridiques
--
Sent via pgsql-general m
Unix, you could do this :
pg_dump -f mess.out mess
sed -i 's/OWNER TO postgres/OWNER TO proper_username/' mess.out
createdb clean
psql -f mess.out clean
You'll also want to modify the REVOKE ALL ON SCHEMA/GRANT ALL ON SCHEMA
that are at the end of the dump file
--
Salutations
"criteria")
>
UPDATE tbl1
SET col3=t2.col3, col4=t2.col4, col5=t2.col5
FROM tbl2 t2 WHERE t2.col1="criteria"
--
Salutations, Vincent Veyron
http://gdlc.fr/logiciels
Applications de gestion des sinistres assurance et des contentieux juridiques
--
Sent via pgsql-gene
7001, extension is pdf, path is : your/directory/7001.doc
Write the file's data to disk, obviously using the same name for the
file as in the link, once the user clicks on the link, using the
on_click event : file will be served to the user.
--
Salutations, Vincent Veyron
http://marica.fr/
d be more an access issue but I'm quite newbie...
Search google groups' archives of comp.databases.ms-access for blob +
write + disk
Blob means binary large object, the equivalent of bytea, you'll find
some code samples.
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion de
cing the problem with 9.1 on a stock Debian Squeeze
machine using backports. On this machine, accented characters would
appear garbled, but update queries were possible.
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contrats, des contentieux juridiques et des sinistres
d'assu
I forgot to mention that the machines use an amd64 processor.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in my
ssh sessions. I'll look again and open another thread if needed, as
Alban suggested.
Thank you.
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contrats, des contentieux juridiques et des sinistres
d'assurance
--
Sent via pgsql-general mailing list (pgsql-general
;
>
You could put a unique constraint on table_lock, or make (table_name,
row_id) the primary key; this would prevent the second user from locking
the same case and you can treat the exception in your code.
--
Salutations, Vincent Veyron
http://vincentveyron.com
Logiciels de gestion des sinistr
resql postgresql-client
I'm not sure if Kubuntu adds some overhead to the installation process.
You might want to try a regular debian install and add the KDE desktop
to it.
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Logiciel de gestion des contentieux juridiques et des
change your settings, then create the cluster.
I would stick with the standard 'apt-get install', unless you have a
reason not to.
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contrats, des contentieux juridiques et des sinistres
d'assurance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mon, 13 Feb 2017 09:52:05 +
Seref Arikan wrote:
> Many thanks for this.
>
+1
--
Bien à vous, Vincent Veyron
https://libremen.com
Logiciels de gestion, libres
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
T
a filter? If that is too
involved, I don't see how they can get involved in postgres anyway.
--
Bien à vous, Vincent Veyron
https://marica.fr
Logiciel de gestion des contentieux juridiques, des contrats et des sinistres
d'assurance
--
Sen
t but i'm not
> sure if it's open source.
>
Don't waste your time, there is one already :
https://www.reddit.com/r/PostgreSQL/
--
Bien à vous, Vincent Veyron
https://compta.libremen.com
Logiciel libre de comptabilité générale
its properties and
become permanently transparent after a while; the mug's look is not very
clean after that.
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contrats, des contentieux juridiques et des sinistres
d'assurance
--
Sent via pgsql-general mailing list (pgsql
the menu bar on
> the website, but with buzzwords associated with postgresql, like
> 'Transactional Data Integrity Extensible" or whatever.
Nice for professionals, but the simplicity of the OP's proposition makes
for a nice brand recognition, I find?
I would suggest
ype_2
So that the application knows which table to use?
But chances are the OP can't change his model easily.
--
Salutations, Vincent Veyron
http://marica.fr/
Gestion des contentieux juridiques, des sinistres d'assurance et des contrats
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
use that recordset (Excel, Access?)
A google search will return several discussions about this problem; here
is an example :
http://social.msdn.microsoft.com/Forums/en-US/32b64a3f-3e7a-4e02-a7ef-824cacfea57a/256-char-limit-on-ado-recordset-field
--
Salutations, Vincent Veyron
http://gdlc.fr/logiciels
A
hat html is extremely well suited to the display of tabular
data, so I'm curious to know what kind of client-side problems you
experience with standard-compliant web forms?
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Gestion des contentieux et des dossiers de sinistres ass
se)
Also, I would think most data in the form _should_ come from dropdowns
populated from the database, for obvious reasons of data integrity? It
certainly is the case in my apps.
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Gestion d
FROM t1)
SELECT t2.id, array_to_string(t2.reordered, '; ') FROM t2 GROUP BY id,
reordered;
Result :
id |array_to_string
+
1 | AUTO; BODY; CHROMOGENIC; ECD FORM; FORMAT; PREDILUTED; RABBIT
2 | AUTO; BODY; CHROMO-GENIC; ECD FORM; FORMAT; PREDILUTED;
n for myapp's backups
/var/backups/myapp/myapp.gz {
weekly
missingok
rotate 52
notifempty
}
--
Salutations, Vincent Veyron
http://marica.fr/site/demonstration
Gestion des contentieux juridiques, des contrats et des sini
US.iso885915
fr_FR@euro
fr_FR.iso885915@euro
POSIX
--
Salutations, Vincent Veyron
http://marica.fr
Gestion des contentieux juridiques, des contrats et des sinistres d'assurance
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) with the appropriate where clause on the date
field and group by clause.
--
Salutations, Vincent Veyron
Legal cases, contracts and insurance claims management
http://libremen.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Le dimanche 15 décembre 2013 à 10:57 -0500, Andrew Sullivan a écrit :
> I thought people'd like to know about this.
Potential submission material for HackerNews maybe? I'm not seeing it
there
https://news.ycombinator.com/news
--
Reg
Le dimanche 05 janvier 2014 à 19:32 -0800, gromitracer a écrit :
> Below are my roles/users and their attributes. Posgresql version: 9.2
>
>Role name |Attributes
>
> | Member of
> ---+-
docs/9.3/static/populate.html
--
Regards, Vincent Veyron
http://libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
On Fri, 28 Feb 2014 16:03:39 -0800 (PST)
Rich Shepard wrote:
> > And, I discovered 'jet-tool' on code.google.com. That'll do the job, I
> > believe.
>
>Well, it won't work: it's a M$ .exe file and the source is apparently in
> some M$-type of Pascal.
>
I've had success with mdbtools, but
http://www.databasefriends.co/2014/03/favorite-relational-database.html
--
http://litigios.libremen.com
Gestión de litigios y de expedientes de seguros de siniestros para el servicio
jurídico
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subsc
On Sun, 2 Mar 2014 15:28:31 +0100
Vincent Veyron wrote:
>
> http://www.databasefriends.co/2014/03/favorite-relational-database.html
>
I forgot to mention that this was posted on reddit :
http://www.reddit.com/r/programming/comments/1zc5aw/favorite_relational_database_poll_results/
trust
#vérifier que ça tourne
psql -V
#restore from dumpall
psql -f 8.4.out postgres
#run update-grub
#reboot
--
Regards, Vincent Veyron
http://libremen.com/
Legal case, contract and insurance claim management softw
> called TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
>
> PRIMARY KEY (id),
> FOREIGN KEY (user_id) REFERENCES my_users(id) ON DELETE CASCADE
> );
--
Salutations, Vincent Veyron
http://marica.fr
Gestion des contentieux juridique
all,
may be with a 'parent' field and recursive queries. You probably have many
requirements that I'm not aware of, but this one can be met)
--
Salutations, Vincent Veyron
http://marica.fr
Gestion des contentieux juridiques, des contrats e
> called TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
>
> PRIMARY KEY (id),
> FOREIGN KEY (user_id) REFERENCES my_users(id) ON DELETE CASCADE
> );
--
Regards, Vincent Veyron
http://libremen.com/
Legal case, contract and insuran
ble that would have a
> lot of null fields. For example answered_date would be null if the call was
> never answered.
>
Not a big problem I should say, unless you deal with really hude data.
--
Salutations, Vincent Veyron
http://marica.fr
Gestio
of reads and writes among concurrent serializable
transactions would create a situation which could not have occurred for any
serial (one-at-a-time) execution of those transactions, one of them will be
rolled back with a serialization_failure SQLSTATE.
--
Rega
of reads and writes among concurrent serializable
transactions would create a situation which could not have occurred for any
serial (one-at-a-time) execution of those transactions, one of them will be
rolled back with a serialization_failure SQLSTATE.
--
Rega
My apologies to all, I posted with the wrong id; reposting
--
Regards, Vincent Veyron
http://libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
add fields such as first_event_date, last_event_date,
duration...
> end_datetime can be NULL (open end).
>
Then the event is not recurring, it just keeps going; I would consider
that a special case.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des sinistres et des contentieux pour
1 - 100 of 162 matches
Mail list logo