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

mething like stack overflow is the best 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 comptabil

Re: [GENERAL] dynamic schema modeling and performance

Op 14/04/2017 om 19:03 schreef Rj Ewing: We do know where we want to end up. We've had the application running for a while using a triple store db. We're looking to move away from the triple store due to performance issues. Our core concept is that each project can define a set of entities

Re: [GENERAL] browser interface to forums please?

Op 05/04/2017 om 19:26 schreef Tim Clarke: On 05/04/17 18:22, Joshua D. Drake wrote: Stackoverflow gives back by providing an interface people want to use. It is free (as in beer) and is hugely popular. We need to be embracing these external communities because it is where our growth is. I

Re: [GENERAL] browser interface to forums please?

ibe, create a folder and 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 -- Se

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

On Mon, 13 Feb 2017 09:52:05 + Seref Arikan <serefari...@kurumsalteknoloji.com> wrote: > Many thanks for this. > +1 -- Bien à vous, Vincent Veyron https://libremen.com Logiciels de gestion, libres -- Sent via pgsql-general mailing

Re: [GENERAL] Difficulty modelling sales taxes

tax_code_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 con

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

it applies, but just 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://m

Re: [GENERAL] Trim performance on 9.5

Op 18/11/2016 om 16:58 schreef William Ivanski: I just ran EXPLAIN ANALYZE, please see images attached. Field doesn't have a index. Em sex, 18 de nov de 2016 às 12:16, vinny > escreveu: On 2016-11-18 15:06, William Ivanski wrote: > Hi,

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

inversely 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 Veyro

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

lso, REFERENCES & TRIGGER 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 ass

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

E rights on a table, I don'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/

Re: [GENERAL] temporary indexes?

On 21-10-15 20:43, Jonathan Vanasco wrote: I couldn't find any mention of this on the archives... Have the project maintainers ever considered extending CREATE INDEX to support "temporary" indexes like CREATE TEMPORARY TABLE? When creating temporary tables for analytics/reporting, I've

Re: [GENERAL] PSQL Tools

Op 18-10-2015 om 16:04 schreef jwienc...@comcast.net: Hello Is anyone aware of any tools like TOAD that are available for Postgresql? Regards John Wiencek There are several, I use EMS SQL-manager freeware version. The commecial version has more features, but the freeware version supports

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

spur.riddles.org.uk#87tx0dc80x@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-g

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

e in queries is nice, but 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, V

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

ie 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-general@post

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

: /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 -- Salutations, Vincent

Re: [GENERAL] PostgreSQL Developer Best Practices

. there other good reasons, that I've forgotten for now :-( (but I remember having them!!!) Oh, so you name your tables 'fish' and 'crow' instead of 'school' and 'murder' ? Such wasted opportunities :p -- Vincent de Phily -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] PostgreSQL customer list

://www.postgresql.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

Re: [GENERAL] A table of magic constants

. 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-general

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

-- 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

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

recevez ce courriel par erreur, veuillez m'en aviser imm?diatement, par retour de courriel ou par un autre moyen. -- Salutations, Vincent Veyron https://legalcase.libremen.com/ Legal case, contract and insurance claim management software -- Sent via

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

, 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 -- Salutations, Vincent

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

-- Salutations, Vincent Veyron https://legalcase.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] Populating missing dates in postgresql data

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 https://libremen.com/ Legal case, contract and insurance

Re: [GENERAL] Populating missing dates in postgresql data

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] FW: Installation

): # 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

Re: [GENERAL] PostgreSQL-related legal question

$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 https://libremen.com/ Legal case, contract and insurance claim

Re: [GENERAL] Change postgresql encoding

PGCLIENTENCODING=LATIN9; psql -f /path/to/dump/file litigios -- 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

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

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. -- Salutations, Vincent Veyron https://libremen.com

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

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 mailing

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

. -- 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.

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 changes to your

Re: [GENERAL] Full text search prefix matching

) -- 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] Speeding up an in-progress wraparound-preventing vacuum

