this could be a black hole here.
I note your comments about disk controllers and will investigate that
area too for our next, larger, install.
Thanks again and regards
John
Greg Smith wrote:
On Sun, 15 Jun 2008, John Tregea wrote:
The machines would be running Windows XP Pro (our clien
reSQL runs fine on the AMD
platform and specifically does anyone have experience with the AMD Phenom™ Quad
Core Processors 9600B.
Thanks in advance
John Tregea
Technology Director
Debraneys
www.debraneys.com
Hi all,
Thanks for the continued suggestions on this question. I will reply
again once it is implemented and working.
Kind regards
John
Alban Hertroys wrote:
Scott Ribe wrote:
You won't have duplicates[1], it's a sequence. It's its purpose.
Now I may have missed something, I didn't follow
Scott, Ken and Tim,
Thanks for the assistance, I appreciate the advice.
Scott,
The example of
select id1 = nextval(somesequence)
could work for me. I have multiple users with our GUI and imagine I
could use transaction protection to ensure no duplicates between
selecting and incrementing th
again.
Regards
John
Tim Allen wrote:
John Tregea wrote:
Greeting again,
I am writing records to postgreSQL from an IDE called revolution. At
the time I perform the INSERT command I need to retrieve the value of
the serial_id column from the newly created row.
Is it possible to have a spec
Sorry, I just realised this should have gone to the SQL list... (Bloody
Newbie's) :-[
John Tregea wrote:
Greeting again,
I am writing records to postgreSQL from an IDE called revolution. At
the time I perform the INSERT command I need to retrieve the value of
the serial_id column fro
the number of rows affected) ?
That would save me doing a SELECT select statement after every INSERT.
Please excuse the terminology if it is not SQL'esque, but I hope you
know what I am getting at.
Thanks in advance
John Tregea
---(end of broa
Hi Brent,
Excellent advice, thanks for taking the time with what must be a fairly
newbie question in GIS terms.
I appreciate your help.
Cheers
John
Brent Wood wrote:
On Tue, 13 Jun 2006, John Tregea wrote:
Thanks Brent,
I will be cautious in my approach. The public schema is the
my
reluctance to modify those tables with the necessary geometry functions,
types etc.
Regards
John
Brent Wood wrote:
On Tue, 13 Jun 2006, John Tregea wrote:
Hi Brent,
I will look at postGIS today. I will try and keep the whole GIS
functionality as a separate schema to avoid confusing
orer LLC
-Original Message-
From: [EMAIL PROTECTED] on behalf of John Tregea
Sent: Sun 6/11/2006 11:18 PM
To: pgsql-general@postgresql.org
Cc:
Subject:[GENERAL] Help with storing spatial (map coordinates) data?
Hi,
I have recently switched to PostgreSQL and had no problem
Hi Brent,
I will look at postGIS today. I will try and keep the whole GIS
functionality as a separate schema to avoid confusing myself, so a
postGIS may be exactly what I am looking for.
Thanks and regards
John
Brent Wood wrote:
On Mon, 12 Jun 2006, John Tregea wrote:
Hi,
I have
hed on but
will be used to put risk assessment matrices into the correct order
along a supply chain.
I will try as you suggest and look at the "cube" datatype
Thanks for your fast reply.
Regards
John T
Tino Wildenhain wrote:
John Tregea schrieb:
Hi,
I have recently switched to P
n for the GUI development and have
only some general experience with SQL.
Thanks in advance
John Tregea
---(end of broadcast)---
TIP 6: explain analyze is your friend
13 matches
Mail list logo
