Hello. My name is Clark Evans. I'm starting a project
to create an "accounting/bookeeping" project using
PostgreSQL. I am one of the founders of jos.org and
became frustrated with the management of a distributed
development effort. I have six month funding starting
Janua
Thank you all who responded to my last e-mail.
It's wonderful to have such a responsive group of
forward thinking people to work with. :)
My last post was made prematurely with less thought
than what was required. I won't have my "act"
together for another month or two... but when I
do you I
Is there anyone working on XML integration?
Services include:
a) Import/Export to XML (DTD defines schema)
b) Access (through stored procedures) to XML (PSAX anyone?)
b) Emulated tables (that direct queries to XML queries)?
c) Other fun XML items.
:) Clark
Anyone working on Row level locking and
on-line recovery?
I have some ideas (and questions) in this area.
Also, I was wondering if there is a "transaction
server" project, i.e., a server that helps provide
a consistent client interface to both the database and
application servers.
Thank you!
Albert Chen wrote:
> I tell my advisor to try PostgreSQL, but he said:
> "Why PostgreSQL is better than other commercial softwares?
> If you could give me ten reasons, and I will give it a try."
I'll give you one reason:
Equal access to the source code.
This allows you to better learn from
Jose',
Thank you for your response.
> --COBOL level 88 using functions---
>
> drop function current_client(text);
> create function current_client(text) returns bool as '
> DECLARE
> status ALIAS for $1;
> BEGIN
> RETURN status IN (''
I'm designing a database schema and have questions about OID.
First, I assume that OID are system assigned? [yes]
Second, Can I use OID as a primary key? [no]
Third, Is the OID invariant under an import/export process? [no]
Fourth, Can I create table with an OID type for referencing another
table
Just a general note. How close are PostgreSQL's
object extensions to those at the ODMG? How hard
would it be to write complant interface? Anyone
working on it?
See: http://www.odmg.org/
Clark
table Y.
Thank you for your thoughts.
:) Clark Evans
The Hermit Hacker wrote:
> On Thu, 11 Feb 1999, dustin sallings wrote:
> > On Fri, 12 Feb 1999, The Hermit Hacker wrote:
> > //Like, [EMAIL PROTECTED] :) How much of what is already
> > // done by the Docs Team pertinent to all this, and, if not, why not?
> > // If our existing manuals don't
Rich Shepard wrote:
>
> So, what I do is print out the docs, punch holes in them and put them
> in a loose-leaf binder. Those folks who want to make the extra effort put
> their docs out in .pdf format and I print them from Acrobat. Except that
> my laser printer doesn't do duplex printing, i
Stephan Doliov wrote:
> The efforts of the docs teams has been tremendous and valuable beyond
> description. The existing docs are the right place to start. It's
> certainly worth it however to expand some sections, create new ones, and
> edit existing ones. From my point of view, the docs give
Thomas Antepoth wrote:
>
> But what to do, if there are several local masters?
I may have interpreted the problem incorrectly, but here is
a similar problem I had...
Say I have 5 plants in a large company. Each of these
plants has a variety of machinery and tools which have
detailed maintance
es unique record ids among all temporary data
> and reexports the data to all his slaves.
>
> But what to do, if there are several local masters?
You have a 'chain of responsibility', the Design Pattern book
will help with this one.
>
> t++
Best,
Clark Evans
It's crude and not very efficient, but here is a solution:
CREATE TABLE temp ( var INT2 );
INSERT INTO temp VALUES (1);
etc.
CREATE FUNCTION temp_row_count() RETURNS FLOAT AS
'SELECT COUNT(*)::FLOAT AS result FROM temp'
LANGUAGE 'sql';
SELECT var, COUNT(*)::FLOAT / temp_row_count() AS pct
FROM
e = table_a.name
);
Hope this will do the trick.
:) Clark Evans
Manuel Lemos wrote:
>
> Hello,
>
> I am trying to use transactions with PostgreSQL with the normal sequence
>
> BEGIN
> one or more SELECT/INSERT/UPDATE/DELETE queries
> COMMIT
> END
>
> But I am getting the following message just like if I haven't started a
> transaction when I commit.
>
> E
Clark Evans wrote:
>
> Manuel Lemos wrote:
> >
> > Hello,
> >
> > I am trying to use transactions with PostgreSQL with the normal sequence
> >
> > BEGIN
> > one or more SELECT/INSERT/UPDATE/DELETE queries
> > COMMIT
> > END
> >
(SELECT name FROM table_b);
Clark Evans wrote:
> SELECT table_a.name, table_a.age
> FROM table_a
> WHERE NOT EXISTS (
> SELECT 'x'
> FROM table_b
>WHERE table_b.name = table_a.name
>);
I'm not sure about how well
Silvio Emanuel Barbosa de Macedo wrote:
> If there is an insert between my INSERT and SELECT, won't the counter be
> increased ? The only way I can understand this is the transaction locks
> inserts... so, in fact there could not exist another insert...
It should be a counter attached to your ses
Leon wrote:
> Why? There will be no such field as "record number", the only
> place where it can exist is the field which references another
> table. I can quite share your feeling about wrongness of
> physical-oriented things in abstract tables, but don't
> plain old indices deal with physical re
21 matches
Mail list logo
