[GENERAL] Postgres version number support

Which versions of Postgres support LOB? Which versions of Postgres does Hibernate 3.2.6..(Gavin left no clues in the Hibernate docs)?Thanks! Martin Gainty __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni

[GENERAL] PostgreSQL 8.4 tar

Hi Guys anyone know where I can zip or tar version of PostgreSQL 8.4 ? Thanks! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité. Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger

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] New Zealand Postgis DBA job vacancy

> From: bexley...@yahoo.com > To: pgsql-general@postgresql.org > Subject: Re: [GENERAL] New Zealand Postgis DBA job vacancy > > > Thinking (entirely) *in* metric doesn't. The problem is working > with *both*, simultaneously, requires some mental agility. > > Nearby, we have one of the few (only

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

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] 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 Mitt

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] 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: pgsql-general@postgresql.

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] 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

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] 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] 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] 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 vertrauli

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. Ha

Re: [GENERAL] plpython module import errors

you will have to compensate for python's version-i*i*t*c behaviour by naming the binary to the exact version of python you are calling e.g. mv python python5 (for python version 5 binary) mv python python6 (for python version 6 binary) then in each of the bash scripts you are calling reference p

[GENERAL] ..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language..

..horribly documented, inefficient, user-hostile, impossible to maintain interpreted language.. to whom might you be alluding to ??? Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich.

Re: [GENERAL] Web Hosting

Gentlemen- Go-daddy *claims* to support postgres http://help.godaddy.com/article/2330 YMMV Martin-- __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfa

Re: [GENERAL] A question about timezone

Good Afternoon select to_char(current_timestamp, 'Day') at time zone 'CET' produces Wednesday for Berlin Martin __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalm

Re: [GENERAL] plpyhton

depends on the configuration implemented to enable caching capability for each type *usually* fastest access can be achived by implementin a Procedure which loads into Procedure Cache allowing consequent accesses to the Procedure 'in memory' (vs Disk I/O) Mar

Re: [GENERAL] Query plan choice issue

a cursory look of the plan details a FTS on dbmail_headername invoked by the JOIN clause JOIN dbmail_headername n ON v.headername_id=n.id you would accelerate the seek appreciably by placing indexes on both participating columns v.headername_id n.id I also see a FTS on domain_headervalue invoke

Re: [GENERAL] SQL Programming Question

Hi Tony -- i usually INSERT the record --then check for PK VIOLATION e.g. IF PK_VIOLATION then UPDATE record is FoxPro still supported??? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

Re: [GENERAL] MySQL versus Postgres

implement row-level locking instead of just table-level locking? 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

Re: [GENERAL] Which CMS/Ecommerce/Shopping cart ?

only on apache is all you can hope for.. why not write it yourself? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so

Re: [GENERAL] Oracle Spatial and PostGis

rent Oracle sdo_filter 3rd param would need to be discarded looks like a hand conversion Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfa

Re: [GENERAL] Writing XML files to Operating System

case write to disk and transmit to p/l Looks like you've just added 12 line-items to the globaldatapoint bill! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten

Re: [GENERAL] NASA needs Postgres - Nagios help

Can you cron the nagios tasks? Sounds like an exciting job. Keep us apprised, Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger

Re: [GENERAL] NASA needs Postgres - Nagios help

safest path is to get the source code and build it..if you are unable to get the source..ping the author..if the author doesnt respond..implement that plugin or feature in another language..(perl/java/php would be my recommendation) keep us apprised, Martin Gainty

Re: [GENERAL] A thought about other open source projects

int Lock(String driver_string_stack_param) if(driver_string_stack_param.equalsIgnoreCase("com.mysql.jdbc.Driver") ; //noop else{ // do Lock Logic } hth Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confi

Re: [GENERAL] [Blatant Alias Abuse] Anyone want to help out with a coding problem?

o you have connections at novell that have a working copy? Takk! Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez az üzenet bizalmas. Ha nem ön az akinek szánva volt, akkor kérjük, hogy jelentse azt nek

Re: [GENERAL] [Blatant Alias Abuse] Anyone want to help out with a coding problem?

keeping anything in RAM means your data will be lost forever when the session is lost..(then again if the data is garbage to begin with then throwing away garbage is no problem) if your data is NOT garbage then you're going to want to persist the data ..look at oracle/mysql and yes even SQL-se

Re: [GENERAL] vulnerability of COPY command

the VO and before any of the offending values get into the database The net effect is wireshark criminals are succeeding in making everyone's lives a living hell..the least we can do is take their pitchfork away! Martin Gainty _

Re: [GENERAL] Installing version 8.4

in windows you'll want to make sure you have at least read access to the binary %PG_HOME%\bin>attrib pg_ctl.exe make sure you implement the postgres binaries with the same username that postgres used to install the binary.. %PG_HOME%\bin>cacls.exe pg_ctl.exe Ma

Re: [GENERAL] INSERTing lots of data

Good Afternoon Szymon! Could you explain what a Python GIL is? and if there is any workaround to Python GIL we can implement to achieve better performance..possibly at the database level? Mit freundlichen Grüßen/Les plus sincères amitiés Martin Gainty

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

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] 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] Avoiding surrogate keys

bill- static information such as country names *should be* de-normalised into non-indexed columns of the driving table as you have already done if on the other hand the column information country names were changing were dynamic then you would want to keep them in their respective table as co

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] Time zone 'GMT+8'

there are 3 terms which refer to GMT GMT in the UK Zulu time for aviators UTC for Scientific measurements UTC is now replacing 'Zulu' and 'GMT' for 0 time references http://wwp.greenwichmeantime.com/info/zulu.htm Martin Gainty

