Re: [GENERAL] Using Postgres to store genetic data

g like Gene ->1..n-> Sequence(s) ->1..n-> GCATPermutations thanks, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein

Re: [GENERAL] Can I have a look at your TuningWizard generated config file?

wide shmall could be ceil(shmmax/PAGE_SIZE) http://www.puschitz.com/TuningLinuxForOracle.shtml#SettingSharedMemory PAGE_SIZE determined by $ getconf PAGE_SIZE 4096 Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de

Re: [GENERAL] explicit JOIN faster than implicit?

here is my best -> worst join scenario starting with best 1)low cardinality tables 2)where or join on indexed columns 3)function indexes 4)concatenated indexes . 5)cartesian join ..every row join specifically joins every other row from every other table Martin Gai

[GENERAL] Proxy for postgres

eplacing direct access, an I'm trying to avoid this. Another option is pgpool, but I see too much lock in tables at transactional queries, and I'm pretty sure this will make my life a lot harder. So the question is, what can I use as a proxy queries to different instances of postgres? Cheer

Re: [GENERAL] Proxy for postgres

On Fri, 2009-08-14 at 10:03 -0700, John R Pierce wrote: > Martin Spinassi wrote: > > I'm searching for something to use as a proxy for different instances of > > postgres. > > ... > > So the question is, what can I use as a proxy queries to different > > inst

Re: [GENERAL] Proxy for postgres

On Fri, 2009-08-14 at 11:04 -0700, John R Pierce wrote: > Martin Spinassi wrote: > > I've been playing around with slony, and as far it didn't make me jump > > of happiness, I think is my better option to use slony for that, > > updating just the master, let slo

Re: [GENERAL] Proxy for postgres

On Fri, 2009-08-14 at 11:36 -0700, John R Pierce wrote: > Martin Spinassi wrote: > > So, what you suggest is: > > > > |-> Master <---| > > pg_pool2 ---||- Slony > > |-> Slave<

Re: [GENERAL] Configuration Question

PostgreSQL programs. Alternatively, set the environment variable LD_RUN_PATH. See the ld(1) man page for more information. either LD_LIBRARY_PATH or LD_RUN_PATH should contain binary folder Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note

Re: [GENERAL] Out of memory on pg_dump

Chris- did you look at Zdenek Kotala's pgcheck ? http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/pgcheck/pgcheck/src/ download 3 source files and run makefile anyone know of a PG integrity checker ? Martin Gainty __ Verzich

Re: [GENERAL] ETL software and training

et me know if i can be of any assistance to your effort Thanks, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitte

Re: [GENERAL] Import data from XML file

Erwin did you try ems-data? http://ems-data-import-2007-for-postgresql.software.informer.com/3.0/ Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

Re: [GENERAL] Viable alternatives to SQL?

as in native SQL, or with an object-oriented Criteria and Example API." Hibernate currently supports the following databases Microsoft SQL Server 2005/2000OracleMicrosoft AccessFirebirdPostgreSQLDB2 UDBMySQLSQLite https://www.hibernate.org/ Mar

Re: [GENERAL] [Skytools-users] WAL Shipping + checkpoint

l? If they remain constant, maybe the logs are just not applied. Also, are there any "restored log file xxx from archive" entries in postgres log? regards, Martin -- 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] [Skytools-users] WAL Shipping + checkpoint

This is logged with DEBUG2, so it should be visible if you set the logging level accordingly. Alternatively, you could attach a debugger to the recovery process and see if the RecoveryRestartPoint() and CheckPointGuts() functions are called at all. regards, Martin -- Sent via pgsql-general maili

Re: [GENERAL] Anybody know where to find Dan Langille?

i think he went to myyearbook.com http://www.linkedin.com/in/danlangille lucky guy! Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger

Re: [GENERAL] Snow Leopard and PG 8.4 problems....

for superusers only dblink-connect takes a libpq style connection string with hostaddr as first attribute dblink("hostaddr=127.0.0.1 port=5432 dbname=mydb user=postgres password=mypasswd"); http://www.postgresql.org/docs/current/static/contrib-dblink-connect.html Mar

Re: [GENERAL] where clause question

you'll need to create an alias beforehand SELECT foo.foo_id, foo.name FROM foo, (SELECT * FROM foo, bar WHERE ...) bar WHERE foo.bar_id = bar.bar_id AND bar.name = 'martini'; Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Not

