"scott.marlowe" <[EMAIL PROTECTED]> writes:
> Sweet. It may be that the promise is turning off the cache, or that the
> new generation of IDE drives is finally reporting fsync correctly. Was
> there a performance difference in the set with write cache on or off?
Check out this thread. It seem
I have a challenge to be able to grant all to the database, and then
have subsequent tables accessible by all users.
It seems to me that this is how a database should work. I do realize
that postgres doesn't do this now. Is there a way around this? Using
rules or some other mechanism?
Dave
--
Da
It seems to me file system journaling should fix the whole problem by giving
you a record of what was actually commited to disk and what was not. I must
not understand journaling correctly. Can anyone explain to me how
journaling works.
- Original Message -
From: "Bruce Momjian" <[EMAIL
I'm a consultant for a large company and they are looking at a database to
use.
I made the suggestion about going with Postgresql.
I told him about it's MVCC design, he liked that ideal, but wanted to know
exactly HOW did it handle the multiple versions of records. He's concerned
because he was
Hi,
does anybody out there have experience with the several PL's which are
available for PostgreSQL? I am currently evaluating several databases
(commercial as well as free & open source) for a new project and would
just like to hear some feedback.
PL/Java seems to be developed by a fairly small
Multiple database services and multiple versions on Red Hat Linux systems
The way it works is that we require a specific service script for each
database service (that is listening on each port). Each of these
services has a init script in /etc/init.d and a corresponding
configuration file in
On Sun, 26 Oct 2003, Mark Kirkwood wrote:
> Got to going this today, after a small delay due to the arrival of new
> disks,
>
> So the system is 2x700Mhz PIII, 512 Mb, Promise TX2000, 2x40G ATA-133
> Maxtor Diamond+8 .
> The relevent software is Freebsd 4.8 and Postgresql 7.4 Beta 2.
>
> Two
On Fri, 24 Oct 2003, Scott Chapman wrote:
> On Friday 24 October 2003 16:23, scott.marlowe wrote:
> > Right, but NONE of the benchmarks I've seen have been with IDE drives with
> > their cache disabled, which is the only way to make them reliable under
> > postgresql should something bad happen.
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Sun, Oct 26, 2003 at 10:02:22PM +, Oliver Kohll wrote:
>> I can't seem to retrieve a comment on a table column. The following copy from
>> psql should I think return a comment:
>>
>> mydatabase=> SELECT relnamespace FROM pg_class WHERE relname='
I'll assume you are on a Windows box. The answer is yes, you can use Excel
to pull back data from a Pg database on a Linux box.
If you are planning to use MS Query and If you don't have MS Query
installed, you will need to install from the disk.
You can download the Pg ODBC driver from the Pg site
yes
Alvaro Herrera wrote:
On Mon, Oct 27, 2003 at 12:08:31AM +0200, Yonatan Goraly wrote:
I have a query that uses the same view 6 times. It seems that the
database engine is calculating the view each time.
The result is very poor performance. The same query takes 2 sec with MS
SQL, and more
Hello,
Yes ODBC will be required and unless you have installed it is not
configured. You can go
here:
http://gborg.postgresql.org/project/psqlodbc/projdisplay.php
For the OpenSource/Free version or here:
http://www.commandprompt.com/
For a commercial (with more features) version.
Si
Sean Chittenden wrote:
> > > If you see a pg_temp_* for every connection, that is a little
> > > overwhelming. pg_toast and stuff aren't really too bad. Is there
> > > any way to access your local temp schema in a way that doesn't
> > > show the others? Could we use backend_pid in the query and
> > If you see a pg_temp_* for every connection, that is a little
> > overwhelming. pg_toast and stuff aren't really too bad. Is there
> > any way to access your local temp schema in a way that doesn't
> > show the others? Could we use backend_pid in the query and show
> > them only their own?
>
On 27 Oct 2003 00:21:07 -0800
[EMAIL PROTECTED] (Klaus P. Pieper) wrote:
>
> What about PL/Python or PL/Ruby? Any experience with these two
> implementations on a production system? Are there any PostgreSQL
> specifics or limitations? Significant differences between these two
> languages?
>
PL/
On Mon, Oct 27, 2003 at 01:40:53AM -0800, Neil Zanella wrote:
> [EMAIL PROTECTED] (Alvaro Herrera) wrote in message
>
> > You can of course do
> > SELECT now() + CAST('5 day' AS interval);
>
> Perhaps I should get myself a copy of the relevant parts of the SQL 99
> standard. How would you do th
Relaxin wrote:
> I'm a consultant for a large company and they are looking at a database to
> use.
>
> I made the suggestion about going with Postgresql.
>
> I told him about it's MVCC design, he liked that ideal, but wanted to know
> exactly HOW did it handle the multiple versions of records. H
"Vilson farias" <[EMAIL PROTECTED]> writes:
> bxs=# select CAST('10:32:14.553243' AS interval(0));
> interval
> -
> 10:32:14.553243
> (1 row)
This is a known bug in 7.3 and before --- it's fixed for 7.4.
regards, tom lane
---(e
Hi there,
I'm trying to access my postgreSQL database using Excel (through MS
Query). I've been reading a bit about ODBC and I'm pretty sure that
this is required. Is there a way to see if this is set up already? Am
I on the right track? The database server is running redhat linux.
Any hel
To use dynamic queries you will probably have to use EXECUTE, take a look
here
http://www.postgresql.org/docs/7.3/interactive/plpgsql-statements.html#PLPGS
QL-STATEMENTS-EXECUTING-DYN-QUERIES
Although that page says that EXECUTE does not support SELECT INTO queries,
but you may be able to build
On Fri, 24 Oct 2003 18:19:05 GMT, Ron <[EMAIL PROTECTED]>
wrote:
>When I try the following with my current database I
>get an error:
> giibdb=# ALTER TABLE project ADD CONSTRAINT company_is_ta FOREIGN
> KEY (companyID) REFERENCES tblCompanies(companyID);
> NOTICE: ALTER TABL
Does anyone know a good commercial application that does multi-master replication for
postgres?
Thanks
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMA
On Mon, 27 Oct 2003, Miso Hlavac wrote:
> hello,
>
> it is possible to write something similar???
>
> create function get_count(varchar(32)) RETURNS int4 AS '
> DECLARE
> tmp int4;
> BEGIN
> SELECT COUNT(*) INTO tmp FROM $1;
> RETURN tmp;
> END;' LANGUAGE 'plpgsql';
Youll need to do somethi
On 27/10/03 3:20 pm, "BARTKO, Zoltan" <[EMAIL PROTECTED]> wrote:
> Ladies and Gentlemen,
>
> Please, enlighten me, if you can, in the following matter:
>
> I made a type:
>
> create type my_type as (
> a integer,
> b integer
> );
>
> since I have a table:
>
> create table my_table (
> a
On Sat, 25 Oct 2003, Marco Colombo wrote:
> On Fri, 24 Oct 2003, scott.marlowe wrote:
> > On Fri, 24 Oct 2003, Scott Chapman wrote:
> [...]
> > > I also love the indentation to
> > > differentiate code blocks rather than the junk I'd been used to seeing in
> > > Perl and previous languages.
> >
On Sat, 25 Oct 2003, James Moe wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Sun, 26 Oct 2003 16:24:17 +1300, Mark Kirkwood wrote:
>
> >I would conclude that it not *always* the case that power failure
> >renders the database unuseable.
> >
> >I have just noticed a similar pos
On Fri, 24 Oct 2003, Staff, Alexander wrote:
> Hi,
> I created a simple table (name char200, zip char10, city char200, street char200, id
> int) and filled some data, appr. 250 000 records, in it.
> I tested accessing some rows (select id from address where id = 4;, select *
> from address w
On Sun, Oct 26, 2003 at 10:43:58AM +, Vadim Chekan wrote:
> Hello there,
>
> I have quite problem with PG 7.3 & 7.4b5
> I create tables using pgAdmin3 v-1.0.1
> I created a table "xType". Pay attention to capital "T" letter.
And when you created it, dod you write it "xType" or xType? With th
hello,
it is possible to write something similar???
create function get_count(varchar(32)) RETURNS int4 AS '
DECLARE
tmp int4;
BEGIN
SELECT COUNT(*) INTO tmp FROM $1;
RETURN tmp;
END;' LANGUAGE 'plpgsql';
SELECT get_count('k_part');
SQL error:
ERROR: parser: parse error at or near "$1" a
29 matches
Mail list logo
