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:
Shahaf Abileah wrote:
I’m looking for a systematic way to document the schema for the
database behind our website (www.redfin.com http://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
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
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
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 noticed.
For high end systems we use Windows 2003 Server
Oisin Glynn
PLPGSQL;
--
Oisin Glynn My status skype:oisinglynn?call
smime.p7s
Description: S/MIME Cryptographic Signature
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
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
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
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
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 database engine for our application
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-general@postgresql.org
Subject: Re: [GENERAL] Database
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
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
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 using the
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
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
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:
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?
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 Server
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
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
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,
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: operator does
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
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
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
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
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
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
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
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
We have 2 tables we expect to grow byup to
50,000 rows per day eachdepending on the customer. In normal
operation we will most likely never update or delete from these tables
asthey arefor historical reporting. (Eventually we may but a limit
on the amount of data and delete older than X
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
amUsing 8.03 on Windows
2000.
Ideally I would like to be able to send data from
postgres to and from ODBC compliant
BAT FILE SHOULD CONTAIN
set PGPASSWORD=postgres
psql.exe MYDATABASE -U postgres -f mysqlfile.sql
Oisin
- Original Message -
From: Josef Springer [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Tuesday, July 19, 2005 1:26 PM
Subject: [GENERAL] How to pass the password for
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.
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
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
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]
Sent: Wednesday, February 09, 2005 10:40 PM
Subject
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:
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 pgsql-general@postgresql.org
Sent:
41 matches
Mail list logo