Its called a "temporal database".
Usually its intended for medical or police databases where
you need a hind sight. i.e. if today is 31/12/2005, what did we know at
20/12/2005.
for example, for a doctor appearing at court and required to testify
what he knew at 20/12/2005.
Very cool.
It would be
On Fri, 2005-03-04 at 19:59 -0500, David A. Cobb wrote:
> I've newly transitioned from Windoze to Debian Linux. And, of course,
> I'm installing things left and right.
>
> I had pgsql up and running, then I had to do a lot of tearing out and
> reinstalling other stuff. Now, when I try to conne
I've newly transitioned from Windoze to Debian Linux. And, of course,
I'm installing things left and right.
I had pgsql up and running, then I had to do a lot of tearing out and
reinstalling other stuff. Now, when I try to connect to psql I get:
psql: FATAL: IDENT authentication failed for u
trilcejf wrote:
> Hi there.
> When i try pass the screen "Initialise database cluster" appear this
> message:
> "Tee PostgreeSQL data directory must be on an NTFS formatted volume"
> Any help on this would be appreciated. Thanks in advance
It means exactly what it says: it wants an NTFS logical p
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I found this same problem. The uninstall really needs to remove this
account. Either that, or the next install process needs to be able
to get the random password somehow.
Open a command prompt, then use the command "net user /delete
postgres" to
Why don't you try to
use another account for the service - while reinstalling just fill in 'posgres2'
as service account...
Best regards,
Peter
- Original Message -
From:
usya usya
To: pgsql-general@postgresql.org
Sent: Friday, March 04, 2005 4:43
PM
Subject
On Fri, Mar 04, 2005 at 03:40:17PM -0500, Tom Lane wrote:
> "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > decibel=# create cast (interval as rrs.seconds) WITH FUNCTION
> > rrs.interval_to_seconds(interval) AS IMPLICIT;
> > CREATE CAST
> > decibel=# select cast('1 month'::interval AS seconds);
>
See
the following article in Microsoft's Knowledgebase which describes how to
get to the system accounts in Windows XP Home. It specifically addresses
changing the Windows administrator password, but as long as you follow the
directions you should see the postgres account along with adminis
On Wed, Mar 02, 2005 at 11:42:59AM -0500, trilcejf wrote:
> Hi there.
> When i try pass the screen "Initialise database cluster" appear this
> message:
> "Tee PostgreeSQL data directory must be on an NTFS formatted volume"
> Any help on this would be appreciated.
> Thanks in advance
It means exact
Thanks, sometimes the obvious just passes me by. :-(
>If the number is negative there needs to be room for the minus sign...
"Martijn van Oosterhout" wrote in message
news:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 2: you can get off al
Goulet, Dick wrote:
\l works fine in psql, but is there a table where this is stored in the data dictionary?
-Original Message-
From: Dorian Büttner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 01, 2005 6:16 AM
To: "[EMAIL PROTECTED]"@postgresql.org
Subject: Re: [ADMIN] Database Name
i have to write a program in C++ using libpq. The
program establishes a connection with the desired database.
I have 4 tables in the database. Now i want to get
the list of attribute names, their data types for each of those 4 tables. how do
i do that?
Thanks you
Surabhi Ahuja
List,
I have a requirement to write a query that lists a set of
attribute/value pairs, but the values need to be dynamically created on
the fly from another query or function. Is it possible to have a table
like this:
Attribute | Value
-
Attrib1 | select val1,
Alexandre da Siva wrote:
> Blobs is not Implemented on PostgreSQL, but I need to this field type on
> PosgreSQL databases, how I can to use this? I'm using delphi...
>
>
> ps: I readed PosgreSQL Manual and other lists and sites, but not get a
> answer for my specific problem
PostgreSQL has large
I know that my problem is due to my carelessness and
ignorance, but I didn’t think that installing PostgreSQL would cause a state
of affairs not easily reversed. Please excuse the length of the following
narrative.
When installing PostgreSQL 8.0.1 on my laptop running Windows
XP Home (S
Hi there.
When i try pass the screen "Initialise database cluster" appear this
message:
"Tee PostgreeSQL data directory must be on an NTFS formatted volume"
Any help on this would be appreciated.
Thanks in advance
---(end of broadcast)---
TIP 6: Hav
hi
I just installed postgres 8.0.1 yesterday on my windows xp machine and it created a service account with an auto-generated password .
pliz help me on how to remove/delete this account.
i tried reinstalling but it couldn't be changed and i couldn't find it any, where is it stored anyway.
Hi,
why this statement:
SELECT 2147483647::abstime, 2147483646::abstime, 2147483645::abstime,
2147483644::abstime, 2147483643::abstime, 2147483642::abstime,
2147483641::abstime, 2147483640::abstime, 2147483639::abstime;
returns null form2147483646 and 2147483645? Is this feature or bug?
(Server v
Hello,
Ive been working with PostgreSQL on Windows for
almost a year. But when I put it in production to the
customer it has had the following error after a power
cut:
invalid page header in block aaa of relation bbb.
in which aaa is a block number and bbb is a table.
Trying to find out wha
Philip Pinkerton wrote:
I am trying to develop an application to access postgresql DB using QT
developer however when running the developer it cannot find the DB driver?
How can I make the driver available to QT?
Any Ideas would be helpful
Philip
---(end of broadcast)
On 3/2/05 3:51 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> I was going to suggest
> REINDEXing those indexes to see if that cuts the vacuum time at all.
The problem with that is it takes a very long time. I've got a couple of
things to try yet on the kswapd problem. If that doesn't work, maybe
"Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> decibel=# create cast (interval as rrs.seconds) WITH FUNCTION
> rrs.interval_to_seconds(interval) AS IMPLICIT;
> CREATE CAST
> decibel=# select cast('1 month'::interval AS seconds);
> ERROR: cannot cast type interval to seconds
Given the current coer
Jim C. Nasby wrote:
decibel=# create cast (interval as rrs.seconds) WITH FUNCTION rrs.interval_to_seconds(interval) AS IMPLICIT;
^^^
decibel=# select cast('1 month'::interval AS seconds);
ERROR: cannot cast type interval to seconds
It's not a schema issue is i
-Original Message-
From: Berend Tober [mailto:[EMAIL PROTECTED]
Sent: Friday, March 04, 2005 8:47 AM
To: Greg Patnude
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] preserving data after updates
> I use a modified form of option 3 with an ON UPDATE RULE the update
rule
> co
I'm trying to create a seconds domain that is an interval 'mashed to
seconds' as I once saw Tom describe it.
decibel=# create domain rrs.seconds as double precision;
CREATE DOMAIN
decibel=# create cast (double precision as rrs.seconds) WITHOUT FUNCTION AS
IMPLICIT;
CREATE CAST
decibel=# create fu
Door number 3.
Thanks for the responses and terrific suggestions!
Scott
On Mar 4, 2005, at 8:28 AM, Greg Patnude wrote:
I use a modified form of option 3 with an ON UPDATE RULE the
update rule
copies the row to an inherited table...
CREATE TABLE dm_user (
id SERIAL NOT NULL PRIMARY KE
> I use a modified form of option 3 with an ON UPDATE RULE the update rule
> copies the row to an inherited table...
I just gotta say that THAT is one COOL use of PG inheritance! Do you find that
it works well and is robust and all the good stuff it seems like would be the
case?
-- Berend
I use a modified form of option 3 with an ON UPDATE RULE the update rule
copies the row to an inherited table...
CREATE TABLE dm_user (
id SERIAL NOT NULL PRIMARY KEY,
lu_user_type INTEGER NOT NULL REFERENCES lu_user_type(id),
dm_user_address INTEGER NOT NULL DEFAULT 0,
"Dr. Stephane Schildknecht" <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> It doesn't. It returns "invalid" and "infinity".
> Is there a reason for this ?
I suppose the "invalid" value is a legacy thing, but "infinity"
certainly strikes me as useful. We have that in the regular
timestamp type
Tom Lane wrote:
=?ISO-8859-2?Q?Filip_Jirs=E1k?= <[EMAIL PROTECTED]> writes:
why this statement:
SELECT 2147483647::abstime, 2147483646::abstime, 2147483645::abstime,
2147483644::abstime, 2147483643::abstime, 2147483642::abstime,
2147483641::abstime, 2147483640::abstime, 2147483639::abstime;
retur
=?ISO-8859-2?Q?Filip_Jirs=E1k?= <[EMAIL PROTECTED]> writes:
> why this statement:
> SELECT 2147483647::abstime, 2147483646::abstime, 2147483645::abstime,
> 2147483644::abstime, 2147483643::abstime, 2147483642::abstime,
> 2147483641::abstime, 2147483640::abstime, 2147483639::abstime;
> returns nul
On Fri, 2005-03-04 at 08:41, Joshua N Pritikin wrote:
> I designed a schema which would benefit from inheritance (in particular,
> an index over more than one table).
>
> However, I read that inheritance is not really implemented yet. So I
> simulated it with extra indexes and extra joins.
>
> I
On Fri, 2005-03-04 at 08:25, Filip JirsÃk wrote:
> Hi,
> why this statement:
> SELECT 2147483647::abstime, 2147483646::abstime, 2147483645::abstime,
> 2147483644::abstime, 2147483643::abstime, 2147483642::abstime,
> 2147483641::abstime, 2147483640::abstime, 2147483639::abstime;
>
> returns null f
I designed a schema which would benefit from inheritance (in particular,
an index over more than one table).
However, I read that inheritance is not really implemented yet. So I
simulated it with extra indexes and extra joins.
Is there any plan / timetable for implementing inheritance (with prop
I do option 3. A generic trigger writes the tablename, field name, type
of change (insert/update/delete) and the old and new values for columns
that were affected. It is kind of a hog, but it works very well. I
have cron delete old entries so it doesn't eat my whole disk.
I haven't tried to ge
Hi,
why this statement:
SELECT 2147483647::abstime, 2147483646::abstime, 2147483645::abstime,
2147483644::abstime, 2147483643::abstime, 2147483642::abstime,
2147483641::abstime, 2147483640::abstime, 2147483639::abstime;
returns null form2147483646 and 2147483645? Is this feature or bug?
(Server ve
Alexandre da Siva wrote:
Blobs is not Implemented on PostgreSQL, but I need to this field type on
PosgreSQL databases, how I can to use this?
I'm using delphi...
ps: I readed PosgreSQL Manual and other lists and sites, but not get a
answer for my specific problem
http://www.postgresql.org/docs/8.
Blobs is not Implemented on PostgreSQL,
but I need to this field type on
PosgreSQL databases, how I can to use this?
I'm using delphi...
ps: I readed PosgreSQL Manual and other lists and
sites, but not get a answer for my specific problem
38 matches
Mail list logo