On Tuesday 09 December 2014 01:58:11 Vincent de Phily wrote: On Monday 08 December 2014 10:17:37 Jeff Janes wrote: You can `strace` for the lseek command to see which file handles it is currently working on, and use lsof to turn those into names. You want to look at where

Re: [GENERAL] Speeding up an in-progress wraparound-preventing vacuum

On Tuesday 09 December 2014 16:56:39 Tom Lane wrote: Vincent de Phily vincent.deph...@mobile-devices.fr writes: It reads about 8G of the table (often doing a similar number of writes, but not always), then starts reading the pkey index and the second index (only 2 indexes on this table

[GENERAL] Speeding up an in-progress wraparound-preventing vacuum

, we're well below 100). The pg_class.relfozenxid on that table is at 680M, while most other tables are around 860M. Could it be that routine vacuums haven't been able to update the relfrozenxid in a long long time, or am I missing something else ? Thanks. -- Vincent de Phily -- Sent via

Re: [GENERAL] Speeding up an in-progress wraparound-preventing vacuum

On Monday 08 December 2014 10:17:37 Jeff Janes wrote: On Mon, Dec 8, 2014 at 4:54 AM, Vincent de Phily bloat, which I'd like to get back asap). Currently about 80% of the IO is devoted to the vacuum process (on average throughout the day, as extrapolated from atop output

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

-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 subscription: http://www.postgresql.org

Re: [GENERAL] Downtime-free 'alter table set tablespace'

On Friday 23 May 2014 15:12:47 Chris Ernst wrote: On 05/23/2014 08:57 AM, Vincent de Phily wrote: I need to reduce downtime to a minimum, so I can't afford to let alter table set tablespace take an exclusive lock on the table for the 2h it'll take to copy the data. You might look

Re: [GENERAL] Receiving many more rows than expected

the problematic query and interruption by other threads, to increase throughput. -- Vincent de Phily -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Downtime-free 'alter table set tablespace'

, if it was that simple, would be great to have in core as a 'set tablespace concurrently' option) ? Thanks. -- Vincent de Phily -- 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] Receiving many more rows than expected

to repeatable read would also fix the issue ? In any case, testing will take time because the bug triggers less than once a day and I haven't yet managed to reproduce it locally. ps: sorry I'm only seeing your answer now, it helps if you cc me when answering the list. -- Vincent de Phily

Re: [GENERAL] Receiving many more rows than expected

On Friday 09 May 2014 16:53:49 Adrian Klaver wrote: On 05/09/2014 08:04 AM, Vincent de Phily wrote: Thanks to all for taking an interest so far, this bug is... weird. Yes weird. I tried to replicate your query to see if I could see anything similar. Tried it on 9.0.17 and 9.3.4 and could

Re: [GENERAL] Receiving many more rows than expected

