Re: [GENERAL] Making changes to PostgreSQL's configure logic so as to have contrib modules installed in a specific directory and make them use PGXS?

postgres user writes: > I want to configure my PostgreSQL installation in such a manner such that > the contrib modules of the PostgreSQL distribution are stored in a specific > directory and they should use the PGXS extensions management system > supported by

Re: [GENERAL] Making changes to PostgreSQL's configure logic so as to have contrib modules installed in a specific directory and make them use PGXS?

Probably your best best is to install normally, then move the contribs to a directory of your choice and make a symbolic link from the old directory. That way it should work with both PostgreSQL and PGXS. On Tue, Jan 31, 2017 at 7:35 PM, Adrian Klaver wrote: > On

Re: [GENERAL] Making changes to PostgreSQL's configure logic so as to have contrib modules installed in a specific directory and make them use PGXS?

On 01/31/2017 03:04 PM, postgres user wrote: Hi, I want to configure my PostgreSQL installation in such a manner such that the contrib modules of the PostgreSQL distribution are stored in a specific directory and they should use the PGXS extensions management system supported by Postgres, as

[GENERAL] Making changes to PostgreSQL's configure logic so as to have contrib modules installed in a specific directory and make them use PGXS?

Hi, I want to configure my PostgreSQL installation in such a manner such that the contrib modules of the PostgreSQL distribution are stored in a specific directory and they should use the PGXS extensions management system supported by Postgres, as they are currently packaged along with Postgres

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

31.01.2017 19:51, Andres Freund: [...] Exactly same trouble with 9.4 (Specifically EDB 9.4.10-1 win32) That's good to know, less because of 519b0757, more because of the latch changes - but they also went in in 9.5... Would it make sense to check some even older ones? Could you use process

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

On 2017-01-31 11:45:33 +0300, Nikolai Zhubr wrote: > 31.01.2017 10:37, I wrote: > > [...] > > > > 1. "select localtimestamp" 40 times (As separate requests, one by > > > > one, but > > > > no delay inserted in between) > > > > 2. wait 1/2 second. > > > > 3. goto 1 > > > > > > Craig, could this be

Re: [GENERAL] Why is table not found?

Thank you all for your answers. You see: it is a newbie question. Egon Am 31.01.2017 um 14:45 schrieb Egon Frerich: > > I created a db 'Hausrat' with a table "Raum". If I look in pgadmin I > find the the table. In sql field is shown: > > > -- Table: "Raum" > > > -- DROP TABLE "Raum"; > > >

Re: [GENERAL] Why is table not found?

> On 31 Jan 2017, at 14:45, Egon Frerich wrote: >> >> CREATE TABLE "Raum" >> ( >> "RaumID" serial NOT NULL, -- Automatisch vergebenes > But psql tells me "Raum" is not existent: > >> egon@xfEinzel ~ $ psql Hausrat >> psql (9.3.15) >> Type "help" for help. >> >> Hausrat=#

Re: [GENERAL] Why is table not found?

On Tue, Jan 31, 2017 at 7:45 AM, Egon Frerich wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I created a db 'Hausrat' with a table "Raum". If I look in pgadmin I > find the the table. In sql field is shown: > > > -- Table: "Raum" > > > > -- DROP TABLE "Raum"; > >

Re: [GENERAL] Why is table not found?

You must quite as "Raum" > On Jan 31, 2017, at 6:45 AM, Egon Frerich wrote: > > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > I created a db 'Hausrat' with a table "Raum". If I look in pgadmin I > find the the table. In sql field is shown: > >> -- Table: "Raum" >>

Re: [GENERAL] Why is table not found?

Hello Egon, You created the table using delimited identifiers: "Raum" which is not the same as Raum of raum or RAUM When you use delimited identifiers (eg: "MyTable" instead of MyTable), the name becomes case sensitive. When you use SQL, you need to use delimited identifiers: select * from

Re: [GENERAL] Why is table not found?

On 31/01/17 13:45, Egon Frerich wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I created a db 'Hausrat' with a table "Raum". If I look in pgadmin I find the the table. In sql field is shown: -- Table: "Raum" -- DROP TABLE "Raum"; CREATE TABLE "Raum" ( "RaumID" serial NOT NULL, --

[GENERAL] Why is table not found?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I created a db 'Hausrat' with a table "Raum". If I look in pgadmin I find the the table. In sql field is shown: > -- Table: "Raum" > > -- DROP TABLE "Raum"; > > CREATE TABLE "Raum" > ( > "RaumID" serial NOT NULL, -- Automatisch vergebenes

Re: [GENERAL] using hstore to store documents

I think Xpath in postgresql is fast enough. I am dumping the raw xml file into a table and then generating data from it. I want all the data to be consistent thats why I am using a database. I am planning to use triggers to generate content of table1_master...table2_master, etc... master ->

Re: [GENERAL] Causeless CPU load waves in backend, on windows, 9.5.5 (EDB binary).

31.01.2017 10:37, I wrote: [...] 1. "select localtimestamp" 40 times (As separate requests, one by one, but no delay inserted in between) 2. wait 1/2 second. 3. goto 1 Craig, could this be a side-effect of 519b0757? That's new in 9.5, and that's directly related to the code paths discussed