[GENERAL] Composite types or composite keys?

Hi, I was reading about composite types and wondering if I should use them instead of composite keys. I currently have tables like this: create table products ( source_system text, product_id text, description text, ... primary key (source_system,

[GENERAL] Postgres Server backend process

Hello, I was going through http://www.postgresql.org/files/developer/tour.pdf and the source at http://doxygen.postgresql.org/postmaster_8c_source.html The pdf shows the daemon process doing authentication and spawning a process to handle the request from the client. The code has these comments

Re: [GENERAL] pg_trgm module: no convertion into Trigrams on one side when comparing

Hi Amit, Do you think it would by difficult to edit the source and wirte a new function, wich does it?   Janek Sendrowski -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Postgres Server backend process

Jayadevan M wrote: The code has these comments - When a request message is received, we now fork() immediately. The child process performs authentication of the request, Now authentication is done by the Backend process and not by the daemon? Yes. The authentication is called in

[GENERAL] counterpart to LOAD

Hi @all, ist there (in 9.1) a way to unload a shared lib? It seems it's impossible since 8.1 or so, i'm right? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Install pg_trgm from source

Hi, I like to change the source code of the pg_trgm extension a little bit. Where can I get the source code and how do I compile it? I can only find the SQL-files of pg_trgm in my directories. Janek Sendowksi

Re: [GENERAL] counterpart to LOAD

Andreas Kretschmer wrote: ist there (in 9.1) a way to unload a shared lib? It seems it's impossible since 8.1 or so, i'm right? Yes: http://www.postgresql.org/docs/9.3/static/xfunc-c.html#XFUNC-C-DYNLOAD (Presently, unloads are disabled and will never occur, but this may change in the

Re: [GENERAL] Install pg_trgm from source

On Fri, Nov 15, 2013 at 10:00 PM, Janek Sendrowski jane...@web.de wrote: Hi, I like to change the source code of the pg_trgm extension a little bit. Where can I get the source code and how do I compile it? If you have fetched a tarball of Postgres or git copy, simply have a look in

Re: [GENERAL] Install pg_trgm from source

Thanks a lot for your Answers.   That's what I was looking for. I couln't find it. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Composite types or composite keys?

On Fri, Nov 15, 2013 at 2:01 AM, Tony Theodore tony.theod...@gmail.com wrote: Hi, I was reading about composite types and wondering if I should use them instead of composite keys. I currently have tables like this: create table products ( source_system text, product_id

Re: [GENERAL] Push predicate down in view containing window function

On Fri, Nov 15, 2013 at 12:43 AM, Philippe Girolami philippe.girol...@sensorly.com wrote: Ok so is there a way i can do something similar ? Would a function returning rows and taking the extra predicate 'values' as parameters be as optimized as the 'good' query in my first email ? There is

[GENERAL] PGSQL: listing db/role and user/role relationships

Hi all, How can I retrieve: 1) each role’s privileges on a given DB For example, if I do: “GRANT ALL PRIVILEGES ON DATABASE thedb TO therole”, how can I list this grant among others with access to “thedb”? 2) which users have access to a given role For example, if I do: “GRANT

Re: [GENERAL] Partitioned table question

On 11/13/2013 06:22 AM, Torsten Förtsch wrote: Hi, we have a table partitioned by time. Each month goes into a separate child table. Primary key in each table is (underlying, ts). The resulting index is perfect for ordering like in the query below. Each child table has a constraint like:

[GENERAL] Save many data chunks to file

Hello! I have a table with image data: /CREATE TABLE images// //(// //id serial,// //image_data bytea,// //...// //);/ This is function for store image data to file: /CREATE OR REPLACE FUNCTION write_bytea ( p_data bytea, p_filename text )// //RETURNS void AS// //$BODY$//

[GENERAL] Postgresql Service and Server synch up issue.

Hi All, We are using postgreql 9.2 as a main backend server for our project. We have been using this server since last year. We have configured postgresql as a windows service. Till last week, we have not faced any issues to start server from service console management, but last week we

Re: [GENERAL] Add COPY statement inside sql function AND/OR call function within function

On 11/12/2013 12:56 PM, Johannes Björk wrote: Hi, Im hoping someone could help me with this. I am new to any kind of sql coding so bare with me. I have written the below working function which I would like to print to .csv file(s) |CREATE FUNCTION retrieve_info(input_method TEXT,

[GENERAL] log_line_prefix

Hi, I was trying different options of log_line_prefix. I am making chnages, doing a pg_ctl reload and checking the output in the log files. For some reason ,the changes seem to have no impact. What am I doing wrong? Here is the output form the log files where you can see the change being accepted

[GENERAL] Re: Add COPY statement inside sql function AND/OR call function within function

Johannes Björk wrote Hi, Im hoping someone could help me with this. I am new to any kind of sql coding so bare with me. I have written the below working function which I would like to print to .csv file(s) CREATE FUNCTION retrieve_info(input_method TEXT, input_species TEXT) RETURNS SETOF