Re: [GENERAL] Why isn't Java support part of Postgresql core?

2014-09-18 Thread Guy Rouillier
not be a problem with larger organizations, since most use centrally-administered software configuration. Thanks. -- Guy Rouillier --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] SSD Drives

2014-04-02 Thread Guy Rouillier
tested. Our adventure with these cards was a presentation at Postgres Open in 2011. Slides are here: https://wiki.postgresql.org/images/c/c5/Nvram_fun_profit.pdf -- Guy Rouillier --- This email is free from viruses and malware because avast! Antivirus protection is active. http

Re: [GENERAL] How to determine max int

2013-11-11 Thread Guy Rouillier
-numeric.html#DATATYPE-INT From the documentation, the range of integer data types is not platform-specific, other than for warning about BIGINT. Perhaps you are remembering compiler documentation, where the default integer size typically *is* platform-dependent? -- Guy Rouillier -- Sent via pgsql

Re: [GENERAL] Forms for entering data into postgresql

2013-10-13 Thread Guy Rouillier
interface is superb. Why bother writing a real application for something that trivial? The point is, use the right tool for the task. It's not always a browser and those who think so are showing their ignorance of a huge and varied technology world. On that we agree. -- Guy Rouillier -- Sent via

[GENERAL] oids on disk not in pg_class

2013-10-07 Thread Guy Rouillier
and May, with some smaller ones as far back as February. What kinds of data are written to disk without being registered in pg_class? How can we determine which (if any) are safe to delete? Thanks. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] oids on disk not in pg_class

2013-10-07 Thread Guy Rouillier
On 10/7/2013 5:58 PM, Steve Atkins wrote: On Oct 7, 2013, at 2:48 PM, Guy Rouillier guy.rouill...@gmail.com wrote: We have a fairly large (1 TB) database we put on all SSDs because of a very high insert and update rate (38 million rows/day). As our business has grown, we've been running

Re: [GENERAL] oids on disk not in pg_class

2013-10-07 Thread Guy Rouillier
On 10/7/2013 6:46 PM, David Kerr wrote: On Mon, Oct 07, 2013 at 06:32:57PM -0400, Guy Rouillier wrote: - So, I ran select pg_relation_filenode(614804) and got no results. Any - suggestions on how I can uncover the identify of this node? - - Thanks much. You could try oid2name: http

Re: [GENERAL] MinGW compiled client library

2013-08-13 Thread Guy Rouillier
. I'm curious what led you to that conclusion. The MinGW site itself does not make such a claim. See http://www.mingw.org/wiki/MixingCompilers. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] ODBC constructs

2013-05-21 Thread Guy Rouillier
but I don't know libpq, I might choose to just stick with what I know and use ODBC. So, really, the first decision you should make is how general you want your app to be, and how long you expect to use it. Other decisions flow from there. -- Guy Rouillier -- Sent via pgsql-general mailing list

Re: [ODBC] [GENERAL] ODBC constructs

2013-05-21 Thread Guy Rouillier
On 5/21/2013 3:32 PM, Dev Kumkar wrote: Well to work with psqlODBC, will I need to recompile the psqlODBC binary and any additional stuff to get ODBC working? No, you don't need to recompile any libraries. You just use them. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] help me to clear postgres problem

2013-03-25 Thread Guy Rouillier
to register an EnterpriseDB account before you can install PPAS. -- Guy Rouillier -- 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] selecting for type cast failures

2013-03-07 Thread Guy Rouillier
the best approach here or is there a better way? I did some quick searching also, looks like regular expressions are your way to go. Here is one for isInteger, for example: varchar ~ '^[0-9]+$' -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] 9.2 timestamp function syntax error

2013-03-05 Thread Guy Rouillier
a function and a type name with the same name? I suppose I could define a synonym to make the function name distinct, but this seems like something that should be addressed. Thanks. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] PostgreSQL connect with Visual C++

2013-03-05 Thread Guy Rouillier
with the latest version. You can get 9.2.3 from the web site (http://www.postgresql.org/). -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] 9.2 timestamp function syntax error

2013-03-04 Thread Guy Rouillier
applied? Thanks. -- Guy Rouillier -- 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] Database (Schema) Objects?

