Thanks Adrian but
psql –U postgres -d PDW -f PDW_June_10.sql
asks - Password for user postgres:
When I type the password the cursor doesn't respond and on enter I get
password failed.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 2:59 PM
To: pgsql
the password it either said password failed or it simply went
back to the root command.
No database information was sent.
pg_hba.conf sets method as md5
I don't know what is meant by your reference to \1.
Bob
-Original Message-
From: bricklen
Sent: Friday, December 24, 2010 3:47 PM
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
When I type psql I am asked for a password. When I attempt to enter a
password the cursor doesn't move.
When I click enter I get failed password for - my computer name.
When I type psql \I - I get the same as above.
Bob
-Original Message-
From: Scott Marlowe
Sent: Friday, December
-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
I attempted loading earlier version of my backup database, using PDW# \I
PDW_May_2010 and it worked.
Looks as tho the June version may have been corrupt.
Thanks again for all of the help.
Bob
-Original Message-
From: Adrian Klaver
Sent: Friday, December 24, 2010 8:21 PM
To: Bob
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
Hi Ashesh
I managed to get 8.4 running.
I had previously downloaded PGAgent and installed it with no effect.
However I just reinstalled it from the File Manager and it did the job.
Now I want to get it going on XP but that isn`t quite so important.
Thanks for all your help.
Bob
From
Windows XP. So
if there is nothing wrong with the PostgreSQL installation it may well be some
common element in both my computers.
Bob
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
anyone suggest a way around these problems. (Enterprise support has yet to
answer).
Bob
I just downloaded and installed Postgresql 8.4 on Windows 7.
During the installation there were two error messages.
One indicated that PGAgent returned and error and the other gave no info
Found it in XP it doesn't seem to exist in Windows 7. I can't even find Doc
and Settings in 7.
It's a large file. I'm not sure what is needed but here is the latter part
of the file.
Bob
--
From: Adrian Klaver adrian.kla...@gmail.com
Sent
(address) MATCH FULL;
ERROR: insert or update on table image violates foreign key constraint
deviceidfk
DETAIL: Key (device_id)=(4022) is not present in table devices.
Help appreciated.
Bob
capability.
Is this a service that would be useful to others?
Bob
.
Is there some way of doing an overall search without having to search each
trigger individually??
Bob
/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 adrian.kla...@gmail.com
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
, 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
This is different from what you originally posted. Is the above still
causing problems?
Yes. The above inserts two
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
, fluid_id, status,
process_graphics_id, device_description)
values (new.p_id_id, new.process_id, new.fluid_id, 'Pump #1', '11',
'Pump');
End if;
Instead I get two identical rows inserted containing the fluid_id = '3501'
and 'Pump #1'.
Bob
- Original Message -
From: Adrian Klaver
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: Adrian Klaver adrian.kla...@gmail.com
To: Tom
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
of the rows, I quite often get the fluid_id for the other
row.
I am using an After Update trigger.
Bob
or when the pump1 column value becomes 'False'.
I would appreciate any suggestions as to how to accomplish this.
Thanks in advance.
Bob
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
as...@me.com wrote:
hi bob,
Undefined symbols:
_fopen$UNIX2003, referenced from:
_parseServiceInfo in libpq.i386(fe-connect.o)
_PasswordFromFile in libpq.i386(fe-connect.o)
ld: symbol(s) not found
collect2: ld returned 1 exit status
Any help would be greatly appreciated.
hm, fopen
//
// iPhonePgAppDelegate.m
// iPhonePg
//
// Created by bob on 11/4/09.
// Copyright __MyCompanyName__ 2009. All rights reserved.
//
#import iPhonePgAppDelegate.h
#import iPhonePgViewController.h
#include libpq-fe.h
@implementation iPhonePgAppDelegate
@synthesize window;
@synthesize viewController;
- (void
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
to shared memory (key=1804, addr=0170): 487
2009-10-29 00:19:20 PDT WARNING: worker took too long to start; cancelled
Is there some way of ensuring that the server always accepts a connection?
Bob
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
me as to the purpose?
Bob
of it.
Bob Gobeille
b...@fossology.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-createopclass.html
many thanks,
bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://www.postgresql.org/docs/8.3/interactive/sql-createopclass.html
I still don't understand the above, but the following works:
create index ufile_name_ginidx on uploadtree using
gin(to_tsvector('english', ufile_name));
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
I use PSQL to set my editor to vi. This works as expected in psql, \e
brings up vi and I edit away.
Is there any way to set my psql command line editor to also use vi
(just like I do with set -o vi in bash)?
I can't find this in the docs.
Thanks,
Bob Gobeille
b...@fossology.org
--
Sent
.
That should have been PSQL_EDITOR.
bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Aug 17, 2009, at 12:46 PM, Alvaro Herrera wrote:
Bob Gobeille wrote:
I use PSQL to set my editor to vi. This works as expected in psql,
\e brings up vi and I edit away.
Is there any way to set my psql command line editor to also use vi
(just like I do with set -o vi in bash)?
I can't
On Aug 17, 2009, at 1:18 PM, Alvaro Herrera wrote:
Bob Gobeille wrote:
I have in my .inputrc this line:
set editing-move vi
and it works like a charm.
I tried this and can't get it to work.
1) I tried putting that in my .bashrc script and sourcing the file
(and also logging
On Aug 17, 2009, at 1:27 PM, Steve Atkins wrote:
On Aug 17, 2009, at 12:15 PM, Bob Gobeille wrote:
On Aug 17, 2009, at 12:46 PM, Alvaro Herrera wrote:
Bob Gobeille wrote:
I use PSQL to set my editor to vi. This works as expected in psql,
\e brings up vi and I edit away.
Is there any
On Aug 17, 2009, at 1:38 PM, kbarn...@kevinbarnard.net wrote:
On Aug 17, 2009, at 1:46 PM, Alvaro Herrera wrote:
Bob Gobeille wrote:
I use PSQL to set my editor to vi. This works as expected in psql,
\e brings up vi and I edit away.
Is there any way to set my psql command line editor
that are guaranteed not to repeat after billions of
iterations. It's very fast as well. Then translate the resulting
integer into the character sequence of your choosing. Here is a
reference: http://en.wikipedia.org/wiki/Linear_feedback_shift_register
Bob Gobeille
Hewlett Packard
Open Source Program
(2);
INSERT INTO master (myint) VALUES (3);
INSERT INTO master_1 (myint) VALUES (1);
Is there anything wrong with this? It seems to work well but I am
concerned that I may be missing something since the docs say the
master will contain no data.
Thanks,
Bob Gobeille
b...@fossology.org
On Aug 7, 2009, at 5:44 PM, Greg Stark wrote:
On Sat, Aug 8, 2009 at 12:27 AM, Bob Gobeillebob.gobei...@hp.com
wrote:
I gather from rtfm that it is typical to set up partitions so that
the
master table has no records. But from my understanding of
partitions and
doing some tests, I don't
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
On Jul 29, 2009, at 7:02 AM, Jasen Betts wrote:
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary and
foreign keys to maintain referential integrity
On Jul 29, 2009, at 8:26 AM, nha wrote:
Hello,
Le 29/07/09 15:02, Jasen Betts a écrit :
On 2009-07-27, Bob Gobeille bob.gobei...@hp.com wrote:
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary and
foreign keys
I would like to combine multiple databases (same schema) into one
master db. Does anyone know how I can reconcile all my primary and
foreign keys to maintain referential integrity.
Many thanks,
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
FUNCTION p_id.ip_orient_3() OWNER TO postgres;
This is how I am calling the function -
select p_id.ip_orient_3();
The error message - control reached end of function without RETURN
I have attempted adding - Return integer; to the end of the function with no
success.
Can anyone help me??
Bob
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
trigger.
An other method would be to have the function triggered by a separate table and
then insert (then delete) a value into that table to trigger the function - but
I am hoping someone can come up with another way?
Bob
- Original Message -
From: Jonah H. Harris
To: Bob
on their machines
or would the interface connect directley to Postgresql - like a website??
Bob
- Original Message -
From: Stefano Nichele stefano.nich...@gmail.com
To: pgsql-general@postgresql.org
Sent: Monday, April 20, 2009 9:26 AM
Subject: Re: [GENERAL] postgreSQL amazon ec2 cloud
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
couple of attempts didn't leave a log behind.
Thanks
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
The log file states parameter listen-adress cannot be changed after
server start; conf change ignored.
I am getting this log entry after saving the file and reloading with the
server shutdown.
Does anyone have a procedure for making changes to this file?
Bob
- Original Message
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
I'm running 8.3 on Windows XP.
I input pg_ctl reload -D c:\program files\postgresql\8.3\data- or any
combination thereof, with or without brackets and the server is running.
The return is - 'pg_ctl: too many command-line arguments'.
Bob
- Original Message -
From: John R Pierce
that the pg_hba file also includes an adress in similar format -
127.0.0.1/32.
How does this compare to my address 192.168.1.100?
Thanks in advance.
Bob
- Original Message -
From: John R Pierce pie...@hogranch.com
To: PostgreSQL pgsql-general@postgresql.org
Sent: Thursday, February 12
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
of the computer and input the other info.
I also ran - listen virtual; on the receiving server.
It hasn't connected successfully. I get the message 'Server not listening'
What else can I do??
Bob
queries hang instead of returning an
error about the lost connection.
Suggestions?
Thanks,
Bob Gobeille
Hewlett Packard
Open Source Program Office
(and http://fossology.org)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
for the cases where
you need it.
Bob
Hi all.
Is there a way to have (sub)transactions within a function body?
I'd like to execute some code (a transaction!) inside a function and later
decide whether that transaction is to be committed or not.
Thanks.
, but I find this
method works for the cases where you need it(logging, huge batch processing
tasks where it's not ideal to process everything in one transaction).
Bob
Hi all.
Is there a way to have (sub)transactions within a function body?
I'd like to execute some code (a transaction!) inside
Coming from an Oracle background my understanding is they're one in the
same.
On Thu, Oct 2, 2008 at 10:37 AM, Alvaro Herrera
[EMAIL PROTECTED]wrote:
Bob Henkel escribió:
Have you looked at creating a function in perl and creating a new
connection? Or using a dblink query which can
=' || UTpk;
execute sql into UTrec;
IF ((UTrec.ufile_mode (128)) = 0) THEN RETURN NEXT UTrec;
END IF;
UTpk := UTrec.parent;
END LOOP;
RETURN;
END;
$$
LANGUAGE plpgsql;
Thanks,
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
*
from function_return_set) order by. But I see no way to reference the
table to be returned.
Thanks,
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
Following is more complete. The balance of the trigger that is not shown
works when tested separately. I didn't include it because it is quite long.
Bob
DECLARE
process_total integer ;
process_id integer ;
procgraphic cursor for select process_id from p_id.p_id, processes_count
where
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
101 - 200 of 491 matches
Mail list logo