Hi
I imported some text using the Quantum GIS dxf2postgiswhich somehow
became distorted through the import.
What should have been imported was TK-208.
What I got was %%UTK-208%%U.
Perhaps I did something wrong while using dxf2postgis?
Otherwise, I can trim the text using - select trim
Hi
I have an unused computer which I am considering turning into a server to run
my Postgresql database.
Is this even possible to do?
If so, can someone suggest an open source server that is relatively easy to set
up? Windows based would be ideal.
Bob
Hi
select
case when somevariable = 2
then (insert into pipe (line)
select bob.edge_data.edge_id
from bob.edge_data, bob.node, pipe
where st_intersects(st_startpoint(bob.edge_data.geom), bob.node.geom)
and bob.node.node_id = 415
and pipe.id = 1)
I am
Hi Alban
Probably no difference except I have four cases and I was trying, in an
attempt to save processing time, to compact commands a little.
Bob
-Original Message-
From: Alban Hertroys
Sent: Tuesday, August 07, 2012 3:40 PM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL
OWNER TO postgres;
-- Trigger: pidnum on project.project
-- DROP TRIGGER pidnum ON project.project;
Help would be appreciated.
Bob
-Original Message-
From: Adrian Klaver
Sent: Wednesday, July 18, 2012 5:47 PM
To: Bob Pawley
Cc: Alan Hodgson ; pgsql-general@postgresql.org
Subject: Re
In all my reading of new and old I never made that connection.
Thanks Adrian
Bob
-Original Message-
From: Adrian Klaver
Sent: Thursday, July 19, 2012 6:50 AM
To: Bob Pawley
Cc: Alan Hodgson ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Trouble with NEW
On 07/19/2012 06
Hi
I would appreciate some fresh eyes on this expression -
update p_id.fluids
set fluid_short =
(select shape.text
from shape, num_search
where (select st_within(shape.wkb_geometry,
st_geometryn(num_search.the_geom4, 1)) = 'true')
and text !~ '[0-9]')
where
It's an insert after trigger function.
The table has a column named fluid_id.
Bob
-Original Message-
From: Alan Hodgson
Sent: Wednesday, July 18, 2012 11:15 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Trouble with NEW
On Wednesday, July 18, 2012 11:07:34 AM Bob Pawley
character varying(100),
pump1 character varying(5),
pump2 character varying(5),
CONSTRAINT fluid_pk PRIMARY KEY (fluid_id)
);
Bob
-Original Message-
From: Adrian Klaver
Sent: Wednesday, July 18, 2012 1:07 PM
To: Bob Pawley
Cc: Alan Hodgson ; pgsql-general@postgresql.org
Subject: Re
Could someone point me to documentation regarding DDL triggers in Postgresql?
Bob
:36 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] DDL Triggers
On 02/15/2012 08:25 AM, Bob Pawley wrote:
Could someone point me to documentation regarding DDL triggers in
Postgresql?
You are going to need to be more specific. Are you talking triggers that
are activated by a DDL statement
Hi
Normally when I need to run a function during an insert I make it a trigger
function of that table.
However, in this case, I need to overwrite the table with which the trigger is
attached.
I would appreciate any suggestions on how to do this.
Bob
Hi
PostgreSQL v9.0
Win 7
I am using the following to dump a database.
I get an error – “could not open output file “.backup”. Permission
denied.”
To me, this sounds as if I am required to create an output file in order to get
an output file.
In previous versions the output file was
The file doesn't exist.
Just in case, I modified the dump to pg_dump -h localhost -p 5432 -U
postgres -v -f PDW2_cp_Nov_2011.backup PDW and got the same error.
Bob
-Original Message-
From: Guillaume Lelarge
Sent: Wednesday, November 09, 2011 9:48 AM
To: Bob Pawley
Cc: Postgresql
-
From: Guillaume Lelarge
Sent: Wednesday, November 09, 2011 9:48 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] DB Dump
On Wed, 2011-11-09 at 08:58 -0800, Bob Pawley wrote:
Hi
PostgreSQL v9.0
Win 7
I am using the following to dump a database.
I get an error – “could not open
I'm logged on to my computer as an administrator(and am the only user). What
other permission do I need??
Bob
-Original Message-
From: Adrian Klaver
Sent: Wednesday, November 09, 2011 10:00 AM
To: Bob Pawley
Cc: Guillaume Lelarge ; Postgresql
Subject: Re: [GENERAL] DB Dump
On 11/09
Opening Command Prompt as administrator solved my problem.
Thanks everybody.
Bob
-Original Message-
From: Raymond O'Donnell
Sent: Wednesday, November 09, 2011 10:41 AM
To: Bob Pawley
Cc: Adrian Klaver ; Guillaume Lelarge ; Postgresql
Subject: Re: [GENERAL] DB Dump
On 09/11/2011
Hi
I am attempting to dump a database using PostgreDAC.
I am getting the following error message which I don’t understand.
Can someone shed some light on this?
“Error message from server: ERROR: column tgisconstraint does not exist
LINE 1: ...c AS tgfname, tgtype, tgnargs, tgargs, tgenabled,
Hi
I have an error somewhere in one of the trigger functions in my database. The
error message only told me it was a ‘Select * From (table name).
Is there a global method of finding where this expression resides other than
searching each script individually.
Bob
Hi
Is there a method of counting the number of elements in an array??
Bob
Hi
I’m having problems making PostgreDAC’s PSQLRestore work without an access
violation.
Could someone please point me to an example code that I can check?
(My PSQLDump is working well, so I am using a valid restore file.)
Bob
-Original Message-
From: Adrian Klaver
Sent: Thursday, September 08, 2011 1:41 PM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] PSQLRestore
On 09/08/2011 09:09 AM, Bob Pawley wrote:
Hi
I’m having problems making PostgreDAC’s PSQLRestore work without an
access violation
-Original Message-
From: Raymond O'Donnell
Sent: Thursday, September 08, 2011 3:23 PM
To: Bob Pawley
Cc: Adrian Klaver ; Postgresql
Subject: Re: [GENERAL] PSQLRestore
On 08/09/2011 23:02, Bob Pawley wrote:
The problem seems to be in this code which I am using to transfer from
-Original Message-
From: Bill Moran
Sent: Thursday, September 01, 2011 8:19 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name
http://www.postgresql.org/docs/9.0/static/plpgsql-statements.html
Section 39.5.4
If you're not familiar with plpgsql at all, you
-Original Message-
From: Raymond O'Donnell
Sent: Friday, September 02, 2011 10:38 AM
To: Bob Pawley
Cc: Bill Moran ; Postgresql
Subject: Re: [GENERAL] Variable column name
On 02/09/2011 18:33, Bob Pawley wrote:
-Original Message-
From: Bill Moran
Sent: Thursday
-Original Message-
From: Bill Moran
Sent: Friday, September 02, 2011 10:53 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name
In response to Bob Pawley rjpaw...@shaw.ca:
I am getting an error -- column 1 does not exist
snip
Select 1 into column
Hi
I want to add information to multiple columns (20 – 40) by employing a loop.
Each pass of the loop will populate one column with an array.
I have tried and I have read that variables can not be used to control column
names.
Is there a means of working around this restriction other than
-Original Message-
From: Bill Moran
Sent: Thursday, September 01, 2011 7:59 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Variable column name
In response to Bob Pawley rjpaw...@shaw.ca:
I want to add information to multiple columns (20 – 40) by employing a
loop. Each
Hi
I exploring the use of arrays.
So far I have created a table and inserted a row and updated the row with an
array
Update library.compare
set _base =
'{2, 0.764149497122068, 4.8886}'
where process_id = 2;
– successfully.
However when I attempt to update a specific element of the
I'm not sure what you mean.
_base -- not base -- is the column name.
Bob
-Original Message-
From: Merlin Moncure
Sent: Monday, August 22, 2011 11:03 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Updating Arrays
On Mon, Aug 22, 2011 at 12:54 PM, Bob Pawley rjpaw...@shaw.ca
left the schema and tables empty as I understand that doing so will dump the
whole database.
Any help would be appreciated.
Bob
From: raghu ram
Sent: Thursday, May 12, 2011 11:36 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Postgredac Dump
On Thu, May 12, 2011 at 10:02 PM, Bob
The last log entry was two hours before I attempted to dump.
Bob
-Original Message-
From: Raymond O'Donnell
Sent: Friday, May 13, 2011 10:44 AM
To: Bob Pawley
Cc: raghu ram ; Postgresql
Subject: Re: [GENERAL] Postgredac Dump
On 13/05/2011 18:30, Bob Pawley wrote:
Hi Raghu
-
From: Raymond O'Donnell
Sent: Friday, May 13, 2011 10:44 AM
To: Bob Pawley
Cc: raghu ram ; Postgresql
Subject: Re: [GENERAL] Postgredac Dump
On 13/05/2011 18:30, Bob Pawley wrote:
Hi Raghu
Thanks for the site.
I am still having problems.
The following downloads a file of 0 bytes.
procedure
Hi
Can anyone point me to an example of how to use the Postgresdac Dump component??
Bob
is a point.
Bob
-Original Message-
From: Adrian Klaver
Sent: Thursday, April 21, 2011 7:22 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley ; Scott Marlowe
Subject: Re: [GENERAL] Different views of remote server
On Thursday, April 21, 2011 9:24:57 am Bob Pawley wrote:
Hi Scott
According
: Thursday, April 21, 2011 7:22 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley ; Scott Marlowe
Subject: Re: [GENERAL] Different views of remote server
On Thursday, April 21, 2011 9:24:57 am Bob Pawley wrote:
Hi Scott
According to NSAuditor(www.nsauditor.com) there is only one server with
port
If it's empty space at the beginning it goes on for a long time.
Can I send the table as an sql dump as an attachment with the list??
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, April 22, 2011 1:29 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org ; Scott Marlowe
@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Different views of remote server
On Wednesday, April 20, 2011 11:09:59 am Bob Pawley wrote:
Hi
This is probably going to turn out to be me doing something stupid, but-
I have two computers, one of which I use as a remote server for my
database.
When
: Scott Marlowe
Sent: Wednesday, April 20, 2011 7:38 PM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL] Different views of remote server
On Wed, Apr 20, 2011 at 1:09 PM, Bob Pawley rjpaw...@shaw.ca wrote:
Hi
This is probably going to turn out to be me doing something stupid, but-
I have two
Hi
This is probably going to turn out to be me doing something stupid, but-
I have two computers, one of which I use as a remote server for my database.
When I connect to the remote database through my interface there are errors
that suggest a problem with the data in one of the tables.
Hi Bill
Thanks for answering.
The problem turned out to be the excessive permissions required in Windows 7
Firewall.
It appears to be working now.
Bob
-Original Message-
From: Bill Moran
Sent: Monday, January 10, 2011 5:55 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL
Hi
I am attempting to connect from two local interfaces to a remote database.
With one interface (SharpMap developed in C#) I have no problems.
With the other interface (Delphi) I have no problem connecting in design mode.
However when I compile Delphi it just hangs, until timeout, without
-Original Message-
From: Alban Hertroys
Sent: Wednesday, December 29, 2010 4:03 AM
To: Bob Pawley
Cc: Adrian Klaver ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 29 Dec 2010, at 4:40, Bob Pawley wrote:
It seems that this has affected just the triggers
-Original Message-
From: Adrian Klaver
Sent: Wednesday, December 29, 2010 8:08 AM
To: pgsql-general@postgresql.org
Cc: Leif Biberg Kristensen
Subject: Re: [GENERAL] Restore problem
On Wednesday 29 December 2010 4:34:39 am Leif Biberg Kristensen wrote:
On Wednesday 29. December 2010
Hi
I have restored a database using psql to windows version 8.4.
During the restore the trigger code became jumbled.
I now have a great number of lines that have moved so that they are now
included in lines the have been commented out – not to mention that the code
is hard to read.
Is
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 4:21 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 3:06:40 pm Bob Pawley wrote:
Hi
I have restored a database using psql to windows version
Yes I was just looking at it.
It seems that it was dumped in that form.
Any thoughts on how that could happen?? Not that it will help in this
instance.
Bob
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:09 PM
To: Bob Pawley
Cc: pgsql-general
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:09 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 5:58:51 pm Bob Pawley wrote:
-Original Message-
From: Adrian Klaver
Sent
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 6:51 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On Tuesday 28 December 2010 6:41:51 pm Bob Pawley wrote:
Bob
--
Adrian Klaver
adrian.kla...@gmail.com
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:06 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:05 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Adrian Klaver
Sent: Tuesday, December 28, 2010 7:33 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On 12/28/2010 07:27 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Tuesday, December
-Original Message-
From: Alan Hodgson
Sent: Tuesday, December 28, 2010 8:12 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore problem
On December 28, 2010, Adrian Klaver adrian.kla...@gmail.com wrote:
On 12/28/2010 07:40 PM, Bob Pawley wrote:
Open the file
Hi
I am attempting to restore a database using -
psql PDW PDW_June_10.sql
psql –U postgres PDW PDW_June_10.sql
The response asks me for a password.
I use the same password with which I connect to the server but it is not
accepted.
Without the –U postgres identifier it asks me for the
-general@postgresql.org
Cc: Bob Pawley
Subject: Re: [GENERAL] Restore
On Friday 24 December 2010 12:36:32 pm Bob Pawley wrote:
Hi
I am attempting to restore a database using -
psql PDW PDW_June_10.sql
psql –U postgres PDW PDW_June_10.sql
psql –U postgres -d PDW -f PDW_June_10.sql
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver adrian.kla...@gmail.com
wrote:
On Friday 24 December 2010 3:28:38 pm Bob Pawley wrote:
Thanks Adrian but
psql –U postgres -d PDW -f PDW_June_10.sql
asks - Password for user postgres
for the postgres user other than what PG Admin uses.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 4:09 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley ; bricklen
Subject: Re: [GENERAL] Restore
On Friday 24 December 2010 4:03:52 pm Bob Pawley wrote:
I have tried
.
Maybe I need to delete the postgres database.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 4:27 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org ; bricklen
Subject: Re: [GENERAL] Restore
On Friday 24 December 2010 4:20:13 pm Bob Pawley wrote:
Version
I just stopped the server after changing config to trust and I got the
message `System error 5 has occurred. Access is denied`
Perhaps this is a clue.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 5:15 PM
To: Bob Pawley
Cc: pgsql-general@postgresql.org
I didn't copy or paste anything. I just clicked Stop.
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 5:41 PM
To: Bob Pawley
Cc: adrian.kla...@gmail.com ; pgsql-general@postgresql.org ; bricklen
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 6:20 PM
24, 2010 6:12 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 5:03 PM, Bob Pawley rjpaw...@shaw.ca wrote:
I don't know what is meant by your reference to \1.
That's a \l the letter l, not a number. It lists the databases
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 6:23 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 7:20 PM, Bob Pawley rjpaw...@shaw.ca wrote:
When I type psql I am asked for a password
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 6:49 PM
To: Bob Pawley
Cc: bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 7:36 PM, Bob Pawley rjpaw...@shaw.ca wrote:
-Original Message- From: Scott
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:17 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:09 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:17 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:09 PM, Bob Pawley wrote:
-Original Message- From: Scott Marlowe
Sent
I tried PDW# \i PDW_June_2_2010.sql (\i FILE as per help)
My guess didn't work.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:33 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24
No error it just went back to PDW#
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December 24, 2010 7:51 PM
To: Bob Pawley
Cc: Adrian Klaver ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 8:46 PM, Bob Pawley rjpaw
Yes the file is in the postgresql bin and that is where I changed directory
to begin this saga.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:49 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
The file is an .sql file from a database dump - same procedure I have used a
number of times previous to this upgrade.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:53 PM
To: Scott Marlowe
Cc: Bob Pawley ; bricklen ; pgsql-general@postgresql.org
Subject
I am installing 8.4 as I had problems with 8.3.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 7:59 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 07:57 PM, Bob Pawley wrote
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:08 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:03 PM, Bob Pawley wrote:
I am installing 8.4 as I had problems with 8.3.
Bob
Thanks for hanging in there.
Merry Christmas to all.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:21 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:15 PM, Bob Pawley wrote
Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On 12/24/2010 08:15 PM, Bob Pawley wrote:
-Original Message- From: Adrian Klaver
Sent: Friday, December 24, 2010 8:08 PM
To: Bob Pawley
Cc: Scott Marlowe ; bricklen ; pgsql-general
Hi
I am attempting to see if my Postgresql installation is running.
I’ve found this -
[root user only] ./database_service.pl status
I don’t understand what is meant by root user.
I also don’t know how “./database_service.pl status” is used.
Bob
Hi Dimitriy
Did you ever get an answer to your query regarding connection security.
I`m not only interested in this aspect, I am also interested in how to detect
any unauthorized connection attempt whether through the front door or the back
door.
Bob
From: Dmitriy Igrishin
Sent: Wednesday,
: Ashesh Vashi
Sent: Monday, May 31, 2010 11:33 AM
To: Bob Pawley
Cc: Postgresql ; adrian.kla...@gmail.com
Subject: Re: [GENERAL] Installing version 8.4
Hi Bob,
On Mon, May 31, 2010 at 10:57 PM, Bob Pawley rjpaw...@shaw.ca wrote:
During the install it was recommended that I run the scripts
During the install it was recommended that I run the scripts at
PostgresPlus\8.4ss\share\PostgreSQL\contrib
The folder contrib is present holding 78 files. But the PostgreSQL folder is
missing.
Perhaps, that may be of some help?
Also I got the same error on my other computer that is running
From: Ashesh Vashi
Sent: Monday, May 31, 2010 11:33 AM
To: Bob Pawley
Cc: Postgresql ; adrian.kla...@gmail.com
Subject: Re: Installing version 8.4
Hi Bob,
On Mon, May 31, 2010 at 10:57 PM, Bob Pawley rjpaw...@shaw.ca wrote:
During the install it was recommended that I run the scripts
adrian.kla...@gmail.com
Sent: Saturday, May 29, 2010 4:35 PM
To: Bob Pawley rjpaw...@shaw.ca
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing version 8.4
On Saturday 29 May 2010 4:26:08 pm Bob Pawley wrote:
Found it in XP it doesn't seem to exist in Windows 7. I can't even find
Doc
Hi Ashesh
Where would I find initcluster.vbs ?
Bob
From: Ashesh Vashi
Sent: Sunday, May 30, 2010 7:27 AM
To: Bob Pawley
Cc: adrian.kla...@gmail.com ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Installing version 8.4
Hi Bob,
On Sun, May 30, 2010 at 4:30 PM, Bob Pawley rjpaw
these installation errors??
Bob Pawley
: Saturday, May 29, 2010 3:54 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley rjpaw...@shaw.ca
Subject: Re: [GENERAL] Installing version 8.4
On Saturday 29 May 2010 3:09:05 pm Bob Pawley wrote:
Hi
I'm having problems installing PostgreSQL 8.4 on Windows 7. (See below)
I downloaded the install
Hi
I don't understand what the following error means.
I am trying to add a foreign key to table image, that holds column device_id.
This is to be controlled by column devices_id in table devices.
ALTER TABLE distributors ADD CONSTRAINT distfk FOREIGN KEY (address) REFERENCES
addresses
Hi
I am developing a PostgreSQL/PostGIS application (Geometric not Geographic).
I want to have the database on the web with a desktop user interface and viewer.
The usual method is to install a PostgreSQL server on a website and go from
there.
However, seeking a more flexible approach, I
Hi
I have an interface (Delphi) for my Postgresql database, that is telling me
that I have an inconsistancy between one of the Postgresql triggers and a
Postgresql table. The problem for me is - the message doesn't give me enough
information to determine which trigger has the error.
Is there
To: Bob Pawley rjpaw...@shaw.ca
Cc: Tom Lane t...@sss.pgh.pa.us; Postgresql
pgsql-general@postgresql.org
Sent: Saturday, January 23, 2010 10:06 AM
Subject: Re: [GENERAL] Old/New
On Saturday 23 January 2010 7:51:28 am Bob Pawley wrote:
I havn't been able to find documentation on how to use \d
wasn't
aware.
Bob
- Original Message -
From: Adrian Klaver adrian.kla...@gmail.com
To: Bob Pawley rjpaw...@shaw.ca
Cc: Tom Lane t...@sss.pgh.pa.us; Postgresql
pgsql-general@postgresql.org
Sent: Friday, January 22, 2010 3:37 PM
Subject: Re: [GENERAL] Old/New
On Friday 22 January 2010
using only PostgreSQL.
This is the reason that I have been avoiding Update triggers until now, so,
if anyone can help my understanding of what is happening I would appreciate
it.
Bob
- Original Message -
From: Tom Lane t...@sss.pgh.pa.us
To: Bob Pawley rjpaw...@shaw.ca
Cc
,
process_graphics_id, device_description)
values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #2', '11',
'Pump');
End if ;
RETURN NULL;
END;
Bob
- Original Message -
From: Tom Lane t...@sss.pgh.pa.us
To: Bob Pawley rjpaw...@shaw.ca
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday
versions of the same row.
Bob
- Original Message -
From: Adrian Klaver adrian.kla...@gmail.com
To: Bob Pawley rjpaw...@shaw.ca
Cc: Tom Lane t...@sss.pgh.pa.us; Postgresql
pgsql-general@postgresql.org
Sent: Friday, January 22, 2010 12:34 PM
Subject: Re: [GENERAL] Old/New
On 01/22/2010
I have a single row that is being duplicated on insert.
Update statement -
update p_id.processes
set pump1 = 'True'
where p_id.processes.fluid_id = '3501' ;
The proper field is updated.
Bob
- Original Message -
From: Adrian Klaver adrian.kla...@gmail.com
To: Bob Pawley rjpaw
adrian.kla...@gmail.com
To: Bob Pawley rjpaw...@shaw.ca
Cc: Tom Lane t...@sss.pgh.pa.us; Postgresql
pgsql-general@postgresql.org
Sent: Friday, January 22, 2010 1:24 PM
Subject: Re: [GENERAL] Old/New
On 01/22/2010 01:16 PM, Bob Pawley wrote:
I have a single row that is being duplicated on insert
Lane t...@sss.pgh.pa.us
Cc: Bob Pawley rjpaw...@shaw.ca; Postgresql
pgsql-general@postgresql.org
Sent: Friday, January 22, 2010 3:01 PM
Subject: Re: [GENERAL] Old/New
On Friday 22 January 2010 2:05:02 pm Tom Lane wrote:
Bob Pawley rjpaw...@shaw.ca writes:
Instead I get two identical rows
No
The table p_id.processes is the start of the fluid_id ident and that column
is serial.
Bob
- Original Message -
From: Adrian Klaver adrian.kla...@gmail.com
To: Bob Pawley rjpaw...@shaw.ca
Cc: Tom Lane t...@sss.pgh.pa.us; Postgresql
pgsql-general@postgresql.org
Sent: Friday
Hi
I am getting a strange result when using the following -
Select fluid_id into fluidid
from p_id.processes
where new.pump1 = 'True'
and old.pump1 = 'False'
or old.pump1 is null;
The fluid_id return is fine when there is a single row. However with two rows,
and updating only one of the
Hi
I have a table that has one column (pump1) controlled by a dbcheckbox. The
values can be True, False or null.
I want to insert a row of values into second table when column pump1 value is
'True'. I don't want the trigger to insert a row when other columns of the
first table are updated or
PostgreSQL does not support specific column updates in triggers.
I found this statement on a blog.
Is there a workaround for this?
I've attempted using 'new' (refering to the specific column) without success.
Bob
which includes pump1 and pump2 as well as the serial
column.
Hope this elucidates you?
Bob
- Original Message -
From: Tom Lane t...@sss.pgh.pa.us
To: Bob Pawley rjpaw...@shaw.ca
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, November 15, 2009 3:43 PM
Subject: Re: [GENERAL
Thanks Sam
Worked perfectly.
Bob
- Original Message -
From: Sam Mason s...@samason.me.uk
To: pgsql-general@postgresql.org
Sent: Thursday, November 05, 2009 10:28 AM
Subject: Re: [GENERAL] Adding a null
On Thu, Nov 05, 2009 at 10:13:28AM -0800, Bob Pawley wrote:
However one
Hi
My copy of PostgreSQL version 8.3 has decided not to receive a connection after
an idle time measured in hours.
It acceptes the connection one I stop the server and then restart. At this
point, it always asks for the password.
Here is the log of the event -
FATAL: could not reattach to
1 - 100 of 341 matches
Mail list logo