2013-03-04 Thread Guy Rouillier
On 3/5/2013 2:03 AM, Stefan Keller wrote: Hi Oracle defines database (schema) objects and non-schema objects (see [1]). Is there also such a thing in Postgres? Yes. See, for example, CREATE USER, CREATE TABLESPACE and CREATE SCHEMA. -- Guy Rouillier -- Sent via pgsql-general mailing list

[GENERAL] PG 9.0.1 StackBuilder wants to install pgJDBC v8.4

2010-11-24 Thread Guy Rouillier
StackBuilder get the list of available files dynamically off the web? Thanks. -- Guy Rouillier -- 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] Constraint: string length must be 32 chars

2010-10-16 Thread Guy Rouillier
id_length char_length(... Sorry, any ideas? (I know it's a stupid question) See the documentation section 5.3.1 Check Constraints. The condition needs to be in parentheses. And in order to name your constraint, you must use the CONSTRAINT variant. -- Guy Rouillier -- Sent via pgsql-general

Re: [GENERAL] It it possible to get this result in one query?

2010-10-15 Thread Guy Rouillier
the 3rd column result as an array instead of string? -Nick On Oct 14, 9:27 pm, guyr-...@burntmail.com (Guy Rouillier) wrote: Sure: select t3.id, coalesce ( t1.title, t2.title, t3.title ), coalesce ( case when t1

Re: [GENERAL] It it possible to get this result in one query?

2010-10-14 Thread Guy Rouillier
]) WHERE id = r.id; ELSE INSERT INTO final_results (id,title,r_types) VALUES (r.id,r.title,ARRAY[tables.t]); END LOOP; END LOOP; -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] IBATIS support for postgres cursors

2010-08-26 Thread Guy Rouillier
On 8/26/2010 5:27 AM, atul.g...@globaldatapoint.com wrote: Hi Guy, Thanks for your reply. We were able to work out with type OTHER. How did you get OTHER to work? Did you define your own TypeHandler? -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] IBATIS support for postgres cursors

2010-08-25 Thread Guy Rouillier
when I find out why OTHER is not working. Or else you can join the MyBatis mailing list. -- Guy Rouillier -- 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] SQL Query Help Please !

2010-07-06 Thread Guy Rouillier
END) as NT028_NT031 Or if you prefer, define an outer select with your select in the FROM clause; in the outer select, you can select each of the 4 columns plus any difference you like. -- Guy Rouillier -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Need Some Recent Information on the Differences between Postgres and MySql

2010-06-25 Thread Guy Rouillier
by this is beyond me. -- Guy Rouillier -- 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] which function should i invoke to create a table and insert tuples?

2010-05-17 Thread Guy Rouillier
). thanks millions! What do you mean by function? Are you trying to do this from PgAdmin, from a stored proc or from some flavor of source code? If either of the latter two, which language? -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] FM format modifier does not remove leading zero from year

2010-01-06 Thread Guy Rouillier
','FMDD.FMMM.FMYY') from dual; 1.01.9 select to_char(DATE'2009-1-1','FM DD.MM.YY') from dual 1.1.9 -- Guy Rouillier -- 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] FM format modifier does not remove leading zero from year

2010-01-06 Thread Guy Rouillier
it on the day? So, in the unusual case that you want to do such a thing, you are asked to use a second occurrence of FM to turn zero suppression back off. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Something like Oracle Forms, but Open Source to use with PostgreSQL?

2009-12-20 Thread Guy Rouillier
://groups.fsf.org/wiki/Oracle_Forms or this if you are looking for a web solution: http://stackoverflow.com/questions/179849/best-solution-for-migration-from-oracle-forms-6i-to-the-web -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] virtualidx exclusive lock

2009-11-09 Thread Guy Rouillier
Uwe Schroeder wrote: On Sunday 08 November 2009 11:38:28 pm Uwe Schroeder wrote: (why it uses a transaction for a simple select is the other thing). Every database interaction happens within a transaction. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Free Tool to design Postgres Databases

2009-10-19 Thread Guy Rouillier
://uml.sourceforge.net/index.php And on it goes. Keep searching and you'll find more. -- Guy Rouillier -- 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] How useful is the money datatype?

