12/31/ would be Y10K problem. :)
Dunno about you but I sorta don't care if somebody has to rewrite my app
8000 years from now. :)
Ian Harding wrote:
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
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. In
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
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 th
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 t
--- "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 dra
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
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 l
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 tha
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
> d
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 exi
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
| T
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]>
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
w
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 t
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
-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
http://archives.postgresql.org/pgsql-hackers/2004-1
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
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 directo
-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)
iD8DBQ
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
"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 th
"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
--
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 a
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 th
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) +
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 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_attrde
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 mod
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 broadcast)
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 th
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
pg_
"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 tha
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 wha
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 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
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
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.
http://webmail.postgresql.org/mj/mj_wwwusr?dom
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 Unicod
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 10
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 va
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 handl
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) + coalesce(m2,0) + ...
+coales
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 .
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,
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.
>
> E
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 TSVECTOR
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
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 fr
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 diffe
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 withou
51 matches
Mail list logo