Re: [GENERAL] How to store data on an external drive

your tables are probably not using the new default tablespace SET default_tablespace = new_tablespace_name any new tables will be placed into new default tablespace by inserting TABLESPACE clause can you put the WHOLE database on the external drive? Martin Gainty

Re: [GENERAL] Adding integers ( > 8 bytes) to an inet

9,223,372,036,854,775,807 boundary i think you discovered the bug! if you feel you have a solution try submitting a patch http://wiki.postgresql.org/wiki/Submitting_a_Patch please ping ping pgsql-hack...@postgresql.org Good Catch! Martin Gainty __ Verzicht

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

*losing money* on this one guys Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

how many PB&J did you make before arriving there? any restaurant in NYC but mickey D's does COST that much this is decidedly O/T so lets take this discussion offline Martin Gainty __ Verzicht und Vertraulichkeitanmerkung Diese Nach

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

get you a lawsuit .. Bye Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung.

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

in the US anyone making false statements about anyone is subject to a libel lawsuit if you want to change that law i suggest you become a lawyer Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese

Re: [GENERAL] I need a Postgres Admin $130K + 20K in NYC Any Ideas?

Amen! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte

[GENERAL] 'Weird' errors

why does initdb choke on these system calls but cygwin command line works fine? Postgres version>postgresql-8.4.1 $ cygcheck -V cygcheck version 1.90.4.1 System Checker for Cygwin Copyright 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006 Red Hat, Inc. Compiled on Jun 12 2008 apologies

Re: [GENERAL] 'Weird' errors

specifically postgres cannot access the server configuration file "/cygdrive/c/Postgres/pgsql/data/postgresql.conf' is there a foolproof way that I will allow postgres to access postgresql.conf? thanks! Martin Gainty __ Ve

Re: [GENERAL] 'Weird' errors

contents thanks, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte

Re: [GENERAL] 'Weird' errors

DR-ADDRESS METHOD local all all trust #END pg_hba.conf start PG VERSION 8.4 END PG_VERSION file $ /cygdrive/c/postgres/pgsql/bin/pg_ctl -D "/pgsql/data" -l logfile start server startin

Re: [GENERAL] Return 30% of results?

//Display the top 40 % of rows in BB_DEPARTMENT SQL> select ROWNUM,ID FROM EMPLOYEES WHERE ROWNUM < .3*(SELECT COUNT(ID) FROM BB _DEPARTMENT) GROUP BY ROWNUM,ID; ROWNUM -- 1 HTH Martin Gainty __ Verzic

Re: [GENERAL] Re: PL/PG SQL: select count(*) into from where - does not compute the where cond - returns always total count

the "does not compute the where condition" needs more definition can you supply the table schema and which columns you want? select count(*) from table will get you the count We can banter on the need to store in views once the schema is known Mar

[GENERAL] Source for CreatedSharedMemoryAndSemaphores

Hello All experiencing a problem with build not finding function CreatedSharedMemoryAndSemaphores any ideas to locate source and or build files for CreatedSharedMemoryAndSemaphores would be appreciated thanks! Martin Gainty __ Verzicht und

Re: [GENERAL] Source for CreatedSharedMemoryAndSemaphores

yep its in /backend/storage/ipci/ipci.c for some reason after i compile backend and try to link postgres i'm missing ipci.o ? i'll append into ipci.o into OBJS and give it a go Thanks Tom! Martin Gainty __ Verzicht und Vertraulichkei

Re: [GENERAL] Source for CreatedSharedMemoryAndSemaphores

) header which means they are native windows binaries been a while since ive compiled/linked binaries but if I can get the 1.4 cygipc source I should be able to compile/link and get a functioning binary for IPC functions thanks tom Martin Gainty

[GENERAL] psql: FATAL: role "postgres" does not exist

All- when starting postgres what does this error mean exactly? psql: FATAL: role "postgres" does not exist what is the exact solution for psql: FATAL: role "postgres" does not exist error? thank you Martin Gainty

Re: [GENERAL] psql: FATAL: role "postgres" does not exist

cant get in at all with psql netstat shows the listener is up on 5432 trying with pgAdmin3 Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene

Re: [GENERAL] psql: FATAL: role "postgres" does not exist

rs databases and tables now btw:those ipc libraries seemed to be wrapped around the axle of elog statements but thats another topic i commented out elog and replaced with printf..and all the ipc errors went away thanks scott! Martin Gainty __ Verzic