2009-10-05 Thread Guy Rouillier
Christophe Pettus wrote: On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote: There is no reason why PG could not support packed decimal. Is that not NUMERIC? No, that is not NUMERIC. All numeric types are stored as binary representations. Packed decimal is not. Perhaps an example would

Re: [GENERAL] How useful is the money datatype?

2009-10-05 Thread Guy Rouillier
Bruce Momjian wrote: Guy Rouillier wrote: Christophe Pettus wrote: On Oct 4, 2009, at 7:09 PM, Guy Rouillier wrote: There is no reason why PG could not support packed decimal. Is that not NUMERIC? No, that is not NUMERIC. All numeric types are stored as binary representations. Packed

Re: [GENERAL] How useful is the money datatype?

2009-10-04 Thread Guy Rouillier
. And for a while would be over 50 years, as packed decimal is still in use today. All banks rely on it. The best way to avoid loss of precision with decimal is to use decimal representation, and not convert to binary at all. There is no reason why PG could not support packed decimal. -- Guy

Re: [GENERAL] Accessing a database form another database

2009-08-10 Thread Guy Rouillier
-other-PostgreSQL-Databases-and-Servers.html -- Guy Rouillier -- 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] Does derby have an embedded Mode like Derby ?

2009-08-04 Thread Guy Rouillier
. The only reason I can see for doing DDL in a unit test would be if the end product will be doing such DDL. -- Guy Rouillier -- 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] Please remove me from the list!

2009-05-28 Thread Guy Rouillier
subscription: http://www.postgresql.org/mailpref/pgsql-general -- Guy Rouillier -- 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] Enumerating a row set

2009-03-26 Thread Guy Rouillier
-anyone-cumulative-sum-in-one-query/ -- Guy Rouillier -- 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] Postgresql

2009-03-12 Thread Guy Rouillier
emails would also encourage people to respond. -- Guy Rouillier -- 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] Pet Peeves?

2009-02-04 Thread Guy Rouillier
bucket rather than the job scheduler bucket. -- Guy Rouillier -- 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] Pet Peeves?

2009-02-03 Thread Guy Rouillier
issue. As has been pointed out here, the schedule could be kept in the DB, which would address that. Having a scheduler in the DB to run those jobs is just the next step. Different stokes, as they say. All about choice. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Pet Peeves?

2009-02-03 Thread Guy Rouillier
? Triggers are already pieces of code that run upon certain events, namely insert, update or delete events. What others do you have in mind? -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] Pet Peeves?

2009-02-02 Thread Guy Rouillier
Gregory Stark wrote: Christopher Browne cbbro...@gmail.com writes: - Managing jobs (e.g. - pgcron) A number of people have mentioned a job scheduler. I think a job scheduler entirely inside Postgres would be a terrible idea. PgFoundry already has a project called Job Scheduler. -- Guy

Re: [GENERAL] Pet Peeves?

2009-01-29 Thread Guy Rouillier
, each with a foreign key to the same reference table, deadlocks are pretty easy to create. This is especially true if the reference table has low cardinality, which is often the case. I don't know if this situation has been improved since that time. -- Guy Rouillier -- Sent via pgsql-general

Re: [GENERAL] Why would I want to use connection pooling middleware?

2009-01-15 Thread Guy Rouillier
application. -- Guy Rouillier -- 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] Ubuntu for servers (was TurnKey PostgreSQL)

2008-12-10 Thread Guy Rouillier
Liraz Siri wrote: Solaris is awesome (dtrace rocks!), but I still prefer Debian/Linux for the same reasons I prefer PostgreSQL over MySQL - its lack of dependence on any single company. OpenSolaris? -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] Ubuntu for servers (was TurnKey PostgreSQL)

2008-12-10 Thread Guy Rouillier
Joshua D. Drake wrote: BSD is dying. We all are, sooner or later ;) -- Guy Rouillier -- 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] db backup script in gentoo

2008-11-30 Thread Guy Rouillier
questions about that distro: http://www.gentoo.org -- Guy Rouillier -- 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] please cansel my subscription

2008-11-27 Thread Guy Rouillier
wrote: thank you! -- Guy Rouillier -- 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] Upgrading side by side in Gentoo

2008-11-13 Thread Guy Rouillier
in a production environment. I have quite a bit of experience in Gentoo and other distros, and for Andrus's situation, I continue to recommend a binary distro with committed multi-year support. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] Upgrading side by side in Gentoo

