On Thu, 2004-04-01 at 20:08, Joshua D. Drake wrote:
mike wrote:
I have just upgraded froom Fedora test1 to test2 which has upgraded
postgres version from 7.4.2 to 7.4.5 (frrom rpm -q)
Uhh unless I am missing something what you have done is impossible.
There is no 7.4.5
Are you sure
Hello,
I have one main table and 2 many-to-many relation tables and 2
one-to-many relation table. Main table has 150 000 rows and many-to-many
tables have about 300 000 rows.
I am creating web portal.
In my query I must call distinct with many-to-many relation. But this
query is too slow for web
SRA America is sponsoring an evening event with me in NYC. If folks
want to go, the details are on our web site under Events.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13
[EMAIL PROTECTED] wrote:
On 4/4/04 11:43 PM, Bruce Momjian [EMAIL PROTECTED] wrote:
OK, new patch applied that causes all threads to wait until the parent
checks their thread-specific pointers. I ran 1000 tests and all passed.
Hopefully it will good for you too.
I'll try to give it a
Hi there,
First of all, I suppose my problem should be at least farly common, but
haven't had luck trying to find what I need by searching on the docs,
google, etc. So please if this issue has already been covered please
point me to some URL, or the list archives, or what you think is
On 4/4/04 11:43 PM, Bruce Momjian [EMAIL PROTECTED] wrote:
OK, new patch applied that causes all threads to wait until the parent
checks their thread-specific pointers. I ran 1000 tests and all passed.
Hopefully it will good for you too.
I'll try to give it a test tonight.
Dumb question...
Hello Miguel,
On Monday 05 April 2004 15:58, Miguel Guzman Miranda wrote:
My issue is that I need to do some replication from Oracle tables to
PSQL. One-way only, incremental, and to a remote machine.
I have to replicate a lot of data from Oracle/MS SQL/Progress to PostgreSQL
I have
Dear All,
What's the best way to store jpgs in postgresql to use in a web page?
I tried to use large objects, but how would you extract them from a table to
be viewed in a web-page without having to write them to a scratch file
somewhere first?
Thanks
Colin
Greg Stark wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] wrote:
On 4/4/04 11:43 PM, Bruce Momjian [EMAIL PROTECTED] wrote:
OK, new patch applied that causes all threads to wait until the parent
checks their thread-specific pointers. I ran 1000 tests and all
I won't say what is right or wrong to do. But some will say to store the
file location in a field such as /mydocs/mypictures/myimage.jpg and then
have your php or what ever open that file. by using a select statement.
Not sure how you would store them in the database and pull it righ out. I
Bruce Momjian [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] wrote:
On 4/4/04 11:43 PM, Bruce Momjian [EMAIL PROTECTED] wrote:
OK, new patch applied that causes all threads to wait until the parent
checks their thread-specific pointers. I ran 1000 tests and all passed.
Hopefully it
I've found bytea works better for me than large objects.
As far as how to retrieve and display, that depends. What scripting
language are you using?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of C G
Sent: Monday, April 05, 2004 12:20 PM
To: [EMAIL
On Mon, 5 Apr 2004, C G wrote:
Dear All,
What's the best way to store jpgs in postgresql to use in a web page?
I tried to use large objects, but how would you extract them from a table to
be viewed in a web-page without having to write them to a scratch file
somewhere first?
There are
PostgreSQL v7.4 on Solaris 9
I've got a simple table
CREATE TABLE public.tbl_system
(
system_id int4 NOT NULL DEFAULT nextval('public.id_seq'::text),
system_name varchar(50) NOT NULL,
description varchar(300),
active bool DEFAULT true,
CONSTRAINT pk_tbl_system PRIMARY KEY
On Sunday 04 April 2004 10:50 pm, Tom Lane wrote:
Troels Arvin [EMAIL PROTECTED] writes:
In the init-script contained in the RPMs downloadable from the PostgreSQL
site (I checked the one for Fedora), an explicit locale is set before
running initdb. - And the explicit locale is not C.
Only
Lamar Owen [EMAIL PROTECTED] writes:
... The initdb locale
settings are stored in initdb.i18n, and they are re-sourced everytime
postgresql is started to prevent data corruption if postmaster is started
with a different locale from the initdb. Tom, is the data corruption issue
still an
On Sat, 03 Apr 2004 22:39:31 -0800, Mooney, Ryan [EMAIL PROTECTED]
wrote:
Ok, so I ran a vacuum analyse. It took ~1.7 days to finish.
Just to make it clear: VACUUM and ANALYSE are two different commands.
VACUUM is for cleaning up. It has to visit every tuple in every page,
and if there are
17 matches
Mail list logo