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
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
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
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
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
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
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
#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
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
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)
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
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
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
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
.@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
'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
>
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
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
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/
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
# 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
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
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
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.
--
, 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
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
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
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
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
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
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
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
> 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
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
> );
--
Salutations, Vincent Veyron
http://marica.fr
Gestion des contentieux juridique
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
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/
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 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
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:
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
> ---+-
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
) 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)
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
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
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;
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
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
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
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
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
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
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
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
;
>
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
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
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
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
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
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/
"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
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
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
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
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
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
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
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
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
> # 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
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_
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
> 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
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
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
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
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
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
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
... 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
I ran out of disk space on the slave, because the archived WAL records were
> not removed. The documentation for archive_cleanup_command states[1]:
>
Hi,
I have no personal experience on the matter, but saw this recent post :
http://archives.postgresql.org/pgsql-general/2012-12/msg00129.php
whi
ECT foo.id::int, foo.nome::text
>FROM foo
> LOOP
> RETURN NEXT;
> END LOOP;
> RETURN;
> END;
> $pippo$ LANGUAGE plpgsql;
>
> Regards
>
> Pavel Stehule
>
> > Cosa sbaglio?
> >
> > Piviul
> >
> >
>
in context:
> http://postgresql.1045698.n5.nabble.com/Performance-Testing-Metrics-tp5732897.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des assurances sinistres et des dossiers contentieux po
>
>
> Ex2) Select type, avg_mytable (values) from mytable Group by type ;
>
>
>
> Type | avg_mytable (values)
>
> -
>
> 1| { 15, 15}
>
> 2 | { 30, 60}
>
>
>
>
>
installed on your system, use :
dpkg -l postgres*
(note : lower case 'l')
to list the files each installed package provides, use :
dpkg -L
e.g. : dpkg -L postgresql-client-8.4
(note : upper case 'L')
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des assu
Le jeudi 01 novembre 2012 à 10:21 -0500, Kevin Burton a écrit :
> Sudo -u postgres psql - now works!! Thank you. Now how do I add a role so
> that I don't have to use sudo?
>
http://www.postgresql.org/docs/9.1/static/app-createuser.html
--
Vincent Veyron
http://marica.f
st lead
me to a very suitable solution for a problem at hand within the next few
days of work : many hours were saved that way.
I could go on, but in short vital is the right word I'd say.
(I'll just mention that I am in constant awe at the level of expertise
dispensed in this particular
I am surprised none of the fine contributors to this thread mentionned
an activity they practice extensively, which is reading this list's
content every day.
Best training material ever in my opinion.
--
Vincent Veyron
http://marica.fr/
Logiciel de gestion des assurances sinistres e
Le mercredi 03 octobre 2012 à 22:15 -0500, Merlin Moncure a écrit :
> Really though, upgrading the database makes the most sense IMO. 8.4
> indicates that your customer is probably sticking with the rhel stock
> packaging
Could be Debian Stable too...
--
Vincent Veyron
http://
field_list .= ', ' . $_ . ' text';
}
my $create_table = 'CREATE TABLE crosstab (' . substr($field_list, 1) .
')';
my $action = spi_exec_query($create_table);
$$ LANGUAGE plperlu;
--
Vincent Veyron
http://marica.fr/
Gestion informatisée des d
c :
http://www.postgresql.org/docs/9.1/static/tablefunc.html
--
Vincent Veyron
http://marica.fr/
Gestion informatique des sinistres d'assurances et des dossiers contentieux
pour le service juridique
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subs
Le mercredi 29 août 2012 à 13:05 -0400, Moshe Jacobson a écrit :
> On Wed, Aug 29, 2012 at 12:11 PM, Vincent Veyron
> wrote:
> Le mercredi 29 août 2012 à 09:48 -0400, Moshe Jacobson a
> écrit :
>
> > Questions:
> > 1. If I
of the documentation for CREATE TABLE explains it :
http://www.postgresql.org/docs/9.1/static/sql-createtable.html
--
Vincent Veyron
http://marica.fr/
Gestion informatique des sinistres d'assurances et des dossiers contentieux
pour le service juridique
--
Sent via pgsql-general mail
in your LIKE clause,
since constraints are copied?
You can drop the constraint and re-create it with the name you want :
http://www.postgresql.org/docs/9.1/static/sql-altertable.html
--
Vincent Veyron
http://vincentveyron.com/
Gestion informatique des sinistres d'assurances et des dossi
castigating
people trying to help for not having said information at least shows a
certain consistency on your part.
Lest we ridicule ourselves publicly, I suggest we leave the discussion
at that and wish you luck in your endeavor.
Vincent Veyron
--
Sent via pgsql-general mailing list (p
application requires 10s to 100s of
instances with a PostgreSQL database, because that could get unwieldy
with big data (which I assumed from the high performance specification)
--
Vincent Veyron
http://marica.fr/
Gestion informatique des sinistres d'assurances et des dossiers contentieux
pour
en with a script, is quite simple. As for the pricing you
give, it can be matched on Amazon using Micro or small instances, which
would be adequate given your load average.
>
>
Well, it _has_ to be more complicated to use AWS than a bare machine,
because of the added layer?
--
Vincent
a setup, rather than simply use bare metal and get good
performance with simplicity?
For instance, the dedibox I use for my app (visible in sig) costs 14,00
euros/month, and sits at .03% load average with 5 active users; you can
admin it like a home pc.
--
Vincent Veyron
http://marica.fr/
Gesti
a setup, rather than simply use bare metal and get good
performance with simplicity?
For instance, the dedibox I use for my app (visible in sig) costs 14,00
euros/month, and sits at .03% load average with 5 active users; you can
admin it like a home pc.
--
Vincent Veyron
http://marica.fr/
Gesti
1 - 100 of 162 matches
Mail list logo