2008-11-12 Thread Guy Rouillier
investigated. -- Guy Rouillier -- 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] Annoying Reply-To

2008-10-23 Thread Guy Rouillier
to list add-on for ThunderBird - it's marked experimental, but may be worth a try: https://addons.mozilla.org/en-US/thunderbird/addon/4455 Works great! Thanks, Ray - no more complaints from me ;). Anyone using Thunderbird to read this list would benefit from this add-on. -- Guy Rouillier

Re: [GENERAL] Annoying Reply-To

2008-10-21 Thread Guy Rouillier
Aidan Van Dyk wrote: But now, if the list munged my reply-to, how would you get back to me? I wouldn't ;). The whole point of a mailing list is to have discussions with the list. If I wanted to correspond with you directly, I wouldn't use the list for that. -- Guy Rouillier -- Sent via

Re: [GENERAL] Session variables (how do I pass session data to a function)

2008-10-20 Thread Guy Rouillier
#FUNCTIONS-ADMIN-SET-TABLE If you'd like to read a fuller discussion of this very topic, search for a thread titled can I define own variables in the archives. I had to do the same thing back then. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Annoying Reply-To

2008-10-17 Thread Guy Rouillier
copies of emails from this list, I delete all of the To: addressees and change the list from CC: to To:. Would be nice if everyone did the same. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [GENERAL] case expression

2008-09-24 Thread Guy Rouillier
Garry Saddington wrote: It does work but returns a column called case. How can I return the case column as 'postcode'? select CASE WHEN postcode ilike '%OO%' THEN '' END as postcode from addresses -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make

Re: [GENERAL] Oracle and Postgresql

2008-08-31 Thread Guy Rouillier
is a great piece of work and equal in performance and features to commercial DBMSs. You can get support contracts from several companies. But there is no single entity that owns PG. CTOs/CIOs like to sleep at night. -- Guy Rouillier -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] SQL Question - Recursion

2008-08-26 Thread Guy Rouillier
have the beginning, ending and # customers added, then attrition = ending - beginning - #added. -- Guy Rouillier -- 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] does postgresql works on distributed systems?

2008-06-04 Thread Guy Rouillier
server, but then *it* completely owns all files related to that instance. Only one instance can be accessing the files related to that instance at any point in time. The same could be done with PostgreSQL. As I said, the NetApp is just a fileserver. -- Guy Rouillier -- Sent via pgsql

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

2008-03-08 Thread Guy Rouillier
- support and encourage. If it were a community project it would be under postgresql.org, as all our sites are, (with the exception of pgFoundry) And with the new exception of the community documentation recently started at http://www.postgresqldocs.org. -- Guy Rouillier -- Sent via pgsql-general

Re: [GENERAL] Watch your PlanetPostgreSQL.org blogs

2008-03-08 Thread Guy Rouillier
Tom Lane wrote: Guy Rouillier [EMAIL PROTECTED] writes: And with the new exception of the community documentation recently started at http://www.postgresqldocs.org. Which in fact has got only the weakest claim to be a community project. If it actually were such, in the sense of having been

Re: [GENERAL] PostgreSQL Docs - Community Documentation

2008-03-03 Thread Guy Rouillier
to the Community Documentation that just got kicked off? -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message

Re: [GENERAL] PostgreSQL Docs - Community Documentation

2008-03-02 Thread Guy Rouillier
you appreciate my Catch-22 ;). About PostgreSQL Docs is an important topic, and should be elevated to the same list as Main Page. -- Guy Rouillier ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Feedback on PLJava

2008-02-21 Thread Guy Rouillier
. -- Guy Rouillier ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] 8.3 Feature List mentions Slony 2.0

2008-02-05 Thread Guy Rouillier
hooks in PostgreSQL 8.3. But if you follow the link, the resulting page only talks about 1.2.12. -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command

Re: [GENERAL] postgresql book - practical or something newer?

2008-02-05 Thread Guy Rouillier
adding a Community Version directly on that page, or adding one to the community page off of Techdocs. -- Guy Rouillier ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] [Pljava-dev] pljava.dll - bogus error

