[GENERAL] C function on Windows 2003/XP

I am trying to follow the instructions on the 8.0 interactive comments (http://www.postgresql.org/docs/8.0/interactive/xfunc-c.html) to build a c function using MSDEV and PostgreSQL 8.3 on Windows XP/2003 I am running into errors around. fatal error C1083: Cannot open include file: 'libintl.h

Re: [GENERAL] Documenting a DB schema

Shahaf Abileah wrote: I’m looking for a systematic way to document the schema for the database behind our website (www.redfin.com ), so that the developers using this database have a better idea what all the tables and columns mean and what data to expect. Any recommen

Re: [GENERAL] PG windows service issues

Yves Moisan wrote: Hi All, I'm new to this list. I've set up postgreSQL on windows about 4 times since the first 8.x series came out. The first time it was 8.0 beta3 IIRC. I believe I've installed another in the 8.0 series, then a 8.1 then just a couple of weeks ago 8.2.4. Every time I ru

Re: [GENERAL] [pgsql] Simple backup utility like mysqldump?

TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq Perhaps google "Postgresql dump" very first result is http://www.postgresql.org/docs/8.1/static/backup.html - Oisin Glynn smime.p7s Description: S/MIME Cryptographic Signature

Re: [GENERAL] PostGreSQL for a small Desktop Application

eem load to breakpoint conditions. FYI We are running MS IIS, PostgreSQL, Oracle XE, all of "our" code(7-8 C++ Services) and a VM image of FC6 on a good XP Pro machine with no complaints so far and the system is providing a real time service in which delays/interruptions would be

Re: [GENERAL] Oracle to PSQL function

OR REPLACE FUNCTION foo() RETURNS void AS $$ DECLARE V_StartTime timestamp with time zone; V_EndTime timestamp with time zone; BEGIN SELECT INTO V_StartTime, V_EndTime P_StartTime, P_EndTime FROM normalize_time_period_limit(NULL::timestamp with time zone, NULL::timestamp with time zone); END; $$ LANGUAGE PLPGSQL; -- Oisin Glynn My status smime.p7s Description: S/MIME Cryptographic Signature

Re: [GENERAL] Predicted lifespan of different PostgreSQL branches

Tom Lane wrote: Dave Page <[EMAIL PROTECTED]> writes: I've been considering only maintaining the current and previous 2 versions in pgInstaller (the Windows binary distro). But that's a *lot* harder to maintain than just PostgreSQL because of all the bundled stuff. In other words, when 8.3 is

Re: [GENERAL] NOTIFY QUESTION

Oisin Glynn wrote: From the Docs see below it implies that the WHERE clause of the update is ignored.( http://www.postgresql.org/docs/8.1/static/sql-createrule.html ) If I create a Rule as CREATE RULE foo_update_false AS ON UPDATE TO foo WHERE NEW.some_flag = TRUE DO NOTIFY foo_update

[GENERAL] NOTIFY QUESTION

From the Docs see below it implies that the WHERE clause of the update is ignored.( http://www.postgresql.org/docs/8.1/static/sql-createrule.html ) If I create a Rule as CREATE RULE foo_update_false AS ON UPDATE TO foo WHERE NEW.some_flag = TRUE DO NOTIFY foo_update; Does the WHERE clause

Re: [GENERAL] Database Failure on Windows XP Pro psql (PostgreSQL)

and print server). The only way to modify the limit is to manually modify binary files. -- Brandon Aiken CS/IT Systems Engineer -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Shelby Cain Sent: Monday, January 08, 2007 3:12 PM To: Oisin Glynn; pgsql-g

Re: [GENERAL] Database Failure on Windows XP Pro psql (PostgreSQL)

al Message ---- From: Oisin Glynn <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Sent: Monday, January 8, 2007 1:33:54 PM Subject: [GENERAL] Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4 I am running postgres on Windows XP and have been for quite a while as the databas

[GENERAL] Database Failure on Windows XP Pro psql (PostgreSQL) 8.1.4

I am running postgres on Windows XP and have been for quite a while as the database engine for our application. On an ODBC connection the following error has started happening. The gap in activity is normal for our application. but the connection failing is a first we have this application liv

Re: [GENERAL] Male/female

Steve Crawford wrote: Richard Troy wrote: On Fri, 8 Dec 2006, Raymond O'Donnell wrote: Yes, the table is used only for humans; it's part of some administrative software I'm writing for an educational institution, and the primary purpose of the gender column is to help the users cope wit

Re: [GENERAL] using a sequence as the functional equivalent to Oracle

Wm.A.Stafford wrote: I'm trying to use a temporary sequence to duplicate the functionality of the Oracle rownum pseudo-column as suggested by Scott Marlow in the archives: http://archives.postgresql.org/pgsql-sql/2005-05/msg00126.php. The Oracle based application I'm porting to PostgreSQL used

Re: [GENERAL] Simple stored procedure examples?

novnov wrote: And here is what shows in the SQL window for that proceedure CREATE FUNCTION "proc_UpdateItemName"(IN "strItemName" "varchar") RETURNS void AS $BODY$update item set itemname = 'fox';$BODY$ LANGUAGE 'sql' VOLATILE; The error is always "ERROR relation "item" does not exist". Not us

Re: [GENERAL] pg_proc Question

Martijn van Oosterhout wrote: On Thu, Nov 02, 2006 at 09:57:28AM -0500, Oisin Glynn wrote: I have named all my functions in a pretty unique way and would like to export just my functions. Is there any way to move just these functions from one db to another.has anyone got a clever piece of

[GENERAL] pg_proc Question

I have named all my functions in a pretty unique way and would like to export just my functions. Is there any way to move just these functions from one db to another.has anyone got a clever piece of SQL that spits out ddl from a select on pg_proc? Or could I use the copy command on pg_proc to

Re: [professionel] Re: [GENERAL] division by zero error in a request

Bernard Grosperrin wrote: Oisin SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) / (sold_parts_amount_dly + sold_labor_amount_dly) from sales where (sold_parts_amount_dly + sold_labor_amount_dly)>0 Thanks for your answer. The real request would be something like this: SELE

Re: [GENERAL] division by zero error in a request

Bernard Grosperrin wrote: I wants to make a view giving me some statistics. I am not sure to understand why something like this SELECT location_id, (sold_parts_amount_dly + sold_labor_amount_dly) / (sold_parts_amount_dly + sold_labor_amount_dly) from sales give me a division by zero error? If

Re: [GENERAL] Windows install problem

Merlin Moncure wrote: On 10/12/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote: On Wed, Oct 11, 2006 at 01:32:29PM +0530, Ravindran G - TLS, Chennai. wrote: > When I start PostgreSQL service, the below error message is displayed and > finally service didn't started. > > The PostgreSQL Database Serv

[GENERAL] Performance and Generic Config after install

As an aside to the "[GENERAL] Advantages of PostgreSQL" thread going on today, I have wondered why the initial on install config of PostgreSQL is (according to most posts) very conservative. I can see how this would be a plus when people may be getting PostgreSQL as part of an OS in the Linux

[GENERAL] File System Access:

All, I have a need to create/copy/delete files on my server from a function in PostreSql. I am running 8.x PostreSql on Windows 200x and my functions etc are currently only in PL/pgSQL. Is there a way to create files/copy them and delete them from PL/pgSQL or could i call an external bat file

Re: [GENERAL] LISTEN considered dangerous

Tom Lane wrote: Flemming Frandsen <[EMAIL PROTECTED]> writes: The listen should simply listen for events issued at the start of the transaction it's executed in. BEGIN; SELECT sleep(10); LISTEN foo; No, I don't think so. regards

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative

Scott Marlowe wrote: On Wed, 2006-07-12 at 05:55, Clodoaldo Pinto wrote: 2006/7/11, Oisin Glynn <[EMAIL PROTECTED]>: Paul Tilles wrote: Version postgres 7.4.7: Following sql UPDATE tablename SET value = 0.0 where value!=-9.4; results in the error message ERROR: op

Re: [GENERAL] doesn't recognize "!=-" (not equal to a negative value)

Paul Tilles wrote: Version postgres 7.4.7: Following sql UPDATE tablename SET value = 0.0 where value!=-9.4; results in the error message ERROR: operator does not exist: smallint !=- integer HINT: No operator matches the given name and argument type(s). You may need to add explicit type ca

Re: [GENERAL] SQL Rule

Could you create the table without the C column then create a view test_view with select a,b,a+b as c,id from test; Oisin Bert wrote: Hi list I have a table construction like the one seen below, when i am updating or inserting i get a recurion, logical. But how to manage it that the rule is j

Re: [GENERAL] PostgreSQL 8.1 v. Oracle 10g xe

Chris Travers wrote: Recently I have been attempting to install Compiere. After spending a lot of time attempting to get it to work, I have given up installing it on PostgreSQL. I did however, get a little experience installing JDBC and PL/Java in the mean time. I discovered in the process

Re: [DOCS] [GENERAL] COPY command documentation

Scott Marlowe wrote: On Thu, 2006-03-23 at 14:12, David Fetter wrote: On Thu, Mar 23, 2006 at 07:00:13PM +0100, Jim Nasby wrote: On Mar 23, 2006, at 4:08 PM, Oisin Glynn wrote: I just discovered that the comments from 8.0 had the answer I was looking for but these comments

[GENERAL] COPY command documentation

I have driven myself to distraction for the last 30 minutes trying to get COPY to work on Windows XP. The Unix style c:/afolder/afile instead of c:\afolder\afile was a desperation attempt. I had tried all sorts of double slashes \\ putting the whole path in quotes basically all sorts of fool

Re: [GENERAL] PostgreSQL on Windows not starting

Chris Travers wrote: I have a customer who is having issues starting PostgreSQL 8.1 on Windows. It worked for a while and now doesn't appear to be running. I thought it was probably a stale pidfile, but had him search and could not find it. Is the pid information still in a pidfile or is it

[GENERAL] [Fwd: Schema Question]

Hi, I have some tables and functions in the public schema. This was probably not the right thing to do. I have a seperate schema with a function and table. The function does a select on the table. The table and function exist in public schema and betteridea schema. I have a user betteridea

Re: [GENERAL] Oracle purchases Sleepycat - is this the "other shoe"

Steve Manes wrote: Marc G. Fournier wrote: As of this moment, if Oracle buys Zend, they could effectively kill PHP ... the core engine that PHP is built around is a Zend engine, so if they were to revoke the license for that, PHP would be dead ... kinda like MySQL with InnoDB ... now, there wa

[GENERAL] VACUUM Question

We have 2 tables we expect to grow by up to 50,000 rows per day each depending on the customer.  In normal operation we will most likely never update or delete from these tables as they are for historical reporting. (Eventually we may but a limit on the amount of data and delete older than X

[GENERAL] DBLINK on WINDOWS?

Hi,   I am trying to get some information on using DBLINK on windows?    I am not having much luck searching the forums/google. Has anyone been using DBLINK on Windows. I am Using 8.03 on Windows 2000.   Ideally I would like to be able to send data from postgres to and from ODBC compliant

Re: [GENERAL] How to pass the password for login in psql

BAT FILE SHOULD CONTAIN set PGPASSWORD=postgres "psql.exe" MYDATABASE -U postgres -f mysqlfile.sql Oisin - Original Message - From: "Josef Springer" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 19, 2005 1:26 PM Subject: [GENERAL] How to pass the password for login in psql Hi, i wa

[GENERAL] System info in/through database on Windows 2000 Postres 8.x

Hi, I am wondering if there is a way to get simple (or more advanced ) system information from the database about the server. Free disk space, Memory usage, CPU usage. And any other health of system information in general. I have done some archive searching but not turned up very much. This

Re: [GENERAL] Referential integrity using constant in foreign key

Is the goal to have code1 always equal 1 and code2 always to equal 2? If this is your goal and you are trying to ensure no-one enters anything other than a 1 in code1 or a 2 in code2 is a check constraint what you are after? I guess if the 2 columns code1 and code2 have fixed values 1 and 2 it se

Re: [GENERAL] is there anyway to get the backends IP address from

I have hit this as well though unlike Tony my errors are generally not test cases! If for example you mistype a column/variable name inside the function Postgres will create and allow the function to run as long as the path through the function containing the error is not executed. It would be

Re: [GENERAL] Group By and wildcards...

This is a very NEWBIE suggestion. I am fully prepared to be laughed out of town... But the where clause defines the result of the aggregate function (in this case the SUM)? Is the only reason for needing the GROUP BY CLAUSE is because the aggregate function demands it? If so could something lik

Re: [GENERAL] Functions with more than 32 parameters

Any advice for an opensource newbie running on Windows 2000? How hard is it to rebuild for windows? Any instructions? What compiler? Oisin - Original Message - From: "Bradley D. Snobar" <[EMAIL PROTECTED]> To: ""Oisin Glynn"" <[EMAIL PROTECTED]>

[GENERAL] Functions with more than 32 parameters

Hi, I am trying to keep database access encapsulated in functions from an insert and update point of view so as all of the applications writing to the database are using the same functions/statements. My problem is I was creating functions to do inserts/updates and now I have a table with more

Re: [GENERAL] Netstat - Lots of PG Connections

If this is a windows box I have noticed that the TIME_WAIT lasts far longer than on linux/unix. It is defined as a multiple of double of another TCPIP timer in the registry! Oisin - Original Message - From: "Lonni J Friedman" <[EMAIL PROTECTED]> To: "CSN" <[EMAIL PROTECTED]> Cc: Sent: T

Re: [GENERAL] Select from function for part of column results

I have something simlar working on windows in V 8.0 My select loks like: SELECT *,function_message_context(inbox.rowid) from inbox; Hope this helps. Oisin - Original Message - From: "Rory Campbell-Lange" <[EMAIL PROTECTED]> To: "Postgresql General List" Sent: Thursday, February 03,