PostgreDAC as a connection tool.
Bob
I don't know - but it sounds like a good place to start.
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, November 26, 2006 3:17 PM
Subject: Re: [GENERAL] Upgrade
On Sun, 2006
This is the example found in the documentation to dump a database.
Examples
To dump a database:
$ pg_dump mydb db.outThe following - $ pg_dump aurel aurel.out - gives me
ERROR: syntax error at or near $ at character 1What am I missing???Bob
No joy
pg_dump aurel aurel.out
Returns -
ERROR: syntax error at or near pg_dump at character 8
I've had a bit of trouble with the PostgreSQL system if that helps. (access
violation with a reinstall)
Bob
- Original Message -
From: Konrad Neuwirth [EMAIL PROTECTED]
To: Bob Pawley
career in order to make use of
them.
(With due apologies to Joel Orr.)
Thanks again.
Bob
- Original Message -
From: Guy Rouillier [EMAIL PROTECTED]
To: PostgreSQL General pgsql-general@postgresql.org
Sent: Wednesday, November 22, 2006 10:13 AM
Subject: Re: [GENERAL] Uninstalling
?
Bob Pawley
depending on how I start
the prompt) and doesn't recogize the instructions.
Help would be greatly appreciated.
Bob Pawley
update' every row in the Processes table is inserted into
the other tables depending on the conditionals. I end up with multiple inserts
of the same information.
Is it possible to create a trigger that inserts only one row for each entry?
Bob Pawley
that you referred to?
Bob
- Original Message -
From: Tomas Vondra [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Friday, November 17, 2006 3:34 PM
Subject: Re: [GENERAL] After Update Triggers
When I trigger 'after insert' the function doesn't work because the
ip_op_equipment
What is an example of how geometric datatypes are being
used?
Bob Pawley
I am looking at PostgreSql native geometry.
I am wondering if it can be used in conjunction with a basic drawing
package.
If so, is there a recommended drawing package to use? Are there any examples
of this type of use?
Bob
- Original Message -
From: Michael Fuhr [EMAIL
Thanks for the link.
However, I was thinking in terms of how and where the geometric datatypes
are used and why they were developed.
Bob Pawley
- Original Message -
From: A. Kretschmer [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, November 02, 2006 10:17
Can anyone point me to an overview ofPostgreSQL
geometry?
Bob Pawley
Any thoughts on why dynamically adding a column to a table
would require a run time of 24,000 + milliseconds??
Adding a serial column to three tables requires almost
100,000 ms.
Bob Pawley
Can anyone point me to an overview of PostGIS and how it
is being used???
Bob Pawley
Thanks Jim
Bob
- Original Message -
From:
James Cradock
To: Postgresql
Cc: Bob Pawley
Sent: Thursday, October 19, 2006 8:35
AM
Subject: Re: [GENERAL] PostGIS
On Oct 19, 2006, at 11:08 AM, Bob Pawley wrote:
Can anyone point me to an overview
ach
fluid.
Anyinsight into what is happening will be
appreciated.
Bob Pawley
create or replace function library_spec() returns
trigger as $$beginDeclare
fluid_type varchar ;
BeginSelect fluid into
fluid_typeFrom p_id.specificationsWhere fluid =
new.fluid ;
If fluid_type library.specificat
Is there any reason can't update to a newer version. Like 8.x?
Geoffrey wrote:
We continue to have segmentation faults of the /usr/bin/postgres process
as I mentioned in an earlier thread. In all cases, the core file
always indicates a segmentation fault, but the backtraces don't seem to
number. )
Thanks for your comments - everything helps at my stage.
Bob Pawley
- Original Message -
From: Brandon Aiken [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Monday, September 25, 2006 7:47 AM
Subject: Re: [GENERAL] serial column
I would tend to agree with Tom
---(1 row)
Time: 70.000 msdev=# ROLLBACK TRANSACTION;ROLLBACKTime: 0.000 msdev=# select * from test_values; c1| c2-+ 2898364 | Autonomous Transaction
(1 row)Time: 0.000 msdev=#Regards,Bob Henkel
I need to develop a serial column that always starts at 1
and is sequential evenafter deletes.
Any ideas???
Bob
Yes
But the only way of insuring that the serial starts at 1 and is sequential
is to recreate the table.
I've tried creating and dropping the table but this generates other issues
which I haven't been able to resolve.
Bob
- Original Message -
From: Gevik Babakhani [EMAIL
Choice a.
I am using the numbers to identify devices.
If a device is deleted or replaced with another type of device I want the
numbering to still be sequential.
Bob
- Original Message -
From: Ragnar [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general
It's the behavior I expect - but the gaps aren't acceptable.
Bob
- Original Message -
From: Gevik Babakhani [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 2:42 PM
Subject: Re: [GENERAL] serial column
Do you have a for instance??
Bob
- Original Message -
From: Ragnar [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 3:10 PM
Subject: Re: [GENERAL] serial column
On sun, 2006-09-24 at 14:29 -0700, Bob
.
Could you point to some documentation for regenerating a column's values
other than manual??
Bob
- Original Message -
From: Gevik Babakhani [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 3:19 PM
Thanks
I'll give that a try.
Bob
- Original Message -
From: Gevik Babakhani [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 4:13 PM
Subject: Re: [GENERAL] serial column
On Sun, 2006-09-24 at 15:29 -0700
To some degree I don't care about the actual number other than roughly
following the device ID.
At some point later in the design the numbers will be updated to project
numbers and then frozen.
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general
numbers without
possibility of a gap.
Perhaps a manually built table is the answer??
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Ragnar [EMAIL PROTECTED]; Postgresql pgsql-general@postgresql.org
Sent: Sunday, September 24, 2006 4:30 PM
I am seeking wording for a procedure that will initiate a
trigger only after another trigger has completed its function. In this case I
want to drop a table that iscreated and usedby the first
trigger.
Could someone point me to documentation?
Bob Pawley
no problem designating the column with the
appropriate letters.
However, I haven't a clue how to add the numerical portion
- or if it is evenpossible.
If anyone has a thought I would appreciate being pointed
to some documentation that covers this.
Bob Pawley
Michael
This works perfectly. Thanks very much for your help.
What is the reason for redefining type_ as device_type ???
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday, August
Michael
Thanks again for your help.
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Saturday, August 26, 2006 1:36 PM
Subject: Re: [GENERAL] Inserting Data
On Sat, Aug 26, 2006 at 01:22
this working.
Bob
then the return
should be all the rows that equal mon (or end).
Is there a
method of modifying the IF _expression_ to look only at the row in which device_number
equals device_number. (Ive tried changing AND to WHERE with no affect.
Thanks for
your help.
Bob
CREATE TABLE
p_id.devices
correct this action?
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Tuesday, August 22, 2006 1:58 PM
Subject: Re: [GENERAL] Inserting Data
On Tue, Aug 22, 2006 at 09:02:52AM -0700, Bob
I thought the NEW qualified the select.
If not, how is select qualified??
Thanks
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Michael Fuhr [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, August 23
= library.devices.device_number
and library.devices.type_ = 'mon' ;
return null ;
end ;
$$ language plpgsql ;
create trigger loop after insert on p_id.devices
for each row execute procedure loop_association();
Gives me an error.
What am I doing wrong?
Bob
- Original Message -
From: Tom Lane [EMAIL
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
pgsql-general@postgresql.org
Sent: Wednesday, August 23, 2006 4:05 PM
Subject: Re: [GENERAL
'
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
pgsql-general@postgresql.org
Sent: Wednesday, August 23, 2006 4:44 PM
Subject: Re: [GENERAL] Inserting Data
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
pgsql-general@postgresql.org
Sent: Wednesday, August 23, 2006 4:44 PM
Subject: Re: [GENERAL] Inserting Data
Bob Pawley [EMAIL
am having a little trouble fully understanding the basic
PostgreSQL structure.
What seems to me to be a logical procedure almost always has problems that I
need to sort through.
Help is greatly appreciated.
Bob.
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob
triggers use NEW.* in the same manner. However, the trigger after
update gives multiple results of the same information.
Is there any way around this problem? Is there perhaps a method restricting
the trigger to an update to a particular column rather than the table as a
whole?
Bob
ortunately this gavemultiple results on the target tables.
Is there a format that will give mea singleinsert for each
original field without the need of creating three triggers???
Bob
other_way_test
BEFORE INSERT
ON foo_table
FOR EACH ROW
EXECUTE PROCEDURE other_way_test()
;
--
Bob Dowling: Head of Unix Systems Division, University Computing Service
[EMAIL PROTECTED] New Museums Site, Pembroke Street, Cambridge. CB2 3QH
01223 334710 http://www-uxsup.csx.cam.ac.uk/~rjd4
, is well beyond my primitive abilities. Also is my
directory requirement combined with rewards actually actually just a
modified shop?
I don’t have a large budget, so was wondering about procuring in
eastern Europe or India – am I completely mad?
Any ideas?
Best Regards/MfG,
Bob Wheldon
Make a table that you can reference. Fill it with Arabic,
English or any language that you wish.
Make it available to the list so those who wish can
particpate and receive a copy of the finished product.
Bob
- Original Message -
From:
Samer
Abukhait
To: pgsql
Thanks Tony
I installed PostgresDAC and it cleared up the problem.
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Jim C. Nasby [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Monday, May 22, 2006 1:54 PM
Subject
How can I determine if my tables are 'read only' or
'read/write'?
Bob
someone explain this difference?
Bob Pawley
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Cc: Frank L. Parks [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, May 10, 2006 3:55 PM
Subject: Re: [GENERAL] Interface
message that the serial fieldrequires a value.
When I remove the serial column the interface inserts a
new value with no problem. When I insert directly via sql the serial column
updates automatically.
What am I missing to make this work through
Delphi?
Bob
Hi Frank
Here's the code entered as part of TUpdateSQL component.
insert into p_id.p_id
(process_name)
values
(:process_name)
I am connected via ODBC.
Thanks
Bob
- Original Message -
From: Frank L. Parks [EMAIL PROTECTED]
To: Postgresql pgsql-general@postgresql.org
Sent
attempting to solve. (Same SQL code)
Lots of challenges for a beginner to work through.
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Frank L. Parks [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday, May 10, 2006
method by allowing the restore on any linux box that
is running postgress as opposed to having to reconstruct the directory
on another server.
Does anyone have any thoughts on this matter. Is one way better than
the other? Thanks in advance.
Bob Powell
Database Administrator
the wrong driver for my version of
Postgresql or is there something in Postgresql that I need toswitch
on???
Bob Pawley
Thanks Tony I found it.
Can you give me a hint as to how to open the file??
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Wednesday, March 29, 2006 8:12 AM
Subject: Re: [GENERAL] Connecting
Bob
considering that
Postrgresql version is a lot newer than Delphi?
If it is possible, can someone point me to a tutorial that
can guide me through the steps. I am new to interspecies
connections?
Is there a better method of making this
comnnection?
Bob Pawley
determine where the problem is - Creator,
Postgresql or me.
Has anyone else experienced difficulty in using these
Postgresql/Java drivers.
Bob Pawley
I am attempting to connect Postgresql (Windows XP, Version
1.2.1 March 28, 2005 (in the PG Admin 3 about ) to Java Studio Creator
2.
Of the four selections presented can someone point to the
driver I should use for PG Version 1.2.1???
Bob
I'll try it.
Thanks for your help.
Bob
- Original Message -
From:
Daniel
Blaisdell
To: Bob Pawley
Cc: Postgresql
Sent: Thursday, March 09, 2006 11:58
AM
Subject: Re: [GENERAL] JDBC
-BEGIN PGP SIGNED MESSAGE-Hash: SHA1I'm
assuming that your real
be ideal.
I am running Postgresql v 8.0 on Windows
XP.
Bob Pawley
Thanks I am using pgadmin for development. I'm looking for a tool with which
I can develop an interface that will be used for entering and accessing
information in context with the user tasks.
Bob
- Original Message -
From: Philippe Ferreira [EMAIL PROTECTED]
To: Bob Pawley [EMAIL
This looks quite interseting.
Thanks Wes
Bob
- Original Message -
From:
Wes Williams
To: 'Bob Pawley' ; 'Postgresql'
Sent: Friday, February 10, 2006 9:14
AM
Subject: RE: [GENERAL] Tool
You may wish to
consider creating a web interface GUI.
For example
Thanks very much Tony.
I'll give it a go.
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Friday, February 10, 2006 11:42 AM
Subject: Re: [GENERAL] Tool
I am developing a database which needs testing prior
, how do I change the stack depth limit? I
can't find anything in the documentation that describes this task.
I understand the default stack depth is about 2
meg. How do I determine what the stack depth should be so that I avoid this
error?
Bob Pawley
Thanks all
I do think I have a recursive problem. It's just hard to see at the moment.
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bricklen Anderson [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Wednesday
Thanks Michael
I'll keep this for future use. I beleive I was using insert into and update
when I should have been using update only.
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Bricklen Anderson [EMAIL PROTECTED]; Postgresql
) and do the conversion as the data is entered.
Any thoughts on how best to accomplish this task with Postgresql would
be appreciated. (Im on Windows XP)
Bob Pawley
or
more tables contain similar information. But, is it only a perception???
Perhaps there is another way???
Bob Pawley
- Original Message -
From: Michael Glaesemann [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Tuesday, January 31
I'm a little concerned about stability since my Postgresql application has
failed three times in the last couple of months. It seems to have failed
when too many things are happening at the same time - mostly things that
have been instigated by my pointing and clicking.
Bob
- Original
not be a Postgresql problem as other applications have
'failed' at various times as well (Empire Earth being one).
I would look at Mac or others if I didn't need to develop in Windows.
Bob
- Original Message -
From: Michael Glaesemann [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc
end
(Min, Max, Norm plus a unit column for each).
The downside is that the number of brackets
required increases for each succeeding column for insert and update. The last
column would comprise 48 brackets, 24 before - 24 after.
Is there a work-around for this.
Bob Pawley
create table
Because it gives me an error otherwise.
I am following the rules layed out in the documentation as follows -
Bob
8.10.2. Array Value Input
Now we can show some INSERT statements.
INSERT INTO sal_emp
VALUES ('Bill',
'{1, 1, 1, 1}',
'{{meeting, lunch}, {meeting
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To: Karsten Hilbert [EMAIL PROTECTED]
Sent: Thursday, January 26, 2006 11:26 AM
Subject: Re: [GENERAL] Arrays
Because with arrays I can include other information such as pointers to
conversion factors and hopefully implement
ERROR: malformed array literal: {100, 250, 500, DegF)
I want to do single dimension arrays.
How did I turn it into multidmensional?
Bob
- Original Message -
From: Stephan Szabo [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; Postgresql
pgsql
ERROR: malformed array literal: {100, 250, 500, DegF)
I want to do single dimension arrays.
How did I turn it into multidmensional?
Bob
- Original Message -
From: Stephan Szabo [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; Postgresql
pgsql
Thank you - my eyes aren't what they used to be.
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Stephan Szabo [EMAIL PROTECTED]; Tom Lane
[EMAIL PROTECTED]; Postgresql pgsql-general@postgresql.org
Sent: Thursday, January 26
I missed that - thanks for the help.
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Stephan Szabo [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Thursday, January 26, 2006 12:12 PM
Subject: Re: [GENERAL] Arrays
The order for the array is Min, Norm, Max, Unit.
I'll probably reorder it with the unit first as every value has a unit.
Bob
- Original Message -
From: Tino Wildenhain [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Stephan Szabo
[EMAIL
Our application will be dispersed amongst many users.
I want to keep the datbase as generic as possible.
Bob
- Original Message -
From: Tino Wildenhain [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Joshua D. Drake [EMAIL PROTECTED]; Stephan Szabo
[EMAIL PROTECTED]; Tom
Thanks Scott - I'll give this a try.
Bob
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Tino Wildenhain [EMAIL PROTECTED]; Joshua D. Drake
[EMAIL PROTECTED]; Stephan Szabo [EMAIL PROTECTED]; Tom
Lane [EMAIL PROTECTED]; Postgresql
My initial tables have columns containing values
such as 12 feet.
I want to perform calculations.
Is there a method in Postgresql to separate the 12
from the unit feet or am I forced to make two columns to separate the feet from
the 12?
Bob Pawley
Hi Tom
I found a datatype called 'interval' which seems to separate time from its
unit.
Is that what you were thinking of??
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Sunday, January
Hi Folks
I have a column for date which defaults to the
ambigous 2005-1-1 format.
The documantation indicates how to change this to
the unambigous Jan 1 2005, but the instructions aren't clear to me.
Any help will be appreciated.
Bob Pawley
Perhaps you have a solution??
Bob
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, January 18, 2006 10:03 AM
Subject: Re: [GENERAL] Dates
On Wed, 2006-01-18 at 12:00, Bob Pawley
Michael
That worked fine.
Thanks for the help. Could you point me to some documentation on the use of
parentheses? Perhaps something that describes what action the parentheses
accomplishes?
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL
Thanks Michael
Bob
- Original Message -
From: Michael Fuhr [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgre General pgsql-general@postgresql.org
Sent: Sunday, December 18, 2005 4:49 PM
Subject: Re: [GENERAL] Views
On Sun, Dec 18, 2005 at 02:52:23PM -0800, Bob Pawley
a remedy.
Bob
--
create view p_id.trial(P_ID_ID, Pipe_ID, Equipment_ID, Fluid_ID,
Fluid, Type_, Function_, Device_ID, Device_Number, Association)as
select devices.p_id_id, pipe_id, equipment_id, process.fluid_id, process.fluid,
devices.type_, devices.function_, device_id, device_number
Are there any practical limits to the number of functions and triggers that
can be applied to any particular table??
Bob
Yes I am trying to insert all valves into the same row as their associated
mon.
Bob
- Original Message -
From: Jim C. Nasby [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Guy Rouillier [EMAIL PROTECTED]; PostgreSQL General
pgsql-general@postgresql.org
Sent: Monday, November
Thank you I'll give it a try.
Bob
- Original Message -
From: Jim C. Nasby [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Guy Rouillier [EMAIL PROTECTED]; PostgreSQL General
pgsql-general@postgresql.org
Sent: Monday, November 28, 2005 4:13 PM
Subject: Re: [GENERAL] Group
into the
auto_control table as the information is being entered or would the control
table need to be fully completed?
Hope this is finally clear.
Thanks for you help.
Bob
- Original Message -
From: Guy Rouillier [EMAIL PROTECTED]
To: PostgreSQL General pgsql-general
.
Following is the example which I stabilized and tested for e-mail.
Bob
Control
device_id
type
association
serial
varchar
int4
1
mon
1
2
valve
2
3
valve
1
4
mon
2
5
valve
1
I want to take the serial ID of several values in different rows in one
table and insert them into a single row of another table.
Would the 'group by' command be the best way to do this?
Bob
auto_control. All items associated with the value '2' into the second row -
etc. etc.
Is this best accomplished by a 'group by' command or subset???
Bob
Control
device_ID type association
serial varchar int4
1 mon 1
2 valve 2
3 valve 1
4 mon 2
5 valve 1
to make this database structure work?
Thanks in advance.
Bob
Sample 1
create table pr
(Process_Name
varchar (60) not null, Fluid_ID serial, Fluid varchar (30) not null,
contain varchar (3),
constraint pr_pk primary key
(fluid_id));
create table pi
(process_name varchar (60), Fluid_ID int4
No - I mean when each row of pr (contain) has 'ip' inserted as a value or
data.
Bob
- Original Message -
From: Alban Hertroys [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgres General pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 9:42 AM
Subject: Re
Thank you.
What clause is acceptable??
Bob
- Original Message -
From: Jaime Casanova [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Postgre General pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 9:55 AM
Subject: Re: [GENERAL] Is it databases in general, SQL
seems to be geared to data retreival. I am trying to move data, as part of
the structure, from one permanent table to another permanent as a primary
key.
Perhaps I am attempting a database structure that SQL, by ityself, will not
support.
Bob
- Original Message -
From: Bricklen
That works. Thanks very much.
Bob
- Original Message -
From: Jaime Casanova [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Alban Hertroys [EMAIL PROTECTED]; Postgres General
pgsql-general@postgresql.org
Sent: Tuesday, November 15, 2005 11:36 AM
Subject: Re: [GENERAL
301 - 400 of 491 matches
Mail list logo