2008-02-01 Thread Guy Rouillier
. This error happened to me years ago and I don't remember what the real issue was. Could you point to the actual problem and I'll see if Windows can identify it? -- Guy Rouillier ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [GENERAL] postgresql book - practical or something newer?

2008-01-31 Thread Guy Rouillier
that is notoriously hard to link to.) -- Guy Rouillier ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Sun acquires MySQL

2008-01-21 Thread Guy Rouillier
. The procs are trivial - just wrappers for insert statements. After I exhausted all alternatives, I replaced the stored proc invocation in the code with inserts. Then, PG was able to achieve the same throughput as BigDBMS. -- Guy Rouillier ---(end of broadcast

Re: [GENERAL] Hijack!

2007-12-11 Thread Guy Rouillier
for the list; although the list always posts to the identity I have set up for mailing lists, for some reason Thunderbird selects a different identity when I reply. -- Guy Rouillier ---(end of broadcast)--- TIP 5: don't forget to increase your

Re: [GENERAL] Temporary, In-memory Postgres DB?

2007-11-19 Thread Guy Rouillier
motherboard with a single Opteron socket and 8 DIMM slots: http://www.tyan.com/product_board_detail.aspx?pid=229 -- Guy Rouillier ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] I want to search my project source code

2007-10-28 Thread Guy Rouillier
can't see how a database engine, with all it's transactional overhead and many other layers, will ever beat a simple grep performance-wise. I've used Eclipse for refactoring, but having done it once, I'm sticking with grep. -- Guy Rouillier ---(end of broadcast

Re: [GENERAL] Install plJava

2007-10-24 Thread Guy Rouillier
the archives there; I think this problem has come up before. -- Guy Rouillier ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] How install postgreSQL in another drive than C:?

2007-10-22 Thread Guy Rouillier
options pane during the installation, look at the bottom of the window. You should see Current location with a destination of C:\Program Files\PostgreSQL\version\. Click the Browse button and change the destination. -- Guy Rouillier ---(end of broadcast

Re: [GENERAL] looking for some real world performance numbers

2007-10-21 Thread Guy Rouillier
thought. -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] looking for some real world performance numbers

2007-10-21 Thread Guy Rouillier
Ow Mun Heng wrote: On Sun, 2007-10-21 at 22:54 -0400, Guy Rouillier wrote: The current app uses stored procedures for all inserts, and PG didn't do well with that approach; substituting embedded inserts fixed that problem. So PG can definitely handle very Can you explain what is embedded

Re: [GENERAL] downloading and installing postgreSQL

2007-10-17 Thread Guy Rouillier
.zip instead. Unzip in a temporary directory, read the README file, then double click the MSI file (or just type the name at a command prompt if you use that.) -- Guy Rouillier ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [GENERAL] can I define own variables?

2007-10-16 Thread Guy Rouillier
Tom Lane wrote: Guy Rouillier [EMAIL PROTECTED] writes: I set that up, and using the SHOW command returns the set value. I searched the archives and I couldn't identify a way to retrieve these values in a trigger function. http://www.postgresql.org/docs/8.2/static/functions-admin.html

Re: [GENERAL] How to set config param temporarily?

2007-10-16 Thread Guy Rouillier
. Is there a simpler approach? See the message thread can I define own variable? for a discussion of how to create a temporarily variable. Took place over the last week. -- Guy Rouillier ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [GENERAL] can I define own variables?

2007-10-15 Thread Guy Rouillier
Tom Lane wrote: Guy Rouillier [EMAIL PROTECTED] writes: Tom Lane wrote: Another possibility, if you only need to store and retrieve values and not do anything especially interesting with them, is to abuse the custom GUC variable facility. I've had several occasions when a user-defined

Re: [GENERAL] can I define own variables?

2007-10-12 Thread Guy Rouillier
surprised that such a common usage scenario has not forced connection-unique user-defined variables into the spec. -- Guy Rouillier ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] SLEEP in posgresql

2007-10-09 Thread Guy Rouillier
) now 2007-10-09 23:50:35.774-04 (1 row) Seems to be working. What version are you using and on what platform? -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send

Re: [GENERAL] an other provokative question??

2007-09-07 Thread Guy Rouillier
to be a significant challenge. -- Guy Rouillier ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] history table

