populated with duplicate rows?
Among other reasons not to have duplicate rows, I want to make
pipe.fluid_id a primary key.
Bob
CREATE TABLE pipe ( fluid_id int4 NOT NULL);CREATE TABLE process(
fluid_id int4 NOT NULL, process varchar, contain varchar) ;create
or replace function base
ed or modified
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 tab
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"
Sent: Tuesday, No
Thank you.
What clause is acceptable??
Bob
- Original Message -
From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgre General"
Sent: Tuesday, November 15, 2005 9:55 AM
Subject: Re: [GENERAL] Is it data
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: "Bri
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"
Sent: Tuesday, November 1
It worked - Thank you
Bob
- Original Message -
From: "William Yu" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, November 15, 2005 11:06 AM
Subject: Re: [GENERAL] Is it databases in general, SQL or Postgresql?
Bob Pawley wrote:
Thank you.
What clause is acceptable??
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
ow of the table
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
.
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
th SQL, or would it be more
suited to the host language?
Would it be possible in SQL to have the information transferred 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 hel
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 is created and used by the first
trigger.
Could someone point me to documentation?
Bob Pawley
I need to develop a serial column that always starts at 1
and is sequential even after 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 Bab
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 PROTE
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"
Sent: Sunday, September 24, 2006 2:42 PM
S
Do you have a for instance??
Bob
- Original Message -
From: "Ragnar" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Sunday, September 24, 2006 3:10 PM
Subject: Re: [GENERAL] serial column
On sun, 2006-09-24
ly
fewer than 1,000.
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&qu
Thanks
I'll give that a try.
Bob
- Original Message -
From: "Gevik Babakhani" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Sunday, September 24, 2006 4:13 PM
Subject: Re: [GENERAL] serial column
On S
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 PROTECTE
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&q
e lowest serial ID number. )
Thanks for your comments - everything helps at my stage.
Bob Pawley
- Original Message -
From: "Brandon Aiken" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 25, 2006 7:47 AM
Subject: Re: [GENERAL] serial column
I would tend to
ach
fluid.
Any insight into what is happening will be
appreciated.
Bob Pawley
create or replace function library_spec() returns
trigger as $$ begin Declare
fluid_type varchar ;
Begin Select fluid into
fluid_type From p_id.specifications Where fluid =
new.fluid ;
If
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 of
Thanks Woody
Bob
- Original Message -
From:
Woody Woodring
To: 'Bob Pawley' ; 'Postgresql'
Sent: Thursday, October 19, 2006 8:18
AM
Subject: Re: [GENERAL] PostGIS
Here is their web page:
http://postgis.refractions.net/
I am prob
give
me some clue as to where the problem originates?
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 PostgreSQL
geometry ?
Bob Pawley
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:
Sent: Thursday, November 02, 2006 10:17 PM
Subje
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&quo
e this trigger works fine when both the fluid and ip_op_equipment are
entered as one entry.
When I trigger 'after 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
t is TG_OP that you referred to?
Bob
- Original Message -
From: "Tomas Vondra" <[EMAIL PROTECTED]>
To:
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 t
ctory name depending on how I start
the prompt) and doesn't recogize the instructions.
Help would be greatly appreciated.
Bob Pawley
ed that the user launch a second 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"
Sent: Wednesday, November 22, 2006 10:13 AM
Sub
?
Bob Pawley
This is the example found in the documentation to dump a database.
"Examples
To dump a database:
$ pg_dump mydb > db.out"The following - $ pg_dump aurel > aurel.out - gives me
"ERROR: syntax error at or near "$" at character 1"What 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&q
r Delphi? I am using 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"
Sent: Sunday, November 26, 2006 3:17 PM
Subject: Re: [
I have just upgraded from v8.0 to 8.1.
In the new version I keep getting errors due to the absence of 'from' -on
triggers that showed no error in the old version.
Was insisting on the use of from a planned part of the upgrade?
Bob Pawley
ces_id
and p_id.devices.device_number = library.devices.device_number ;
RETURN NULL;
END;
$$
LANGUAGE 'plpgsql' ;
CREATE TRIGGER loopnumbering AFTER INSERT ON p_id.loops
FOR EACH ROW EXECUTE PROCEDURE p_id.loopnumber();
- Original Message -
From: "Jeff Davis" <[EMAIL PROT
Thanks Jeff
I'm going through a learning curve. I don't need to add possible
instability.
Thanks again.
Bob
- Original Message -
From: "Jeff Davis" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Se
something??
Bob
I just installed PostgreSQL 8.1 and PG Admin 1.6.1 .
These versions have a sequential column, that is not part of the table,
identifying the rows.
Is there any method of accessing those numbers and identifying them with
elements within the table??
Bob Pawley
That's what they are doing.
That is also what I am looking for, if it is accessable. If so, I can use
that information to add a sequential numerical element to my information
that doesn't have the restrictions of a serial column.
Bob
- Original Message -
From: "Richa
When a row is deleted the serial number and oid are also deleted. The
sequence then has gaps which are inadmissible.
Bob
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>;
Sent: Monday, December 04, 200
etter - perhaps.
Bob
- Original Message -
From: "Raymond O'Donnell" <[EMAIL PROTECTED]>
To:
Sent: Monday, December 04, 2006 3:53 PM
Subject: Re: [GENERAL] PG Admin
On 4 Dec 2006 at 15:40, Bob Pawley wrote:
When a row is deleted the serial number and oid are also
Your missing the point.
I am creating a design system for industrial control.
The control devices need to be numbered. The numbers need to be sequential.
If the user deletes a device the numbers need to regenerate to again become
sequential and gapless.
Bob
- Original Message
Perhaps - but they aren't necessarily meaningless as pure information.
Bob
- Original Message -
From: "Steve Atkins" <[EMAIL PROTECTED]>
To: "PgSQL General"
Sent: Monday, December 04, 2006 4:33 PM
Subject: Re: [GENERAL] PG Admin
On Dec 4, 2006
of no consequence - as long as the
totallity of numbers assigned are sequential and gapless.
Bob
- Original Message -
From: "Berend Tober" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "pgsql general"
Sent: Monday, December 0
way of using that? For instance the
devices would be numbered coresponding to the row number that is already
being generated.
Bob
- Original Message -
From: "Adrian Klaver" <[EMAIL PROTECTED]>
To:
Cc: "Bob Pawley" <[EMAIL PROTECTED]>; "Berend Tobe
The physical devices don't get numbered until the design is established and
stable. This is known as the construction stage.
Bob
- Original Message -
From: "Adrian Klaver" <[EMAIL PROTECTED]>
To:
Cc: "Bob Pawley" <[EMAIL PROTECTED]>; "Sco
Perhaps I can - it will be learning curve for me. However, the development
would be so much easier to apply if it were available in PostgreSQL in a
form similar to generating a serial column.
Bob
- Original Message -
From: "Alban Hertroys" <[EMAIL PROTECTED]>
I am receiving an error message about a missing "From Clause" in an insert
statement.
I've tried a number of variations of adding a from clause with no success.
Could someone help with the following statement??
Insert Into p_id.loop_sequence (monitor) values(p_id.loops.monitor) ;
Bob Pawley
le or
serial column.
Dropping and recreating does the job but it can be unstable and requires
either on or two extra tables for each sequence you wish to generate.
Bob
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PR
I would like to learn the basics of PostgreSQL geometric types.
Can someone point to a simple explanation of how it works (preferably within
the PostgreSQL database) how it is being used and any drawing system that would
display the results?
Thanks in advance.
Bob Pawley
Thank you.
Thats the technical view. I was hoping for a more generel overview - as if I
knew absolutely nothing about geometric types and their uses.
(Which is close to the truth.)
Geometric Types (and GIS) for dummies would be ideal.
Bob
- Original Message -
From: Shoaib Mir
Hi
I want to combine a PostgreSQL project with my host interface software to make
an installable, c/w the PostgreSQL server.
Can someone please point to the document that explains how this is
accomplished??
I am using Delphi's version of InstallShield on Win XP.
Bob Pawley
Hi
I have managed to turn my host software into an executable. It runs well using
my installed database and server.
What files in PostgreSQL do I need to include to have the host software, the
PostgreSQL server and database run as an independant application??
Bob Pawley
I've already built the PostgreSQL database. Now I want to turn it and the
Delphi interface (host) into a distributable application.
I am using Installshield and I need to pick up the files in Postgres to
include.
Bob Pawley
- Original Message -
From: "John McCawle
Yes
I want to include the service and the tables, triggers etc. as an
installable application for one, or more, users.
I don't know if this is considered embedded or not, but there seems to be a
lack of infomation on how to accomplish this.
Bob
- Original Message -
From: &q
Thanks Tony
What PostgreSQL files do I use?
Bob
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>;
Sent: Tuesday, December 19, 2006 8:53 AM
Subject: Re: [GENERAL] Creating an Independant Application
B
What is the best way of installing the tables, triggers etc? Do I add a
project dump file or generate them from an sql file?
Bob
- Original Message -
From: "Tony Caduto" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>;
Sent: Tuesday, Decem
- nowhere is it stated where the command is typed.Perhaps someone
can tell me?Bob Pawley
which in PostgreSQL is
Bob
- Original Message -
From: "Ray Stell" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Wednesday, December 20, 2006 11:07 AM
Subject: Re: [GENERAL] Starting Postgresql
a
which in PostgreSQL is
Bob
- Original Message -
From: "Bob Pawley" <[EMAIL PROTECTED]>
To: "Ray Stell" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Wednesday, December 20, 2006 11:12 AM
Subject: Re: [GENERAL] Starting Postgresql
which
Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm
Bob
- Original Message -
From: "Richard Huxton"
To: "Raymond O'Donnell" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent: Wednesday, December 20, 2006 11:43 AM
Subject
I missing?
Insert Into library.devices (Item_id, device, a_d, designation, function_,
type_, function1)
Values ( 'Tdeviceft2a', \lo_import ('c:/program
files/postgresql/8.0/lib/images/magflow.bmp'), 'a', 'F', 'A_Flow', 'mon',
'Flow') ;
Bob Pawley
If I can't use lo_import what method do you suggest I use for a large object
(in this case images).
Bob
- Original Message -
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Postgresql"
Sent:
do
this is to rebuild the database as part of the installataion. Rather than
rebuild, which I think is inefficient, I am looking into building the
database as a remote server.)
Part of the database is an image file using lo_import, which works well on
localhost.
Bob
- Original
nt me to a simple instruction set for a backup/restore operation
using the PG Admin resource??
Bob
sing an earlier version??
Bob
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Shoaib Mir" <[EMAIL PROTECTED]>
Cc: "Bob Pawley" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Thursday, December 28, 2006 11:30 AM
Subj
When I change it to view "all files" it's there - but it won't do anything.
Bob
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Shoaib Mir" <[EMAIL PROTECTED]>; &q
GEOGCS["Anguilla 1957",DATUM["Angui..."
pg_restore: *** aborted because of error
Process returned exit code 1."
The GIS feature was removed from the PostgreSQL application before the
project dump.
Anyone have any thoughts on how to get around this??
Bob
- Or
he error.
Any thoughts??
Bob
- Original Message -
From: "Dave Page" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Shoaib Mir" <[EMAIL PROTECTED]>; "Postgresql"
Sent: Friday, December 29, 2006 12:10 AM
Subject: Re: [G
Looking through PGAdmin where would I find the spatial references that the
errror message references?
Bob
- Original Message -
From: "Richard Huxton"
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Dave Page" <[EMAIL PROTECTED]>; "Shoaib
Found it in template 1. This seems strange as both servers and pgadmins are
the same version and I haven't opened the template until today.
Bob
- Original Message -
From: "Richard Huxton"
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "Dave Page"
Hello,
I have just updated to postgres8.1 and have the
following problem. The first line of the "PostgreSQL
database dump"
says:
SET client_encoding = 'SQL_ASCII';
which is correct. However, the restore says:
ERROR: invalid byte sequence for encoding "UTF8":
0xe02031
HINT: This error can als
d to make sure I can configure for
tcpip, and am trying to login as a local user with a user account on the
machine.
Other ideas? I am not having much luck finding more in the docs.
TIA
Bob
Tijnema ! wrote:
On 3/17/07, rwhartung <[EMAIL PROTECTED]> wrote:
Hi,
I have this short p
Hi all,
I have been struggling with phpPgAdmin 4.1 - login failures. There
does not yet seem to be a fix. Where can I find a prior version for FC6
- rpm, tar.gz etc.
Thanks,
Bob
---(end of broadcast)---
TIP 5: don't forget to increase
ebook, through an alias (DeviceNotebookMouseUpAlias). I want
to have the Postgres use this alias to trigger the function.
Could someone point me to any literature that would help me with this project?
Bob Pawley
error indicates an
incompatibility between the table's TStringField class and the TImage class.
Perhaps if I could solve that challenge I may be able to figure out the
rest.
Bob
- Original Message -
From: "Andrej Ricnik-Bay" <[EMAIL PROTECTED]>
To: &quo
Listen/notify implies a dynamic table that is constantly on the change. Am I
correct?
The table I am talking about is completed through one interface then
imported as a relatively static information base for the application in
which I am seeking help.
Bob
- Original Message
s of loops with a second button. (Perhaps an
entire project of loops with a third button.)
Bob
- Original Message -
From: "Andrej Ricnik-Bay" <[EMAIL PROTECTED]>
To: "Bob Pawley" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Tuesday, March 2
I think that may be what I have been trying to do.
Can you point me to some literature on how to do that? I'm just learning the
basics of Delphi and the documenation I've seen so far hasn't been very
specific.
Bob
- Original Message -
From: "Tony Caduto"
I've been using the PostgreSQL server without really understanding how it works
or how it is structured.
Could someone point me to a 'simple' description???
Bob Pawley
I am looking for a mentor for PostgreSQL and Delphi.
I have developed a PostgreSQL database which needs to interface with an
existing Delphi application.
If anyone is interested please contact me off line at [EMAIL PROTECTED] .
Compensation to be discussed.
Bob Pawley
;
PSQLQuery1.ParamByName('LoopNumberEdit').Value := Edit1.Text;
PSQLQuery1.Execsql;
end;
Running Delphi 6 and PostgreSQL 8.2 on Win XP.
Bob
on issue of pltcl.so matter? I'm using the pltcl.so from my older 7.2 branch.
Thanks!
Bob PowellDatabase Administrator
f it
there either.
I had a user who uses pgamind on occassion for quering the backend who
told me that he did not intterupt any of the criteria he was running.
Do I just chalk it up to a "transient anomaly" ?
Thanks for any help you can give.
Bob Powell
Da
?
Also, my method for creating another superuser is to update the
pg_shadow files "usesuper" field to 't'. Are there any issues I should
be aware of for doing such a thing. Thanks.
Bob Powell
Database Administrator
---(end of broadcast)-
all 192.168.1.0 255.255.255.0 md5
coming before the other line, I can connect to the server database using
a password. However, if it follows the line, I cannot. Am I doing
something wrong here also?
Thanks for any help.
--
Bob Parnes
[EMAIL PROTECTED]
---(e
Hello everyone:
If I excute the following:
CREATE table Test_backup as
SELECT * FROM Test_Scores;
it creates my table without the original table's constraints or
triggers.
Is there a way to preserve them in the copy?
Thanks.
Bob Powell
Database Administ
r time. If you responded the other day I may have
lost your message as I was on the road.
Bob Hartung
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
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]>; "Postgr
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"
Sent: Monday, Novembe
Are there any practical limits to the number of functions and triggers that
can be applied to any particular table??
Bob
e command perhaps you can suggest 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_, dev
301 - 400 of 502 matches
Mail list logo
