search for: postgressql

On 19/05/2019 17:08, mabi via dovecot wrote: > ??????? Original Message ??????? > On Sunday, May 19, 2019 4:44 PM, John Fawcett via dovecot > <dovecot at dovecot.org> wrote: > >> I don't have PostgresSql, would you be able to verify if this syntax >> would work: INSERT INTO last_logins (last_login,username,domain) >> VALUES (1558273000,'user at domain.tld >> <mailto:user at domain.tld>','domain.tld') ON CONFLICT(username) UPDATE >> SET last_login=155827...

...used in > MySQL. That's it, PostgreSQL does not have "ON DUPLICATE KEY" but instead uses "ON CONFLICT" as documented here: https://www.postgresql.org/docs/10/sql-insert.html#SQL-ON-CONFLICT > You could verify the query being used by turning on query logging in > PostgresSQL. I enabled query logging as suggested and found out that Dovecot dict is not using the "ON CONFLICT" feature of INSERT with PostgreSQL, as you can see from the query below: INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'user at domain.tld','domain.t...

Hi List Apologies if this isn''t the correct place for this query (I''ve tried a search of the mail archives but not had much joy). I''m running R (2.14.0) on a Mac (OSX v 10.5.8, 2.66GHz, 4GB memory) and am having a few performance issues with reading data in from a Postres database (using RPostgreSQL). My query / code are as below # -----------------------------

Hello. For building REmbeddedPostgres in Omegat project(http://www.omegahat.org/RSPostgres/) requiring PostgresSQL's libs, I've tried to build R1.6.1 on Cygwin following the instruction of http://www.stats.ox.ac.uk/pub/Rtools/ since full-spec PostgresSQL running on Windows can run only on Cygwin environment, However I've got following error messages. make -C front-ends Rpwd make[1]: Entering dir...

On 19/05/2019 16:25, John Fawcett via dovecot wrote: > INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'user at domain.tld','domain.tld') I don't have PostgresSql, would you be able to verify if this syntax would work: INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'user at domain.tld','domain.tld') ONCONFLICT(username) UPDATE SET last_login=1558273000,domain='user at domain.tld' It's important to check...

...That's it, PostgreSQL does not have "ON DUPLICATE KEY" but instead uses "ON CONFLICT" as documented here: > > https://www.postgresql.org/docs/10/sql-insert.html#SQL-ON-CONFLICT > >> You could verify the query being used by turning on query logging in >> PostgresSQL. > I enabled query logging as suggested and found out that Dovecot dict is not using the "ON CONFLICT" feature of INSERT with PostgreSQL, as you can see from the query below: > > INSERT INTO last_logins (last_login,username,domain) VALUES (1558273000,'user at domain.tld',...

...ot at dovecot.org> wrote: >> >> Attached is a tentative patch. I've verified no regression for mysql. >> There should be no regression for sqlite as the code path is identical. >> >> Are you able to test for pgsql? As mentioned by Akie it will break >> for PostgresSql < 9.5 but probably it was not working anyway due to >> duplicate keys. Whether this is a wider problem depends on whether >> the insert code is being used for other purposes too. >> >> If you or someone can verify it works on PostgresSql >= 9.5, then the >> next...

...rated (0.1250s) ================== However, this is misleading, since the column was in fact not changed, and Null values are still accepted, seriously compromising data integrity. Has anyone encountered this problem? Is it caused by any mistake I can fix? The problem exists on Rails 1.1.2 with PostgresSQL 8.1.3 on both Windows and Debian Stable. -- -Alder

...PM, John Fawcett via dovecot <dovecot at dovecot.org> wrote: > Attached is a tentative patch. I've verified no regression for mysql. There should be no regression for sqlite as the code path is identical. > > Are you able to test for pgsql? As mentioned by Akie it will break for PostgresSql < 9.5 but probably it was not working anyway due to duplicate keys. Whether this is a wider problem depends on whether the insert code is being used for other purposes too. > > If you or someone can verify it works on PostgresSql >= 9.5, then the next step will be to make it conditional...

Hi List, Does any one know what package I need to use in order to fetch/get a large sized dataframe from SQL? I have already used sqldf package which is good for fetching large sized csv files. Thanks Alireza [[alternative HTML version deleted]]

