Microsoft
sql server 2005
cannot be shared on multiple systems i,e in a
network environment when
it is installed in one system it cannot be accessed
one other
systems.
Nonsense!
Where did you get this stuff?
I have even played with MS SQL Server 2005 Express,
and it is not crippled
--- Bob Pawley [EMAIL PROTECTED] wrote:
I'm getting a little frustrated with this problem.
Can anyone tell me what is wrong with the following
code.
I have tested the portions separately and they all
work.
When I try it as a whole I get the message control
reached end of trigger
--- Martijn van Oosterhout [EMAIL PROTECTED] wrote:
'transform_null_equals' won't help you at all here
since it only help
in the very specific case of comparing with a
constant. The easiest is
to think of NULL as meaning 'unknown'. Clearly you
can't compare that
usefully with anything.
--- Ian Sillitoe [EMAIL PROTECTED] wrote:
I completely take your points - so maybe I should be
asking for advice on
database design instead.
We are annotating nodes on a hierarchical structure
where NULL implied an
I don't mean to be rude, but yuck. Why provide a
record for data that
--- Webb Sprague [EMAIL PROTECTED] wrote:
...linear algebra ...
... matrices and vectors .
...Especially if some GIST or similar index
could efficiently search
for vectors close to other vectors...
I see a potential problem here, in terms of how one
defines close or similitude. I
--- Bill Moran [EMAIL PROTECTED] wrote:
In response to dvanatta [EMAIL PROTECTED]:
What's up with 3 of the 7 being from Pennsylvania?
What's the connection?
Well, as everyone knows, Pennsylvania is a haven for
brilliant
people. In fact, simply living in Pennsylvania
makes you
--- rihad [EMAIL PROTECTED] wrote:
Dec 18 15:49:41 myhost postgres[29832]: [35-1]
ERROR: 23505: duplicate
key value violates unique constraint foo_key
Dec 18 15:49:41 myhost postgres[29832]: [35-4]
INSERT INTO foo
Dec 18 15:49:41 myhost postgres[29832]: [35-5]
(a,b,c)
Dec 18 15:49:41
--- Colin Wetherbee [EMAIL PROTECTED] wrote:
Sam Mason wrote:
On Sun, Dec 16, 2007 at 06:31:56PM -0500, Colin
Wetherbee wrote:
If I write one Perl sub for each operation on the
table (e.g. one that
gets the username and password hash, another that
gets the last name and
first name,
--- Sam Mason [EMAIL PROTECTED] wrote:
On Mon, Dec 17, 2007 at 01:29:10PM -0500, Ted Byers
wrote:
I routinely keep my SQL code distinct from my
Perl,
java or C++ code. When a client program needs to
do
something with the database, then either a child
process executes a script I have
Thanks Uwe
This is a great start. It reduces the dump from 2 MB
down to 167K, but out of 6833 lines of SQL, 5744
relate to the public schema in the DB, and I didn't
touch that. It has over a dozen types, 419 functions,
c., that were put there by postgresql the moment I
created the database.
--- Tom Lane [EMAIL PROTECTED] wrote:
Ted Byers [EMAIL PROTECTED] writes:
Is there a way to tell pg_dump to just dump the
SQL
statements required to create the tables,
sequences,
indeces, keys, c.?
pg_dump -s ?
Thanks Tom
I DON'T need to restore or
recreate things like users
--- Tom Lane [EMAIL PROTECTED] wrote:
Ted Byers [EMAIL PROTECTED] writes:
It seems the public schema is
automagically created by Postgres every time I
create
a new database on a given server, and it has over
a
dozen types, over 400 functions, c. I don't
really
understand why
--- Richard Huxton [EMAIL PROTECTED] wrote:
Tino Wildenhain wrote:
Hi Ted,
Ted Byers wrote:
Thanks Uwe
This is a great start. It reduces the dump from
2 MB
down to 167K, but out of 6833 lines of SQL, 5744
relate to the public schema in the DB, and I
didn't
touch
OK, Now I am a bit confused. The manual doesn't say
what to do if you don't see template1 or template0 on
the server, or even whether or not you should be able
to see them when using a tool like pgAdmin. But it
does say:
The postgres database is also created when a database
cluster is
Thanks Richard.
--- Richard Huxton [EMAIL PROTECTED] wrote:
Ted Byers wrote:
Amyway, when I look at the server using pgadmin, I
don't see either template0 or template1. I see
only
template_postgis. Should I be able to see
template0
and template1 among the databases on the server
Thanks All. I learned plenty this morning.
--- Douglas McNaught [EMAIL PROTECTED] wrote:
On 12/10/07, Ted Byers [EMAIL PROTECTED]
wrote:
OK. A worry. How is template_postgis
constructed?
Is it just a handy reference to template1? Or
does it
exist independantly? I don't want
Thanks all. I tried the appended code in a trigger
function, but postgresql won't take it.
It complains that assets.quantity is not a scalar.
However, the WHERE clause in that select statement
guarantees that at most only one record will be
returned. An open position on a given kind of asset
--- Vivek Khera [EMAIL PROTECTED] wrote:
On Dec 10, 2007, at 5:04 PM, Colin Wetherbee wrote:
For what it's worth, the real algorithm would be
as follows. I
hadn't had enough coffee yet, and I forgot the
UPDATE bit.
IF
(a query matching your old data returns rows)
THEN
Thanks Erik
In a stored procedure you'd just execute the UPDATE
and then check
the FOUND variable to see if it found a row to
update:
UPDATE table_name SET foo='bar' WHERE id=5;
IF NOT FOUND THEN
INSERT INTO table_name (id, foo) VALUES (5, 'bar');
END IF;
To be clear, if I
Is there a way to tell pg_dump to just dump the SQL
statements required to create the tables, sequences,
indeces, keys, c.? I DON'T need to restore or
recreate things like users, or most other kinds of DB
objects. Just routine DDL statements. Looking
through a dump file for a small database, it
--- Erik Jones [EMAIL PROTECTED] wrote:
On Dec 6, 2007, at 2:36 PM, Ted Byers wrote:
[snip]
What you want to do here for handling the update v.
insert is called
an UPSERT. Basically, what you do is run the
update as if the row
exists and catch the exception that is thrown
IS there such a thing? I can be the first to consider
this.
What I am aiming for is a solution with a couple
coupled tables, one of which represents state through
time and the other represents transactions or deltas
on the state. With one field (a floating point
number) in the state table (or
--- Ted Byers [EMAIL PROTECTED] wrote:
IS there such a thing? I can be the first to
consider
this.
OOPS. The mind is faster than the fingers. That
should have been I can NOT be the first to consider
this.
Ted
---(end of broadcast)---
TIP
--- Richard Huxton [EMAIL PROTECTED] wrote:
Ivan Sergio Borgonovo wrote:
On Tue, 04 Dec 2007 08:14:56 +
Richard Huxton [EMAIL PROTECTED] wrote:
Unless it's an obvious decision (millions of
small identical
queries vs. occasional large complex ones) then
you'll have to
test.
Thanks Shane,
It works reasonably well. It gets the right answer,
but I guess my data set is much larger than your test.
Please consider the appended data.
The first two SQL statements are directly comparable.
My Left join is marginally simpler, as shown by
EXPLAIN, and runs to completion in
--- Shane Ambler [EMAIL PROTECTED] wrote:
Ted Byers wrote:
Please consider the following statement (it
becomes
obvious if you remember the important thing about
the
table is that it has columns for each of stock_id,
price_date, and price).
(SELECT * FROM stockprices WHERE
Please consider the following statement (it becomes
obvious if you remember the important thing about the
table is that it has columns for each of stock_id,
price_date, and price).
(SELECT * FROM stockprices WHERE stock_id = 1 ORDER BY
price_date DESC LIMIT 1)
UNION
(SELECT * FROM (SELECT * FROM
--- Gregory Stark [EMAIL PROTECTED] wrote:
Ted Byers [EMAIL PROTECTED] writes:
As a prelude to where I really want to go, please
consider the following SELECT statement.
SELECT close_price FROM stockprices A
WHERE price_date =
(SELECT MAX(price_date) FROM stockprices B
--- Tom Lane [EMAIL PROTECTED] wrote:
Ted Byers [EMAIL PROTECTED] writes:
OK, it is challenging to present it in plain text,
but
here is the HTML exported by MySQL Query Browser.
Why are you asking this list for help with a MySQL
performance problem?
because my question isn't really
--- Scott Marlowe [EMAIL PROTECTED] wrote:
On Nov 9, 2007 11:47 AM, Ted Byers
[EMAIL PROTECTED] wrote:
--- Tom Lane [EMAIL PROTECTED] wrote:
Ted Byers [EMAIL PROTECTED] writes:
[snip]
Which is better depends largely on how your database
is built. MySQL
still uses loops for all
As a prelude to where I really want to go, please
consider the following SELECT statement.
SELECT close_price FROM stockprices A
WHERE price_date =
(SELECT MAX(price_date) FROM stockprices B
WHERE A.stock_id = B.stock_id AND A.stock_id =
id);
stockprices has a primary key
--- Greg Smith [EMAIL PROTECTED] wrote:
On Fri, 2 Nov 2007, Kevin Hunter wrote:
I don't have ammo to defend (or agree?) with my
friend when he says
that Postgres requires a DBA and MySQL doesn't so
that's why they
choose the latter.
[snip]
To step back for a second, the
--- Andreas Strasser [EMAIL PROTECTED]
wrote:
Hello,
i'm currently designing an application that will
retrieve economic data
(mainly time series)from different sources and
distribute it to clients.
It is supposed to manage around 20.000 different
series with differing
numbers of
--- Michael Glaesemann [EMAIL PROTECTED] wrote:
On Oct 4, 2007, at 9:30 , Ted Byers wrote:
I do not know if PostgreSQL, or any other RDBMS,
includes the ability to call on software such as
R
See PL/R:
http://www.joeconway.com/plr/
Thanks. Good to know.
Ted
--- Stefan Schwarzer [EMAIL PROTECTED]
wrote:
Hi there,
how can I avoid results like this: 9.50184e+06
Instead it should return the real value, as
950184.
But 9.50184e+06 IS the real value! That is about nine
and a half million, not nine hundred and fifty
thousand, BTW. I do not see
--- Marcelo de Moraes Serpa [EMAIL PROTECTED]
wrote:
Hello list,
[snip]
* Each http request gets an instance of a session_id
? Or is it
per-connection ?
It depends. There is no necessary correlation between
a session as defined within a web application and a
session as defined in the
Sorry for top posting - but this is an annoying of this web interface to email.
:-(
Isn't what you're doing here a misuse of the idea of a transaction. I don't
claim to be an expert in this, but I thought the idea of a transaction was that
you bundle a group of statements together that
Here are just a few observations.
What you have described is a classic taxonomy problem. The simplest approach
is to create a table to contain the basic attributes of the obtjects in the
database. Using your example, such attributes may be anatomical (two eyes, two
ears, four limbs, one
I don't know about partial indexing, but in a similar situation to what you
describe, I have resorted to special tables designed specifically to hold one
day's worth of data and to support our daily processing. I'd put the daily
data into specific tables, with all the requisite indeces, and
I just checked the manual and it says nothing about being able to use the SQL
copy to access network files.
But you have an option that almost works for you. I am sure others here will
have some suggestions, but if I were in your place, I'd gather more information
about where
? How would you compare them
to the other options (such as C++, Java, Perl, c.)?
Cheers,
Ted
Rich Shepard [EMAIL PROTECTED] wrote:
On Mon, 30 Apr 2007, Ted Byers wrote:
I am not sure I see why it would be good to do this using SQL, but I do
know that I have used a number
I am not sure I see why it would be good to do this using SQL, but I do know
that I have used a number of Perl packages for this sort of thing. When I have
done this in the past, I'd do the date and time calculations in Perl and feed
the result to whatever RDBMS I happen to be using
Naz
First, there is nothing you can do about the computational load except make
your code as efficient as possible. Get it right and then make it fast.
But there is only so much you can do. If a calculation requires an
integer sum and an integer difference, you inevitably have two integer
- Original Message -
From: Randall Smith [EMAIL PROTECTED]
I'll give the pghackers forum a visit and since I'm already on the subject
here, I'll make a direct comparison of the situation. Microsoft's Internet
Explorer web browser is known to have poor support for the CSS standard,
It is not hard to calculate, as you can see... but it would be nice if
date_trunc('week', date) could do that directly. Even if it became
date_trunc('week', date, 4) or date_trunc('week', date, 'Wednesday')
it
would be nice... :-) And that is what I was trying to ask ;-)
Use
- Original Message -
From: Omar Eljumaily [EMAIL PROTECTED]
To: Ted Byers [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Friday, March 09, 2007 5:00 PM
Subject: Re: [GENERAL] Setting week starting day
Ted, my reason for asking the question that I believe precipitated
- Original Message -
From: omar [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Friday, March 09, 2007 10:40 PM
Subject: Re: [GENERAL] OT: Canadian Tax Database
Tom, I promise this isn't a political statement, even though it's on the
same thread.
I'm curious what people
- Original Message -
From: Joshua D. Drake [EMAIL PROTECTED]
To: Richard Huxton dev@archonet.com
Cc: pgsql-general@postgresql.org
Sent: Thursday, March 08, 2007 8:00 AM
Subject: Re: [GENERAL] OT: Canadian Tax Database
Richard Huxton wrote:
http://www.thestar.com/News/article/189175
And due at least in part to government (and other institutions operated
by
damned fools) opting for the least expensive provider rather than paying
for
someone who actually knows what they're doing. Just as buying cheap junk
always comes back to get you, hiring incompetent fools that don't
- Original Message -
From: Alan Hodgson [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Thursday, March 08, 2007 11:32 AM
Subject: Re: [GENERAL] OT: Canadian Tax Database
On Thursday 08 March 2007 08:15, Ted Byers [EMAIL PROTECTED]
wrote:
They would have satisfied
Richard Huxton wrote:
http://www.thestar.com/News/article/189175
For instance, in some cases the field for the social insurance number
was instead filled in with a birth date.
Unbelievable. Sixty years of electronic computing, fifty years use in
business and the professionals who built
- Original Message -
From: Bill Moran [EMAIL PROTECTED]
To: Rikard Pavelic [EMAIL PROTECTED]
Cc: Tom Lane [EMAIL PROTECTED]; pgsql-general@postgresql.org
Sent: Thursday, March 08, 2007 3:18 PM
Subject: Re: [GENERAL] security permissions for functions
In response to Rikard Pavelic
Functions are controlled by the same ACL mechanism that tables and
everything
else follows. Thus you have the idea of user id X may do Y with object
Z
i.e. user barbara may execute function somefunction().
But there's no real way to alter those permissions outside of changing the
user ID
Mark Similar issues with Mysql. It's faster,
But it doesn't matter *how* fast you get the *wrong* answer. :)
I thought one of the first rules of software engineering was First make it
right and only then make it fast!
Granted, most of my experience has more to do with number crunching and
Maybe his real goal all the backups readily available to be read by
my program (opening the backup read only) is to have a historical
record of what certain records looked like in the past.
There are other ways of doing that, though.
If your speculation is right, perhaps the OP ought to
- Original Message -
From: Ron Johnson [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Wednesday, February 14, 2007 3:46 PM
Subject: Re: [GENERAL] backup database by cloning itself
It seems to me that if you really want a historical record of what
certain tables looked
Would it not be simpler to just create two trigger functions, one that acts on
insert operations and a second that acts on update operations? A 30 second
glance at the Postgresql documentation showed me that it is possible to have
more than one row level trigger for a given table, which
- Original Message -
From: Merlin Moncure [EMAIL PROTECTED]
the open standard to convert data from one database to another,
unfortunately, is SQL. SQL is incomplete, illogical, and obscure, so
here we are.
The same can be said about any programming language, can it not?
Even
- Original Message -
From: Michael Schmidt
To: Jan Mura ; pgsql-general@postgresql.org
Sent: Thursday, February 08, 2007 12:54 PM
Subject: Re: [GENERAL] SQL textbook
Many books are available for download. Joe Celko is a well respected
author and just about anything with his name on
Hi Ted,
Hi Thorsten,
Am Donnerstag, 25. Januar 2007 19:53 schrieb Ted Byers:
The question I'd ask before offering a solution is, Does the order of
the
id data matter, or is it a question of having all the results for a given
id together before proceeding to the next id? The answer
The question I'd ask before offering a solution is, Does the order of the
id data matter, or is it a question of having all the results for a given id
together before proceeding to the next id? The answer to this will
determine whether or not adding either a group by clause or an order by
Is the original application ASP or SP.NET? It makes a difference,
particularly if it was developed to take advantage of ASP.NET 2. It might
conceivably be ASP.NET 3, but since that is brand new I can't see anyone
paying to replace an ASP.NET 3 application that was just created. If it is
- Original Message -
From: Merlin Moncure [EMAIL PROTECTED]
To: Janning Vygen [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Wednesday, April 12, 2006 12:31 PM
Subject: Re: [GENERAL] Hardware related question: 3ware 9500S
[snip]
- I want to know if 3ware 9500 S is
- Original Message -
From: Scott Marlowe [EMAIL PROTECTED]
To: Ted Byers [EMAIL PROTECTED]
Cc: Merlin Moncure [EMAIL PROTECTED]; Janning Vygen [EMAIL PROTECTED];
pgsql general pgsql-general@postgresql.org
Sent: Wednesday, April 12, 2006 2:24 PM
Subject: Re: [GENERAL] Hardware related
On Thursday 30 March 2006 03:03, Aaron Glenn wrote:
Anyone care to share the great books, articles, manifestos, notes,
leaflets, etc on data modelling they've come across? Ideally I'd like
to find a great college level book on data models, but I haven't come
across one that even slightly holds
May I ask a question about this?
I will be working on an older database in which the original developer
stored XML documents as a single variable length text field. To process it,
it has to be retrieved in full and parsed. But the structure of it is
simple in that it has an element for each
I am developing a small web application. Currently, our web server is
sitting outside our firewall (running its own firewall), and the
application
being developed would let users do things like place orders.
My question is...what and where is the database for this?
What do you mean when you
in a Perl script or java
application? I suppose I will have to have at least a basic Java
application, or perl script, if only to connect to the database and invoke any
functions I have created to do this.
Any suggestions would be appreciated.
Thanks,
Ted
R.E. (Ted) Byers, Ph.D., Ed.D.R
Bob,
If you're interested in a free java tool, you might want
to look at NetBeans (now version 5). It is one of the best I have seen,
and I have used a wide variety of such tools in a number of different
programminglanguages. Understand, though, that you have a wide
variety of options,
you,
or others, may have on these questions would be greatly appreciated.
Cheers,
Ted
R.E. (Ted) Byers, Ph.D., Ed.D.
R D Decision Support Solutions
http://www.randddecisionsupportsolutions.com/
---(end of broadcast)---
TIP 5: don't forget
Nico,
I do not believe there is anyone who can tell you the best way to go as
that is determined by far more than DB access.
That said, I am inclined to agree with John. I would expand on that to say
that if Delphi is the only language you know, then it is the best option for
getting
ored procedures and functions precisely because of
my studies of ways to make distributed applications secure.
Thanks,
Ted
R.E. (Ted) Byers, Ph.D., Ed.D.R D Decision
Support Softwarehttp://www.randddecisionsupportsolutions.com/
REATE" to
make the correction. I am puzzled though that I can't find it when I go
back to the pgAmin main window and search through the whole database (after
pressing F5 to refresh the contents of the windows).
Thanks to all who helped me on this matter.
Cheers,
Ted
R.E. (Ted) Bye
to all relevant people/sites.
If you faced this problem, what would you do, and why?
Cheers,
Ted
R.E. (Ted) Byers, Ph.D., Ed.D.
R D Decision Support Software
http://www.randddecisionsupportsolutions.com/
---(end of broadcast)---
TIP 9: In versions
Did you find a fix for it?
- Original Message -
From:
Jonel
Rienton
To: 'Ted Byers' ; pgsql-general@postgresql.org
Sent: Wednesday, December 28, 2005 1:24
PM
Subject: RE: [GENERAL] Final stored
procedure question, for now anyway
it's because
uggestions?
- Original Message -
From:
Jonel
Rienton
To: 'Ted Byers' ; pgsql-general@postgresql.org
Sent: Wednesday, December 28, 2005 4:16
PM
Subject: Re: [GENERAL] Final stored
procedure question, for now anyway
yup, just use lowercase all the
time
From:
- Original Message -
From: Frank L. Parks [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Wednesday, December 28, 2005 7:27 PM
Subject: [Bulk] Re: [GENERAL] Final stored procedure question, for now
anyway
Do you refresh you database after you add the function? It will not
t variable in the second insert?
Thanks,
Ted
R.E. (Ted) Byers, Ph.D., Ed.D.R D Decision
Support Softwarehttp://www.randddecisionsupportsolutions.com/
Hi Jaime,
Thanks.
I'd suggest the manual be edited by an educator, since it is a little dense
for someone coming to it for the first time. Once I read your reply to me,
and reread the manual, I understood. But on first reading, it is a little
too dense and short on examples.
Regarding
79 matches
Mail list logo