[GENERAL] CREATE LANGUAGE workaround

'/postgres/pgsql/bin/plpgsql.dll' LANGUAGE C; CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER pg_finfo_plpgsql_call_handler; is there a system defined script I can run which would map the plpgsql handler to the plpgsql type automatically? thanks! Mar

Re: [GENERAL] computed values in plpgsql

Reid- shoehorn a variable into EXECUTE statement which will be casted as text and then do a substring to acquire extracted results EXECUTE ''INSERT INTO payments_'' ||select * from substring(CAST(import_ts::date AS text) from 0 for 7) || VALUES(NEW.*) || '';

Re: [GENERAL] bulk inserts

copy http://www.postgresql.org/docs/8.1/interactive/populate.html cheers, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sei

Re: [GENERAL] Procedure for feature requests?

is there a way to create a cast with assignment e.g.? CREATE CAST ((date,date) AS int4) WITH FUNCTION generate_series(date,date) AS ASSIGNMENT;http://www.postgresql.org/docs/8.4/static/sql-createcast.html ? Martin Gainty __ Verzicht und

Re: [GENERAL] Embarassing GROUP question

IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. what types of caching issues are you experencing? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung

Re: [GENERAL] Postgres won't start. Nothing in the log.

did you install (i should say register) postgres and pg_ctl binaries as postgres user are you executing postgres and pg_ctl binaries as postgres user ? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese

Re: [GENERAL] interface for "non-SQL people"

oracle handles html output with packages ..i would assume pg would have similar sgml output capability? crystal has been limited to ODBC dsn (datasources) althogh sap seem to be open to a more Opensource approach using JDBC based data sources Martin Gainty

Re: [GENERAL] Free Tool to design Postgres Databases

Geometry and or WKT parameters which map to core Postgres tables - Postgis.c Would appreciate any documentation which identified core functions, maps base core functions to actual c file names (and ot their library names) *gruss* Martin Gainty

Re: [GENERAL] PHP + PDO + PGPOOL = Segmentation fault

cause of this error greetings Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede

[GENERAL] uuids with btree_gist

t=# create table v(item text, lifetime tstzrange, value text, test(# exclude using gist (item with =, lifetime with &&)); CREATE TABLE test=# Is there any reason that the required uuid access method isn't implemented? How hard is it to implement this? Thanks, Martin -- Sent via

[GENERAL] Spurious error messages from pg_restore

When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database into a new, blank database it generates thousands of error messages like this: pg_restore: [archiver (db)] could not execute query: ERROR: schema "myschema" does not exist Command was: DROP INDEX myschema.some_index

Re: [GENERAL] Generic function for partitioning function?

d NOT do > this. I must confess, it seems so straightforward that I feel like I > must be missing something. I do something similar with my OpenERP setup. The only caveat I have is that foreign key constraints don't work with partitioned tables. Martin -- Sent via pgsql-genera

Re: [GENERAL] Spurious error messages from pg_restore

ould want any existing function with the same signature to be overwritten. On 04.09.2013 18:20, Adrian Klaver wrote: On 09/04/2013 07:02 AM, Evan Martin wrote: Also, even without --clean I get 3 errors: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Erro

Re: [GENERAL] Spurious error messages from pg_restore

Johnston wrote: Evan Martin wrote Also, even without --clean I get 3 errors: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE geometry_columns_delete em pg_restore: [archiver (db)] could not execute query: ERROR: rule

Re: [GENERAL] Spurious error messages from pg_restore

though, and such pain points are unnecessary. Backups and restores should "just work". They do in MSSQL and I think they can in Postgres, too. Regards, Evan On 04.09.2013 23:26, David Johnston wrote: Evan Martin wrote When I use pg_restore with --clean to restore a PostgreSQL 9.2.

[GENERAL] Danger of renaming an enum label?

I'd like to rename one of the labels of an enum in PostgreSQL 9.2 This can easily be done by updating pg_enum, as described at http://tech.valgog.com/2010/08/alter-enum-in-postgresql.html but I'd like to understand: what is the danger of doing so? If, as the post says, the data only references

[GENERAL] Drop all overloads of a function without knowing parameter types

Hi All, Is there any easy way to drop a function (all overloads of it) without knowing the parameter types? If not, it would be good to see it added. When I change a function definition I just want to run the SQL script that defines it and have any existing function replaced. CREATE OR REPLA

