Hi,
On Windows 7, I am trying to install PostgreSQL 9.5 (
*postgresql-9.5.2-1-windows-x64.exe*) with different locales, but it is
getting installed with default locale only, which is, `*English_United
States.1252*`. I tried both the methods, GUI and unattended/silent, but the
results are same.
I
Solution:
C is able to compile with an embedded shell script.
So a small C program with an argument being the user passed to the shell
script it succeded succesfully.
I am aware that it could be my question was not specifically relevant to
Postgresql! :)
It took a while to solve. :)
Thanks
Poul
My goal is to grap a user from the OS and and substitute the grapped user -
to be the owner of the database - in the sql commands
e.g using shell-script substitution syntax:
create user ${user} with login;
create tablespace ${user} location '/path/${user)';
create database ${us
"David G. Johnston" writes:
> On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen wrote:
>> In the postgresql.log I get "select datname from $1".
> That is expected when you parameterize a query - the query string includes
> parameters instead of values.
It looks like Poul is hoping to use a par
On Wed, Nov 23, 2016 at 3:46 AM, Poul Kristensen wrote:
> In the postgresql.log I get "select datname from $1".
>
That is expected when you parameterize a query - the query string includes
parameters instead of values. What you are seeing is the "Prepare"
component of a "prepare-execute". Wh
The below mentioned pg_database does not appear in $1.
In the postgresql.log I get "select datname from $1".
Do you have a suggestion of how to solve this?
I get double declarations when using both
char *paramValues[1]
char *paramValues[1]
//char *value1 = "pg_database";
//char **paramValues = &v
On Tue, Nov 22, 2016 at 8:22 AM, Poul Kristensen wrote:
> I think I understand.
> When I use this in my code I get
> "undefined reference to `PQexecParms'
>
The correct name is PQexecParams (note the last "a"). Sorry I missed that
when first looking. Also, just to be sure, did you include the
Poul Kristensen writes:
> When I use this in my code I get
> "undefined reference to `PQexecParms'
> when compiling.
IIRC, it's PQexecParams not PQexecParms
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
I think I understand.
When I use this in my code I get
"undefined reference to `PQexecParms'
when compiling.
references in main is
const char *conninfo; /* connection string to the database */
PGconn *conn; /* connection to the database */
PGresult *res; /* result of sql query */
int nFields;
On Mon, Nov 21, 2016 at 11:22 AM, Poul Kristensen wrote:
> Thank you for fast repons!
>
> The $1 substitution below. I assume that it refers to "joe's place". But
> it is not very clear to me, how "joe's place" will appear instead of $1
> when running. Where is it possiible to read more about thi
On Mon, Nov 21, 2016 at 8:56 AM, Poul Kristensen wrote:
> Hi!
>
> Hopefully this is this list.
>
> A shell variabel is defined like this
>
> var1= value
>
> used like ${var1}.
>
> How is the equal defened in the Postgresql C programming?
>
> Thanks.
>
> Poul
>
> BTW: I have not received my order
On 11/21/2016 06:56 AM, Poul Kristensen wrote:
Hi!
Hopefully this is this list.
A shell variabel is defined like this
var1= value
used like ${var1}.
How is the equal defened in the Postgresql C programming?
You probably need to be more specific about what aspect of using C in
Postgres yo
Hi!
Hopefully this is this list.
A shell variabel is defined like this
var1= value
used like ${var1}.
How is the equal defened in the Postgresql C programming?
Thanks.
Poul
BTW: I have not received my ordered book yet!
On Tue, Oct 04, 2016 at 07:46:48PM +, Shaun McCready wrote:
> Hello,
>
> I'm having an issue with using the new UPSERT feature in Postgres 9.5
>
> I have a table that is used for aggregating data from another table. The
> composite key is made up of 20 columns, 10 of which can be nullable.
>
Hello,
I'm having an issue with using the new UPSERT feature in Postgres 9.5
I have a table that is used for aggregating data from another table. The
composite key is made up of 20 columns, 10 of which can be nullable.
Below I have created a smaller version of the issue i'm having, specifically
ailto:adrian.kla...@aklaver.com]
Sent: Thursday, June 30, 2016 7:47 PM
To: Hanan Brener ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64
bit)
On 06/30/2016 09:24 AM, Hanan Brener wrote:
Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; rub
-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL 9.5 and PL/Ruby install problem(Centos 6 64
bit)
On 06/30/2016 09:24 AM, Hanan Brener wrote:
> Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8
How did you install the Postgres server?
>
> and get from
> *https://pkgs.
On 06/30/2016 09:24 AM, Hanan Brener wrote:
Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8
How did you install the Postgres server?
and get from
*https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html*
I would say where you install plruby from depend
Hanan Brener writes:
> Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8
> and get from
> https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html
> - plruby libraries(postgresql-plruby-0.5.3-4.el6.x86_64).
> Additional installed postgresql95-libs
> (postgresq
Installing on Centos 6 PostgreSQL 9.5 (64 bit) ; ruby 1.8
and get from
https://pkgs.org/centos-6/epel-x86_64/postgresql-plruby-0.5.3-4.el6.x86_64.rpm.html
- plruby libraries(postgresql-plruby-0.5.3-4.el6.x86_64).
Additional installed postgresql95-libs
(postgresql95-libs-9.5.2-1PGDG.rhel6.x86_64)
On 03/05/2016 05:34 PM, Stefan Keller wrote:
I'd like to extend (and complete) this thread by collecting
programs/frameworks/applications that provide REST services over
Postgres.
I see following categories and open source web frameworks and/or libs:
Those which
* attach Postgres directly, like
I'd like to extend (and complete) this thread by collecting
programs/frameworks/applications that provide REST services over
Postgres.
I see following categories and open source web frameworks and/or libs:
Those which
* attach Postgres directly, like PostgREST (Haskell) or jsgrest
(JavaScript serv
On 12/02/16 17:34, Adrian Klaver wrote:
On 02/12/2016 08:06 AM, James Keener wrote:
https://github.com/begriffs/postgrest also looks interesting!
I thought the purpose of Spring/Spring Boot was to provide the REST
services in front of your choice of data store. Not sure how
On 02/12/2016 08:06 AM, James Keener wrote:
https://github.com/begriffs/postgrest also looks interesting!
I thought the purpose of Spring/Spring Boot was to provide the REST
services in front of your choice of data store. Not sure how putting
another server in the stack is
>
>
> https://github.com/begriffs/postgrest also looks interesting!
>>
>
> I thought the purpose of Spring/Spring Boot was to provide the REST
> services in front of your choice of data store. Not sure how putting
> another server in the stack is going to help things.
I was simply responding to t
On 02/12/2016 07:43 AM, James Keener wrote:
https://github.com/begriffs/postgrest also looks interesting!
I thought the purpose of Spring/Spring Boot was to provide the REST
services in front of your choice of data store. Not sure how putting
another server in the stack is going to help thing
https://github.com/begriffs/postgrest also looks interesting!
On Fri, Feb 12, 2016 at 10:24 AM, Adrian Klaver
wrote:
> On 02/12/2016 03:00 AM, Peter van Eck wrote:
>
>>
>>
>> Hi, We are looking into setting up a PostgreSQL environment for an
>> application that inputs JSON through via http rest
On 02/12/2016 03:00 AM, Peter van Eck wrote:
Hi, We are looking into setting up a PostgreSQL environment for an
application that inputs JSON through via http rest calls.
Now that we havent been using Postgres for these kind of setups I was
wondering what the course of action is in setting this
On Fri, Feb 12, 2016 at 4:00 AM, Peter van Eck wrote:
>
>
> Hi, We are looking into setting up a PostgreSQL environment for an
> application that inputs JSON through via http rest calls.
>
> Now that we havent been using Postgres for these kind of setups I was
> wondering what the course of actio
Hi, We are looking into setting up a PostgreSQL environment for an
application that inputs JSON through via http rest calls.
Now that we havent been using Postgres for these kind of setups I was
wondering what the course of action is in setting this up.
The development team is coding this
On 01/08/2016 08:45 PM, Deven Phillips wrote:
I DID get a foreign table to work using the following:
CREATE FOREIGN TABLE customer (
id BIGINT,
name VARCHAR(150),
parent_id BIGINT,
oracle_id BIGINT,
last_updated_time TIMESTAMP,
created_time TIMESTAMP) SERVER mysql OPTIONS (dbname 'mydb', table_n
On 01/08/2016 08:45 PM, Deven Phillips wrote:
I DID get a foreign table to work using the following:
CREATE FOREIGN TABLE customer (
id BIGINT,
name VARCHAR(150),
parent_id BIGINT,
oracle_id BIGINT,
last_updated_time TIMESTAMP,
created_time TIMESTAMP) SERVER mysql OPTIONS (dbname 'mydb', table_n
OK, that did it! I submitted 2 PRs to the EnterpriseDB/mysql_fdw GitHub
project which should resolve all outstanding issues for me.
https://github.com/EnterpriseDB/mysql_fdw/pull/81
https://github.com/EnterpriseDB/mysql_fdw/pull/82
Isn't it great when Open Source works like it's supposed to!!!
I think that I may have found the problem. It looks like the mysql_fdw uses
the following query to gather information about the foreign schema:
SELECT
t.TABLE_NAME,
c.COLUMN_NAME,
CASE
WHEN c.DATA_TYPE = 'enum' THEN LOWER(CONCAT(c.COLUMN_NAME, '_t'))
WHEN c.DATA_TYPE = 'tinyint' THEN 'sma
Additional details. The MySQL server I am targeting is running
version 5.1.73. Perhaps it's too old of a version to support foreign schema
import?
Deven
On Fri, Jan 8, 2016 at 11:45 PM, Deven Phillips
wrote:
> I DID get a foreign table to work using the following:
>
> CREATE FOREIGN TABLE custo
I DID get a foreign table to work using the following:
CREATE FOREIGN TABLE customer (
id BIGINT,
name VARCHAR(150),
parent_id BIGINT,
oracle_id BIGINT,
last_updated_time TIMESTAMP,
created_time TIMESTAMP) SERVER mysql OPTIONS (dbname 'mydb', table_name
'customer');
And I was subsequently able to
Apparently not, though I have done so in the past on PostgreSQL 9.4. It
appears to be related to the "schema" with which the foreign table is
associated:
mydb=# CREATE FOREIGN TABLE customer (
id BIGINT,
name VARCHAR(150),
parent_id BIGINT,
oracle_id BIGINT,
last_updated_time TIMESTAMP,
created_ti
On 01/08/2016 07:04 AM, Deven Phillips wrote:
Hi all,
I installed the newly released PostgreSQL 9.5 this morning and
compiled the latest mysql_fdw extension from EnterpriseDB. I was able to
create the SERVER and USER MAPPING, but I cannot seem to get IMPORT
FOREIGN SCHEMA to do anything. Th
Hi all,
I installed the newly released PostgreSQL 9.5 this morning and compiled
the latest mysql_fdw extension from EnterpriseDB. I was able to create the
SERVER and USER MAPPING, but I cannot seem to get IMPORT FOREIGN SCHEMA to
do anything. The command executes without error, but none of the
On 03/25/2015 07:36 AM, yba...@symcor.com wrote:
Hi.
I have question regarding release of postgresql 9.5 - Are we expecting
it to be released in Sept 2015?
1) Since Postgresql 9.4 was released last year in Dec 2014 instead of
Sept 2014, Just wanted to confirm as we would like to plan our upgrad
Hi.
I have question regarding release of postgresql 9.5 - Are we expecting it
to be released in Sept 2015?
1) Since Postgresql 9.4 was released last year in Dec 2014 instead of Sept
2014, Just wanted to confirm as we would like to plan our upgrade project
based on the release date.
2) Can w
41 matches
Mail list logo
