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

7;m sure that there are legitimate reasons for requiring greater precision, but none of those reasons happen to apply to me. I dare say that they don't apply to most people who want to store monetary values in a database. Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsq

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

Hi Thom, Here's how I represent currency values: CREATE DOMAIN currency AS numeric(10,2); I understand money has been deprecated. It has one obvious flaw that I can think of: It cannot represent different currencies in different tuples, with a currency_id field. Regards, Peter Geog

Re: [GENERAL] multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit

ows. Looks like it's the bug you mention. I guess I'll just upgrade to 8.4.1. Thanks, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] multiple calls to dblink_connect from within pl/pgSQL function exhaust connection limit

onnect to my main db, execute this function and disconnect (dblink connections only persist for as long as the connection that originated them, I also understand from the docs). Nonetheless, I'd like to know what's happening here. Why the apparent resource leak? Thanks, Peter Geoghegan --

Re: [GENERAL] c++ program to connect to postgre database

t MinGW, but probably not the Dev-C++ flavour. I suggest you download visual studio 2008 express, and use that to build libpqxx. No one uses Dev-C++ anymore anyway. Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

Re: [GENERAL] Suggested way of associating PG user metadata with record

newname), then your text column becomes incorrect. Yes, that had occurred to me. I think I'll go ahead and take the obvious approach. On the whole, it seems very easy to implement and maintain to me, and the alternative approach doesn't buy me any very appreciable advantage. Thanks, Pete

Re: [GENERAL] Suggested way of associating PG user metadata with record

obvious thing and using a text column as described in my original mail. I'd like to do whatever is considered canonical, but I'm not sure what that is in this case. Thanks, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Suggested way of associating PG user metadata with record

cause what I've described strikes me as a fairly common requirement, I suspect there may be a purpose-built, more direct and efficient feature I could use, such as a referential user datatype or something like that. Is there? If not, does the obvious approach seem reasonable? Regards,

Re: [GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

at. That strikes me as fairly kludgey - acceptable for some utility shellscript, but probably not for what is supposed to be a responsive program. Perhaps it would be preferable to call the function after the operation, but before the application reports success. I'll look into it. Regards, P

Re: [GENERAL] Re: Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

roved upon? Regards, Peter Geoghegan -- 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] Re: Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

your libpq calls. The only thing that I don't check the return value of is PQreset, which returns void. What do you mean? Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully

ty in the real world, my program crashes without displaying an error message (I would expect to see a visual C++ runtime error message). Can someone suggest a reason for this, or a workaround? Regards, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Maintaining connectivity/failing gracefully when my application is connected to a PostgreSQL server over Wi-fi on a PDT/PDA handset

rror message (I would expect to see a visual C++ runtime error message). Can someone suggest a reason for this, or a workaround? Regards, Peter Geoghegan -- 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?

What about postgreSQL's inability to re-order columns? Please don't point out that I shouldn't rely on things being in a certain order when I SELECT * FROM table. I'm well aware of that, I just generally have an aesthetic preference for a table's columns being in a certa

[GENERAL] Maintaining an index on a large table: Is there any potential for it to stall my application?

libpqxx, but I have reservations due to the possible implications for thread safety - pqxx lacks "a flexible mechanism for thread synchronization", so this might cause headaches. Thanks, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes t

[GENERAL] Performing a sub-query in a SELECT SUM aggregate.

ors or something? Thanks, Peter Geoghegan -- 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] Problem with windows Postgres 8.3.1 MSI binary distribution

If I get the install to the point where it prompts me "Service 'PostgreSQL Database Server 8.3'(pgsql-8.3) failed to start. Verify that you have sufficient priveleges to start system services", I can connect to the database with pgAdmin III without any apparent issues. Soif you close the instal

Re: [GENERAL] Problem with windows Postgres 8.3.1 MSI binary distribution

Syra, No, I'm not running a silent install. Regards, Peter -- 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] Problem with windows Postgres 8.3.1 MSI binary distribution

Syra, Yes, the svchost.exe process is running. Back to the drawing board Regards, Peter -- 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] Problem with windows Postgres 8.3.1 MSI binary distribution

Syra, I can confirm that secondary logon appears as enabled under "Services". I guess that narrows down the problem... Regards, Peter -- 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] Problem with windows Postgres 8.3.1 MSI binary distribution

Syra, It is my machine, and I have exclusive access to it. I cannot think of why it would be disabled. I'm trying to figure out how to verify that it is running. I found a Korean blog post that discusses the problem, but the google translate isn't great: http://www.google.com/translate?u=http%3A%

Re: [GENERAL] Problem with windows Postgres 8.3.1 MSI binary distribution

vaert N.V. > > Tel.: +32 3 444 4237 > http://www.agfa.com > > > > "Peter Geoghegan" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > > 04/09/2008 04:34 PM > > To pgsql-general@postgresql.org > > cc > > Subject [GENERAL] Problem

[GENERAL] Problem with windows Postgres 8.3.1 MSI binary distribution

Hello, I have a problem with the windows Postgres 8.3.1 MSI binary distribution. When I attempt to install postgres 8.3.1 with postgres automatically creating its own user account, the installer complains: "Service 'PostgreSQL Database Server 8.3'(pgsql-8.3) failed to start. Verify that you have

Re: R: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

Paolo, Oh yes, I see it now. It was necessary to re-initialise the database in order for that to appear, which I have not done until now. Now I have a new problem. When I attempt to install postgres 8.3.1 with postgres automatically creating its own user account, the installer complains: "Servic

Re: [GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

didn't work as described in my original e-mail.That being the case, how should I proceed? Thanks, Peter Geoghegan -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Debugging Pl/PgSQL functions with the debug contrib module

--- The only available on PgFoundry is a source distribution: http://pgfoundry.org/frs/?group_id=1000175 . Building this would necessitate setting up a mingw build environment, which would be a lot of effort. What is the simplest, most direct way of enabling debugging of Pl/PgSQL un

<    1   2   3