I am on Windows and am running an anti virus program. But I was running the
same programs on Windows before without this problem.
Bob
- Original Message -
From: Richard Huxton d...@archonet.com
To: Bob Pawley rjpaw...@shaw.ca
Cc: pgsql-general@postgresql.org
Sent: Thursday, October 29
Hi
While looking at an error message for iexplore.exe, I noticed, on Task Manager,
that there are 5 or more instances of postgres.exe running. Each instance is
consuming between 7 to 10 megs of resources, for a total of almost 50 megs.
Is this normal behavour?
If so, could someone enlighten
I haven''t required line numbers on my query pages before now.
I'm using PGAdmin version 1.8.4.
Is this something that can be turned on?
Bob
Hi
I want to try using functions but I am having trouble understanding return.
This is the function -
CREATE OR REPLACE FUNCTION p_id.ip_orient_3()
RETURNS integer AS
$BODY$
Begin
Insert into fluids (fluid_id) values ('1') ;
End;
$BODY$
LANGUAGE 'plpgsql' VOLATILE
COST 100;
ALTER
That worked.
However, perhaps I don't understand the idea of a function.
If the , in this case ('1'), was in fact an unknown variable what would the
return be?
Bob
- Original Message -
From: John R Pierce pie...@hogranch.com
To: Bob Pawley rjpaw...@shaw.ca; pgsql-general
Pawley
Cc: John R Pierce ; pgsql-general@postgresql.org
Sent: Friday, June 26, 2009 10:30 AM
Subject: Re: [GENERAL] Need help using function
On Fri, Jun 26, 2009 at 1:28 PM, Bob Pawley rjpaw...@shaw.ca wrote:
However, perhaps I don't understand the idea of a function.
Please review
Hi Stefano
I'm intrigued with Amazon EC2 and did a little search on it.
From your experience could it be used in similar fashion as a website -
running a Postgresql database and having users access the database through
an interface?
If so, would the users need a Java environment installed
Hi
I've had the server shut itself down when attempting to connect, even with
PG Admin.
Is there anything I can do to ensure that the pg server continues to run
during a connection?
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
Admin forced a shutdown when I was on localhost
although my application attempting to conect did force a shutdown.
A simple 'stop' then 'start' resolves the immediate problem.
Bob
- Original Message -
From: Steve Crawford scrawf...@pinpointresearch.com
To: Bob Pawley rjpaw
What log should I get and how do I get it??
Bob
- Original Message -
From: Adrian Klaver akla...@comcast.net
To: Bob Pawley rjpaw...@shaw.ca
Cc: PostgreSQL pgsql-general@postgresql.org; Steve Crawford
scrawf...@pinpointresearch.com
Sent: Wednesday, March 11, 2009 10:21 AM
Subject
Hi
I do need some help here.
I am still having trouble making a remote connection. The 'Server doesn't
listen' message comes up.
The config files have been changed as shown below.
Postgresql.conf
#listen_addresses = '*'
pg_hba
# TYPE DATABASE USER CIDR-ADDRESs IP-Mask
Removed #
Reloaded postmaster, restarted server.
Server still isn't listening.
Bob
- Original Message -
From: John R Pierce pie...@hogranch.com
To: Bob Pawley rjpaw...@shaw.ca; pgsql-general@postgresql.org
Sent: Sunday, February 15, 2009 1:44 PM
Subject: Re: [GENERAL] Attempting
-
From: John R Pierce pie...@hogranch.com
To: Bob Pawley rjpaw...@shaw.ca; pgsql-general@postgresql.org
Sent: Sunday, February 15, 2009 1:44 PM
Subject: Re: [GENERAL] Attempting to connect
Bob Pawley wrote:
Hi
I do need some help here.
I am still having trouble making a remote connection
Finally Success
Thanks everyone
Bob
- Original Message -
From: John R Pierce pie...@hogranch.com
To: Bob Pawley rjpaw...@shaw.ca
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Sunday, February 15, 2009 3:05 PM
Subject: Re: [GENERAL] Attempting to connect
# IPv4 local
I am attempting to load postmaster.
pg_ctl reload
I don't understand what is needed for [-D DATADIR]. I have tried the path to
Postgresql with no luck.
I've also leftoff [-s] since it doesn't appear to be needed.
Help would be appreciated.
Bob.
--
Sent via pgsql-general mailing list
pie...@hogranch.com
To: PostgreSQL pgsql-general@postgresql.org
Sent: Saturday, February 14, 2009 2:25 PM
Subject: Re: [GENERAL] pg_hba reload
Bob Pawley wrote:
I am attempting to load postmaster.
pg_ctl reload
I don't understand what is needed for [-D DATADIR]. I have tried the path
, 2009 3:26 PM
Subject: Re: [GENERAL] Remote Connection
Bob Pawley wrote:
Hi
I've been operating on localhost successfully for some time.
I am now attempting to access a Postgresql 8.3 database installed on one
of my other computers conneted through a router.
Is this possible?
My first attempts
In pg_hba there is a reference to reloading postmaster using pg_ctl.
Does postmaster reload when the server is restarted??
Bob
- Original Message -
From: Raymond O'Donnell r...@iol.ie
To: Bob Pawley rjpaw...@shaw.ca
Cc: John R Pierce pie...@hogranch.com; PostgreSQL
pgsql-general
Hi
I've been operating on localhost successfully for some time.
I am now attempting to access a Postgresql 8.3 database installed on one of my
other computers conneted through a router.
Is this possible?
My first attempts have been with Postgresql Admin.
I changed host to the IP address of
Could somebody translate this error message for me??
Bob
cursor unnamed portal 1 is not simply updateable scan of table p_id
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
= '1'
where current of procgraphic;
I get the same error message when I define the cursor with the same select.
I am not sure how to make the query simpler and still have it access the
right row on fetch.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL
Is it allowed to declare a cursor in this manner??
Declare
procgraphic cursor for select p_id.p_id.process_id from p_id.p_id,
processes_count
where p_id.p_id.p_id_id = processes_count.p_id_id;
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL
I have the following cursor that gives me an error near open.
Can someone please tell me what I am doing wrong??
Bob
DECLARE
procgraphic cursor for select process_id from p_id.p_id, processes_count
where p_id.p_id.p_id_id = processes_count.p_id_id;
begin
Open procgraphic ;
Fetch
]
To: Richard Huxton [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; PostgreSQL
pgsql-general@postgresql.org
Sent: Tuesday, July 29, 2008 2:35 PM
Subject: Re: [GENERAL] Cursor
Richard Huxton [EMAIL PROTECTED] writes:
Bob Pawley wrote:
DECLARE
procgraphic cursor for select process_id from
Thanks Tom
Qualifying the column was the solution.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Richard Huxton [EMAIL PROTECTED]; PostgreSQL
pgsql-general@postgresql.org
Sent: Tuesday, July 29, 2008 2:51 PM
Subject: Re: [GENERAL
Yes
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: Tom Lane [EMAIL PROTECTED]; Bob Pawley [EMAIL PROTECTED]
Cc: Richard Huxton [EMAIL PROTECTED]; PostgreSQL
pgsql-general@postgresql.org
Sent: Tuesday, July 29, 2008 3:03 PM
Subject: Re: [GENERAL] Cursor
The syntax error was running the function while not in a trigger.
The trigger gave null as a return.
The error was syntax error at or near Open.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Richard Huxton [EMAIL PROTECTED
I haven't been able to find much information on Fetch for Update. Does 8.3
support this command??
If so, could someone please point out my error in the following?
Bob
BEGIN
SELECT count (p_id.pid.process_id) INTO Proccount
FROM p_id.p_id
WHERE process_id = new.process_id;
Declare
I understand that a cursor can be opened and used through sql commands.
However, when a host application accesses a particular row on a particular
table can that be detected within the sql medium?
Or does that information have the be accessed by transmitting from the host?
Bob
--
Sent
Is there a GUI for pg_dump???
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Is there a GUI for pg_dump???
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi
I'm copying PostgreSQL discussion group in case the following problem
involves their efforts.
I am running Postgresql 8.3 with Postgis latest version and PGAdmin 1.8.2 on
Windows XP.
I imported a shapefile using conversion and upload and it installed with no
problem.
When I viewed
IMHO and WADR I am on four different types of lists.
When I am following a thread I very much appreciate those respondents who
get their point across up front without making me wade through previous
posts which I have already read.
I can understand the concept of bottom posting as a means of
I need to ask this question.
What do you mean whan you say Don't top post???
I've seen this many times before and still don't understand.
Bob
- Original Message -
From: Andrej Ricnik-Bay [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Cc: Kevin Hunter [EMAIL PROTECTED];
Hi
I am seeking a simple viewer that will display WKT geometric information
housed in a Postgris of Postgresql database without it needing extensions,
srid, projectons or any other geographical attributes.
A simple database geometry viewer.
If anyone knows of such a device I would
]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Obe, Regina [EMAIL PROTECTED]; PostgreSQL
pgsql-general@postgresql.org
Sent: Wednesday, April 16, 2008 2:09 AM
Subject: Re: [GENERAL] Not Geography
Bob Pawley wrote:
[GENERAL] Not GeographyI have PostgreSQL, c/w the geometry
attachment, installed on Win XP. I
I have Postgresql database that I would like to link to the geometry side of
Postgis. (This has little comparison to geography)
Does anyone know of a tool or documentation that could get me started??
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
to be so geographically
oriented that I wanted to query a larger audience.
Bob
- Original Message -
From: Obe, Regina
To: Bob Pawley ; PostgreSQL
Sent: Tuesday, April 15, 2008 10:50 AM
Subject: RE: [GENERAL] Not Geography
I have Postgresql database that I would like to link
I'm getting a little frustrated with this problem.
Can anyone tell me what is wrong with the following code.
I have tested the portions separately and they all work.
When I try it as a whole I get the message control reached end of trigger
procedure without RETURN.
Any help greatly
The count procedure appears to be working well.
Thanks Adrian for your help.
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, March 23, 2008 4:04 PM
Subject: Re: [GENERAL] Insert
I have two tables - p_id.association and p_id.devices
If a new row in p_id.association has a value - say 2 in column mon_function
and a value 5 in column monitoring_fluid I want the new value for
mon_function inserted into table p_id.devices ONLY when 2 AND 5 do not
appear in the same row in
execute procedure monitor_install();
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, March 23, 2008 2:24 PM
Subject: Re: [GENERAL] Insert
On Sunday 23 March 2008 1:48 pm, Bob Pawley wrote
,
sump integer,
CONSTRAINT devices_pk PRIMARY KEY (devices_id)
)
WITHOUT OIDS;
ALTER TABLE p_id.devices OWNER TO postgres;
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, March 23, 2008 2:58 PM
!= . Is this symbol the same as ?
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Daniel Verite [EMAIL PROTECTED]; Bob Pawley
[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 7:16 AM
Subject: Re: [GENERAL] Updating
On Monday 17 March 2008 4:54 am
;
create trigger monitorinstall before update on p_id.association
for each row execute procedure monitor_install();
- Original Message -
From: Daniel Verite [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Adrian Klaver [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Monday
Is there a method available for triggering a function after an update on a
particular column in a table?
The only way that I have found is to trigger after an update on the whole
table, which of course can lead to problems.
Bob
--
Sent via pgsql-general mailing list
Would it be possible to get an example of such coding??
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 5:14 PM
Subject: Re: [GENERAL] Updating
On Sunday 16 March 2008 3
Jones [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Monday, February 11, 2008 10:29 AM
Subject: Re: [GENERAL] oids
On Feb 11, 2008, at 12:15 PM, Bob Pawley wrote:
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids' are oids still in use behind the scenes??
Bob
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I have a table with four columns that will either be null or hold the value
'true'.
I want to obtain the count of these columns, within a particular row, that
have 'true' as a value (0 to 4).
I have attempted the Select count method but it seems that I need something
more.
If anyone has
I use graphics in the application I am writing with PostgreSQL as the
database.
I am storing the graphics in a file separate from Postgres and accessing
them using lo_import.
Is there any method of incorporating the graphics into PostgreSQL so that
they become part of the database on
Thanks Erik. In between those attempts I did try what you suggest.
It failed, apparently due to not making a connection with the server.
Bob
- Original Message -
From: Erik Jones [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent
for each successful dump???
If not, does anyone have thoughts on where the problem could be??
Bob Pawley
---(end of broadcast)---
TIP 6: explain analyze is your friend
, at one
time??
If you see any other challenges to this plan, I would appreciate it if you
would please let me know.
Bob Pawley
At the moment the database dump is 4.1 meg.
I suspect the end result will be less than 10 meg including the user's
information.
Is there other size information you need?
Bob
- Original Message -
From: Richard Huxton [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc
.
The database will also be used to transfer information to other engineering
databases yet to be completed.
Bob
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Monday, December 03, 2007 8:35 AM
Hi
Is there any method of clearing the serial numbering so that ID references
can start afresh without rebuilding the database.
Of I use postgresql as part of my application I would like to use pgdump to
ensure that I have the latest version and starting the serial numbering at
#1 would be
If your holy grail is the ability of using infomation to drive drawings I
have to ask if you have any idea what that could lead too?
- Design productivity would increase by factors of hundreds - perhaps
thousands.
- Information would be infinitly adaptable.
- Structure that information
could theoretically just store
the vector additions/changes/deletions that happen from one revision to the
next.
-- Ilan
On Oct 30, 2007, at 11:34 AM, Bob Pawley wrote:
If your holy grail is the ability of using infomation to drive drawings I
have to ask if you have any idea what
the password.
I keep getting authentication failure.
When I attempt to do a new pg_dump with -Fc I also get a request for
password with identical results.
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED
.
If the error message is correct how does pg_restore know what to put where?
I used the same command to successfully install the same pg_dump file into
PostgreSQL 8.1 running on the same computer.
Any thoughts would be much appreciated.
Bob Pawley
---(end
.
This is becoming quite frustrating.
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, October 28, 2007 11:45 AM
Subject: Re: [GENERAL] pg_restore
On Sunday 28 October 2007 11:32 am, Bob
an aurel.sql file which I just
successfully dumped a few minutes ago from the 8.1 on my other computer.
Could pg_restore in my 8.2 be corrupted??
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Adrian Klaver [EMAIL PROTECTED]; pgsql-general
-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]; Tom Lane [EMAIL PROTECTED]
Sent: Sunday, October 28, 2007 3:15 PM
Subject: Re: [GENERAL] pg_restore
On Sunday 28 October 2007 3:01 pm, Bob Pawley wrote:
The latest in the saga -
By using - pg_restore -h localhost -d PDW -U postgres aurel.sql
I would like to try PostgreSQL 8.3 without uninstalling version 8.1.
Is this possible??
Bob Pawley
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Is there any way of converting text from an AutoCad (.dwg ot .dxf) file into a
PostgreSQL Database??
Bob Pawley
I have a column with data structured as follows.
32TT - 0002
32LT- 0004
32PT-0005
Is there a way of selecting all of the rows containing LT in that column??
I have attempted variations of ' *LT* ' with out success.
Bob Pawley
loop_set;
Bob Pawley
sequentially - lowest ID to highest ID or vice-versa?
3. Is there another mehod of accomplishing this task other than fetch?
Bob Pawley
That's marvelous - thanks.
Bob
- Original Message -
From: brian [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, October 18, 2007 9:45 AM
Subject: Re: [GENERAL] ordering rows
Bob Pawley wrote:
Hi
I have a table 'import' which is an amalgam of two other tables
next From loop_set;
Bob Pawley
The documentation states that PostgreSQL does not support updating data via a
cursor.
Has that changed in the last little while.
Bob Pawley
I want to be able to convert a PostgreSQL database to other formats such as
Oracle, Access etc. - with, as well as without, the data.
Can this task be accomplished by employing pg_dump in SQL?
Bob Pawley
Is there a better method of transfering the database and data to between
DBs?
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Tuesday, October 02, 2007 3:26 PM
Subject: Re: [GENERAL] pg_dump
Can anyone tell me why a table developed through the PG Admin interface isn't
found by SQL when accessing it through the SQL interface??
Bob Pawley
, are there any tools that may assist me in developing this graphic
interface?
Bob Pawley
clip_image001.gif
I have numerous entries in a column of table 1, some of which are duplicated.
I need to transfer this information to table 2 so that I have column that can
be used as a primery key.
Any help is appreciated.
Bob Pawley
Yes please send me a copy.
Bob
- Original Message -
From: Harvey, Allan AC [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]; Scott Marlowe
[EMAIL PROTECTED]
Cc: Csaba Nagy [EMAIL PROTECTED]; David Gardner
[EMAIL PROTECTED]; Postgres general mailing list
Hi All
Is there a fast and easy method of transferring information between MS Excel
and PostgreSQL??
Bob Pawley
. Drake wrote:
Bob Pawley wrote:
Hi All
Is there a fast and easy method of transferring information between MS
Excel and PostgreSQL??
odbc?
Joshua D. Drake
Bob Pawley
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
I am attempting to update a table using a value that is displayed on a TEdit
component. I am getting an access violation error.
Can someone tell me what I am doing wrong??
procedure TLoopBuilderForm.NewLoopButtonClick(Sender: TObject);
var Edit1 : TEdit ;
begin
I am looking for a mentor for PostgreSQL and Delphi.
I have developed a PostgreSQL database which needs to interface with an
existing Delphi application.
If anyone is interested please contact me off line at [EMAIL PROTECTED] .
Compensation to be discussed.
Bob Pawley
I've been using the PostgreSQL server without really understanding how it works
or how it is structured.
Could someone point me to a 'simple' description???
Bob Pawley
, through an alias (DeviceNotebookMouseUpAlias). I want
to have the Postgres use this alias to trigger the function.
Could someone point me to any literature that would help me with this project?
Bob Pawley
indicates an
incompatibility between the table's TStringField class and the TImage class.
Perhaps if I could solve that challenge I may be able to figure out the
rest.
Bob
- Original Message -
From: Andrej Ricnik-Bay [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; PostgreSQL
-
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Tuesday, March 20, 2007 2:16 PM
Subject: Re: [GENERAL] Postgresql to Delphi
Bob Pawley wrote:
Hi
I have posed this question to the Delphi list but they don't appear to
be able to help.
I am
with a second button. (Perhaps an
entire project of loops with a third button.)
Bob
- Original Message -
From: Andrej Ricnik-Bay [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Tuesday, March 20, 2007 2:28 PM
Subject: Re: [GENERAL
Looking through PGAdmin where would I find the spatial references that the
errror message references?
Bob
- Original Message -
From: Richard Huxton dev@archonet.com
To: Bob Pawley [EMAIL PROTECTED]
Cc: Dave Page [EMAIL PROTECTED]; Shoaib Mir [EMAIL PROTECTED];
Postgresql pgsql
Found it in template 1. This seems strange as both servers and pgadmins are
the same version and I haven't opened the template until today.
Bob
- Original Message -
From: Richard Huxton dev@archonet.com
To: Bob Pawley [EMAIL PROTECTED]
Cc: Dave Page [EMAIL PROTECTED]; Shoaib Mir
??
Bob
- Original Message -
From: Dave Page [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Shoaib Mir [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Friday, December 29, 2006 12:10 AM
Subject: Re: [GENERAL] Backup Restore
Bob Pawley wrote:
When I change
returned exit code 1.
The GIS feature was removed from the PostgreSQL application before the
project dump.
Anyone have any thoughts on how to get around this??
Bob
- Original Message -
From: Dave Page [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Shoaib Mir [EMAIL PROTECTED
PostgreSQL 8.1 running on Win XP. PGAdmin Version 1.6.2
When I backup my database on one computer using PG Admin 3 then attempt to open
the file on a second computer - PG Admin does NOT recognize the file. The
documentation isn't helpful, at least for a neophyte such as I.
Can someone point me
version??
Bob
- Original Message -
From: Dave Page [EMAIL PROTECTED]
To: Shoaib Mir [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Thursday, December 28, 2006 11:30 AM
Subject: Re: [GENERAL] Backup Restore
Shoaib Mir wrote:
Well I
When I change it to view all files it's there - but it won't do anything.
Bob
- Original Message -
From: Dave Page [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Shoaib Mir [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Thursday, December 28, 2006 12:06 PM
, function_,
type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow', 'mon',
'Flow') ;
Bob Pawley
If I can't use lo_import what method do you suggest I use for a large object
(in this case images).
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday, December 22, 2006 10:12 AM
Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday, December 22, 2006 10:32 AM
Subject: Re: [GENERAL] lo_import
On Fri, 2006-12-22 at 10:25 -0800, Bob Pawley wrote:
If I can't use lo_import what method do you
is it stated where the command is typed.Perhaps someone
can tell me?Bob Pawley
which in PostgreSQL is
Bob
- Original Message -
From: Ray Stell [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:07 AM
Subject: Re: [GENERAL] Starting Postgresql
a shell
http://en.wikipedia.org
which in PostgreSQL is
Bob
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To: Ray Stell [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:12 AM
Subject: Re: [GENERAL] Starting Postgresql
which in PostgreSQL is
Bob
101 - 200 of 341 matches
Mail list logo