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

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

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 ru

Re: [GENERAL] browser interface to forums please?

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] Recorded PostgreSQL at 10TB and Beyond

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] Difficulty modelling sales taxes

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] PostgreSQL mirroring from RPM install to Source install

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] 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, > > I recently

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

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] Proper use of Groups and Users (Roles).

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] Proper use of Groups and Users (Roles).

#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] 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 notic

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

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] error on CREATE INDEX when restoring from dump file: could not read block 0

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)

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

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] backup and archive postgresql data older than 6 months

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

Re: [GENERAL] PostgreSQL Developer Best Practices

ous wrt spelling > > 3. 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

Re: [GENERAL] PostgreSQL customer list

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] A table of magic constants

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] PGFoundry Sample databases (particularly world)?

.@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] How to exclude blobs (large objects) from being loaded by pg_restore?

'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: [SQL] Re: [GENERAL] Link Office Word form document with data from PostgreSQL

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] Link Office Word form document with data from PostgreSQL

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: [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] Populating missing dates in postgresql data

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] 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) To make

Re: [GENERAL] PostgreSQL-related legal question

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] Change postgresql encoding

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] Need advice for handling big data in postgres

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] Storing Video's or vedio file in DB.

, 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] Storing Video's or vedio file in DB.

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.

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] Full text search prefix matching

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

On Tuesday 09 December 2014 16:56:39 Tom Lane wrote: > Vincent de Phily 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 t

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 l

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

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

ctions in that timespan (that'd need 890 transactions per second, 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, o

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

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] Receiving many more rows than expected

e :/ The refactoring had to do with taking status queries to a different connection, and changing the timing of calling 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

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'

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

ackup, rsync, and catalog update (which, 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

ly seeing your answer now, it helps if you cc me when answering the list. -- 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

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.

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

Re: [GENERAL] Receiving many more rows than expected

On Friday 09 May 2014 07:01:32 Tom Lane wrote: > Vincent de Phily writes: > > In case it changes anything, this is the uncut (but still anonimized) > > > > function: > > query = """UPDATE foo SET processing = 't' WHERE id IN > >

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

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 gett

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:

[GENERAL] Receiving many more rows than expected

uts and other problems as a result. The id column is your typical primary key integer 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

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 postgre

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] Re: any way for a transaction to "see" inserts done earlier in the transaction?

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?

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

On Tue, 15 Apr 2014 07:21:58 -0700 Robert DiFalco 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 paren

Re: [GENERAL] Approach to Data Summary and Analysis

> 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

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

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

Re: [GENERAL] Statistically significant poll results

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/

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

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

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

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

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

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 co

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

979716 (deleted) -- 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] fastest dump/restore

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] New to postgresql - Do I have to be a "superuser" to be able to create a database?

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

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 in

Re: [GENERAL] Need help with upsert

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

[GENERAL] Mixed locales and date formatting

_US one? Here is a test case : 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.

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

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

Re: [GENERAL] Help function to sort string

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] Forms for entering data into postgresql

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] Forms for entering data into postgresql

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] Using ODBC and VBA to pull data from a large object

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] [PG9.1] CTE usage

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

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

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] Locale Issue

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] Locale Issue

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] Application locking

; > 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] utf8 errors

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

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] Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form

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] Open bytea files (images, docs, excel, PDF) stored in Postgresql using a Microsoft Access form

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] Update from select

"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] refactoring a database owner without "reassign owned"

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] how to create materialized view in postgresql 8.3

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] Building 3rd-party contrib/extension on Windows?

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] Hosting PG on AWS in 2013

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] Scalable cluster

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] Perl function leading to out of memory error

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

Re: [GENERAL] fascinating article on postgresql mailing lists

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] SQL sentence to insert where updated rows is zero...

> # 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] Optimizing query?

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] Optimizing query?

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?

> 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

  1   2   3   4   >