...Timo, I am compiling dovecot-1.0.beta3, and I get the following message when the dovecot-auth module is being compiled: Undefined symbol sql_drivers_register_all first referenced in main.o Now I had run 'configure' with the '--without-sql-drivers' since I neither have MySQL or PostgresSQL installed on my server. Does this mean I DO have to get either package, install, and run it '--with-sql-drivers'? Or is it that the '--without...' feature doesn't work as intended? Am I making ANY sense? Thanks.

...terisk/cdr.db, creates a table 'cdr' inside it and inserts all CDR records into this table. Please comment. I'll use this in my project DESTAR (http://www.holgerschurig.de/destar.html) to show these CDR records in some web form. SQLITE is usually much easier to handle than mysql/postgressql, you don't need no running database daemon for it, yet it is very fast and supports SQL for ad-hoc queries.

Hi folks, I''m a linux noob, and I''m trying to pick a distro for my rails server. I don''t want to start a flame-war about linux distros! I''m interested in the best distribution for these criteria: 1 - Simplicity of getting ruby and rails set-up (gem updates) 2 - Stability (it is a server, after all) 3 - Support resources (community, and as a fall-back, paid

Hello, I am trying to setup the last_login plugin on Dovecot 2.3 in order to log a user's last IMAP login into a separate PostgreSQL table called last_login. I am actually following that guide: https://docs.iredmail.org/track.user.last.login.html with the exception that I use PostgreSQL instead of MySQL. So far it works at least for the very first login of a user but it looks like Dict

...> >>> Attached is a tentative patch. I've verified no regression for >>> mysql. There should be no regression for sqlite as the code path is >>> identical. >>> >>> Are you able to test for pgsql? As mentioned by Akie it will break >>> for PostgresSql < 9.5 but probably it was not working anyway due to >>> duplicate keys. Whether this is a wider problem depends on whether >>> the insert code is being used for other purposes too. >>> >>> If you or someone can verify it works on PostgresSql >= 9.5, then &g...

...= TRUE, : object 'storage.testappend_slt' not found I've tried variations on the table name including dropping the schema, using all uppercase, adding the tablespace name, etc., all without success. I searched R help and found similar problems have been encountered with Oracle and postgresSQL. http://www.mail-archive.com/r-help@r-project.org/msg19386.html The approach in the above link looked promising, but I don't know how to set the search path for DB2... Additional information, possibly helpful? > odbcGetInfo(channel), DBMS_Name DBMS_Ver Driver...

Hi, Love Rails... I''m looking for a Production Quality Server that brings the same ease of use as Rails does to web development. I''ve tried TextDrive, and never got it to work. I''m sure there are good reasons why it didn''t work but they are beyond me. I''ve contacted tech support there several times, and it seems that there are so many setups that

...ied directories for PostgreSql , so I used the option --configure-args to specify where are the PostgreSql libraries and headers. * The installation then seemed to be a success : ------------------------------------------------------------------------ R CMD INSTALL /home/faisnel/PostGresSql/RPgSQL_1.0-0.tar.gz --configure-args='--with-pgsql-libraries=/usr/local/pgsql/lib --with-pgsql-includes=/usr/local/pgsql/include' * Installing *source* package 'RPgSQL' ... creating cache ./config.cache checking for crypt in -lcrypt... yes checking how to run the C preprocessor......

...s. It works quickly. And using NoSQL helps solve problems with different fields for samples metrics fields. Then it will be possible to store different metrics for different testsuites in one table. What do you think about this proposal? I used MongoDB, but I know that there is NoSQL extension for PostgresSQL with JSONB fields which are more effective than JSON-encoded BLOB, because it can be included in queries very simply and let use indexes. About proposal that not all metrics should be shown. It can be added as a field in JSON in .fields file, which describes fields getted from test-suite. To see o...

...ure. > > > > Proposal > > > > We suggest to do third part of LNT (as Chris Matthews suggested). This > part will be used for getting custom metrics and running any test-suite. > > We suggest to use NoSQL database (for example, MongoDB or JSON/JSONB > extension of PostgresSQL, which let use PostgresSQL as NoSQL database) for > this part. This part will be enable if there is path to NoSQL database in > config file. > > It helps to have one Sample table(collection in NoSQL). If we use > schemaless feature in MongoDB, for example, then it’s possible to add n...