On Thursday 08 May 2014 16:05:59 Sim Zacks wrote: On 05/08/2014 02:09 PM, Vincent de Phily wrote: The problem is that sometimes (once every few days at about 2-300K queries per day) I get many more rows than the max 5000 I asked for (I've seen up to 25k). And I'm getting timeouts and other

Re: [GENERAL] Receiving many more rows than expected

On Thursday 08 May 2014 16:56:25 Adrian Klaver wrote: On 05/08/2014 03:11 PM, Vincent de Phily wrote: On Thursday 08 May 2014 06:30:39 Adrian Klaver wrote: On 05/08/2014 04:09 AM, Vincent de Phily wrote: The histogram shows a large amount of small values, progressively becoming rarer

Re: [GENERAL] Receiving many more rows than expected

On Friday 09 May 2014 07:01:32 Tom Lane wrote: Vincent de Phily vincent.deph...@mobile-devices.fr writes: In case it changes anything, this is the uncut (but still anonimized) function: query = UPDATE foo SET processing = 't' WHERE id IN (SELECT id FROM foo WHERE

Re: [GENERAL] Receiving many more rows than expected

On Friday 09 May 2014 08:01:47 Adrian Klaver wrote: On 05/09/2014 01:45 AM, Vincent de Phily wrote: Before you grow suspicious of that conf_getint, the config is loaded once at program startup, and the overlarge results hapen together with normal results without having left the loop. Just

[GENERAL] Receiving many more rows than expected

with a unique index. I've checked the problematic cases and there are no id gaps or duplicate rows. There are multiple threads in the program, but only the main thread is running enqueue_loop(). I'm not sure if this is a server or a driver issue. Any idea ? Thanks. -- Vincent de Phily -- Sent

Re: [GENERAL] Receiving many more rows than expected

On Thursday 08 May 2014 06:30:39 Adrian Klaver wrote: On 05/08/2014 04:09 AM, Vincent de Phily wrote: Hello, I'm processing records in batches using PG 9.1.12, python 2.7, and psycopg 2.5.2 : Comments in the code below: def enqueue_loop(q): curs = DB_HANDLER.cursor

Re: [GENERAL] Arduino SQL Connector

On 18-04-14 06:21, John R Pierce wrote: On 4/17/2014 9:09 PM, Steve Spence wrote: You know what? Fine, it doesn't matter that much to me. I'm happy to continue using MySQL. It works with the Arduino quite nicely. Postgres doesn't work. That's Postgres loss not mine. I really thought the

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

. -- 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://www.postgresql.org/mailpref/pgsql-general

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

. -- 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://www.postgresql.org/mailpref/pgsql-general

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

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] Approach to Data Summary and Analysis

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 et des sinistres d'assurance -- Sent via pgsql-general mailing

Re: [GENERAL] Approach to Data Summary and Analysis

(user_id) REFERENCES my_users(id) ON DELETE CASCADE ); -- 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

Re: [GENERAL] Approach to Data Summary and Analysis

On Tue, 15 Apr 2014 07:21:58 -0700 Robert DiFalco robert.difa...@gmail.com wrote: I'm sorry Vincent I'm not exactly sure what you are proposing. Are you proposing that I add another table in addition to what I already have that all the other tables JOIN to and add a state field in that parent

Re: [GENERAL] Approach to Data Summary and Analysis

(user_id) REFERENCES my_users(id) ON DELETE CASCADE ); -- 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

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

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 software -- Sent via pgsql

Re: [GENERAL] Statistically significant poll results

On Sun, 2 Mar 2014 15:28:31 +0100 Vincent Veyron vv.li...@wanadoo.fr 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

[GENERAL] Statistically significant 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

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

On Fri, 28 Feb 2014 16:03:39 -0800 (PST) Rich Shepard rshep...@appl-ecosys.com 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

Re: [GENERAL] Deleted files still open long after droping a database

. Unfortunately, the complainant is running 9.1.2. Thanks for the detailed info, great to see it's already fixed. As it happens, we're in the process of moving to new servers, where we'll strive to get a better update process going. -- Vincent de Phily -- Sent via pgsql-general mailing list (pgsql

[GENERAL] Deleted files still open long after droping a database

) -- Vincent de Phily -- 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] Deleted files still open long after droping a database

On Monday 17 February 2014 18:46:49 Vincent de Phily wrote: Hi List, I have droped a database a few hours ago to reclaim some badly-needed space, but that disk space has not been freed yet. Investigating further, there are lots of deleted but open files that seem to correspond to the droped

Re: [GENERAL] fastest dump/restore

-- 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://www.postgresql.org/mailpref/pgsql

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

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 -- Regards, Vincent

Re: [GENERAL] postgresql or xquery?

On 06-12-13 11:54, e-letter wrote: Readers, Admittedly, a biased place to ask (!), but for a new database project, how best to evaluate whether postgresql or xquery should be used. As a novice of postgresql and xml, am not sure what is most appropriate for a new database that will be tested

Re: [GENERAL] Need help with upsert

