Re: [GENERAL] PostgreSQL-related legal question

2015-03-11 Thread Vincent Veyron
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

Re: [GENERAL] FW: Installation

2015-03-11 Thread 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

Re: [GENERAL] Populating missing dates in postgresql data

2015-03-27 Thread Vincent Veyron
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

Re: [GENERAL] Populating missing dates in postgresql data

2015-03-27 Thread 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/

Re: [GENERAL] Link Office Word form document with data from PostgreSQL

2015-03-30 Thread Vincent Veyron
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

Re: [SQL] Re: [GENERAL] Link Office Word form document with data from PostgreSQL

2015-03-30 Thread Vincent Veyron
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

Re: [GENERAL] How to exclude blobs (large objects) from being loaded by pg_restore?

2015-05-02 Thread Vincent Veyron
'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 >

Re: [GENERAL] PGFoundry Sample databases (particularly world)?

2015-05-05 Thread Vincent Veyron
.@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

Re: [GENERAL] A table of magic constants

2015-07-11 Thread Vincent Veyron
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

Re: [GENERAL] PostgreSQL customer list

2015-08-19 Thread Vincent Veyron
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

Re: [GENERAL] backup and archive postgresql data older than 6 months

2015-08-26 Thread Vincent Veyron
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

[GENERAL] error on CREATE INDEX when restoring from dump file: could not read block 0

2015-09-27 Thread Vincent Veyron
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

Re: [GENERAL] error on CREATE INDEX when restoring from dump file: could not read block 0

2015-09-28 Thread 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)

Re: [GENERAL] error on CREATE INDEX when restoring from dump file: could not read block 0

2015-09-28 Thread Vincent Veyron
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

Re: [GENERAL] PostgreSQL mirroring from RPM install to Source install

2016-12-16 Thread 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

Re: [GENERAL] Difficulty modelling sales taxes

2017-01-02 Thread Vincent Veyron
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

Re: [GENERAL] Proper use of Groups and Users (Roles).

2016-02-16 Thread Vincent Veyron
#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

Re: [GENERAL] Proper use of Groups and Users (Roles).

2016-02-16 Thread Vincent Veyron
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

Re: [GENERAL] Thoughts on "Love Your Database"

2016-05-04 Thread Vincent Veyron
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

Re: [GENERAL] Basic Tutorials for 9.0

2010-11-15 Thread Vincent Veyron
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

Re: [GENERAL] Implement online database using Postgresql

2010-12-07 Thread Vincent Veyron
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

Re: [GENERAL] COPY FROM and INSERT INTO rules

2010-12-07 Thread Vincent Veyron
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

Re: [GENERAL] How to obtain the maximum value of a date, between 3 tables...

2010-12-08 Thread Vincent Veyron
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://

Re: [GENERAL] How to obtain the maximum value of a date, between 3 tables...

2010-12-08 Thread Vincent Veyron
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

Re: [GENERAL] range intervals in window function frames

