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 (both
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 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
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 att
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
STRAINT name_ UNIQUE (p_id_name )
)
WITH (
OIDS=FALSE
);
ALTER TABLE project.project
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
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
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 P
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 p_id.flui
: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
Could someone point me to documentation regarding DDL triggers in Postgresql?
Bob
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
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
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
--Original Message-
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 – “coul
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
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 c
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
-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
-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.
The
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: 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" :
I am getting an error -- "column "1" does not exist"
Select
-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: Thu
-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
-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" :
I want to add information to multiple columns (20 – 40) by employing a
loop. Each pass o
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 cre
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 wrote:
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 array
-
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.
proc
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
viable database.
I 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, 2
Hi
Can anyone point me to an example of how to use the Postgresdac Dump component??
Bob
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 Ma
: 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
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
Acco
From: 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 wrote:
Hi
This is probably going to turn out to be me doing something stupid, but-
I have two compute
@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
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.
Using
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 ope
-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 1
-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: 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 wrote:
On 12/28/2010 07:40 PM, Bob Pawley wrote:
>> Open the file in Wordpad and see
-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: 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 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
> adria
-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
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 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
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 there
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
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
-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
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
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
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
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 wrote:
I
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
-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
-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 wrote:
-Original Message- From: Scott Marlowe
Sent: Friday
-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 wrote:
When I type psql I am asked for a password. When I attempt to
ember 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 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 da
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:
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
.
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
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
4, 2010 3:47 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Restore
On Fri, Dec 24, 2010 at 3:38 PM, Adrian Klaver
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 postgre
59 PM
To: pgsql-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 P
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 pa
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 wrote:
During the install it was recommended that I run the scripts at
PostgresPlus
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 wrote:
During the install it was recommended that I run the scripts at
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 Win
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 wrote
lete correctly
Failed to start the database server.
Creating Uninstaller
Creating uninstaller 25%
Creating uninstaller 50%
Creating uninstaller 75%
Creating uninstaller 100%
Installation completed
Log finished 05/29/10 at 15:37:22
--
From: "Adrian Klaver"
Sent: Saturday, May 29, 2
Sent: Saturday, May 29, 2010 3:54 PM
To:
Cc: "Bob Pawley"
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 from Enterpris
ould suggest a way around these installation errors??
Bob Pawley
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 (address
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 woul
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 s
/release-8-5.html
"Add a WHEN clause to CREATE TRIGGER, allowing a boolean expression to be
checked to determine whether the trigger should be fired."
Would this change solve my problem, or is there another solution around?
Bob
- Original Message -
From: "Adrian Klaver&quo
tion of which I wasn't
aware.
Bob
- Original Message -
From: "Adrian Klaver"
To: "Bob Pawley"
Cc: "Tom Lane" ; "Postgresql"
Sent: Friday, January 22, 2010 3:37 PM
Subject: Re: [GENERAL] Old/New
On Friday 22 January 2010 3:25:34 pm Bob
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"
To: "Bob Pawley"
Cc: "Tom Lane" ; "Postgresql"
Sent: Friday, January 22, 2010 3:19 PM
Subject: Re:
if;
If new.pump2 = 'True'
then
Insert into p_id.devices (p_id_id, process_id, fluid_id, status,
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
-
d = '3501'
and 'Pump #1'.
Bob
- Original Message -
From: "Adrian Klaver"
To: "Bob Pawley"
Cc: "Tom Lane" ; "Postgresql"
Sent: Friday, January 22, 2010 1:24 PM
Subject: Re: [GENERAL] Old/New
On 01/22/2010 01:16
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"
T
ginally posted. Is the above still
causing problems?
Yes. The above inserts two versions of the same row.
Bob
- Original Message -
From: "Adrian Klaver"
To: "Bob Pawley"
Cc: "Tom Lane" ; "Postgresql"
Sent: Friday, January 22, 2010 12:34 PM
S
Insert into p_id.devices (p_id_id, process_id, fluid_id, status,
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"
the interface, but
it happens even when I update pump1 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 Lan
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 r
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 w
ever, when the serial column is
updated I get a return which includes pump1 and pump2 as well as the serial
column.
Hope this elucidates you?
Bob
----- Original Message -
From: "Tom Lane"
To: "Bob Pawley"
Cc: "Postgresql"
Sent: Sunday, November 15, 2009 3
"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
Thanks Sam
Worked perfectly.
Bob
- Original Message -
From: "Sam Mason"
To:
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 variable sometimes returns a null v
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"
To: "Bob Pawley"
Cc:
Sent: Thursday, October 29, 2009 10:24 AM
Subject: Re: [GE
1 - 100 of 347 matches
Mail list logo
