Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread Adrian Klaver
On 02/03/2016 03:09 PM, drum.lu...@gmail.com wrote: On 4 February 2016 at 12:03, David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com mailto:drum.lu...@gmail.com>>wrote: Hi all,

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread John R Pierce
On 2/3/2016 3:32 PM, Andreas Joseph Krogh wrote: This query works for me in 9.5: SELECT CAST(customer_id AS BIGINT), csv_data, freshbooks_id, myob_id, ppy_id, qb_id, xero_id, _iid FROM ( VALUES ('3915105', E'\x1A', E'\x1A', 'c59894cb-0ffe-4ad6-823d-73c1392142b6', E'\x1A', E'\x1A', E'\x1A', '44

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread David G. Johnston
On Wed, Feb 3, 2016 at 4:09 PM, drum.lu...@gmail.com wrote: > > > On 4 February 2016 at 12:03, David G. Johnston > wrote: > >> On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com < >> drum.lu...@gmail.com> wrote: >> >>> Hi all, >>> >>> Below is an example of the auto-generated update query, wit

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread Andreas Joseph Krogh
På torsdag 04. februar 2016 kl. 00:09:41, skrev drum.lu...@gmail.com < drum.lu...@gmail.com >:     On 4 February 2016 at 12:03, David G. Johnston mailto:david.g.johns...@gmail.com>> wrote: On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread drum.lu...@gmail.com
On 4 February 2016 at 12:03, David G. Johnston wrote: > On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com > wrote: > >> Hi all, >> >> Below is an example of the auto-generated update query, with >> client-supplied keys (_iid). There's a fatal error when _iid is not >> numeric. However; this s

Re: [GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread David G. Johnston
On Wed, Feb 3, 2016 at 3:48 PM, drum.lu...@gmail.com wrote: > Hi all, > > Below is an example of the auto-generated update query, with > client-supplied keys (_iid). There's a fatal error when _iid is not > numeric. However; this should accept any value. > > *Question:* How could I do something t

[GENERAL] Fatal error when not numeric value - PostgreSQL 9.2

2016-02-03 Thread drum.lu...@gmail.com
Hi all, Below is an example of the auto-generated update query, with client-supplied keys (_iid). There's a fatal error when _iid is not numeric. However; this should accept any value. *Question:* How could I do something that would allow _iid to be more than just an INT? WITH in_rows AS (

Re: [GENERAL] Postgres 9.5 - password for new windows user

2016-02-03 Thread Rader, David
Sofy - One of your early emails said setting up a DB from the command line. Did you run the installer from the command line or as a windows application? If you want to try a different Windows graphical installer, you can try the one from BigSQL: http://www.bigsql.org/se/postgresql/packages.jsp -d

Re: [GENERAL] Postgres 9.5 - password for new windows user

2016-02-03 Thread Adrian Klaver
Ccing list On 02/03/2016 11:27 AM, Weisenberg, Sofy Hefets wrote: Hi Adrian, I have already uninstalled and installed before, and every time I run setup, I am not prompted for a password. And you are not prompted to create a database superuser? Or more to the point what are the steps that yo

Re: [GENERAL] handling time series data

2016-02-03 Thread Keith Brown
Thanks for the responses. So, it seems what I am trying to do isn't out of the norm. I will get the column store driver a try. Are there any plans to have this natively support in Postgresql? That would be a great "killer" feature. On Tue, Feb 2, 2016 at 7:53 PM, Brent Wood wrote: > Hi Keith,

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
On 03/02/2016 14:05, arnaud gaboury wrote: >>> >>> thetradinghall=> SELECT u.username ||'@'||d.domain as email_address >>> FROM email.mailusers u >>> INNER JOIN >>> email.domainlist d >>> ON >>> (u.domain_id=d.id); >>> >>>email_address >>> --- >>> arnaud

Re: [GENERAL] Postgres 9.5 - password for new windows user

2016-02-03 Thread Adrian Klaver
On 02/03/2016 05:47 AM, Weisenberg, Sofy Hefets wrote: Thanks for the response! Yes, I am sure that I was not prompted during setup to enter a password. Perhaps the graphical installer that I have is different from the one shown in the link. I went through all of the other steps, but it skippe

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread arnaud gaboury
>> >> thetradinghall=> SELECT u.username ||'@'||d.domain as email_address >> FROM email.mailusers u >> INNER JOIN >> email.domainlist d >> ON >> (u.domain_id=d.id); >> >>email_address >> --- >> arnaud.gabo...@thetradinghall.com >> (1 row) >>

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
On 03/02/2016 13:57, arnaud gaboury wrote: > On Wed, Feb 3, 2016 at 2:19 PM, Raymond O'Donnell wrote: >> On 03/02/2016 13:11, arnaud gaboury wrote: >> >>> Hum hum... >>> -- >>> SELECT u.username ||'@'||d.domain as email_address >>> FROM email.mai

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread arnaud gaboury
On Wed, Feb 3, 2016 at 1:55 PM, Ricardo Ramírez wrote: > For resetting the id you may want to take a look at the sequence > manipulation functions [1] Problem has been solved by removing the id column. > > Regards, > Ricardo > > [1]http://www.postgresql.org/docs/current/static/functions-sequenc

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread arnaud gaboury
On Wed, Feb 3, 2016 at 2:19 PM, Raymond O'Donnell wrote: > On 03/02/2016 13:11, arnaud gaboury wrote: > >> Hum hum... >> -- >> SELECT u.username ||'@'||d.domain as email_address >> FROM email.mailusers u >> INNER JOIN >> email.domain d >> ON >> (

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
On 03/02/2016 13:11, arnaud gaboury wrote: > Hum hum... > -- > SELECT u.username ||'@'||d.domain as email_address > FROM email.mailusers u > INNER JOIN > email.domain d > ON > (u.domain_id=d.domain.id) > WHERE id=1; > > ERROR: missing FROM-clau

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread arnaud gaboury
On Wed, Feb 3, 2016 at 1:51 PM, Raymond O'Donnell wrote: > On 03/02/2016 12:18, arnaud gaboury wrote: >> $ psql -V >> psql (PostgreSQL) 9.4.5 >> >> I am quite a newbie in psql. I am setting an email server and need to >> create then query psql tables to get some information: mainly email >> addres

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread Ricardo Ramírez
For resetting the id you may want to take a look at the sequence manipulation functions [1] Regards, Ricardo [1]http://www.postgresql.org/docs/current/static/functions-sequence.html On Wed, Feb 3, 2016, 06:26 arnaud gaboury wrote: > On Wed, Feb 3, 2016 at 1:18 PM, arnaud gaboury > wrote: > >

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread Raymond O'Donnell
On 03/02/2016 12:18, arnaud gaboury wrote: > $ psql -V > psql (PostgreSQL) 9.4.5 > > I am quite a newbie in psql. I am setting an email server and need to > create then query psql tables to get some information: mainly email > address and mail directory. > > For now I have created two tables this

Re: [GENERAL] SSD gives disappointing speed up on OSX

2016-02-03 Thread FarjadFarid(ChkNet)
Whilst the problem with the old filing system is correct. May be you want to ring out the best out of your current set up. There are a few things you can do to improve these performance figures. 1) Turn off logging during insert. 2) Ensure logging is performed on a different disk than where db

Re: [GENERAL] SSD gives disappointing speed up on OSX

2016-02-03 Thread FarjadFarid(ChkNet)
Whilst the problem with the old filing system is correct. May be you want to ring out the best out of your current set up. There are a few things you can do to improve these performance figures. 1) Turn off logging during insert. 2) Ensure logging is performed on a different disk than where db

Re: [GENERAL] query from two tables & concat the result

2016-02-03 Thread arnaud gaboury
On Wed, Feb 3, 2016 at 1:18 PM, arnaud gaboury wrote: > $ psql -V > psql (PostgreSQL) 9.4.5 > > I am quite a newbie in psql. I am setting an email server and need to > create then query psql tables to get some information: mainly email > address and mail directory. > > For now I have created two t

[GENERAL] query from two tables & concat the result

2016-02-03 Thread arnaud gaboury
$ psql -V psql (PostgreSQL) 9.4.5 I am quite a newbie in psql. I am setting an email server and need to create then query psql tables to get some information: mainly email address and mail directory. For now I have created two tables this way. Both tables are in same database and schema. I only i

Re: [GENERAL] SSD gives disappointing speed up on OSX

2016-02-03 Thread Chris Mair
I have a program that inserts 50M records of about 30 bytes each [..] Now I suspect the limit is OSX throttling per-process CPU. Does this sound right? Mmm... I don't think so. How do you perform the inserts? - Single inserts per transaction? - Bundled inserts in transactions (with or with