2010-12-14 Thread Vincent Veyron
[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

Re: [GENERAL] Searing array fields - or should I redesign?

2010-12-16 Thread Vincent Veyron
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

Re: [GENERAL] Searching array fields - or should I redesign?

2010-12-16 Thread Vincent Veyron
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 -

Re: [GENERAL] Constraining overlapping date ranges

2010-12-22 Thread Vincent Veyron
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

Re: [GENERAL] Constraining overlapping date ranges

2010-12-22 Thread Vincent Veyron
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

Re: [GENERAL] Restore problem

2010-12-30 Thread Vincent Veyron
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

Re: [GENERAL] Restore problem

2010-12-31 Thread Vincent Veyron
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

Re: [GENERAL] problem updating from form

2011-01-03 Thread Vincent Veyron
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

Re: [GENERAL] set theory question

2011-02-05 Thread Vincent Veyron
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

Re: [GENERAL] Looking for Suggestion on Learning

2011-02-06 Thread Vincent Veyron
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:

Re: [GENERAL] Very slow moving between partition

2011-02-07 Thread Vincent Veyron
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

Re: [GENERAL] Web Hosting

2011-03-09 Thread Vincent Veyron
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

Re: [GENERAL] triggers and FK cascades

2011-03-19 Thread Vincent Veyron
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

Re: [GENERAL] When was ANALYZE run in the past?

2014-11-30 Thread Vincent Veyron
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

Re: [GENERAL] Full text search prefix matching

2014-12-16 Thread Vincent Veyron
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

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Vincent Veyron
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

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Vincent Veyron
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

Re: [GENERAL] Storing Video's or vedio file in DB.

2014-12-17 Thread Vincent Veyron
, 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

Re: [GENERAL] Need advice for handling big data in postgres

2015-01-15 Thread Vincent Veyron
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. --

Re: [GENERAL] Change postgresql encoding

2015-02-09 Thread Vincent Veyron
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

Re: [GENERAL] Picking the first of an order in an aggregate query

2013-01-08 Thread Vincent Veyron
... 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

Re: [GENERAL] Linux Distribution Preferences?

2013-01-14 Thread Vincent Veyron
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

Re: [GENERAL] Linux Distribution Preferences?

2013-01-15 Thread Vincent Veyron
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

Re: [GENERAL] Linux Distribution Preferences?

2013-01-15 Thread Vincent Veyron
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

Re: [GENERAL] Linux Distribution Preferences?

2013-01-15 Thread Vincent Veyron
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

Re: [GENERAL] Linux Distribution Preferences?

2013-01-17 Thread Vincent Veyron
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

Re: [GENERAL] PostgreS Security Concern

2013-01-22 Thread Vincent Veyron
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

Re: [GENERAL] Optimizing query?

2013-01-30 Thread Vincent Veyron
> 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

Re: [GENERAL] Optimizing query?

2013-01-31 Thread Vincent Veyron
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

Re: [GENERAL] Optimizing query?

2013-01-31 Thread Vincent Veyron
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_

Re: [GENERAL] SQL sentence to insert where updated rows is zero...

2013-01-31 Thread Vincent Veyron
> # 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

Re: [GENERAL] fascinating article on postgresql mailing lists

2013-02-11 Thread Vincent Veyron
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

Re: [GENERAL] fascinating article on postgresql mailing lists

2013-02-11 Thread Vincent Veyron
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

Re: [GENERAL] Perl function leading to out of memory error

2013-02-20 Thread Vincent Veyron
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

Re: [GENERAL] Scalable cluster

2013-03-04 Thread Vincent Veyron
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

Re: [GENERAL] Hosting PG on AWS in 2013

2013-04-08 Thread Vincent Veyron
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

Re: [GENERAL] Building 3rd-party contrib/extension on Windows?

2013-04-08 Thread Vincent Veyron
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

Re: [GENERAL] how to create materialized view in postgresql 8.3

2013-04-10 Thread Vincent Veyron
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

Re: [GENERAL] refactoring a database owner without "reassign owned"

2013-05-13 Thread Vincent Veyron
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

Re: [GENERAL] Update from select

2013-05-13 Thread Vincent Veyron
"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

Re: [GENERAL] Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form

2013-06-07 Thread Vincent Veyron
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/

Re: [GENERAL] Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form

2013-06-08 Thread Vincent Veyron
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

Re: [GENERAL] utf8 errors

2013-06-27 Thread Vincent Veyron
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

Re: [GENERAL] utf8 errors

2013-06-27 Thread Vincent Veyron
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

Re: [GENERAL] utf8 errors

2013-06-28 Thread Vincent Veyron
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

Re: [GENERAL] Application locking

2013-06-29 Thread Vincent Veyron
; > 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

Re: [GENERAL] Locale Issue

2013-08-22 Thread Vincent Veyron
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

Re: [GENERAL] Locale Issue

2013-08-23 Thread Vincent Veyron
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

Re: [GENERAL] Recorded PostgreSQL at 10TB and Beyond

2017-02-13 Thread Vincent Veyron
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

Re: [GENERAL] browser interface to forums please?

2017-04-05 Thread Vincent Veyron
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

Re: [GENERAL] Not sure this should be asked here but...

2017-04-24 Thread Vincent Veyron
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

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-05 Thread Vincent Veyron
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

Re: [GENERAL] Call for design: PostgreSQL mugs

2013-09-10 Thread Vincent Veyron
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

Re: [GENERAL] [PG9.1] CTE usage

2013-09-16 Thread Vincent Veyron
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

Re: [GENERAL] Using ODBC and VBA to pull data from a large object

2013-09-19 Thread Vincent Veyron
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

Re: [GENERAL] Forms for entering data into postgresql

2013-10-12 Thread Vincent Veyron
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

Re: [GENERAL] Forms for entering data into postgresql

2013-10-12 Thread Vincent Veyron
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

Re: [GENERAL] Help function to sort string

2013-10-18 Thread Vincent Veyron
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;

Re: [GENERAL] Need help how to manage a couple of daily DB copies.

2013-10-25 Thread Vincent Veyron
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

[GENERAL] Mixed locales and date formatting

2013-11-14 Thread Vincent Veyron
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

Re: [GENERAL] Need help with upsert

2013-12-04 Thread Vincent Veyron
) 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)

Re: [GENERAL] Some good news ([i...@arin.net: [arin-announce] ARIN Database Migration Completed])

2013-12-16 Thread Vincent Veyron
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

Re: [GENERAL] New to postgresql - Do I have to be a "superuser" to be able to create a database?

2014-01-06 Thread Vincent Veyron
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 > ---+-

Re: [GENERAL] fastest dump/restore

2014-01-27 Thread Vincent Veyron
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:

Re: [GENERAL] Moving data from M$ JetDB file to Postgres on Linux

2014-03-01 Thread Vincent Veyron
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

[GENERAL] Statistically significant poll results

2014-03-02 Thread Vincent Veyron
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

Re: [GENERAL] Statistically significant poll results

2014-03-03 Thread Vincent Veyron
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/

Re: [GENERAL] upgrading from debian 6 to 7--do in place or wipe-and-install?

2014-03-29 Thread Vincent Veyron
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

Re: [GENERAL] Approach to Data Summary and Analysis

2014-04-14 Thread Vincent Veyron
> 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

Re: [GENERAL] Approach to Data Summary and Analysis

2014-04-15 Thread Vincent Veyron
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

Re: [GENERAL] Approach to Data Summary and Analysis

2014-04-15 Thread Vincent Veyron
> 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

Re: [GENERAL] Approach to Data Summary and Analysis

2014-04-15 Thread Vincent Veyron
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

Re: [GENERAL] Re: any way for a transaction to "see" inserts done earlier in the transaction?

2014-04-17 Thread Vincent Veyron
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

Re: [GENERAL] Re: any way for a transaction to "see" inserts done earlier in the transaction?

2014-04-17 Thread Vincent Veyron
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

Re: [GENERAL] Re: any way for a transaction to "see" inserts done earlier in the transaction?

2014-04-17 Thread Vincent Veyron
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

Re: [GENERAL] Recurring events

2011-06-07 Thread Vincent Veyron
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   2   >