Re: [GENERAL] Drop all overloads of a function without knowing parameter types

ads of a given function name..." Regards, Evan On 03/02/2014 19:09, Tom Lane wrote: Evan Martin writes: Is there any easy way to drop a function (all overloads of it) without knowing the parameter types? Something along the lines of do $$ declare fname text; begin for fname in sel

Re: [GENERAL] Drop all overloads of a function without knowing parameter types

In a nutshell: I think the difficulty of dropping functions is inconsistent with the difficulty of dropping other objects and I'd like to see this inconsistency fixed. So I don't agree with the suggestion of matching function names using a regex, since that's not supported for other types of o

Re: [GENERAL] Re: Drop all overloads of a function without knowing parameter types

On 04/02/2014 19:56, David Johnston wrote: No, they cannot. If the arguments change you are dealing with an entirely new object. And often you end up keeping the old function around for backward-compatibility. Of course, I understand that it's a different object, technically, but from the user

[GENERAL] CET ERROR: requested WAL segment has already been removed

#x27;s possible that I've lost data somewhere. Is there anything sensible I can do beyond restoring from the last good backup? Thanks Martin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Efficiently delete rows not referenced by a foreign key

Hi All, I have a database schema where if row is deleted from one table the rows it references in another table should also be deleted, unless still referenced by something else. Eg. Table A has foreign key to table B. When I delete a row from A I also want to delete the referenced row in B,

Re: [GENERAL] Dump Database

pgsql-general-ow...@postgresql.org wrote on 17/03/2014 12:50:20: > From: José Pedro Santos > To: Postgres Ajuda , > Date: 17/03/2014 12:56 > Subject: [GENERAL] Dump Database > Sent by: pgsql-general-ow...@postgresql.org > > Dear all, > > I'm trying to dump my database using the following comm

Re: [GENERAL] plpython module import errors

rence python5 or python6 the correct version you can also setup an alias in the .bashrc to point to the 'right version' *friends dont let friends code in python* Martin __ Note de déni et de confidentialité Ce message est confidenti

Re: [GENERAL] Looking for Silicon Valley/Peninsula/San Francisco users group

http://sfbayarea.fullcalendar.com/ec/org/1419 please give a quick hello to Larry Ellison for me! l8r Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas

Re: [GENERAL] SSDD reliability

what is this talk about replicating your primary database to secondary nodes in the cloud.. or is cloud computing still marketing hype? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

Re: [GENERAL] What is the average salary for Postgresql DBA

WashingtonDC-NY corridor is 100k+ greater Boston is averaging 50k. (depends on where you want to go) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

Re: [GENERAL] Postgres errors in Drupal install.

