Hi,
Am Mon, 2003-07-14 um 21.01 schrieb Ian Barwick:
On Monday 14 July 2003 16:04, Stefan Armbruster wrote:
Hi,
I tried to migrate a database from 7.3.2 down to PostgreSQL 7.2.2
Any particular reason?
Yes, I'm developing with 7.3.2, production is 7.2.2.
and
got some trouble. The
On Monday 14 Jul 2003 11:16 pm, Terence Chang wrote:
Hi all:
I am new to PostgreSQL DB, however I have years experience with Oracle 8i
and MS SQL. I am in the process to promot PostgreSQL to my future client,
due to the cost. I am just wondering if overall people feels frustrated
with
I have never heard about NetFlix, but there is a small company in sweden which use
almost the same scheme... You pay a monthly fee, fill in a form with your
name+address, which movies you want and then they send them to you, i think you can
have at most five movies at a time... and when you
I have a problem here.I need to get a list of sequence ids of a
particular sequence. What I mean by this isI have a table that has
say...15 recordsand I'm using a sequence for the primary key of that
table. Now the values of the primary key is 1 to 10 for the 1st 10 records.
And then
I have a testprogram (using libpq) reading data from a cursor and large objects
according to the result of the cursor. The cursor is opened in a serializable
transaction.
Just for test reasons I know tried the following:
I started the test program that reads the data from the cursor and that
Title: RE: [GENERAL] How to find Missing Sequences
How about something like:
given a table:
tbl {
pk int4
}
SELECT ((SELECT max(pk) as lub FROM tbl AS t WHERE t.pktbl.pk).lub+1)::text || ' to ' || tbl(tbl.pk-1)::text FROM tbl WHERE NOT EXISTS (SELECT pk FROM tbl AS tb WHERE tb.pk=tbl.pk-1)
On 14 Jul 2003 at 15:16, Terence Chang wrote:
due to the cost. I am just wondering if overall people feels frustrated with
PostgreSQL or feels happey with it.
Happy; and you can't beat the cost!
1. What is your favorite GUI tool for PostgreSQL?
PgAdmin, though I use psql directly on the
On 14 Jul 2003 at 15:16, Terence Chang wrote:
1. What is your favorite GUI tool for PostgreSQL?
pgaccess - Mac OS X and Linux (will also run on any Tcl capable OS)
2. In your organization, do you have someone who works as full time
PostgreSQL DBA?
No I look after several database servers
If I switched from signed integers to unsigned integers (and from INET
to real IPv4 addresses, consisting of the relevant 32 bits only) I
think I could save about 25% of my table size.
Does PostgreSQL already implement these data types? I don't think so.
If I succeed in implementing them, would
On 14/07/2003 23:16 Terence Chang wrote:
[snip]
I have the following questions. Please reply me offline, so the mailling
list won't get flood. Thanks!
1. What is your favorite GUI tool for PostgreSQL?
Most of th time, I find psql to be perfectly adequate for the job. If I
need to look at long
On Tue, 15 Jul 2003 13:23:30 +0100 Paul Thomas [EMAIL PROTECTED] wrote:
On 14/07/2003 23:16 Terence Chang wrote:
[snip]
I have the following questions. Please reply me offline, so the
mailling
list won't get flood. Thanks!
1. What is your favorite GUI tool for PostgreSQL?
Most of th
On Tue, 15 Jul 2003 08:42:27 -0400 (EDT) Richard Welty [EMAIL PROTECTED] wrote:
i've played with dbvisualizer, found it useful, then found
that for one particular combination of versions (postgresql dbvis) it
wouldn't show me all tables.
ok, that didn't really come out right. there was a
1. What is your favorite GUI tool for PostgreSQL?
Tool to do what? As a DBA I find GUI front ends tend to be either
too restrictive or try to do too much and thus become too complicated.
(Oracle's Enterprise Manager Console is a classic example of feature
creep, or is that feature gallop?)
OTOH, I'm in the process of writing a GPL table-driven web-based table
browser/data entry program in PHP because I can't find one that does
what I want. I hope to be able to put out a beta of it by September,
assuming my own personal feature gallop is coming down the home
stretch by then.
On Sat, Jul 12, 2003 at 01:22:01PM -0700, Raymond wrote:
1) Are inserts, updates and deletes on views permissible?
Yes, but you need to write rules for this. Momjian's book (available
from A-W, I believe, or through the PostgreSQL web site) has a
discussion of how to do it.
2) Can triggers be
Hi,
Can anyone tell me what the limitations are regarding records?
Say I have a table with 50 fields of 20 characters each. If a table can
be 16 TB, how many records can it hold?
If you all have any other size benchmarks or such please include it. Is
PG ready for huge db's? How big is the
In what ways is the application you are writing going to be different from
phpPgAdmin?
I see it as more of a web-based application forms development engine
than as a DBA tool.
--
Mike Nolan
---(end of broadcast)---
TIP 7: don't forget to
Bruno Wolff III [EMAIL PROTECTED] writes:
Does PostgreSQL already implement these data types? I don't think so.
If I succeed in implementing them, would you accept a patch?
You can have unsigned integers using a domain with a check constraint.
They take twice as much storage as necessary.
On 15 Jul 2003, Joe Maldonado wrote:
Hello,
Vacuum analyze is taking a really long time on a fairly small table and
during the time the vacuum is running all select * from the table;
seems to hang untill the vacuum is done. Any help on this matter would
be greatly appreciated...
On Tue, Jul 15, 2003 at 04:09:28PM -0400, Joe Maldonado wrote:
Hello,
Vacuum analyze is taking a really long time on a fairly small table and
during the time the vacuum is running all select * from the table;
seems to hang untill the vacuum is done. Any help on this matter would
be
On 15 Jul 2003, Joe Maldonado wrote:
Hello,
Vacuum analyze is taking a really long time on a fairly small table and
during the time the vacuum is running all select * from the table;
seems to hang untill the vacuum is done. Any help on this matter would
be greatly appreciated...
What
Hello,
had Somebody compared Postgresql vrs Firebird? What is the main
diferent between this DBs? performance? support? flexibility?.
Best Regards!
-BEGIN PGP PUBLIC KEY BLOCK-
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
On Tue, 15 Jul 2003, Andrew Sullivan wrote:
On Tue, Jul 15, 2003 at 11:04:53AM -0700, Jay O'Connor wrote:
Actually what I meant is how long the vacuum runs. We're going to have a
big database (few TB projected, but I don't know where those numbers come
from) and I'm trying to ausage
Sorry forgot to mention we are running postgres 7.2.3.
-Joe
On Tue, 2003-07-15 at 16:15, scott.marlowe wrote:
On 15 Jul 2003, Joe Maldonado wrote:
Hello,
Vacuum analyze is taking a really long time on a fairly small table and
during the time the vacuum is running all select * from
On Tuesday 15 Jul 2003 9:09 pm, Joe Maldonado wrote:
Hello,
Vacuum analyze is taking a really long time on a fairly small table and
during the time the vacuum is running all select * from the table;
seems to hang untill the vacuum is done. Any help on this matter would
be greatly
On Tuesday 15 Jul 2003 7:38 pm, Vincent Hikida wrote:
OK. This has been bothering me. I finally recreated what I remember as an
anomoly in Oracle involving nulls. It also works the same way in
PostgreSQL. I guess in mind I extrapolated that there was a problem with
WHERE 1 IN (1,2,NULL) which
On Tue, Jul 15, 2003 at 04:09:28PM -0400, Joe Maldonado wrote:
Vacuum analyze is taking a really long time on a fairly small table and
during the time the vacuum is running all select * from the table;
seems to hang untill the vacuum is done. Any help on this matter would
be greatly
-Original Message-
From: Erick Dennis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 1:27 PM
To: [EMAIL PROTECTED]
Subject: [GENERAL] Firebird vrs Postgresql
Hello,
had Somebody compared Postgresql vrs Firebird? What is the main
diferent between this DBs?
OK, so I thought I'd do some more checking.
MySQL is known for just swallowing what you give it and going on without
raising an exception. numeric is also one of them
SQL script in postgresql:
create table testa (i1 numeric (4,2), i2 numeric(4,2));
insert into testa values (100.23,99.34);
On Tue, Jul 15, 2003 at 10:26:54PM +0200, Erick Dennis wrote:
had Somebody compared Postgresql vrs Firebird? What is the main
diferent between this DBs? performance? support? flexibility?.
I've heard from two different and unrelated sources that Firebird
corrupted data for them; the only way
I'm not sure this is still the case, but I recently chose PostgreSQL over
Firebird because Firebird requires direct access to the database file.
There is no way to access it via TCP/IP with drivers, etc. That killed
Firebird in my mind.
Derek
- Original Message -
From: Erick Dennis
- Original Message -
From: Dann Corbit [EMAIL PROTECTED]
To: Erick Dennis [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 11:04 PM
Subject: Re: [GENERAL] Firebird vrs Postgresql
-Original Message-
From: Erick Dennis [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
On Tuesday 15 July 2003 09:51, Stefan Armbruster wrote:
Hi,
Am Mon, 2003-07-14 um 21.01 schrieb Ian Barwick:
On Monday 14 July 2003 16:04, Stefan Armbruster wrote:
Hi,
I tried to migrate a database from 7.3.2 down to PostgreSQL 7.2.2
Any particular reason?
Yes, I'm developing
, 15.07.2003, 23:32, Derek Hamilton :
I'm not sure this is still the case, but I recently chose PostgreSQL over
Firebird because Firebird requires direct access to the database file.
There is no way to access it via TCP/IP with drivers, etc. That killed
Firebird in my mind.
It's not like
On 16 Jul 2003, Markus Bertheau wrote:
В Втр, 15.07.2003, в 23:32, Derek Hamilton пишет:
I'm not sure this is still the case, but I recently chose PostgreSQL over
Firebird because Firebird requires direct access to the database file.
There is no way to access it via TCP/IP with drivers,
--- Derek Hamilton [EMAIL PROTECTED] wrote:
I'm not sure this is still the case, but I recently
chose PostgreSQL over
Firebird because Firebird requires direct access to
the database file.
There is no way to access it via TCP/IP with
drivers, etc. That killed
Firebird in my mind.
Derek
On Wednesday 16 July 2003 00:32, Andrew Gould wrote:
4. I couldn't find the documentation to tell me where
to start once I installed the database server. (This
may have been obvious to a DBA.)
Here:
http://www.ibphoenix.com/main.nfs?a=ibphoenixpage=ibp_download
there is a Firebird Quick Start
Jan,
Now they have a patent on their system of rental subscription service.
I wonder how much the guy in the patent office got paid for that. If he
claims he got nothing, IMHO he simply claims he's less smart than a
piece of toast ... for granting such a rubber band patent you have to
get
Dmitry Tkach [EMAIL PROTECTED] writes:
But what the hell is my problem then??? I swear, I do insert into the
view there :-)
It's a really huge view, looking at a whole bunch of different tables...
I'd hate having to post the whole thing...
All I can guess is a bug (or pilot error) that's
39 matches
Mail list logo