Peter Eisentraut wrote:
> As the release of PostgreSQL 8.1 draws near, it is once again time to update
> the translations of the program messages. To check the status of your
> language, check out this web site:
>
> http://developer.postgresql.org/~petere/nlsstatus/
>
> To participate in t
Hi
I am very new to FreeBSD (Windows Background), but am busy trying to
implement a PostgreSQL database that I have running in the Windows
environemtn on FreeBSD. Naturally, most of my problems so far have been
geeting to grips with FreeBSD.
Anyway, I am having a problem at the moment. Having bei
google for postgresql_autodoc-1.21
On 10/18/05, Dann Corbit <[EMAIL PROTECTED]> wrote:
I use ER/Win for that. There are some other tools too. Search thearchives.> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-> [EMAIL PROTECTED]
] On Behalf Of Bruno Cochofel> Sent: Tu
On Wed, 2005-12-10 at 18:02 -0400, Bill Bartlett wrote:
> [snipped]
>
> > May not be the best choice on Windows for production use, though for
> > development, it should be adequate.
>
> Are there known issues with the Windows version for production use, or
> is this simply because of the rela
Problem is: to offer such a thing with a straight face, we'd have to
confine ourselves to an Oracle-subset version of SQL. For instance,
lose the ability to distinguish empty-string from NULL.
I wasn't saying we write it - let Oracle do it :D
Chris
---(end of broadcas
pg_autodoc is nice and open source
Generates HTML, DIA, and other formats
Best Wishes,
Chris Travers
Metatron Technology Consulting
Dann Corbit wrote:
I use ER/Win for that. There are some other tools too. Search the
archives.
-Original Message-
From: [EMAIL PROTECTED] [
Tom Lane <[EMAIL PROTECTED]> writes:
> And it's been looked at a few times, and rejected as being far too
> bug-prone. The number of ways to screw up by using physical column
> number where you should have used logical, or vice versa, is daunting.
One way to make sure there are no such bugs woul
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Strangely a pgsql to oracle exporter is a good thing. It'd be a great
> feature of PostgreSQL. Imagine how many people would start on
> PostgreSQL if they KNEW that one day they could easily move to Oracle if
> they needed to. Risk managem
1) PostgreSQL to Oracle database conversion utilities released by
Oracle (unlikely given extensible languages in PostgreSQL).
Strangely a pgsql to oracle exporter is a good thing. It'd be a great
feature of PostgreSQL. Imagine how many people would start on
PostgreSQL if they KNEW that one
As Andrew noted, we've already heard plenty of FUD from Oracle. What
we've not seen is a FUD campaign based on serious study of our
weaknesses --- they've only bothered to muster transparent attacks on
"open source DBs" in general. My prediction is that the next step will
be FUD that's really de
On Tuesday 18 October 2005 23:44, Chris Travers wrote:
> Christopher Kings-Lynne wrote:
> > With no disrespect to PostgreSQL, MySQL has 100x our downloads and
> > installations...
> >
> > Oracle is simply going after by far the biggest open source database
> > player...
>
> As I said, Oracle demon
Chris Travers <[EMAIL PROTECTED]> writes:
> IMO, it is likely to start with one of two things:
> 1) PostgreSQL to Oracle database conversion utilities released by
> Oracle (unlikely given extensible languages in PostgreSQL).
> 2) Some sort of FUD campaign on the part of Oracle directed
> speci
Christopher Kings-Lynne wrote:
With no disrespect to PostgreSQL, MySQL has 100x our downloads and
installations...
Oracle is simply going after by far the biggest open source database
player...
As I said, Oracle demonstrated in 2000 that they had already singled
MySQL out for special comp
as quick as Access to build a bunch of forms , pump data into
spreadsheets, charts, word processing applications. It is often little
things that make the difference - the speed with which drop down lists
can be created is a huge boon to an access developer when the business
needs an app that re
I use ER/Win for that. There are some other tools too. Search the
archives.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Bruno Cochofel
> Sent: Tuesday, October 18, 2005 8:16 PM
> To: pgsql-general@postgresql.org
> Subject: [GENER
Hi Onyx,
From what i understand Postgresql will scale with more cpus, but not in
the same way as threaded server would.
I believe that as each process(backend) is created it will get assigned
to a CPU.
From what I can tell it works in a similar fashion to the Firebird
classic server.
Hopefu
Hi you all,
His there any SW that can do reverse engineering on postgreSQL
databases? I need something that can create entity-relationship models
from an already made db, and something that can create a db from a model.
Thanks,
Bruno
---(end of broadcast)-
> Using psql how can I ask postgresql to show the actual number of rows of a
> table?
What do you mean by 'actual number of rows'?
Is there a reason you can't just do:
select count(*) from this_table:
--
Mike Nolan
---(end of broadcast)---
T
If there smart enough to
be buying innobase these days, you can bet that by now they have this stuff
all straightened out.
No, that doesn't seem to follow ... if Oracle are spending their
resources to attack MySQL rather than us, the conclusion would be that
they are clearly still more inform
Thanks for your attention to the wording of the Dialog in the
Connections wizard.
As to your questions about the problems that i was having with the
latest version of rekall, I installed and ran it on a Dell Optiplex 150
GX (Pent 3 1GHZ, 512 Ram) running Fedora Core 3. My home network has 3
m
Robert Treat <[EMAIL PROTECTED]> writes:
> If there smart enough to
> be buying innobase these days, you can bet that by now they have this stuff
> all straightened out.
No, that doesn't seem to follow ... if Oracle are spending their
resources to attack MySQL rather than us, the conclusion wou
On Monday 17 October 2005 13:01, Scott Marlowe wrote:
> On Mon, 2005-10-17 at 09:46, Christopher Kings-Lynne wrote:
> > > Please don't make this assumption. PostgreSQL is *very* much on their
> > > radar, and probably represents the biggest long-term threat to their
> > > core database business at
"Onyx" <[EMAIL PROTECTED]> writes:
> Hello Everyone,
> Does anyone know if PostgreSQL supports running on dual processors, and
> will efficiently utilize the dual processors for performance? More
> specifically, will PostgreSQL utilize the dual processor performance of
> using dual-core AMD chips
On Oct 18, 2005, at 4:35 PM, Onyx wrote:
Hello Everyone,
Does anyone know if PostgreSQL supports running on dual processors,
and will efficiently utilize the dual processors for performance?
More specifically, will PostgreSQL utilize the dual processor
performance of using dual-core AMD
SELECT COUNT(*) FROM ;
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of vittorio
> Sent: Tuesday, October 18, 2005 10:29 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Number of rows of a table
>
> Using psql how can I ask
Rough English request translation:
We are 5th year students studying
computer engineering, we want to have information concerning advanced relational
data modeling and the manipulation of the abstract types from data by the
postquel language and the postgres system. We are need of your as
On Tue, 2005-10-18 at 16:35, Onyx wrote:
> Hello Everyone,
> Does anyone know if PostgreSQL supports running on dual processors,
> and will efficiently utilize the dual processors for performance?
> More specifically, will PostgreSQL utilize the dual processor
> performance of using dual-core AMD
On Oct 18, 2005, at 21:52 , [EMAIL PROTECTED] wrote:
Hi, all of a sudden (?) it seems like the stuff I am putting into a
table is getting the wrong character coding. The definition of the db
is like this:
CREATE DATABASE my_sampledb
WITH OWNER = postgres
ENCODING = 'LATIN1'
TABL
On Oct 19, 2005, at 2:29 , vittorio wrote:
Using psql how can I ask postgresql to show the actual number of
rows of a
table?
For table foo,
select count(*) from foo;
An up-to-date count of the number of actual rows is not stored some
place in the database. If an estimate is adequate for
guys
I am having difficulty compiling postgresql8.0.3 using ports on FreeBSD. I
need to use either MIT or HEIMDAL KRB5 to 'make' it.
How do I do it? (I am a newbie with make). make --DWITH_MIT_KRB5 etc haven't
worked out.
(apologies for multiple mails)
TIADISCLAIMER: The information in this messa
Using psql how can I ask postgresql to show the actual number of rows of a
table?
Ciao
Vittorio
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
bonjour:
nous sommes des étudiants de fin d'études 5éme année informatique ingénieurs , nous voulons avoir des cours concernant les bases de données avancées précisemment modéle relationnel étendu et la manipulation des types abstraits de données par les langages postquel et les systémes p
Hi, all of a sudden (?) it seems like the stuff I am putting into a
table is getting the wrong character coding. The definition of the db
is like this:
CREATE DATABASE my_sampledb
WITH OWNER = postgres
ENCODING = 'LATIN1'
TABLESPACE = pg_default;
Still I get crap out from it when I
Title: PostgreSQL on Dual Processors, Dual-Core AMD Chips
Hello Everyone,
Does anyone know if PostgreSQL supports running on dual processors, and will efficiently utilize the dual processors for performance? More specifically, will PostgreSQL utilize the dual processor performance of using
Neil Conway <[EMAIL PROTECTED]> writes:
> We could improve on this by reordering fields on-disk to reduce
> alignment/padding requirements, during CREATE TABLE. We'd need to be
> sure to present the same column order back to the client application, of
> course, but that should be possible. The noti
In terms of really good GUI clients we are now at a stage where we are
spoilt for choice.
There is PgAdmin, both III and the new Beta are excellent.
Aquafold Data Studio is also nice.
I use SQLManager Postgresql Manager from sqlmanager.net all the time.
PGLightning is also very good.
I actually p
Wim Bertels wrote:
suggestions to good clients?
tnx,
Hi,
You should check out PG Lightning Admin(PGLA) at:
http://www.amsoftwaredesign.com
We developed it because of the weirdness of PG Admin III on windows.
PGLA has a MDI interface with a MDI task bar that shows open MDI windows.
It al
Andrew Sullivan wrote:
On Tue, Oct 18, 2005 at 01:19:53PM -0700, Chris Travers wrote:
Ok. but it is still a lazy approach and indicates that Oracle has not
singled us out for special treatment. Again, this was not the case with
MySQL as of 2000 at the latest.
I may be more paranoid,
Andrew Sullivan wrote:
On Sat, Oct 15, 2005 at 06:04:54PM -0700, Chris Travers wrote:
Out of curiosity, what is wrong with requiring client SSL certs to
access the system and only issuing them to the PGPool system (or using a
different CA if you need to issue client certs to the end users)?
On 10/18/05, Wim Bertels <[EMAIL PROTECTED]> wrote:
Dear friends,i've been using postgresql quiet some time now,but i don't find any really good clients for "dummies" to this database.When i look at pgadmin:an anoying feature: it closes when u do something illegal, instead of
saying: u don't have t
Gregory Youngblood wrote:
On Mon, 2005-10-17 at 12:05 -0700, Chris Travers wrote:
5) Independant patent license firms. I guess it is a possibility, but in the
end, companies that mostly manufacture lawsuits usually go broke. Why would
you sue a non-profit if you were mostly trying to make
Op dinsdag 18 oktober 2005 16:30, schreef Raymond O'Donnell:
> On 18 Oct 2005 at 15:41, Wim Bertels wrote:
> > When i look at pgadmin: an anoying feature: it closes when u do
> > something illegal, instead of saying: u don't have the rights to do
> > this.
>
> You must be using an old version - pgA
Andrew Sullivan wrote:
Note the slide at the beginning of that from "PostgreSQL" to "open
source database products". That trick is consistent with several
other things I've seen from Oracle, including Ellison, on this topic.
The idea is to lump everything into the "open source" class, and the
On Tue, 2005-10-18 at 13:07 -0700, Chris Travers wrote:
Gregory Youngblood wrote:
> On Mon, 2005-10-17 at 12:05 -0700, Chris Travers wrote:
>
>>5) Independant patent license firms. I guess it is a possibility, but in the end, companies that mostly manufacture lawsuits usually go broke. Wh
On Tue, Oct 18, 2005 at 01:19:53PM -0700, Chris Travers wrote:
> Ok. but it is still a lazy approach and indicates that Oracle has not
> singled us out for special treatment. Again, this was not the case with
> MySQL as of 2000 at the latest.
I may be more paranoid, but that may be because our
On Tue, Oct 18, 2005 at 02:00:57PM -0400, Neil Conway wrote:
> We could improve on this by reordering fields on-disk to reduce
> alignment/padding requirements, during CREATE TABLE. We'd need to be
> sure to present the same column order back to the client application, of
> course, but that should
On Mon, 2005-17-10 at 12:25 -0500, Jim C. Nasby wrote:
> So, if you have a bunch of int2's all next to each other in a table,
> they will happily just consume 2 bytes. The issue comes when you try
> and mix them with other fields randomly, since many other fields
> require int alignment.
We could
Thanks all. They are very helpful!
- Emi
Emi Lu wrote:
Hello all,
Could someone suggest some online documents/links about postgreSQL DB
synchronization please?
What is "DB synchronization"? Are you talking about replication?
PDF discussion by Bruce
http://candle.pha.pa.us/main/writing
>
> PDF discussion by Bruce
>http://candle.pha.pa.us/main/writings/pgsql/replication.pdf
> Slony
>http://gborg.postgresql.org/project/slony1/projdisplay.php
> Commercial support from Command Prompt
>http://www.commandprompt.com/
> Pgpool
>http://pgcluster.projects.postgresql.org/
>
Emi Lu wrote:
Hello all,
Could someone suggest some online documents/links about postgreSQL DB
synchronization please?
What is "DB synchronization"? Are you talking about replication?
PDF discussion by Bruce
http://candle.pha.pa.us/main/writings/pgsql/replication.pdf
Slony
http://gborg.p
I've been using AM Software's PG Lightning Admin and like it a lot.
There were a couple of very small issues that were fixed quickly and I
haven't encountered any "bad behavior" for quite some time. Some of
the nice features for "dummies" (like me, most of the time) are structured
filter
On 18 Oct 2005, at 16:57, Andrew Sullivan wrote:
On Tue, Oct 18, 2005 at 04:37:23PM +0100, Alex Stapleton wrote:
Release a cheaper / free alternative and people will use it because
they will have almost no reason not to. This means that cheaper and
as good as does have a place in the market e
Hello Folks,
first i want to apologize for my bad english :~)
we got here apparntly 2 issues with the above mentioned functionality:
1. I want to use functions with composite types as parameters,
which is no deal on our current production server(postgres 7.4.3)
but don't wor
On Mon, 2005-10-17 at 12:05 -0700, Chris Travers wrote:
5) Independant patent license firms. I guess it is a possibility, but in the end, companies that mostly manufacture lawsuits usually go broke. Why would you sue a non-profit if you were mostly trying to make a buck with the lawsuit?
Wim Bertels <[EMAIL PROTECTED]> writes:
> Dear friends,
>
> i've been using postgresql quiet some time now, but i don't find any
> really good clients for "dummies" to this database. When i look at
[snip]
Others may disagree., but among many reasons that I find Postgres very
attractive is that
On Tue, Oct 18, 2005 at 04:37:23PM +0100, Alex Stapleton wrote:
> Release a cheaper / free alternative and people will use it because
> they will have almost no reason not to. This means that cheaper and
> as good as does have a place in the market even if it's not a
> conventional solution.
On Mon, Oct 17, 2005 at 11:18:19AM -0700, Chris Travers wrote:
> I.e. I see no evidence that Oracle is taking the PostgreSQL threat
> seriously, and the FUD campaign is more evidence that they don't (there
> are plenty of areas where Oracle has an edge over PostgreSQL-- the idea
> that "PostgreS
Emi,
Hmm, I might be wrong but, I believe the topic you are asking about is
Replication. Google for PostgreS(QL) Replication and see if that helps.
- Onyx
---
Onyx Mueller
Software Engineer
i-cubed : information integration & imaging LLC
201 Linden Street : Third Floor
Fort Collins, CO 80524
97
On 18 Oct 2005, at 15:59, Andrew Sullivan wrote:
On Sat, Oct 15, 2005 at 05:58:20PM -0700, Chris Travers wrote:
And in the market we're talking
about "cheaper" is not the main consideration for "better than". I
think other arguments are useful -- access to source (and therefore
auditab
>
> i've been using postgresql quiet some time now, but i don't
> find any really good clients for "dummies" to this database.
> When i look at pgadmin:
> an anoying feature: it closes when u do something illegal, instead of
> saying: u don't have the rights to do this.
Which version of PgAdmin
Richard Huxton writes:
> [EMAIL PROTECTED] wrote:
>> I need you expert opinions on the following statement.
> You have four statements here.
Also, no one of those statements is a reason for using serializable mode
instead of read committed mode, since they all apply to read committed
just as wel
Hello all,
Could someone suggest some online documents/links about postgreSQL DB
synchronization please?
Thanks a lot,
Emi
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Sat, Oct 15, 2005 at 05:58:20PM -0700, Chris Travers wrote:
> Repeat after me... Data integrity, like security, is a process, not a
> product.
I understand that. The problem is not that _I_ don't understand it,
but that the market for real, industrial multi-master replication is
so far relat
As the release of PostgreSQL 8.1 draws near, it is once again time to update
the translations of the program messages. To check the status of your
language, check out this web site:
http://developer.postgresql.org/~petere/nlsstatus/
To participate in the translation effort, please follow t
On Sat, Oct 15, 2005 at 06:04:54PM -0700, Chris Travers wrote:
> Out of curiosity, what is wrong with requiring client SSL certs to
> access the system and only issuing them to the PGPool system (or using a
> different CA if you need to issue client certs to the end users)? This
Hmm, I like th
On Oct 18, 2005, at 12:52 AM, Scott Marlowe wrote:What problems have you run into lately? And could pg_restore fix them, or were they too hairy?the only issues I have are when not doing a full dump/restore of a DB -- ie only pulling in data into an existing table structure. the ordering is not gu
On 18 Oct 2005 at 15:41, Wim Bertels wrote:
> When i look at pgadmin: an anoying feature: it closes when u do
> something illegal, instead of saying: u don't have the rights to do
> this.
You must be using an old version - pgAmin used to do that at one
time, and indeed it was VERY annoying, but
Amit Sanon wrote:
but when i restart my windows i am unable to start the service. the service
start is set to automatic but it doesnt start automatically and when i try
to manually start it it gives an error
Could not start PostgreSQL Database Server 8.0 service on local computer
Error 1069: Ser
Dear friends,
i've been using postgresql quiet some time now,
but i don't find any really good clients for "dummies" to this database.
When i look at pgadmin:
an anoying feature: it closes when u do something illegal, instead of
saying: u don't have the rights to do this.
When i look at phpgpadm
hi,
i recently installed postgres8.0.4 on my comp. my OS is Windows 2000. it installed postgres database as service and made an local account on my comp.
but when i restart my windows i am unable to start the service. the service start is set to automatic but it doesnt start automatically and wh
Is there a way for me to quickly calculate the maximum size of a row
for a table? I wanted to know if there was an automatic way to do it
before I do it manually.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an app
Florian Ledoux wrote:
An autovacuum deamon has been installed as a Windows service during
the setup of my PG 8.0.3 server on WinXP. I am surprised because I
believed that autovacuum was only available in 8.1 server. There is
no autovacuum_XXX parameters in postgresql.conf... How can I be sure
th
>>
Doesn't really matter if the legal issues are ultimately in one's favor, if
one's erstwhile opponent has enough lawyer time ... even if you can survive the
lengthy battle, it may well be a pyrrhic victory.
<<
Well, I would assume two things would happen in a case like that. The first is
t
On Sun, 16 Oct 2005, CSN wrote:
> I've been meaning to try out PostGIS and see what it
> is capable of. Is anybody using it? Do you have
> accompanying URLs?
>
www.postgis.org is the obvious one, which probably doesn't help much :-)
I'm using it extensively, underlying a few reasonably functio
[EMAIL PROTECTED] wrote:
I need you expert opinions on the following statement.
You have four statements here.
The primary reason I use serialized transactions is to avoid race
conditions.
Difficult to say why _you_ use them - they certainly can help there.
Make sure you read the bit on "
surabhi.ahuja wrote:
when i connect to it
it shows: server_encoding : LATIN9
and client_encoding: LATIN9
from where did it get these values
From your environment - the machine is presumably defaulting to some
locale that uses LATIN9 for it's character-set.
i want them to be UNICODE.
pl
I know the LUCENE " inverted index " is just like follows:
keyword doc_id[frequence] location
guangzhou 1[2] 3，6
he 2[1] 1
i 1[1] 4
live 1[2],2[1] 2，5，2
shanghai 2[1] 3
Yes
so ,before I thought that
I need you expert opinions on the following statement.
The primary reason I use serialized transactions is to
avoid race conditions. One of postgresql's famed features
is the MVCC (multi-version concurrency control) aka
serialized transactions, which allows you to avoid using
row/table level
hi all
i am facing a problem and here it is:
i install the following (postgres) rpms as
root
postgresql-libs-8.0.0-1PGDG.i686.rpm
postgresql-8.0.0-1PGDG.i686.rpm
and
postgresql-server-8.0.0-1PGDG.i686.rpm
now i try to create a database
/usr/bin/createdb temp
when i connect to it
it sho
Hi Tom
At 03:32 18/10/2005, Tom Lane wrote:
Johan Wehtje <[EMAIL PROTECTED]> writes:
> I was more disappointed in the fact that when the Wizard is used to
> build a Database connection to Postgresql the information box text
> informs the user that the "Postgresql is not as fast as MySql, but doe
really thanks for Teodor Sigaev,beat regards.
Becaue it's very importent or me these days,so I posted it again.
>> I only know that GiST is also "Inverse Order OF Idexing",but of course >> it is a tree NOT as lucene does
>Tsearch2 doesn't use inverted index (yet), and so it easy to update (y
THANKS very very much again for Teodor Sigaev 's help.
really thanks.
>> I only know that GiST is also "Inverse Order OF Idexing",but of course >> it is a tree NOT as lucene does
>Tsearch2 doesn't use inverted index (yet), and so it easy to update (your index >is always full - online indexin
because of its way of "Inverse Order OF Idexing",and "The GiST Tree is
well for larting lan but doesn't for chinese lan(also ineffifent for
Japanese lan)"。
About japanese look at http://www.oss.ecl.ntt.co.jp/tsearch2j/ (it's on
Japanese, but you can contact with developer)
I only know
I tried to reproduce it, but it seems that my problem vanished since i
switched from pg_pconnect to pg_connect in PHP. Maybe this is of any help.
But in my understanding the reported failure should not be influenced by
selection of pg_connect vs. pg_pconnect.
i will report if this problem arise
I don't know if I'm going to get a copy of
pg_filedump. What's the best way to fix this - dump
then restore?
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROTECTED]> writes:
> > oid | ctid| xmin | cmin | xmax |
> cmax | id
> >
>
+---+-+-
85 matches
Mail list logo