2007-08-21 Thread Guy Rouillier
; you've got the correct userid to log by just looking at the connection details. -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [GENERAL] history table

2007-08-21 Thread Guy Rouillier
Robin Helgelin wrote: On 8/21/07, Guy Rouillier [EMAIL PROTECTED] wrote: Well, you haven't told us much about your webapp. Are you using connection pooling? If so, then you'll need to provide the webapp userid as an additional parameter to your database updates. If you are not using

Re: [GENERAL] Writing most code in Stored Procedures

2007-08-18 Thread Guy Rouillier
is still going through the resolution logic, even if you only have a single instance of a given name. -- Guy Rouillier ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your

Re: [GENERAL] Writing most code in Stored Procedures

2007-08-17 Thread Guy Rouillier
is that, as anyone who has worked professionally for a number of years knows, no magic bullets exist. General guidelines can be helpful, but each scenario must be individually investigated. -- Guy Rouillier ---(end of broadcast)--- TIP 2: Don't

Re: [GENERAL] Writing most code in Stored Procedures

2007-08-17 Thread Guy Rouillier
insert/update rates. Is there a PG knowledgebase where this kind of information might be useful? -- Guy Rouillier ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

2007-06-18 Thread Guy Rouillier
all these half-baked comparisons. -- Guy Rouillier ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/

Re: [GENERAL] Using the power of the GPU

2007-06-08 Thread Guy Rouillier
this one. Until someone comes out with a standardized approach for utilizing whatever extra processing power exists on a GPU in a generic fashion, I can't see much payback for writing special code for the NVIDIA 8800. -- Guy Rouillier ---(end of broadcast

Re: Creditcard Number Security was Re: [GENERAL] Encrypted column

2007-06-07 Thread Guy Rouillier
any of these outsourcers indemnify corporate customers against fraud or data loss? -- Guy Rouillier ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: Creditcard Number Security was Re: [GENERAL] Encrypted column

2007-06-07 Thread Guy Rouillier
$800, you probably don't have to worry. If on the other hand this is your only bank and you have your life savings in there, you most definitely should consider the risks to which you are exposing your finances. -- Guy Rouillier ---(end of broadcast

Re: [GENERAL] Encrypted column

2007-06-04 Thread Guy Rouillier
-user passwords. -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [GENERAL] multimaster

2007-06-02 Thread Guy Rouillier
it in the domain they work in - Java. Should the Java folks complain because Perl scripts on CPAN are not accessible from Java? -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [GENERAL] multimaster

2007-06-01 Thread Guy Rouillier
-jdbc.objectweb.org. Narrow niche, but if it happens to be the one you are in, then it's an option. I took a quick look at the user's page, and both of them were using PostgreSQL. -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through

Re: [GENERAL] hundreds of schema vs hundreds of databases

2007-05-29 Thread Guy Rouillier
there is a compelling evidence that different databases are required. -- Guy Rouillier ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [GENERAL] 8.3

2007-05-29 Thread Guy Rouillier
for the development of 8.3 is: * mid-May, 2007 - All patches applied, beta testing begins * July, 2007 - Release of 8.3.0 -- Guy Rouillier ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [GENERAL] the future of pljava development

2007-05-24 Thread Guy Rouillier
like to become committers to the PL/Java project? Sure, I'm willing to help. -- Guy Rouillier ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] the future of pljava development

2007-05-23 Thread Guy Rouillier
/Java move forward slowly than get dropped. -- Guy Rouillier ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

Re: [GENERAL] Technical Documentation and Community Login

2007-04-20 Thread Guy Rouillier
George Weaver wrote: Original Message From Guy Rouillier http://www.postgresql.org/docs/techdocs.71. Color me dumb, but I can't figure a way to download the document Apache 2.0, Tomcat 5.5, WARs PostgreSQL 8.1 JDBC DataSources on Windows XP. When I click on the link to the document

[GENERAL] Technical Documentation and Community Login

2007-04-19 Thread Guy Rouillier
on Windows XP. When I click on the link to the document, it just brings me back to the same page. So then I figured perhaps I needed a community login. So I created one 3 or 4 days ago, but I'm still waiting for the confirmation email to arrive. Is that server stuck? -- Guy Rouillier

  1   2   3   >