Dave and John drupal is built on php php is a binary which plays by the memory limitations posted in php.ini php.ini: memory_limit=32M ; Maximum amount of memory a script may consume (32MB) crank that down if Drupal is exhausting heapspace Martin Gainty GMT+5 (this week

Re: [GENERAL] [PERFORM] DELETE taking too much memory

How up to date are the statistics for the tables in question? What value do you have for effective cache size? My guess would be that planner thinks the method it is using is right either for its current row number estimations, or the amount of memory it thinks it has to play with. -Origina

Re: [GENERAL] [PERFORM] DELETE taking too much memory

iate stats target, and then explaining the query again to see if it's more accurate. Cheers -Original Message- From: Vincent de Phily [mailto:vincent.deph...@mobile-devices.fr] Sent: 08 July 2011 10:20 To: French, Martin Cc: pgsql-general@postgresql.org; pgsql-performa...@postgresql.

Re: [GENERAL] Programmer ( Postgres), Milwaukee - offsite-Remote - onsite

Hi Gavin I do'nt believe Rao would discriminate against anyone that speaks the Kings English. If you want to stay in NZ Did you try sending a resume to den...@sosnoski.com http://www.sosnoski.co.nz Dennis' expertise is web-servicesHTH, Mar

Re: [GENERAL] Russian Language Spam

11/08/why-russians-fear-august/ Validimir is up to his old tricks. Martin Gainty __ Trust ...but verify..Ronald Reagan > Date: Sun, 7 Aug 2011 23:00:53 -0700 > From: pie...@hogranch.com > To: pgsql-general@postgresql.org > Subject: Re: [GENE

[GENERAL] Plans to fix table inheritance caveats

Hi, Are there any plans to fix the caveats documented in section 5.8.1, particularly allowing rows in a derived table to satisfy a foreign key defined on a base table? I know it's on the TODO list ( http://wiki.postgresql.org/wiki/Todo#Inheritance ) - just wondering if anyone is actually work

[GENERAL] Please make it easy to drop a database that is in use

Hi All, When I'm developing against a PostgreSQL database I often drop and re-create it and I often find that the drop fails, because it's "in use by other users". This is really annoying, especially when I know full well there are no other users - it's just me. I'm aware of the workaround:

Re: [GENERAL] Please make it easy to drop a database that is in use

privileges, which I don't think should be required to drop your own database. Regards, Evan On 20/06/2012 10:51 PM, Sergey Konoplev wrote: On Tue, Jun 19, 2012 at 1:40 PM, Evan Martin wrote: When I'm developing against a PostgreSQL database I often drop and re-create it and I often

Re: [GENERAL] Please make it easy to drop a database that is in use

On 21/06/2012 10:20 PM, Sergey Konoplev wrote: On Thu, Jun 21, 2012 at 2:03 PM, Evan Martin wrote: 1) The workaround requires extra work for each developer (or at least each client application) using PostgreSQL, while a fix in PostgreSQL would solve this once and for all. It is not clean what

Re: [GENERAL] Please make it easy to drop a database that is in use

On 22/06/2012 12:07 AM, Tom Lane wrote: SELECT pg_terminate_backend(procpid) FROM pg_stat_activity WHERE datname = 'dropme'; ERROR: must be superuser to signal other server processes As far as that goes, there's a pending patch to reduce the privileges required to use pg_terminate_backend. I'm

[GENERAL] question about installation

se.Or will postgres-installation simply notice i already have a data folder there and ask if i want to share this?Could you please guide me through the path of how to install postgresql on the 2nd computer, so that both computers share their data in the same folder..I used postgresql 8.4Regards,Martin

Re: [GENERAL] How to stop a query

As Scott mentioned, kill -9 on a Postgres process is not a wise idea on a Postgres process.If you query is coming from another application, then terminating that application with a kill -9 *may* work, but is, as scott says, a last resortI tend to use kill -TERM (15) to disconnect the client, which

Re: [GENERAL] At what point does a big table start becoming too big?

> > I have a table with 40 million rows and haven't had any performance > issues yet.> > Are there any rules of thumb as to when a table starts getting too big?> > For example, maybe if the index size is 6x the amount of ram, if the> table is 10% of total disk space, etc?> > > -- > My rule here is

Re: [GENERAL] At what point does a big table start becoming too big?

> > >> > > I have a table with 40 million rows and haven't had any performance> > > issues yet.> > >> > > Are there any rules of thumb as to when a table starts getting too big?> > >> > > For example, maybe if the index size is 6x the amount of ram, if the> > > table is 10% of total disk space, etc

Re: [GENERAL] Need psql send email

->datasend("From:" . $sender . "\n"); $mail->datasend("To:" . $recipient . "\n"); $mail->datasend("Reply-To: ". $sender . "\n"); $mail->datasend("Subject:" . $subject

Re: [GENERAL] Need psql send email

/ApacheHTTPServer then allow those scripts (PL-SQL or Perl or Java) to invoke sendmail to the SMTPMailServer inside the firewall If you are sponsoring your own email-server and I hope you are DISALLOW OPEN RELAY Martin Gainty __ Verzicht und

Re: [GENERAL] Need psql send email

you just have to weigh up the options and choose the best one for your situation/application. Cheers Martin = Romax Technology Limited Rutherford House Nottingham Science & Technology Park Nottingham, NG7 2PZ England Telephone numbers: +44 (0)115 951 88

Re: [GENERAL] Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version();

8.4. Martin -- 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] migrate from PostgreSQL to Oracle

squirrel http://www.squirrelsql.org/index.php?page=plugins Saludos desde EEUU Martin __ Porfavor ..no altere o interrumptir esta communicacion > Date: Thu, 25 Oct 2012 15:50:08 +0200 > From: jose.soa...@sferacarta.com > To: pgsq

Re: [GENERAL] remote connection refused

Usually, after what you've already confirmed, it's likely to be one of the following: - check "listen_address" is set correctly in postgresql.conf. (try "listen_address = *" and restart postgres) - check port 5432 is open on iptables. (service iptables status, netstat -a | grep 5432) Cheers

Re: [GENERAL] Problem with aborting entire transactions on error

> if { no error during query } { > do it > } else { > withdraw this one > if { ROLLBACK_ON_ERROR } { >rollback entire transaction > } > } I fear that this is no-where near as simple as it's been taken for, and without looking at the code, I would imagine that this would touch so

[GENERAL] C Function Memory Management

Ok, so just a (hopefully) quick question. I know that I should be using the Postgres function palloc in place of malloc, but what about realloc? Is there an equivalent? Thanks. = Romax Technology Limited Rutherford House Nottingham Science & Technolo

Re: [GENERAL] C Function Memory Management

Hi Pavel > > yes, > > repalloc > Maybe I should've looked a little harder for that one! Ha Ha! I assume it's an exact functional copy of realloc, and see where I get with it! Many Thanks. = Romax Technology Limited Rutherford House Nottingham Sc

Re: [GENERAL] C Function Memory Management

not necessary to preserve the data once the function is complete. So out of curiosity, what would be your approach for data preservation cross call? Cheers Martin = Romax Technology Limited Rutherford House Nottingham Science & Technology Park No

Re: [GENERAL] C Function Memory Management

t; Postgres source code. If you are looking to cache data longer than > one query then it takes more thought. > > regards, tom lane Thanks Tom. I'll have a look into this when I have more time. Kind Regards. Martin. = Romax

Re: [GENERAL] cannot load server.crt

t After Date" 3)make sure Signature matches Public Key4)Make sure Issuer CN (Canonical Name) is from a valid Certificate Authority (such as Verisign, Thawte) Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité

Re: [GENERAL] OneCNC XR5 3D Mill Expert v30.43 Crack

exactly what are the Latitude and Longitude coordinates of your company in China? Martin __ Verzicht und Vertraulichkeitanmerkung Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine

Re: [GENERAL] New Zealand Postgis DBA job vacancy

Gavin BTW: Americans dont walk anywhere ..we drive our 2 gallons to the mile Hummers everywhere we go (so Im hoping that gas is cheap there) I dont know anything about New Zealand but can one live on South Island and work on North Island and or vice-versa? Ich spreche kein Arabisch Martin

Re: [GENERAL] New Zealand Postgis DBA job vacancy

until 1 Jan 2013! so...why doesn't Postgres port to embedded systems? Martin Gainty __ ...place long-winded disclaimer here... Date: Thu, 27 Dec 2012 08:45:22 +1300 From: gavinflo...@archidevsys.co.nz To: adrian.kla...@gmail.com CC: mgai...@hotmai

Re: [GENERAL] New Zealand Postgis DBA job vacancy

ured tables (eliminates > the need to write lots of special parsers to be able to impose > structure on what would otherwise be unstructured "bytes") > MG>so do you reduce CPU or IO when you take a java variable final int foo=1; > and insert foo as a const column in a t

Re: [GENERAL] OneCNC XR5 3D Mill Expert v30.43 Crack

number I am unableto answer your query without those details Martin Gainty __ alteration or disrupt this transmission of electronic transmissions is a violation of US Federal Statutes and will be prosecuted to the fullest extent of applicable Federal

Re: [GENERAL] optimalisation with EXCEPT clause

r, if there is a tool (something like an index on all colums) available in the database itself, I would be eager to use it. Thanks again, Winco > -- > GJ * From: "Kincel, Martin" * To: * Subject: optimalisation with EXCEPT clause * Date: Tue, 13 Apr 201

Re: [GENERAL] partitioned lookup table?

Andreas- I have marched to the Oracle drumbeat of partitioning table instead of using FK constraint for years Are there timings which show FK constraint a better alternative than partitioning? Martin Gainty __ Jogi és Bizalmassági

Re: [GENERAL] Avoiding surrogate keys

cents martin- __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder

Re: [GENERAL] Creating indexes?

=864.0 HTH Martin Gainty “I shall take all the troubles of the past, all the disappointments, all the headaches, and I shall pack them in a bag and toss them in the East River.” - Trygve Lie __ Note de déni et de confidentialité Ce message est confidentiel

Re: [GENERAL] Catch exception from plpy

ot; return "test_tryex function has succeeded"' ' LANGUAGE plpythonu; Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorge

Re: [GENERAL] Writing SRF

with those configuration settings Saludos Cordiales desde EEUU! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoefli

<    1   2   3   4   5   6   7   >