On Oct 14, 2004, at 5:33 AM, Eric D. Nielsen wrote:
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the concept in
Temporal Data and the Relational Model, by Date, Darwen,
Lorentzos. A lot of it is not realizable without
Mark Dexter wrote:
update orders set RequiredDate =
(case when c.city in ('Seattle','Portland') then date(o.OrderDate) + 1
else date(o.OrderDate) + 2 end)
from orders o
join customers c on
o.Customerid = c.Customerid
where c.region in ('WA','OR')
and orders.orderid = o.orderid
The only
Andrew Sullivan wrote:
On Wed, Oct 06, 2004 at 05:25:58PM +0100, Mark Gibson wrote:
I had to remove Slony's schema manually as I was having problems
with it. I was in the process of removing all Slony related stuff,
and all my slave tables when this problem occurred, and was going to
start again
Hi,
given a table with some data, e.g. some monthly measures. Some of the
measures are missing though.
id m1 m2 m3 m4 m5 m12
--
1 23 45 66 76 76 12
2 76 NULL 77 88 77 ... 89
3 67 87 98 NULL 78 ... NULL
I would like the calculate the
Hello,
I have a table that uses tsearch2 and, of course, and index and trigger
to keep everything updated. Something like:
CREATE TABLE sometable (
id SERIAL,
someinteger INTEGER
sometext TEXT,
sometext2TEXT,
sometext3TEXT,
sometext_fti
On Fri, Oct 15, 2004 at 06:48:40AM +0200, Jaromir Dolecek wrote:
Stuart Bishop wrote:
Indeed - I was under the impression that the timezone would be preserved
(which is the case in the external datetime libraries I use), but I now
see that PostgreSQL will lose this information.
Err - how
On Fri, 15 Oct 2004, Net Virtual Mailing Lists wrote:
Hello,
I have a table that uses tsearch2 and, of course, and index and trigger
to keep everything updated. Something like:
CREATE TABLE sometable (
id SERIAL,
someinteger INTEGER
sometext TEXT,
sometext2TEXT,
Alexander Pucher wrote:
Hi,
given a table with some data, e.g. some monthly measures. Some of the
measures are missing though.
id m1 m2 m3 m4 m5 m12
--
1234566767612 276NULL77
88 77
You can replace Null values by the and make the
defaut Value 0 !
If u can't change the Data in the databaseyou
can use the coalesce function which replaces the Null value by zero (or any
specified value in thesecond argument):
select (coalesce(m1,0) + coalesce(m2,0) + ...
Hi All,
Earlier this year there was a discussion between Tom and Ezra regarding extending 'set
session authorization' to facilitate changing
the identity of a connection. A synopsis of the discussion is that Tom felt this was
bad and the web application should have more
responsibility for
Vivek Khera wrote:
GS == Greg Stark [EMAIL PROTECTED] writes:
GS David Garamond [EMAIL PROTECTED] writes:
GS Another reason to move to 7.4.5 would be that each version
GS introduced changes in behaviour. You're going to be dealing with
GS minor headaches from things like '' not being a valid
Thank you all who helped me out on this..
I had tried the distinct but not inside the count.
I was using the group by because this could have multiple returns but
after adding the distinct to inside the count it worked like a
charm!!!
Thanks to everyone who helped out on this one!
At 05:01 PM
Some help please?? :-) Anyone?
-Original Message-
From: [EMAIL PROTECTED] on behalf of Jason Tesser
Sent: Wed 10/13/2004 10:00 AM
To: [EMAIL PROTECTED]
Cc:
Subject:[GENERAL] converting database to unicode
I have a database in sql_ascii that I need to convert to
On Fri, 15 Oct 2004 09:11:05 +0800, Keow Yeong Huat Joseph
[EMAIL PROTECTED] wrote:
Hi, Can anyone tell me how to unsubscribe my address from the mailing list.
Thanks.
Regards
Joseph
You can do it the same place you sign up at.
On Fri, Oct 15, 2004 at 07:59:19AM -0500, Jason Tesser wrote:
Some help please?? :-) Anyone?
Did you try recoding the plain-text dump using recode or iconv?
-Original Message-
From: [EMAIL PROTECTED] on behalf of Jason Tesser
Sent: Wed 10/13/2004 10:00 AM
To: [EMAIL PROTECTED]
David Rysdam [EMAIL PROTECTED] writes:
... I would like to have psql (optionally?) not even send me NOTICE
messages.
Have you looked at client_min_messages?
regards, tom lane
---(end of broadcast)---
TIP 5: Have you
Uhh no. Could you help me understand how to do that. I am currently using the
following to dump and restore
pg_dump -Fc --username=xxx --dbanme=xxx filename
pg_restore -Fc --username=xxx --dbname filename
-Original Message-
From: Alvaro Herrera [mailto:[EMAIL
Tom Lane wrote:
David Rysdam [EMAIL PROTECTED] writes:
... I would like to have psql (optionally?) not even send me NOTICE
messages.
Have you looked at client_min_messages?
regards, tom lane
I had not, because I'd never heard of it. :) Looks like exactly what
Robin Ericsson [EMAIL PROTECTED] writes:
Is there even a way to solve it this way via a procedure?
If you want the range to depend on a procedure parameter then you're
back to square one: the planner has no way to know the values that
parameter will take on, and its default assumption is that
On Fri, Oct 15, 2004 at 09:36:42AM -0500, Jason Tesser wrote:
Uhh no. Could you help me understand how to do that. I am currently using the
following to dump and restore
pg_dump -Fc --username=xxx --dbanme=xxx filename
pg_restore -Fc --username=xxx --dbname filename
Something like
Scott Cain [EMAIL PROTECTED] writes:
Heck! So much for feeling close. It is somewhat frustrating to me that
such an obviously useful tool (having and using audit tables) should be
so difficult to implement.
The only really reasonable way to implement this is as a C function
anyway. I think
ljb [EMAIL PROTECTED] writes:
The README for 8.0beta3 is wrong on Tcl and I sent in a patch so it should
be fixed in a future release.
Yeah, looks like Neil applied that about two weeks ago.
regards, tom lane
---(end of
Hi Tom,
You are probably right that the performance will become an issue. I do
have a working solution using plpgsql, though, so I will at least try it
out for a while.
For anyone who is interested, I created a template file (using the perl
module Template.pm syntax) that works with the perl
On Mon, Oct 11, 2004 at 10:28:22AM +0100, Richard Huxton wrote:
One thing you might want to test is what happens when you manually
create a sequence separate from a table, i.e. no such table-name exists.
Instead of querying pg_statio_user_sequences, you could get the
sequences from pg_attrdef
Hi,
I am getting ready to release a new version of my postgresql
browser and regrettably no longer have access to any
version 7 of postgresql.
I have a static link against the 8.0.0b3 version of libpq
should this still work when accessing a version 7 database?
Thanks
Jerry
On Fri, 15 Oct 2004, Najib Abi Fadel wrote:
You can replace Null values by the and make the defaut Value 0 !
If u can't change the Data in the database you can use the coalesce function which
replaces the Null value by zero (or any specified value in the second argument) :
select (coalesce(m1,0)
I have a situtation where a particular table includes a timestamp column and
a id column. The query I am working with right now filters based on
timestamp and orders based on ID.
I have not found enough information about how multicolumn indexes actually
work to determine if one will help me in
Hmm. You have an audit_ table for each table that is audited. I chose
to have one big ugly audit table for all audited tables. I wonder which
is more flexible/useful.
Right off the bat I can see that if you add or rename a column you would
need to add or rename a column in your audit_ table
Greg Wickham [EMAIL PROTECTED] writes:
... (Postgres has strict limitations on usernames which make using
them for users impractical.)
Er, which strict limitations would those be? You can put almost
anything into a double-quoted identifier.
regards, tom lane
Thomas Yagel [EMAIL PROTECTED] writes:
Right now the index that I have on timestamp is not used because the Primary
Key(ID) index is chosen for ordering. If I place a multicolumn index on
(timestamp, id) will that index be able to filter the timestamp and still be
used for returning the
Is it down ?
regards
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 15 Oct 2004, snpe wrote:
Is it down ?
No, not now.
- --
Devrim GUNDUZ
devrim~gunduz.orgdevrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.1 (GNU/Linux)
I try cvs update and get this :
cvs update: cannot open directory /projects/cvsroot/pgsql-server/config: No such file
or directory
cvs update: skipping directory config
cvs update: cannot open directory /projects/cvsroot/pgsql-server/contrib: No such file
or directory
cvs update: skipping
On Thu, Oct 14, 2004 at 11:16:48AM +0200, Leonardo Francalanci wrote:
I read Chapter 23. Monitoring Database Activity to monitor postgresql,
but on Solaris it doesn't work. I tried /usr/ucb/ps, but it doesn't
work either (I only see the postmaster startup parameters). Isn't there
any other
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 15 Oct 2004, snpe wrote:
I try cvs update and get this :
cvs update: cannot open directory /projects/cvsroot/pgsql-server/config: No such file
or directory
Use pgsql, not pgsql-server. Per
Hi Ian,
I created one audit table for each table in the database just because
that seemed to me to be the sensible thing to do. The reason we want
audit tables is so that we can ask the question: what was the state of
the database 6 months ago and the easiest way to answer that question
is with
Ah, time travel. I don't think it will be quite that easy since if
there was no modification of a record on that day, there will be no data
returned, and if there were several modifications on that day, there
will be several records returned. I think you will need a correlated
subquery for each
Have you thought about unifying the audit + the current table and add
from/to datestamps for every record?
Example:
from_dt to_dt value
9/1/2004 9/30/2004 ABC
9/30/2004 10/5/2004 XYZ
10/6/2004 12/31/ 123
This would let you use the following query on the same table whether you
Oh yes. I do that a lot for attributes that need a history (last name,
which changes when you get married, etc) It is a bit more complicated
for queries though, since I use null to indicate an unknown end date
instead of the Y2K problem solution below.
-Ian
William Yu [EMAIL PROTECTED]
Hi Tom,
I didn't know that double quotes around user names permitted much more variety (of
user names).
As always - many many thanks.
-Greg
| -Original Message-
| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom
| Lane
| Sent: Saturday, 16 October 2004 3:14 AM
|
I am trying to install PostgreSQL on OS X 10.3, using the package from Entropy.ch. The installation instructions there, as well as anywhere else I have seen them on the net, say to create a user (using the System Preferences pane) with a shortname postgres. The problem is, this user already
Eric D. Nielsen wrote:
I'm in the process of adding more historic information to one of my
databases. I've liked the theoretical treatment of the concept in
Temporal Data and the Relational Model, by Date, Darwen,
Lorentzos. A lot of it is not realizable without a lot of user
defined
I recently installed PostGreSQL-7.4.5 on my OSX 10.3.5 system. I did not, however
have the problem you're encountering. There was no postgres user already
created on my system.
1. It's not like postgres just rolls off the tongue. It's hard to imagine another user of
your system choosing that
Thanks for the Snodgrass reference, it is rather similar and pre-dates
the book I was looking at. (Same notion of valid/transaction times,
but Date's non-SQL approach) From a quick skim it doesn't address the
distinction Date et al draw between historic and current temporal data;
however it
Nathan:
Yes and no. My guess is that either postgres is now a default user included with the Pather version, you inadvertantly created the user once before (or during installation), or Marc Liyanage (bless his soul) created it for you during installation. Of the three, I doubt it is the latter
--- Eric D. Nielsen [EMAIL PROTECTED] wrote:
Thanks for the Snodgrass reference, it is rather similar and pre-dates
the book I was looking at. (Same notion of valid/transaction times,
but Date's non-SQL approach) From a quick skim it doesn't address the
distinction Date et al draw
Devrim,
I update cvs in last two years with
cd /u1/pgsql
cvs up -dPC
I see this error today and I delete all and checkout again
It is fine now; pgsql guys destroy cvs often
regards
On Friday 15 October 2004 06:52 pm, Devrim GUNDUZ wrote:
Hi,
On Fri, 15 Oct 2004, snpe wrote:
I try cvs
I'm having a problem with a value coming out of a loop.
CREATE OR REPLACE FUNCTION funmessagespermintotal()
RETURNS int8 AS
'
DECLARE
this_rServer record;
this_rSum record;
this_iSum bigint;
this_iTotal bigint;
this_iMsgsPerMin bigint;
this_sQuery varchar(500);
BEGIN
this_iTotal := 0;
FOR
George,
I'd like to thank you for the link as well. It looks really interesting
after reading the front matter.
On Oct 16, 2004, at 10:07 AM, George Essig wrote:
--- Eric D. Nielsen [EMAIL PROTECTED] wrote:
Thanks for the Snodgrass reference, it is rather similar and pre-dates
the book I was
Hello. I have a query like:
SELECT big_table.*
FROM little_table, big_table
WHERE little_table.x = 10 AND
little_table.y IN (big_table.y1, big_table.y2);
I have indexes on both big_table.y1 and big_table.y2 and on
little_table.x and little_table.y. The result is a sequential scan of
big_table.
50 matches
Mail list logo