. -- Salutations, Vincent Veyron Legal cases, contracts and insurance claims management http://libremen.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Mixed locales and date formatting

: createdb default_locale createdb english_locale --locale en_US.iso885915 --template=template0 output of psql -l : default_locale | vincent | LATIN9 | fr_FR@euro | fr_FR@euro | english_locale | vincent | LATIN9 | en_US.iso885915 | en_US.iso885915 | psql -c select to_char

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

} -- Salutations, Vincent Veyron http://marica.fr/site/demonstration 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

Re: [GENERAL] Help function to sort string

; CHROMOGENIC; ECD FORM; FORMAT; PREDILUTED; RABBIT 2 | AUTO; BODY; CHROMO-GENIC; ECD FORM; FORMAT; PREDILUTED; RABBIT 3 | AUTO; ECD FORM; FORMAT -- Salutations, Vincent Veyron http://marica.fr/site/demonstration Gestion des contentieux juridiques, des

Re: [GENERAL] Forms for entering data into postgresql

forms? -- Salutations, Vincent Veyron http://marica.fr/site/demonstration Gestion des contentieux et des dossiers de sinistres assurance pour le service juridique -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Forms for entering data into postgresql

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 des contentieux juridiques, des contrats et des sinistres

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

/32b64a3f-3e7a-4e02-a7ef-824cacfea57a/256-char-limit-on-ado-recordset-field -- Salutations, Vincent Veyron http://gdlc.fr/logiciels Applications de gestion des contentieux juridiques et des dossiers de sinistres assurance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

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

, 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] Call for design: PostgreSQL mugs

or whatever. Nice for professionals, but the simplicity of the OP's proposition makes for a nice brand recognition, I find? I would suggest to write 'postgresl.org' for the message. -- Salutations, Vincent Veyron http://marica.fr/ Gestion des contrats, des contentieux juridiques et des sinistres

Re: [GENERAL] Call for design: PostgreSQL mugs

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-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Locale Issue

LC_MEASUREMENT=fr_FR.UTF-8 LC_IDENTIFICATION=fr_FR.UTF-8 LC_ALL= See my previous e-mail (sent just a few minutes before this one). Agreed : 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

Re: [GENERAL] Locale Issue

-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 sinistres d'assurance

Re: [GENERAL] Application locking

preventing two callers from locking the same case? 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

Re: [GENERAL] utf8 errors

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'assurance -- Sent via pgsql-general

Re: [GENERAL] utf8 errors

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

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@postgresql.org

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

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 des contrats, des contentieux

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

.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/site/demonstration Progiciel de gestion des sinistres

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

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, Vincent Veyron http://marica.fr/site/demonstration

Re: [GENERAL] Update from select

.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-general mailing list (pgsql-general@postgresql.org) To make changes

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

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 mailing list (pgsql-general

Re: [GENERAL] Hosting PG on AWS in 2013

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 -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Building 3rd-party contrib/extension on 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 mailing list (pgsql

Re: [GENERAL] Scalable cluster

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/site/demonstration Progiciel de gestion des sinistres

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

$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 dossiers contentieux pour le service juridique -- Sent via pgsql-general mailing list

Re: [GENERAL] fascinating article on postgresql mailing lists

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 des sinistres assurance et des contentieux

Re: [GENERAL] fascinating article on postgresql mailing lists

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 gets a response' sits below 60

Re: [GENERAL] Optimizing query?

? -- 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.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Optimizing query?

Le jeudi 31 janvier 2013 à 11:06 +0100, Pavel Stehule a écrit : 2013/1/31 Vincent Veyron vv.li...@wanadoo.fr: 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(column_1); where my_function

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

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 gestion des contentieux juridiques et des sinistres d'assurance -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Optimizing query?

-- 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.postgresql.org

Re: [GENERAL] PostgreS Security Concern

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 Veyron http://marica.fr/site/demonstration Logiciel de gestion

  1   2   3   4   >