On 07/01/11 01:56, Benjie Buluran wrote:
Hi pgSQL peeps!
I’m stumped on this question for over 3 days now.
PERFORM dblink_exec('SELECT sp_insert_detailtable('|| pActivityId ||',
'|| pserialnumber ||')');
I’m using the DEBUG function in pgAdmin, and I keep getting the
“*statement returning
com]
Sent: Friday, January 07, 2011 4:03 PM
To: Benjie Buluran
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Inserting data from one database to another using
stored functions
On Thu, Jan 6, 2011 at 6:56 PM, Benjie Buluran
wrote:
Hi pgSQL peeps!
I'm stumped on this question
On Thu, Jan 6, 2011 at 6:56 PM, Benjie Buluran <
benjie.bulu...@igentechnologies.com> wrote:
> Hi pgSQL peeps!
>
>
>
> I’m stumped on this question for over 3 days now.
>
>
>
> I need to run a stored function in Database A (“sf DBa”) which calls a
> stored function in Database B (“sf DBb”).
>
>
>
On Mon, 2006-11-13 at 09:37 -0300, Rodrigo Sakai wrote:
> Hi, I have a question about how to insert data in composite types!
>
>
>
> Imagine the exemple:
>
>
>
> CREATE TYPE t_time AS (
>
> a date,
>
> b date
>
> );
>
>
>
> CREATE TABLE salary (
>
>salary numeric(10,2),
> Hi, I have a question about how to insert data in composite types!
>
> CREATE TYPE t_time AS (
> a date,
> b date
> );
>
> CREATE TABLE salary (
>salary numeric(10,2),
>t_date t_time
> );
>
> I know that if I want to insert data in the table SALARY I
> just have to do like:
>
>
Michael
Thanks again for your help.
Bob
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Saturday, August 26, 2006 1:36 PM
Subject: Re: [GENERAL] Inserting Data
On
On Sat, Aug 26, 2006 at 01:22:49PM -0700, Bob Pawley wrote:
> What is the reason for redefining type_ as device_type ???
The function doesn't redefine type_; it selects the value of the
type_ column into a local variable named device_type to avoid
querying library.devices more than once. That loc
t;
Sent: Friday, August 25, 2006 12:31 PM
Subject: Re: [GENERAL] Inserting Data
On Fri, Aug 25, 2006 at 09:35:21AM -0700, Bob Pawley wrote:
The library.devices table holds the static information on each
of the devices that are available to the user.
Is library.devices.device_number
On Fri, Aug 25, 2006 at 09:35:21AM -0700, Bob Pawley wrote:
> The library.devices table holds the static information on each
> of the devices that are available to the user.
Is library.devices.device_number a unique attribute? That is, for
a given device_number, is there at most one row in librar
On Thu, Aug 24, 2006 at 09:20:11AM -0700, Bob Pawley wrote:
> In attempting to use the IF expression (below) I receive an error
> message stating the return includes two or more rows. This seems
> to make sense since I am asking if one condition exists
> (p_id device_number = library device_number
On Wed, Aug 23, 2006 at 07:34:43PM -0700, Bob Pawley wrote:
> Let me explain.
I'll build a simple example based on what you describe. Please
make corrections as necessary.
> I have a table called p_id.devices which accumulates the devices_id for a
> multitude of differing devices used in P&ID d
On Wed, Aug 23, 2006 at 05:34:27PM -0700, Bob Pawley wrote:
> Could you explain why Postgresql simply doesn't accept the simple 'where'
> statement that was in my earlier e-mail.
Because INSERT doesn't take a WHERE clause. If you want to do the
insert conditionally then use an IF statement as To
ls behind the structure as best I can.
Bob
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Michael Fuhr" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Wednesday, August 23, 2006 4:44 P
e simple 'where'
statement that was in my earlier e-mail.
Bob
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Michael Fuhr" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Wed
Bob Pawley <[EMAIL PROTECTED]> writes:
> What I have is one table which stores device_id numbers that are referenced
> on the second table "library.devices".
> I need to insert device_ids from the first table that satisfy the conditions
> of the argument found on the library table. Hence the 'whe
ar all I can get are errors when I attempt this procedure.
Hence - my problem.
Bob
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Michael Fuhr" <[EMAIL PROTECTED]>; "Postgresql"
Bob Pawley <[EMAIL PROTECTED]> writes:
> insert into p_id.loops (monitor) values (new.devices_id)
> where new.device_number = library.devices.device_number
> and library.devices.type_ = 'mon' ;
Huh? How did library.devices get into this? Are you trying to join to
it, and if so why, seeing tha
: "Tom Lane" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Michael Fuhr" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Wednesday, August 23, 2006 3:31 PM
Subject: Re: [GENERAL] Inserting Data
Bob Pawley <[EMAIL PROTECTED]&
Bob Pawley <[EMAIL PROTECTED]> writes:
> I thought the NEW qualified the select.
Not at all; that would rather cripple the ability to write interesting
triggers. I think what you are really wanting to do here is just
insert into p_id.loops (monitor) values (new.devices_id);
stgresql"
Sent: Wednesday, August 23, 2006 3:18 PM
Subject: Re: [GENERAL] Inserting Data
Bob Pawley <[EMAIL PROTECTED]> writes:
Perhaps we can look at the following as a simple example of what is
happening-
-
create or replace function loop_association() returns t
Bob Pawley <[EMAIL PROTECTED]> writes:
> Perhaps we can look at the following as a simple example of what is
> happening-
> -
> create or replace function loop_association() returns trigger as $$
> begin
> Insert Into p_id.loops (monitor)
> select new.devices_id
> from p_id.devices ;
correct this action?
Bob
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Tuesday, August 22, 2006 1:58 PM
Subject: Re: [GENERAL] Inserting Data
On Tue, Aug 22, 200
On Tue, Aug 22, 2006 at 09:02:52AM -0700, Bob Pawley wrote:
> I set aside the procedure you sent to me as it resulted in multiple rows of
> the same information. (In fact one variation produced 100 rows for each of
> the 9 "new" fields creating a 900 row table.
If it was doing that then it would
Help is greatly appreciated.
Bob.
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Monday, August 21, 2006 4:47 PM
Subject: Re: [GENERAL] Inserting Data
On Mon, Aug
On Mon, Aug 21, 2006 at 08:27:58AM -0700, Bob Pawley wrote:
> Yes - Multiple rows of the same data are created in each secondary table.
>
> I have two triggers that are identical in format although handling
> different tables. One is triggeres after insert and with this there is no
> multiplying
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Friday, August 18, 2006 7:27 PM
Subject: Re: [GENERAL] Inserting Data
On Fri, Aug 18, 2006 at 09:27:19AM -0700, Bob Pawley wr
On Fri, Aug 18, 2006 at 09:27:19AM -0700, Bob Pawley wrote:
> I need to insert data from one table into three other tables.
>
> I attempted the following format.
[...]
> insert into p_id.loops (monitor)
> Select p_id.devices.devices_id
> Where p_id.devices.device_number = library.devices.devi
On 8/18/06, Bob Pawley <[EMAIL PROTECTED]> wrote:
Unfortunately this gave multiple results on the target tables.
Is there a format that will give me a single insert for each original field
without the need of creating three triggers???
Bob
try using old/new in your trigger functions.
insert
28 matches
Mail list logo
