Hi all, I have a question!
Suppose that you have a 'virtualstore'
database that are owned by Peter, the enterprise DBA. So why the tables that we
create inside 'virtualstore' don't have peter as owner automatically??? I mean,
why don't the tables inherits the owner of the database???
hi
i am migrating from postgres 7.3.9 to 8.0.3
I am facing a issue with encoding.
By default when i create new database it creates as UNICODE
In the earlier version the encoding was SQL_ASCII
so i am passing this variable while initializing the db directory
/usr/local/pgsql/bin/initdb -D /usr/
Rodrigo Sakai wrote:
> Hi all, I have a question!
> Suppose that you have a 'virtualstore' database that are owned by
> Peter, the enterprise DBA. So why the tables that we create inside
> 'virtualstore' don't have peter as owner automatically??? I mean, why
> don't the tables inherits the owne
Kailash Vyas <[EMAIL PROTECTED]> writes:
> The database cluster will be initialized with locale en_GB.UTF-8.
> initdb: warning: encoding mismatch
> The encoding you selected (SQL_ASCII) and the encoding that the selected
> locale uses (UTF-8) are not known to match. This may lead to
> misbehavior i
Sorry for the delay in replying.
The use-case that I have is the following. I'm writing a
job-control tracking sub-system that will store when jobs are
started, finished, failed, etc. I would like to have the ability
to have a process that is requesting to start, to actually wait a
specified pe
Don Drake wrote:
Sorry for the delay in replying.
The use-case that I have is the following. I'm writing a job-control
tracking sub-system that will store when jobs are started, finished,
failed, etc. I would like to have the ability to have a process that
is requesting to start, to actua
I just saw the interview made in LinuxWorld with Enterprisedb, my
question is: are they really supporting PostgreSQL like they claim?
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
Izoel Aguiar C wrote:
I just saw the interview made in LinuxWorld with Enterprisedb, my
question is: are they really supporting PostgreSQL like they claim?
Yes. They hired David Cramer, Jonah Harris and Alverro. They also
sponsored the community in their booth for LinuxWorld.
They are
From what I've seen in their beta version, yes their just being a Red
Hat like var and adding some gui based add-ons.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Izoel Aguiar C
Sent: Tuesday, August 23, 2005 12:43 PM
To: pgsql-admin@postgresql.org
Sub
-- Forwarded message --
From: jose fuenmayor <[EMAIL PROTECTED]>
Date: Aug 22, 2005 1:37 PM
Subject: Indexes (Disk space)
To: pgsql-admin@postgresql.org
Hi all,
I have the following question.
Is there anyway for me to know how much space on disk will ocupy an
index, created in a d
Goulet, Dick wrote:
From what I've seen in their beta version, yes their just being a Red
Hat like var and adding some gui based add-ons.
Well that isn't true at all. They have added a huge Oracle compatibility
layer.
Sincerely,
Joshua D. Drake
-Original Message-
From: [EMAIL
On a related note, you might be interested in
http://pgfoundry.org/projects/pgjob/
On Tue, Aug 23, 2005 at 09:42:27AM -0500, Don Drake wrote:
> Sorry for the delay in replying.
>
> The use-case that I have is the following. I'm writing a job-control
> tracking sub-system that will store when job
select * from pg_class;
or
select relname, relpages from pg_class where relname = '[index-name]';
the pages give you the information about the space the index uses, a
page has 8kb.
[...]Every table and index is stored as an array of pages of a fixed
size (usually 8Kb, although a different p
13 matches
Mail list logo
