2008/6/28 Steve Atkins [EMAIL PROTECTED]:
On Jun 27, 2008, at 9:53 PM, Adam Rich wrote:
Bob Duffey [EMAIL PROTECTED] writes:
I'm seeing some query plans that I'm not expecting. The table in
question
is reasonably big (130,000,000 rows). The table has a primary key,
indexed
cursor to iterate over the result of this query, and the second
plan is non-blocking whereas the first is blocking (due to the sort
operator).
Any help appreciated.
Thanks,
Bob
2008/6/28 Tom Lane [EMAIL PROTECTED]:
Bob Duffey [EMAIL PROTECTED] writes:
I'm seeing some query plans that I'm not expecting. The table in
question
is reasonably big (130,000,000 rows). The table has a primary key,
indexed
by one field (ID, of type bigint). Thus, I would expect
mean. I've already tried your suggestion (set
enable_seqscan to off) with no luck.
Bob
in the geometriy column.
Would anyone have any thoughts - other than to buy new hardware??
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
of easily
generating digests. However, digests don't seem to be an issue on any of the
lists to which I subscribe.
The concept of most lists should be the free exchange of ideas in the most
efficient manner possible.
Bob
- Original Message -
From: Gregory Stark [EMAIL PROTECTED
I need to ask this question.
What do you mean whan you say Don't top post???
I've seen this many times before and still don't understand.
Bob
- Original Message -
From: Andrej Ricnik-Bay [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]
Cc: Kevin Hunter [EMAIL PROTECTED
appreciate the information.
Thanks in advance.
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
In case you are lost with that distinction, geometric data types are based
on a flat 2D graph to locate a point, line, rectangle, polygon etc
Yes - this is what I am interested in with the eventual potential of 3D.
Bob
- Original Message -
From: Shane Ambler [EMAIL PROTECTED
I have Postgresql database that I would like to link to the geometry side of
Postgis. (This has little comparison to geography)
Does anyone know of a tool or documentation that could get me started??
Bob
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
to be so geographically
oriented that I wanted to query a larger audience.
Bob
- Original Message -
From: Obe, Regina
To: Bob Pawley ; PostgreSQL
Sent: Tuesday, April 15, 2008 10:50 AM
Subject: RE: [GENERAL] Not Geography
I have Postgresql database that I would like to link
appreciated.
Bob
Declare
pumpnumber integer;
Begin
Select count(*) Into pumpnumber From p_id.devices, p_id.processes
Where device_number = '11'
and p_id.devices.fluid_id = p_id.processes.fluid_id
and p_id.processes.ip_op_equipment = 'op';
If pumpnumber = 1 then
Update p_id.devices
Set number = '#1
The count procedure appears to be working well.
Thanks Adrian for your help.
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, March 23, 2008 4:04 PM
Subject: Re: [GENERAL] Insert
in p_id.devices.
The following gives me a return of more than one row and I can't figure
out what's wrong.
Any thoughts would be appreciated.
Bob
Declare
xmon_function varchar;
Begin
Select mon_function into xmon_function
From p_id.association
Where mon_function = new.mon_function
execute procedure monitor_install();
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, March 23, 2008 2:24 PM
Subject: Re: [GENERAL] Insert
On Sunday 23 March 2008 1:48 pm, Bob Pawley wrote
Is this what you need??
Bob
CREATE TABLE p_id.association
(
monitor integer,
devices_id integer NOT NULL,
mon_function integer,
monitoring_fluid integer,
ps_open character varying(5),
ps_closed character varying(5),
CONSTRAINT association_pkey PRIMARY KEY (devices_id)
)
WITHOUT OIDS
Hello,
How can i connect my application dynamically to postgres schema. Its like
this
1)One database postgres
2) It has one database say 'Test'
3)Now i created some number of schema in it say test1, test2,test3 etc all
have same same structure but different data
4)Now my web application
!= . Is this symbol the same as ?
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Daniel Verite [EMAIL PROTECTED]; Bob Pawley
[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 7:16 AM
Subject: Re: [GENERAL] Updating
On Monday 17 March 2008 4:54 am
;
create trigger monitorinstall before update on p_id.association
for each row execute procedure monitor_install();
- Original Message -
From: Daniel Verite [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Adrian Klaver [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Monday
Is there a method available for triggering a function after an update on a
particular column in a table?
The only way that I have found is to trigger after an update on the whole
table, which of course can lead to problems.
Bob
--
Sent via pgsql-general mailing list (pgsql-general
Would it be possible to get an example of such coding??
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, March 16, 2008 5:14 PM
Subject: Re: [GENERAL] Updating
On Sunday 16 March 2008 3
All of my tables are without oids.
I have an application in which I drop, then recreate a table (to reset
serial numbers) and with an update on the new information I get an error
about a specific oid missing.
Any thoughts would be appreciated.
Bob
- Original Message -
From: Erik
I'm running Postgresql 8.2 on Windows.
If I create a table 'without oids' are oids still in use behind the scenes??
Bob
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
any thoughts it would be much appreciated.
Bob
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through
on pg_dump
Bob
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
Thanks Erik. In between those attempts I did try what you suggest.
It failed, apparently due to not making a connection with the server.
Bob
- Original Message -
From: Erik Jones [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent
for each successful dump???
If not, does anyone have thoughts on where the problem could be??
Bob Pawley
---(end of broadcast)---
TIP 6: explain analyze is your friend
, at one
time??
If you see any other challenges to this plan, I would appreciate it if you
would please let me know.
Bob Pawley
At the moment the database dump is 4.1 meg.
I suspect the end result will be less than 10 meg including the user's
information.
Is there other size information you need?
Bob
- Original Message -
From: Richard Huxton [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc
.
The database will also be used to transfer information to other engineering
databases yet to be completed.
Bob
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: PostgreSQL pgsql-general@postgresql.org
Sent: Monday, December 03, 2007 8:35 AM
be a good thing.
Bob
---(end of broadcast)---
TIP 6: explain analyze is your friend
properly and knowedge will result.
- We would begin to realize the full potential of computing power.
Is that what you were saying??
Bob
- Original Message -
From: Richard Broersma Jr [EMAIL PROTECTED]
To: pgsql-general@postgresql.org; Andy [EMAIL PROTECTED]
Sent: Monday, October 29
Thanks Ilan this looks promising.
Bob
- Original Message -
From: Ilan Volow
To: pgsql-general@postgresql.org
Sent: Tuesday, October 30, 2007 3:01 PM
Subject: Re: [GENERAL] PostgreSQL and AutoCad
As I have a vested interest in storing AutoCad stuff in PostgreSQL, I
the password.
I keep getting authentication failure.
When I attempt to do a new pg_dump with -Fc I also get a request for
password with identical results.
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED
.
If the error message is correct how does pg_restore know what to put where?
I used the same command to successfully install the same pg_dump file into
PostgreSQL 8.1 running on the same computer.
Any thoughts would be much appreciated.
Bob Pawley
---(end
.
This is becoming quite frustrating.
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Cc: Bob Pawley [EMAIL PROTECTED]
Sent: Sunday, October 28, 2007 11:45 AM
Subject: Re: [GENERAL] pg_restore
On Sunday 28 October 2007 11:32 am, Bob
an aurel.sql file which I just
successfully dumped a few minutes ago from the 8.1 on my other computer.
Could pg_restore in my 8.2 be corrupted??
Bob
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Adrian Klaver [EMAIL PROTECTED]; pgsql-general
This is the dump command
pg_dump -h localhost -d Aurel -U postgres
Could you suggest a dump command that will match the restore command -
pg_restore -h localhost -d PDW -U postgres aurel.sql
Thanks
Bob
- Original Message -
From: Adrian Klaver [EMAIL PROTECTED]
To: pgsql
I would like to try PostgreSQL 8.3 without uninstalling version 8.1.
Is this possible??
Bob Pawley
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
Is there any way of converting text from an AutoCad (.dwg ot .dxf) file into a
PostgreSQL Database??
Bob Pawley
I have a column with data structured as follows.
32TT - 0002
32LT- 0004
32PT-0005
Is there a way of selecting all of the rows containing LT in that column??
I have attempted variations of ' *LT* ' with out success.
Bob Pawley
loop_set;
Bob Pawley
sequentially - lowest ID to highest ID or vice-versa?
3. Is there another mehod of accomplishing this task other than fetch?
Bob Pawley
That's marvelous - thanks.
Bob
- Original Message -
From: brian [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, October 18, 2007 9:45 AM
Subject: Re: [GENERAL] ordering rows
Bob Pawley wrote:
Hi
I have a table 'import' which is an amalgam of two other tables
next From loop_set;
Bob Pawley
The documentation states that PostgreSQL does not support updating data via a
cursor.
Has that changed in the last little while.
Bob Pawley
I want to be able to convert a PostgreSQL database to other formats such as
Oracle, Access etc. - with, as well as without, the data.
Can this task be accomplished by employing pg_dump in SQL?
Bob Pawley
Is there a better method of transfering the database and data to between
DBs?
Bob
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Tuesday, October 02, 2007 3:26 PM
Subject: Re: [GENERAL] pg_dump
Can anyone tell me why a table developed through the PG Admin interface isn't
found by SQL when accessing it through the SQL interface??
Bob Pawley
, are there any tools that may assist me in developing this graphic
interface?
Bob Pawley
clip_image001.gif
I have numerous entries in a column of table 1, some of which are duplicated.
I need to transfer this information to table 2 so that I have column that can
be used as a primery key.
Any help is appreciated.
Bob Pawley
Yes please send me a copy.
Bob
- Original Message -
From: Harvey, Allan AC [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]; Scott Marlowe
[EMAIL PROTECTED]
Cc: Csaba Nagy [EMAIL PROTECTED]; David Gardner
[EMAIL PROTECTED]; Postgres general mailing list
pgsql-general
Hi All
Is there a fast and easy method of transferring information between MS Excel
and PostgreSQL??
Bob Pawley
Thanks
Does one version of ODBC work for all versions of Excel and Postgresql.
I am wanting to transfer one or two tables from Excel and manipulate the
information in Postgresql then transfer the results back to Excel as a
single table.
I am using Excel 2000 and PostgreSql 8.1.
Bob
('LoopNumberEdit').Value := Edit1.Text;
PSQLQuery1.Execsql;
end;
Running Delphi 6 and PostgreSQL 8.2 on Win XP.
Bob
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
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
, 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
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: Bob Pawley [EMAIL PROTECTED]; PostgreSQL
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
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 pgsql-general@postgresql.org
Sent: Tuesday, March 20, 2007 2:28 PM
Subject: Re: [GENERAL
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 your
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 php script: [op;ening ?php and closing
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 also
Looking through PGAdmin where would I find the spatial references that the
errror message references?
Bob
- Original Message -
From: Richard Huxton dev@archonet.com
To: Bob Pawley [EMAIL PROTECTED]
Cc: Dave Page [EMAIL PROTECTED]; Shoaib Mir [EMAIL PROTECTED];
Postgresql pgsql
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 dev@archonet.com
To: Bob Pawley [EMAIL PROTECTED]
Cc: Dave Page [EMAIL PROTECTED]; Shoaib Mir
??
Bob
- Original Message -
From: Dave Page [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Shoaib Mir [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Friday, December 29, 2006 12:10 AM
Subject: Re: [GENERAL] Backup Restore
Bob Pawley wrote:
When I change
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
- Original Message -
From: Dave Page [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc: Shoaib Mir [EMAIL PROTECTED
to a simple instruction set for a backup/restore operation
using the PG Admin resource??
Bob
version??
Bob
- Original Message -
From: Dave Page [EMAIL PROTECTED]
To: Shoaib Mir [EMAIL PROTECTED]
Cc: Bob Pawley [EMAIL PROTECTED]; Postgresql
pgsql-general@postgresql.org
Sent: Thursday, December 28, 2006 11:30 AM
Subject: Re: [GENERAL] Backup Restore
Shoaib Mir wrote:
Well I
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]; Postgresql
pgsql-general@postgresql.org
Sent: Thursday, December 28, 2006 12:06 PM
, 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 pgsql-general@postgresql.org
Sent: Friday, December 22, 2006 10:12 AM
to 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
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 pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:07 AM
Subject: Re: [GENERAL] Starting Postgresql
a shell
http://en.wikipedia.org
which in PostgreSQL is
Bob
- Original Message -
From: Bob Pawley [EMAIL PROTECTED]
To: Ray Stell [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:12 AM
Subject: Re: [GENERAL] Starting Postgresql
which in PostgreSQL is
Bob
Here's the url http://fusion.gat.com/~osborne/dbdoc/postgres/postmaster.htm
Bob
- Original Message -
From: Richard Huxton dev@archonet.com
To: Raymond O'Donnell [EMAIL PROTECTED]
Cc: Postgresql pgsql-general@postgresql.org
Sent: Wednesday, December 20, 2006 11:43 AM
Subject: Re
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: Johann
Thanks Tony
What PostgreSQL files do I use?
Bob
- Original Message -
From: Tony Caduto [EMAIL PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Tuesday, December 19, 2006 8:53 AM
Subject: Re: [GENERAL] Creating an Independant Application
Bob Pawley
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]; pgsql-general@postgresql.org
Sent: Tuesday, December 19, 2006 9
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 McCawley [EMAIL PROTECTED
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
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
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
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 PROTECTED]; pgsql-general@postgresql.org
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]
To: Bob Pawley [EMAIL
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: Richard Huxton dev
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]; pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 10:43 AM
- perhaps.
Bob
- Original Message -
From: Raymond O'Donnell [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
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 pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 4:33 PM
Subject: Re: [GENERAL] PG Admin
On Dec 4, 2006, at 3:53 PM
, is 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 pgsql-general@postgresql.org
Sent: Monday, December 04, 2006 7:15 PM
Subject: Re
something??
Bob
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
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 PROTECTED]
To: Bob Pawley [EMAIL PROTECTED]
Cc
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 pgsql-general@postgresql.org
Sent: Wednesday, November 29, 2006 4:41
201 - 300 of 491 matches
Mail list logo
