On Mon, Jun 21, 2004 at 08:29:54PM +0100, Richard Huxton wrote:
> Christopher Browne wrote:
> >When this particular application got discussed on local LUG mailing
> >list, this emerged as being one of the factors most likely to be a Big
> >Deal.
>
> Yep, except... Madison said a laptop was involve
Thank You, I installed now the 7.2.4-Version and it works. But how do I
reach my Data? My 7.2.-installation is now in /usr/local/pgsql/ , my
data - also 7.2 - are in /usr/lib/pgsql.old/data/ ...??
Tom Lane wrote:
Heiko Pohl <[EMAIL PROTECTED]> writes:
upgrading my OS from RedHat 8.0 to FC2,
Christopher Browne wrote:
After a long battle with technology, [EMAIL PROTECTED] (Richard Huxton), an earthling,
wrote:
5. You might want to batch together queries into transactions of a few
hundred or even few thousand updates.
When this particular application got discussed on local LUG mailing
raptor wrote:
]- re: to myself... In fact I was using postgres in the past afaik
6.x versions or so (no outer joins, rule system was still not fully
working ... it was good on paper was good but, ... now glad it has
advanced so much :")).. then i got using Inter Base(FireBird).
(really cool db :")
On Thu, Jun 17, 2004 at 06:07:05PM -0400, Carl Anderson wrote:
> >I am working with 7.4.1 under Linux (SuSE 8.1) The server is a HP ProLiant
> >DL 380-G3, 2x Intel Pentium4-Xeon, 2.8 GHz, 4 GB memory and a RAID 5
> >system with ca. 500 GB diskspace (xfs file system)
> >
> >
> >When doing big tran
On Fri, Jun 18, 2004 at 02:32:16PM -0400, Tom Lane wrote:
> > Since that 7.4.2 release-note only talked about crashing queries due to the
> > 7.4.1 bug, but not about data-corruption occuring, I wondered if the
> > symptoms I have seen are related to the alignment bug in 7.4.1 or not.
>
> No, I d
Hello List,
We're looking for a DB modeler who is also a Pg guru. Our principal need is
someone to model a global product database so that it can handle quite
massive i18n (up to 12 languages and lots of country/region relations)
Anyone with experience in this area is welcome to contact us. A mor
On my system I get permission denied when I switch to pgtest2 and select *
from pgtest_func.
Chris
-- create objects --
CREATE USER pgtest1 WITH ENCRYPTED PASSWORD 'pass' NOCREATEDB NOCREATEUSER;
CREATE USER pgtest2 WITH ENCRYPTED PASSWORD 'pass' NOCREATEDB NOCREATEUSER;
CREATE SCHEMA pgtest1 AU
After a long battle with technology, [EMAIL PROTECTED] (Richard Huxton), an earthling,
wrote:
> 5. You might want to batch together queries into transactions of a few
> hundred or even few thousand updates.
When this particular application got discussed on local LUG mailing
list, this emerged as
Running Fedora Core 2 trying to build pgadmin3 from source.
Build wxWindows from sources. Appeared to build and install no problem.
But when building pgadmin get the following error as it tries to build
pgadmin3.
/usr/local/lib/libwx_gtk2ud_core-2.5.a(corelib_settings.o)(.text+0xa55):
In functi
AFAIK, every database uses some sort of 'large object interface'. Surely
you could still move between DBs even using BLOB fields?
"Sailer, Denis (YBUSA-CDR)" <[EMAIL PROTECTED]> wrote:
There was a posting in the mailing list archives that I can't find
anymore. The web site right now is present
On Sunday 20 June 2004 03:37 pm, Tom Lane wrote:
> Consider passing the appropriate sequence name to the function as a
> trigger parameter.
That was going to be a last resort. So there is no way to access the DEFAULT
value that a column would get if no value or a DEFAULT was sent in an insert?
"Chris Ochs" <[EMAIL PROTECTED]> writes:
> Ok this probably isn't a bug but a side affect of how functions are cached.
> Changing the function to use EXECUTE to perform the query works. I don't
> know if this particular scenario was ever even though of before, or if in
> the future it would make s
Madison Kelly wrote:
Richard Huxton wrote:
Madison Kelly wrote:
Hi all,
I am new to the list and I didn't want to seem rude at all so I
wanted to ask if this was okay first.
No problem. Reading your message below, you might want to try the
performance list, but general is a good place to start
Denis,
You'd get better results if you posted this to the jdbc list.
Dave
On Mon, 2004-06-21 at 11:49, Sailer, Denis (YBUSA-CDR) wrote:
> There was a posting in the mailing list archives that I can't find
> anymore. The web site right now is presenting a list of items from a
> search in a reason
Ok this probably isn't a bug but a side affect of how functions are cached.
Changing the function to use EXECUTE to perform the query works. I don't
know if this particular scenario was ever even though of before, or if in
the future it would make sense to have the query planner not cache the
ses
There was a posting in the mailing list archives that I can't
find anymore. The web site right now is presenting a list of items from a
search in a reasonable amount of time, but takes 5-10 minutes to retrieve the
detail for each one as they are clicked. Rather frustrating.
This per
Richard Huxton wrote:
Madison Kelly wrote:
Hi all,
I am new to the list and I didn't want to seem rude at all so I
wanted to ask if this was okay first.
No problem. Reading your message below, you might want to try the
performance list, but general is a good place to start.
I have a program
A followup on this. If I "select * from account_settings" directly it
works, but if I call the function "get_accountsettings_by_username" it
fails. So it seems like an issue with functions in particular. Following
is the function in question if that helps.
CREATE OR REPLACE FUNCTION get_accoun
Sorry; I didn't include details at first because I wanted to make sure
that was an approprate request for this list.
I have the program run 'VACUUM ANALYZE' after every major update/insert
job and I have in fact indexed the three columns that I search through
when I need to decide to update (if
It doesn't currently seem possible to switch between different users using
SET SESSION AUTHORIZATION. If I log in as the superuser and switch to
another user that works, but if I then switch to a second user in succession
I get permission denied when I try to select from a table that the user doe
=?ISO-8859-1?Q?Michal_T=E1borsk=FD?= <[EMAIL PROTECTED]> writes:
> Is it possible to put a database name in slow query log?
7.5 will have a feature for this, but in existing releases you'd have to
hack up elog.c to do it.
regards, tom lane
---(end
22 matches
Mail list logo