Re: [GENERAL] C++ and Postgis

y not just take the extra step to rewrite to Java..yes it doesnt support multiple inheritance of classes but you *can implement multiple interfaces* Comments? Martin Gainty __ WARNING: Information contained may be deemed unsuitable for marketing, liber

Re: [GENERAL] Rejected token 3A37-A32F-9E8B

good catch on man in the middle forgery postmaster..keep up the good work! 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] pgp encryption functions

i have to ask ..any relation to guru charles petzold? http://en.wikipedia.org/wiki/Charles_Petzold Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der

Re: [GENERAL] Why are there pg_dump errors in my Apache httpd error_log ? (Postgres 8.3.7 on CentOS 5)

* define an error logfile for a # container, that host's errors will be logged there and not here. # ErrorLog logs/error.log Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertra

Re: [GENERAL] How to automatically find the *right* libpq_fe.h?

rties msgid=Speichern greeting=GutenTag item.edit={0} bearbeiten item.create={0} neu anlegen item.list={0}-Liste token.transfer.time=Die \u00dcberweisung wurde am {0,date,HH:mm:ss MM-dd-} durchgef\u00fchrt endTag=VielGluck firstName=Martin //to acquire localised key for jsp

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

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] 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] 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] 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] 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] 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] 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.*) || '';

[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] 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

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

[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] 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

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

[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] 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

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] 'Weird' errors

s > Date: Thu, 17 Sep 2009 17:25:07 -0400 > From: t...@sss.pgh.pa.us > > Martin Gainty writes: > > i flipped to my regular account and re-created the db with initdb -D > > newFolder > > i have noticed that initdb basically deletes everything ..and the reason &g

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

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

[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] 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

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?

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?

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?

*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] 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] 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] 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] 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] 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 se

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] 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] 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] 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] 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] 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

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] 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] Oracle Help in PG?

alot of Oracle experts answer t...@yahoogroups.com what is your oracle question? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger

Re: [GENERAL] Store derived data or use view?

i just asked NASA the same question I'll post the answer back to the list.. Martin Gainty We can lick gravity, but sometimes the paperwork is overwhelming. - Wehrner Von Braun __ Verzicht und Vertraulichkeitanmerkung/Note de déni

Re: [GENERAL] Switching from MySQL: ON DUPLICATE KEY UPDATE, plpgsql function

contempating installing a insert,update trigger on forums_topics table something like SET search_path = public; CREATE TRIGGER "MyTableName_Trig" AFTER INSERT OR DELETE OR UPDATE ON "forum_topics" FOR EACH ROW EXECUTE PROCEDURE "FORUM_CATCH_UP_ALL" (); HTH Martin

Re: [GENERAL] What's wrong with this query?

this SQL thing you speak of. On Sun, Jun 21, 2009 at 5:20 PM, Martin Gainty wrote: testcase for a null uuid? thanks, Martin __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Si

Re: [GENERAL] What's wrong with this query?

testcase for a null uuid? thanks, 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

Re: [GENERAL] Invalid statement name (null) in line ## - what am I doing wrong ?

can we see the original statement ? can you combine the 2 statements to produce the necessary cursor OPEN curs1 FOR EXECUTE 'SELECT * FROM ' || quote_ident($1);http://www.postgresql.org/docs/8.1/interactive/plpgsql-cursors.html takk Martin __ Verzic

Re: [GENERAL] 10 TB database

would suggest Oracle 11 for DB of 10TB or greater http://www.oracle.com/solutions/performance_scalability/tpc-h-10tb-11g.html Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich

Re: [GENERAL] Sum of multiplied deltas

Marc very concerned about the 'dirty' classification any suggestions? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfae

Re: [GENERAL] PL/PGSQL

mg>hopefully quick response Hello everybody, I'm Jordi from Spain, I'm new on this mailing list. I hope I could help anybody in the future but now I new some help because I read a lot of documentation but I can't find an answer. I have two questions:

Re: [GENERAL] PostgreSQL and XA Distributed Transaction Protocol

from what i can see here autocommit is not supported http://archives.postgresql.org/pgsql-jdbc/2009-01/msg00027.php Not sure if autocommit is part of the JTA spec? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de

Re: [GENERAL] Query timeout in dbcp

http://pgtclng.projects.postgresql.org/pgtcldocs-20070115/pgtcl-example-asyncevent.html an asynchronous callback that is called after specified number of secs and cancels the query re-posting to postgres users list for more clarification Martin Gainty

Re: [GENERAL] nooby q: how get a row just inserted?

yes i would suggest using OID included in Postgres distro is a sample create table,index named fti.pl does this answer your question? Martin Gainty __ Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Diese Nachricht ist

Re: [GENERAL] Switching databases over JDBC/ODBC

DB's but perhaps a vendor/contractor/consultant such as yourself may know of connection mechanism which would dynamically switch the original connection from old DB parameters to new DB parameters? Martin Gainty __ Jogi és Bizalmassági kinyilatkoz

Re: [GENERAL] Switching databases over JDBC/ODBC

does '\connect' work with Type-IV JDBC Database? can you effectively 'drop' the first DB connection and somehow read a different set of DB parameters to connect to a new DB? thanks, Martin Gainty __ Verzicht und Vertraulichkeitan

Re: [GENERAL] Switching databases over JDBC/ODBC

n to one database using a 'known' set of Database specific parameters an interesting concept tho' anyone? Martin Gainty __ Jogi és Bizalmassági kinyilatkoztatás/Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité Ez

  1   2   3   >