Re: [GENERAL] Problem with pl/python procedure connecting to the internet

In cases like this I normally restart the progresql under strace/truss etc and then wade through the output, it will normally tell me which process was invoked. On 23/08/15 18:49, Tom Lane wrote: Igor Sosa Mayor joseleopoldo1...@gmail.com writes: Adrian Klaver adrian.kla...@aklaver.com writes:

[GENERAL] returning only part of a rule set

I have a psql function that make a general sql query, returns a set of results Q. Is there anyway that I can limit the size of the result sets ? Dave. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:

Re: [GENERAL] returning only part of a rule set

On 25/11/14 21:36, Adrian Klaver wrote: On 11/25/2014 01:27 PM, Dave Potts wrote: I have a psql function that make a general sql query, returns a set of results Q. Is there anyway that I can limit the size of the result sets ? Put a LIMIT on the query. If that is not what you want then we

Re: [GENERAL] returning only part of a rule set

On 25/11/14 22:24, David G Johnston wrote: Thanks List, I think this is the right way to go. Adrian Klaver-4 wrote If I am only interested in get 2 entries per result set, I would expect to see Actually =2. How do you determine which rows to keep, by id or something else? 1 xx,yy 2 xx,yy

[GENERAL] Partitioning V schema

Hi List I am looking for some general advice about the best was of splitting a large data table,I have 2 different choices, partitioning or different schemas. The data table refers to the number of houses that can be include in a city, as such there are large number of records. I am

[GENERAL] debugging postgres server memory checker

hi List, As a result of writing a C 'postgres' function, I have a memory corruption problem. Something is either being free twice or I am accessing beyond the data structure and corrupting the malloc/free/sbrk memory pool. My attempts to memory support in glibc, that been stopped because

[GENERAL] How to debugging a an external C function(IMMUTABLE STRICT )

Hi I have written an external C function to be called by postgres called using the LANGUAGE 'C' IMMUNTABLE STRICT interface Most of the time when call it, I get the expected results. Some times I get random rubbish in the result set. Postgres always gets the type of the arguments correct, ie it

[FIXED] Re: [GENERAL] problems connecting to php via pg_connect and PGCLUSTER

Thanks guys its sorted. Both your suggestions worked :-) Scott Marlowe wrote: On Mon, Feb 6, 2012 at 4:03 PM, Dave Potts dave.po...@pinan.co.uk wrote: I have two versions of postgres installed, 8.4 and 9.1 installed on the same machine To connect to my 9.1 database, I defined

[GENERAL] problems connecting to php via pg_connect and PGCLUSTER

I have two versions of postgres installed, 8.4 and 9.1 installed on the same machine To connect to my 9.1 database, I defined the envromental variable PGCLUSTER=9.1/main and use psql to connect via php pg_connect I have try saying define(PG_OPTIONS , --cluster=9.1/main); and using the

Re: [GENERAL] problems connecting to php via pg_connect and PGCLUSTER

with pg_connect wrote: On 07/02/12 10:03, Dave Potts wrote: I have two versions of postgres installed, 8.4 and 9.1 installed on the same machine To connect to my 9.1 database, I defined the envromental variable PGCLUSTER=9.1/main and use psql to connect via php pg_connect I have try saying

[GENERAL] default database selector

I am running Ubuntu 11.04, I have Postgres 8.4 and 9.1 installed. My default when I say psql it connects to postgres 8.4 ie I set export PGCLUSTER=9.1/main it connects to 9.1 Q. How can I connect to 9.1 by default without having to set PGCLUSTER? I looked in /etc/postgresql-common, there

[GENERAL] debugging the server[ module causes server cash]

Hi I have just inherited a private C module that lives in the context of the server with little or no documentation. It crashes taking the database down, is there any advice on how to debug this type of beast ? This is not a problem with the postgres server but user module. -- Sent via

[GENERAL] Loading long lat values converting degrees to decimal values

Hi List I am trying to load some data points stored as lat/long values Q. Do I convert the degree values (0-59.59) to a decimal value in range 0-100, or is setting the right srs value good enough? Dave. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

[GENERAL] Loging of postgres requests

I am using a 3rd front end to generate postgres requests , its reportng an error with the database. Is there anyway of loging which sql requests the application is actual sending to postgres. I need to known if the error is being created by the application generating invalid SQL or if

Re: [GENERAL] Loging of postgres requests

log_min_duration_statement to 0, then it will log ALL statements, which could also give you what you want if you want to see all SQL statements. Terry Terry Fielder [EMAIL PROTECTED] Associate Director Software Development and Deployment Great Gulf Homes / Ashton Woods Homes Fax: (416) 441-9085 Dave

Re: [GENERAL] pain of postgres upgrade with extensions

Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 - dump version N database - create empty version N+1 database - install N+1's version of each needed contrib module into new database - restore dump, ignoring object already exists errors There is a TODO to

[GENERAL] postgres schema printer

Is there such a thing as an opensource schema printer for postgres ? Dave. begin:vcard fn:David Potts n:Potts;David x-mozilla-html:FALSE version:2.1 end:vcard ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster