am Tue, dem 07.10.2008, um 21:20:53 -0400 mailte Tom Lane folgendes:
> Luis Castillo <[EMAIL PROTECTED]> writes:
> > I would like to know how can I control in my database the rows that a
> > user has inserted. I mean many users can insert information in a table
> > but when trying to update the
On Tue, Oct 7, 2008 at 11:27 AM, Mark Roberts
<[EMAIL PROTECTED]> wrote:
>
>
>> My problem is, I need to benchmark set of tables, where - we can
>> assume - schema of each table is unknown, and we have no assumption on
>> any fields being present there. (altho, if there is no other way to do
>> it,
On Tue, Oct 7, 2008 at 4:08 AM, tsp <[EMAIL PROTECTED]> wrote:
>
> I am facing this problem but i didn't find the solution what mentioned here.
> Where are the folders "/usr/bin" and "usr/local/pgsql/bin/"
Then I guess the first question is what OS are you running and how
were the current and prev
Luis Castillo <[EMAIL PROTECTED]> writes:
> I would like to know how can I control in my database the rows that a
> user has inserted. I mean many users can insert information in a table
> but when trying to update the information I want that a user can change
> only those rows inserted by him.
Hello,
Q: How efficient is this?
If connectionHash is unique or near to it, and everything's indexed...
it could work for reasonable K values depending on your performance
requirements.
Nice to hear.
Every time i create a new table should i create a table with all
columns and
query from
On Tue, Oct 7, 2008 at 7:30 PM, Saptarshi Guha <[EMAIL PROTECTED]> wrote:
> Q: How efficient is this?
If connectionHash is unique or near to it, and everything's indexed...
it could work for reasonable K values depending on your performance
requirements.
> Every time i create a new table should
Bessette-Halsema, Dominique E. wrote:
> Is there a way to use the hostname that is in the /etc/hosts file
> instead of the IP address in pg_hba.conf
No. It has been discussed but we've not found a good way in which it
should work.
--
Alvaro Herrerahttp://www.Com
Bruce Momjian escribió:
> Well, I posted about this in August with no one replying:
>
> http://archives.postgresql.org/pgsql-admin/2008-08/msg00068.php
>
> Basically, there is a mismatch between what libpq and the backend think
> is the username, and that affects how MD5 uses the salt on t
Thanks much. Silly Me, I had an extraneous comma
-Original Message-
From: Raymond O'Donnell [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2008 8:12 PM
To: Bill Reynolds
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Left outer join question
On 08/10/2008 01:02, Bill Reyno
On 08/10/2008 01:02, Bill Reynolds wrote:
>Is it possible to have a left outer join on 2 tables from the same
> originating table where T1 left outer joins to T2 and T1 left outer
> joins to T3? I guess I'm stuck on the FROM clause syntax or trying to
> do something you just can't do.
Maybe
Hey folks, stuck on something here and maybe I went down a dead end
road.
Is it possible to have a left outer join on 2 tables from the same
originating table where T1 left outer joins to T2 and T1 left outer
joins to T3? I guess I'm stuck on the FROM clause syntax or trying to
do something yo
Hello,
I guess this is basic question for DBAs. I have several tables, each
numbering in 100,000's of rows.
They all have have connectionHash as the primary key and indices on
several variables.
E.g
Table1 has connectionHash, duration, type
Table2 has connectionHash, location
Table3 has conn
Hi list,
I would like to know how can I control in my database the rows that a
user has inserted. I mean many users can insert information in a table
but when trying to update the information I want that a user can change
only those rows inserted by him. Is this possible with Postgresql?
th
Hi!
* Martin Pitt <[EMAIL PROTECTED]> [2008-10-02 18:12:47 CEST]:
> Markus Wanner [2008-10-02 12:49 +0200]:
> > Unfortunately we are stuck with several Postgres 8.2 installations from
> > etch backports, which are no longer maintained by the backports, because
> > only 8.2 got dropped from
Hi again :)
* Markus Wanner <[EMAIL PROTECTED]> [2008-10-06 17:34:13 CEST]:
> Gerfried Fuchs wrote:
> > On the
> > other hand, I still don't fully understand the problems of not being
> > able to upgrade to pg-8.3 properly. People seem to have been able to
> > upgrade from 8.1 to 8.2, so w
I am facing this problem but i didn't find the solution what mentioned here.
Where are the folders "/usr/bin" and "usr/local/pgsql/bin/"
[webattach] IT-Dienstleistungen wrote:
>
> Thanks Scott, now I got it! ;)
>
> I found older copies of pg_dump in "/usr/bin" while the newer were in
> "/usr/l
Hi!
One (hopefully) last reply. :)
* Markus Wanner <[EMAIL PROTECTED]> [2008-10-07 10:52:55 CEST]:
> Gerfried Fuchs wrote:
> > Then again, that was already required when switching from 8.1 to 8.2.
> > And it was never a secret that backports.org is a moving target, just as
> > testing i
Hi
Is there a way to use the hostname that is in the /etc/hosts file
instead of the IP address in pg_hba.conf
Dominique Bessette
SAIC
(858) 826-9182
Greetings! The United States PostgreSQL Association (PgUS), in accordance
with its bylaws, is holding an election at the semi-annual meeting for
the remaining four board seats.
Information about the election procedure, timeframe, and links to the
nominee platforms are all available at:
https://w
Alvaro Herrera wrote:
> Tom Lane escribi?:
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > I don't know of a way to make MD5 and db_user_namespace work cleanly so
> > > we are considering removing db_user_namespace in 8.4.
> >
> > We are? It's no more or less ugly than the day it was put in (
Hi,
I enjoy discussing and I think we are getting closer to an understanding
with every mail.
Gerfried Fuchs wrote:
It would have to flow from the main pool to backports. I am no
authority here, even though I understand that it might sound a bit like
it, but I don't see the chances for the e
On October 20th 2007 the first annual PostgreSQL Conference: West
commenced. It was a single day, single room event.
On March 29th and 30th the first annual PostgreSQL Conference: East
commenced. It was a two day, three room event which.
On October 10-12th the second annual PostgreSQL Conference:
> My problem is, I need to benchmark set of tables, where - we can
> assume - schema of each table is unknown, and we have no assumption on
> any fields being present there. (altho, if there is no other way to do
> it, we could assume id bigint not null default nextval('someseq'));
> basically, I
2008/10/7 Richard Broersma <[EMAIL PROTECTED]>
> On Tue, Oct 7, 2008 at 9:47 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]>
> wrote:
>
> > If someone loves a challenge, and is able to provide me with an answer to
> my
> > problem - please do so. Also, if this can be done, but with slightly
> > differ
On Tue, Oct 7, 2008 at 9:47 AM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote:
> If someone loves a challenge, and is able to provide me with an answer to my
> problem - please do so. Also, if this can be done, but with slightly
> different requirements - please let me know too.
> Thanks, this is
Hey folks,
I want to do a fairly simple thing, but so far I see no way in which this
could be implemented with postgresql. So I decided to ask folks here.
My problem is, I need to benchmark set of tables, where - we can assume -
schema of each table is unknown, and we have no assumption on any fiel
On Tuesday 07 October 2008 08:54:31 am justin wrote:
> johnf wrote:
> > I have a friend I asked to load postgres 8.3 on his XP machine. He then
> > tested a python script which accesses several tables and discovered that
> > it retrieves data very slowly. It takes about 20 seconds to retrieve the
johnf wrote:
I have a friend I asked to load postgres 8.3 on his XP machine. He then
tested a python script which accesses several tables and discovered that it
retrieves data very slowly. It takes about 20 seconds to retrieve the data -
on localhost. However, using a remote connection to a
On Tuesday 07 October 2008 08:20:16 am you wrote:
> On Tue, Oct 7, 2008 at 11:11 AM, johnf <[EMAIL PROTECTED]> wrote:
> > I then thought it had something to do with the data -although the data
> > set is small. I did a complete dump and restored on his machine and
> > again got the same results.
I have a friend I asked to load postgres 8.3 on his XP machine. He then
tested a python script which accesses several tables and discovered that it
retrieves data very slowly. It takes about 20 seconds to retrieve the data -
on localhost. However, using a remote connection to a postgres datab
Tapio.Niva wrote:
> we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
> itself is working as expected.
> We are using PostreSQL via following perl version
>
> # perl -v
> This is perl, v5.10.0 built for i686-linux-thread-multi
> (with 4
Hi,
Magnus Hagander wrote:
> Not having followed the whole discussion here.. But if location is the
> only issue, we could perhaps provide a repository on the postgresql.org
> servers for this, in case Debian does not want it on their official ones?
Thanks for the offer, but location is not reall
Markus Wanner wrote:
> Hi,
>
> Alvaro Herrera wrote:
>> If there are no backported packages for any given Postgres major
>> version, what will happen is that a lot of people will be forced to
>> build them from source, which is a lot worse. (There is a reason why
>> PGDG provides RPM for all majo
Hi,
On Tue, 2008-10-07 at 09:23 -0500, Eduardo Arévalo wrote:
> distro Centos 5.2 x64
Since you want to use 8.3 IIRC, then, run:
rpm -Uvh \
http://yum.pgsqlrpms.org/reporpms/8.3/pgdg-centos-8.3-4.noarch.rpm
and then use yum to install GeOS, PostGIS and PostgreSQL 8.3.4. All have
64-bit support.
Tom Lane wrote:
>
> libreadline depends on libtermcap in RHEL-5, but so far as I can see
> this dependency is explicit in the RPM, so it shouldn't have been
> possible to not install termcap. (However, I'm not sure just how bright
> the dependency solver was in RHEL-5 ... maybe it let you install
Thank you, Scott. That's interesting to know about. It doesn't solve
my initial problem, though, because the C++ application was written
without transactions. (Yet another illustration of the lack of database
knowledge on the part of the initial developers.)
RobR
-Original Message-
Fr
I have 3 database in my cluster , and would make backup online just one
database ,atually i using pg_hotbackup --backupdir=/var/lib/pgsql/backups
--datadir=/var/lib/pgsql/data
but this command make a full backup in cluster.
anybody help me!
Tnks
Paulo Moraes
Novos endereços, o Yahoo! q
Hello,
thanks for help, -m32 option to Makefile and make was successful, so was
also make test & make install.
Our own tests are connecting to postgres - at least so far.
Tom,we are using 32-bit perl & 32-bit postgres on 64-bit RHEL4, because
some of our sw still are 32-bit.
DBD::Pg is the latest
Carlos Moreno <[EMAIL PROTECTED]> writes:
> I just downloaded the latest, 8.3.4, and I'm trying to install it on
> a CentOS 5.2 machine with all the updates (64-bit --- the system
> is an Opteron DC)
> The configure script fails reporting it doesn't find readline.
libreadline depends on libtermc
<[EMAIL PROTECTED]> writes:
> we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
> itself is working as expected.
> ...
> Our problem is that DBD::Pg version 2.10.7 will not compile ,
> LD_RUN_PATH="/usr/lib" gcc -shared -O2 Pg.o dbdimp.o quote.o types.o
> -o blib/arch/auto/DBD/P
On Mon, 2008-10-06 at 09:26 -0500, Eduardo Arévalo wrote:
> hello is campatible install postgresql-8.3.4-1-linux-x64 with
> postgis-1.3.3.
> postgis there for 64-bit architecture??
> There are the libraries and proj4 GEOS arqitectura for 64-bit??
For which distro? Many distros has these stuff in
Hi Markus,
Markus Wanner [2008-10-07 11:08 +0200]:
> Do I understand correctly, that https://code.launchpad.net/postgresql
> currently holds the debian packaging files in a bazaar repository?
It has branches for p-common and 8.3.
http://arch.debian.org/arch/pkg-postgresql/mpitt/ has the branches
Yi Zhao wrote:
> I have a table contains some duplicate records, and this table create
> without oids, for example:
> id | temp_id
> +-
> 10 | 1
> 10 | 1
> 10 | 1
> 20 | 4
> 20 | 4
> 30 | 5
> 30 | 5
> I want get the duplicated records r
Hi,
Martin Pitt wrote:
> So it's not a lot of work, but it must be done regularly and in time.
That's good news. And about my experience when backporting 8.2.9 and
8.2.10 for etch as well.
Do I understand correctly, that https://code.launchpad.net/postgresql
currently holds the debian packaging
Hi,
Alvaro Herrera wrote:
> If there are no backported packages for any given Postgres major
> version, what will happen is that a lot of people will be forced to
> build them from source, which is a lot worse. (There is a reason why
> PGDG provides RPM for all major versions, for a lot of Redhat
Hi,
Gerfried Fuchs wrote:
> Then again, that was already required when switching from 8.1 to 8.2.
> And it was never a secret that backports.org is a moving target, just as
> testing is, where the backported versions on backports.org come from.
While that's correct, nobody was forced to do that
Hello,
we have 32-bit PostgreSQL version 8.3.4 on 64-bit RHEL4 , Postgres
itself is working as expected.
We are using PostreSQL via following perl version
# perl -v
This is perl, v5.10.0 built for i686-linux-thread-multi
(with 4 registered patches, see
2008/10/7 Yi Zhao <[EMAIL PROTECTED]>:
> I have a table contains some duplicate records, and this table create
> without oids, for example:
> id | temp_id
> +-
> 10 | 1
> 10 | 1
> 10 | 1
> 20 | 4
> 20 | 4
> 30 | 5
> 30 | 5
> I want get t
48 matches
Mail list logo
