Re: [Lazarus] TPQConnection.CreateDB: ENCODING, OWNER, TEMPLATE, LC_CTYPE, TABLESPACE

2014-10-29 Thread Joost van der Sluis
On 10/28/2014 02:03 AM, silvioprog wrote: On Wed, Oct 8, 2014 at 12:44 PM, Michael Van Canneyt Hello buddy, sorry for my long delay. Thanks for the great tip, I tried it too, but unfortunately the postgre rejected that talking something like unrecognized param for this operation. Today I

Re: [Lazarus] TPQConnection.CreateDB: ENCODING, OWNER, TEMPLATE, LC_CTYPE, TABLESPACE

2014-10-29 Thread silvioprog
On Tue, Oct 28, 2014 at 8:19 AM, Reinier Olislagers reinierolislag...@gmail.com wrote: On 28/10/2014 02:03, silvioprog wrote: Today I fixed that using a mix of codes: creating the database using the original postgre driver for Java, and calling java -jar create_mydb params via TProcess.

Re: [Lazarus] TPQConnection.CreateDB: ENCODING, OWNER, TEMPLATE, LC_CTYPE, TABLESPACE

2014-10-29 Thread silvioprog
On Wed, Oct 29, 2014 at 8:26 AM, Joost van der Sluis jo...@cnoc.nl wrote: On 10/28/2014 02:03 AM, silvioprog wrote: On Wed, Oct 8, 2014 at 12:44 PM, Michael Van Canneyt Hello buddy, sorry for my long delay. Thanks for the great tip, I tried it too, but unfortunately the postgre rejected

Re: [Lazarus] TPQConnection.CreateDB: ENCODING, OWNER, TEMPLATE, LC_CTYPE, TABLESPACE

2014-10-28 Thread Reinier Olislagers
On 28/10/2014 02:03, silvioprog wrote: Today I fixed that using a mix of codes: creating the database using the original postgre driver for Java, and calling java -jar create_mydb params via TProcess. Now it worked like a charm! Please don't raise a bug tracker issue... especially one with a

Re: [Lazarus] TPQConnection.CreateDB: ENCODING, OWNER, TEMPLATE, LC_CTYPE, TABLESPACE

2014-10-27 Thread silvioprog
On Wed, Oct 8, 2014 at 12:44 PM, Michael Van Canneyt mich...@freepascal.org wrote: On Wed, 8 Oct 2014, silvioprog wrote Hello, I need to create a PostgreSQL database from my application. The TPQConnection.CreateDB works fine, but I need to configure some properties of my database in your

[Lazarus] TPQConnection.CreateDB: ENCODING, OWNER, TEMPLATE, LC_CTYPE, TABLESPACE

2014-10-08 Thread silvioprog
Hello, I need to create a PostgreSQL database from my application. The TPQConnection.CreateDB works fine, but I need to configure some properties of my database in your creation. In pgAdmin, I execute: CREATE DATABASE myuser WITH ENCODING='UTF8' OWNER=myowner TEMPLATE=template1

Re: [Lazarus] TPQConnection.CreateDB: ENCODING, OWNER, TEMPLATE, LC_CTYPE, TABLESPACE

2014-10-08 Thread Michael Van Canneyt
On Wed, 8 Oct 2014, silvioprog wrote: Hello, I need to create a PostgreSQL database from my application. The TPQConnection.CreateDB works fine, but I need to configure some properties of my database in your creation. In pgAdmin, I execute: CREATE DATABASE myuser   WITH ENCODING='UTF8'