Re: [GENERAL] Why are stored procedures looked on so negatively?

I do not see why stored procedures are particular better for asynchronous application design. this can be done, as some pointed before, using standard libraries. Furthermore, while this does not apply to databases that do not burden users with heavy per-cpu costs, for many companies that build

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

Withing PG procedures at least in pgsql it is impossible to do 'money' calculations without a loss of precision. There is an open source library by IBM that I use in my C++ code to do this, and may be it can be incorporated into PG it is called decNumber http://speleotrove.com/decimal/decnumber.

Re: [GENERAL] [Q] optmizing postgres for 'single client' / many small queries

ions. Thanks On Wed, 02 Sep 2009 14:45 -0400, "Tom Lane" wrote: > "V S P" writes: > > Well, actually > > somebody has written a C++ ORM > > [ that is causing all your problems and you say you can't discard ] > > Just out of curiosit

Re: [GENERAL] [Q] optmizing postgres for 'single client' / many small queries

ks) Thank you in advance On Wed, 02 Sep 2009 14:26 -0400, "Tom Lane" wrote: > "V S P" writes: > > The application typicall goes like this > > > select id, child_tb_key_id, from tb1 > > > then for each selected row above > >

Re: [GENERAL] [Q] optmizing postgres for 'single client' / many small queries

ehule" wrote: > Hello > > Are you sure, so you have to use PostgreSQL - maybe SQLite or > memcached is better for your task. > > regards > Pavel Stehule > > 2009/9/2 V S P : > > Hi, > > our application is using Postgres in a rather unusuall way. >

[GENERAL] [Q] optmizing postgres for 'single client' / many small queries

Hi, our application is using Postgres in a rather unusuall way. It is used by a GUI application to store several hundred thousand 'parameters'. Basically it is used like a big INI file. There are about 50 tables with various parameters. The application typicall goes like this select id, child_t

Re: [GENERAL] [Q] parsing out String array

ere I tried I get syntax error thank you in advance for help > > On Wed, 12 Aug 2009 20:52 -0700, "Scott Bailey" > wrote: > > V S P wrote: > > > if I have field declared > > > myvalue text[][] > > > > > > insert into vladik (myval) >

[GENERAL] [Q] parsing out String array

if I have field declared myvalue text[][] insert into vladik (myval) values ( '{{"\",A", "\"B"}, {"Y", "Q"}}' ) What do you guys use in your treasurechest of 'addons' to successfully parse out the above trickery and get and get the 4 strings ",A "B Y Q from within Postgres stored procedure as

Re: [GENERAL] [Q] single image Table across multiple PG servers

ott Marlowe <[2]scott.marl...@gmail.com> wrote: On Mon, Jul 13, 2009 at 11:16 PM, V S P<[3]torea...@fastmail.fm> wrote: > Hello > > I am researching how to store the data for easy 'user-driven' > reporting (where I do not need to develop application for > every user re

[GENERAL] [Q] single image Table across multiple PG servers

Hello I am researching how to store the data for easy 'user-driven' reporting (where I do not need to develop application for every user request). The data will typically be number ranges and text strings with unique Id for each row I hope there will be a lot of data :-). So in that anticipati

[GENERAL] [Q] sequence and index name limits in 8.4

Searched docs and the web but only saw references to the older version of postgres where changing source code was recommended ( NAMEDATALEN) if more than 31 characters in the names are desired. wanted to ask if this is still the case in 8.4 (I need at least 128) thank you in advance, VSP -- Vla

Re: [GENERAL] [Q] rollback after select?

other email) both were related problem to the fact that PG I have to issue commits even for the 'non sql' statements. sorry I did not figure this out before posting, Vlad On Sun, 29 Mar 2009 20:20 -0400, "V S P" wrote: > I have read that > if a given connection has an

[GENERAL] [Q] rollback after select?

tand how it is happening. all my tables are in a new schema I call 'prod', when I connect to the database I set right away 'set search_path to prod', assuming that all of the SQLs now will be going to 'prod'. But may be this somehow gets screwed up after a rol

[GENERAL] [Q] LOG: failed to commit client_encoding

27;" What does this LOG string mean, and what should I do? if there is a place with all the error messages and explanation I would certainly appreciate the link (I just tried regular searches but could not find it). thank you in advance, Vlad -- V S P torea...@fastmail.fm -- http://www

[GENERAL] [Q] ODBC Decimal(19,6)

not work yet. thanks in advance, Vlad -- V S P torea...@fastmail.fm -- http://www.fastmail.fm - Access your email from home and the web -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

[GENERAL] [Q] ODBC connect shows RELEASE / SAVEPOINT on selects

those messages in the log). Thanks in advance, Vlad -- V S P torea...@fastmail.fm -- http://www.fastmail.fm - A no graphics, no pop-ups email service -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/

Re: [GENERAL] [Q] Cluster design for geographically separated dbs

ber right, there was something called a 'Step' for the sequence values. Vlad On Sun, 08 Mar 2009 01:13 -0700, "Scott Marlowe" wrote: > On Sat, Mar 7, 2009 at 2:03 PM, V S P wrote: > > > And wanted to ask what would be the main challenges I am facing with

Re: [GENERAL] [Q] string to int hash function for small range

at, 07 Mar 2009 21:17 -0700, "Scott Marlowe" wrote: > On Sat, Mar 7, 2009 at 7:33 PM, V S P wrote: > > I would like to have a function > > given a user id varchar(64) to get a hash number between 0 and 255. > > > > I first tried md5 but the number it returns is

[GENERAL] [Q] string to int hash function for small range

to know if there are any other 'built-in' ways this is to get the database id based on user id. thanks in advance, Vlad -- V S P torea...@fastmail.fm -- http://www.fastmail.fm - One of many happy users: http://www.fastmail.fm/docs/quotes.html -- Sent via pgsql-general ma

[GENERAL] [Q] Cluster design for geographically separated dbs

e 'Defgrament' the IDs (as the data with BIGserial keys can be deleted). It looks to me that If I design things to take advantage of Skype's plproxy -- I will be able to leverage, what appears to be, a relatively easy way to get data between databases (for reports that span clu

Re: [GENERAL] pg_get_serial_sequence Strangeness/Unreliable?

ot need to prefix my table names with 'public' all the time. V S P On Tue, 25 Nov 2008 09:46:37 -0400, "Jeff MacDonald" <[EMAIL PROTECTED]> said: > Hello everyone, > > I'm using "PostgreSQL 8.2.5 on amd64-portbld-freebsd6.1, compiled by > G

Re: [GENERAL] Using Postgres to store high volume streams of sensor readings

any win. > > > >regards, tom lane > > Thanks for your feedback! This is just as I supposed, but i didn't > had the Postgres experience to be certain. > I'll include your conclusion to my report. > > Ciprian Craciun. > &

Re: [GENERAL] [Q]updating multiple rows with Different values

wanted to know. Thank you again for such a quick help. On Sun, 23 Nov 2008 10:11:56 +0100, "Gerhard Heift" <[EMAIL PROTECTED]> said: > On Sat, Nov 22, 2008 at 10:04:48PM -0500, V S P wrote: > > Hello, > > searched documentation, FAQ and mailing list archives >

[GENERAL] [Q]updating multiple rows with Different values

O will support it as well). Thank you in advance, VSP -- V S P [EMAIL PROTECTED] -- http://www.fastmail.fm - Access all of your messages and folders wherever you are -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to you