Henry Combrinck wrote:
<>It sounds to me like the real problem is with non-schema-aware client
software.
They're using Office XP Developer (Access 2000). No hope of fixing that.
No problem at all.
It's easy to automate the table linking process.
I have a table in access that holds - among other th
Oops! Gaetano Mendola <[EMAIL PROTECTED]> was seen spray-painting on a wall:
> Chris Browne wrote:
> > The Slony-I team is proud to present the 1.0.4 release of the most
> > advanced replication solution for the most advanced Open Source
> > Database in the world.
> >
> > The release tarball i
Hi Folks,
I'm looking for something that is completely independent of the MSVC++
Dev Studio environment, something that will compile and run under
win32 using the mingw distribution. A class that allows schema
definitions to be made and recordsets to be queried and updated would
be wonderful. It d
> ... I see a mysql user
> also. I know I did not create or install that :).
> ...
That has in there by default since sometime before Jaguar. It's not used
unless you install mysql, but mysql became part of the default install
in the server versions somewhere after 10.0 beta, which might have
so
Dennis Gearon <[EMAIL PROTECTED]> writes:
> I am trying to see if any of some
> appointments fall between two dates.
> the query looks like this:
> SELECT appointment
> FROM the_table
> WHERE date_mask < date_range
> AND
> flipped_date < flip_bits(the_table(date_mask));
> Now,
Vic Cekvenich wrote:
I am trying to write a sigle command to update the max number from
detail.
Something like:
update group set max_msgid=max(c.msgid)
from group g, content c
where g.id=c.g_id
So group is master, content is detail. I want group to stroe
max(msgid) from content.
Syntax
John DeSoi wrote:
Hi Carlo,
On Oct 20, 2004, at 9:47 PM, Carlo Florendo wrote:
but I was wondering how the name globbing scenario I presented is
possible? If it is not possible to do it with any configuration
files, could anyone point out at source code level what can be done
since I'd like to
Is the following example a good, and correct one, for using a functional
index? (the 'flip_bits' function would have to be written, and for the
correct size of bit(N) ):
I think I came up with a better way to search through some dates. It
would use a functional index. I am trying to see if a
"Ruediger Herrmann" <[EMAIL PROTECTED]> writes:
> has anyone implemented row versions/timestamps in PostgreSQL or any
> thoughts on this?
> Did I hit the right term? What I want to achieve is optimistic
> concurrency beyound transaction boundaries. When retrieving data
> I would also retrieve the
On Sunday night, we're going to be looking at rolling up beta4, so that
everyone is working with 'the same copy' as far as all of the changes that
have gone in over the past couple of weeks.
If anyone has any outstanding bug reports, or patches, that haven't been
addressed yet, please submit th
Chris Browne wrote:
> The Slony-I team is proud to present the 1.0.4 release of the most
> advanced replication solution for the most advanced Open Source
> Database in the world.
>
> The release tarball is available for download
>http://developer.postgresql.org/~wieck/slony1/download/slony1-1.
> and what sort of capabilities PostgreSQL has to scale across
> > multiple CPUs and hosts (multithreading, load balancing, etc).
> >
>
> Well, PostgreSQL can certainly take advantage of multiple CPU's,
> although there are some cases where we could do more (use multiple CPU
> on one query). You
Hi all,
has anyone implemented row versions/timestamps in PostgreSQL or any
thoughts on this?
Did I hit the right term? What I want to achieve is optimistic
concurrency beyound transaction boundaries. When retrieving data
I would also retrieve the row version and later on, in a different
transact
Dennis Gearon wrote:
I am designing something that may be the size of yahoo, google, ebay, etc.
Just ONE many to many table could possibly have the following
characteristics:
3,600,000,000 records
This is a really huge monster one, and if you don't partition that
table in some way I think you'
The Slony-I team is proud to present the 1.0.4 release of the most
advanced replication solution for the most advanced Open Source
Database in the world.
The release tarball is available for download
http://developer.postgresql.org/~wieck/slony1/download/slony1-1.0.4.tar.gz
There are a limite
On 21 Oct 2004, Robert Treat wrote:
> slony to set up load balancing depending on your needs... though I
> should say that PostgreSQL has tremendous ability to scale up even
> without getting into all the buzzword friendly schemes.
You should strive to pool your connections, though. Of course, t
On Thu, 2004-10-21 at 15:40, John Wells wrote:
> Guys,
>
> My boss has been keeping himself busy reading MySQL marketing pubs,
> and came at me with a few questions this morning regarding PostgreSQL
> features (we're currently moving to PostgreSQL).
>
I'd be interested to see what my$ql has to s
Bill, Madonna, and I are going out for beers after work. I'll mention it.
Richard Huxton
Don,
If the data is can be mapped as 2D or 3D Cartesian coordinates, you could
use spatial operators from PostGIS.
Rick
Don Isgit
Guys,
My boss has been keeping himself busy reading MySQL marketing pubs,
and came at me with a few questions this morning regarding PostgreSQL
features (we're currently moving to PostgreSQL).
While I don't think either are really that important for our
situation, he wanted to know specifically w
Henry Combrinck wrote:
It sounds to me like the real problem is with non-schema-aware client
software.
They're using Office XP Developer (Access 2000). No hope of fixing that.
Don't be pessimistic - give Bill a call and see if he'll accept a patch...
Failing that, I wrote a small VBA procedure to
Robert Fitzpatrick wrote:
I have a project where it is necessary to determine Outliers of lab
results and looking for some pointers on the best way to handle this
type of calculation with PostgreSQL. Possibly an operator? I have no
experience with that. I found some info on the web for calculating
> It sounds to me like the real problem is with non-schema-aware client
> software.
They're using Office XP Developer (Access 2000). No hope of fixing that.
> ...I think your options are to fix that, or downgrade to a
> non-schema-aware database (eg. Postgres 7.2 or before).
...and miss out on
I have a project where it is necessary to determine Outliers of lab
results and looking for some pointers on the best way to handle this
type of calculation with PostgreSQL. Possibly an operator? I have no
experience with that. I found some info on the web for calculating
Outliers, here is one of t
On Thursday October 21 2004 10:07, Tom Lane wrote:
> "Henry Combrinck" <[EMAIL PROTECTED]> writes:
> > I've been approached by the development people about removing the
> > 'public' schema. They complain about having to manually remove the
> > 'public_' tag from table names generated by their deve
On 10/21/2004 10:27 AM, [EMAIL PROTECTED] wrote:
Hello
MySQL has information about several storage engines. MEMORY to handle
temporary tables, InnoDB to handle transactions and which also can split
its table data over several files/partitions. Splitting of storage is
something which according to th
"Henry Combrinck" <[EMAIL PROTECTED]> writes:
> I've been approached by the development people about removing the 'public'
> schema. They complain about having to manually remove the 'public_' tag
> from table names generated by their development software whenever they
> link to PG via ODBC.
> Re
> Splitting of storage is
> something which according to the following article, PostgreSQL does not
> support:
>
> http://www.devx.com/dbzone/Article/20743
>
> But I cannot verify this due to lack of information.
Hm. How about reading the standard PostgreSQL documentation ?
It at least depends on
I tried using Reflection ftp client.
I get logged in to ftp server anonymously and I get asked what is your account?
I then get the message access denied.
"Marc G. Fournier" <[EMAIL PROTECTED]>
10/19/2004 04:39 PM
To: [EMAIL PROTECTED]
cc: "Joshua D
[EMAIL PROTECTED] wrote:
Hello
MySQL has information about several storage engines. MEMORY to handle
temporary tables, InnoDB to handle transactions and which also can split
its table data over several files/partitions. Splitting of storage is
something which according to the following article, Pos
PostgreSQL uses it's own internal storage engine. It doesn not
support multiple one. As for splitting files accross partitions this
is a feature of version 8.0 called tablespaces.
http://developer.postgresql.org/docs/postgres/manage-ag-tablespaces.html
Should get you pointed in the right direct
On Thu, Oct 21, 2004 at 04:27:24PM +0200, [EMAIL PROTECTED] wrote:
> Hello
>
> MySQL has information about several storage engines.
I think you will find fairly broad agreement around here that the
idea of different storage engines for different jobs is a bad one.
But to answer your question. .
Hello all
I've been approached by the development people about removing the 'public'
schema. They complain about having to manually remove the 'public_' tag
from table names generated by their development software whenever they
link to PG via ODBC.
Renaming or using another schema is not what th
On 21. okt 2004, at 01:30, Dennis Gearon wrote:
I am designing something that may be the size of yahoo, google, ebay,
etc.
Grrr. Geek wet-dream.
Just ONE many to many table could possibly have the following
characteristics:
3,600,000,000 records
each record is 9 fields of INT4/DATE
I don't
At 9:20 AM -0400 10/21/04, John DeSoi wrote:
On Oct 21, 2004, at 4:43 AM, David Teran wrote:
One thing is for sure: MacOS X, neither panther (10.3) nor jaguar
(10.2) have a user named 'postgres' as default. And Apple Remote
Desktop 2.x which uses internally a postgres 7.3.2 database to
store sta
Hello
MySQL has information about several storage engines. MEMORY to handle
temporary tables, InnoDB to handle transactions and which also can split
its table data over several files/partitions. Splitting of storage is
something which according to the following article, PostgreSQL does not
support
On Oct 21, 2004, at 4:43 AM, David Teran wrote:
One thing is for sure: MacOS X, neither panther (10.3) nor jaguar
(10.2) have a user named 'postgres' as default. And Apple Remote
Desktop 2.x which uses internally a postgres 7.3.2 database to store
statistic data does not use the postgres user af
Hi Carlo,
On Oct 20, 2004, at 9:47 PM, Carlo Florendo wrote:
but I was wondering how the name globbing scenario I presented is
possible? If it is not possible to do it with any configuration
files, could anyone point out at source code level what can be done
since I'd like to try playing around
On Wed, 2004-10-20 at 23:01 -0700, Joshua D. Drake wrote:
> Dennis Gearon wrote:
>
> > Google probably is much bigger, and on mainframes, and probably Oracle
> > or DB2.
>
> Google uses a Linux cluster and there database is HUGE. I do not know
> which database
> they use. I bet they built their
I think the user is there in 10.3 by default. Apple is using
PostgreSQL in one of their products. In order to use postgres (and to
have postgres show up as a normal user available in the login menu) I
deleted the user in NetInfo Manager. You also have to delete the
postgres group. After doing t
On Thu, 2004-10-21 at 09:08 +0200, JiÅÃ NÄmec wrote:
> Hello,
>
> I am looking for some modeler to create a database structure - tables,
> relations etc. I use DBDesigner, but it is primarily designated for
> MySQL.
>
> What tool do you use for PostgreSQL? - sheets and crayons?
http://techdocs.p
You can't create an index on a view (as far as I could figure out).
However it can be easily argued that you don't need any because the
way views seem to be implemented in PG is as an alias for the view
query. So when you join a table to a view you are actually joining it
to the related table in th
Hello,
I am looking for some modeler to create a database structure - tables,
relations etc. I use DBDesigner, but it is primarily designated for
MySQL.
What tool do you use for PostgreSQL? - sheets and crayons?
--
Jiří Němec, ICQ: 114651500
www.menea.cz - www stránky a aplikace
-
43 matches
Mail list logo
