On Fri, 2005-12-09 at 08:45, gabor wrote:
[...]
>
> are there any cases, where a normal vacuum is unable to reclaim some
> space
Hello
We have det same problem in some databases running 7.4.8. Having
max_fsm_pages and max_fsm_relations properly configurated does not help.
It looks like
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Source code MD5 and SHA1 checksums for PostgreSQL 8.1.0
For instructions on how to use this file, please see:
http://www.gtsm.com/postgres_sigs.html
## Created with md5sum:
5e1f1a7c5f62170b56a3bf2512fdec2d postgresql-8.1.0.tar.bz2
61ada6238aebbe
On Fri, Dec 09, 2005 at 12:15:44PM +0800, Kathy Lo wrote:
> > See the shmctl() manpage:
> >
> >int shmctl(int shmid, int cmd, struct shmid_ds *buf);
> >
> > One of the command ids is IPC_RMID
> >
> Do I need to change the source code of postgresql if I want to set
> IPC_RMID flag to solve t
Hi !
We have an old web service with a pgsql database (in Suse Linux). This
database created by another programmer who no accessible now.
We want to dump this database to get data from it. But I have no passwords.
I do many things, but I cannot create dump from this database.
I know the name
am 09.12.2005, um 12:21:25 +0100 mailte [EMAIL PROTECTED] folgendes:
> Hi !
>
> We have an old web service with a pgsql database (in Suse Linux). This
> database created by another programmer who no accessible now.
>
> We want to dump this database to get data from it. But I have no passwords.
Hi all,
is it possible to index 2 columns in a table with tsearch2 using
different configurations for each column index?
I have a table publications that is defined as follows (simplified):
CREATE TABLE publications
(
title text,
author_list text,
fti_title tsvector,
>
> The configuration seems to work fine, but I can't get tsearch2 to
> use the 'author' config for column 'author_list' and 'default'
> config for column 'title'. Is there any way to accomplish this?
>
It's totally possible. I don't think you can accomplish this using the simple
tsearch trigger
"Andrus Moor" <[EMAIL PROTECTED]> writes:
> I have a table containing month column in format mm.
>
> create table months ( tmkuu c(7));
> insert into months values ('01.2005');
> insert into months values ('02.2005');
>
> How to create select statement which converts this column to date type
On 12/8/2005 9:12 PM, Luca Pireddu wrote:
I wrote a trigger function with the intent of preventing the deletion of a
parent record when a referencing record would not allow it. However, the
result is that the referencing record stays, but the referenced one is gone,
so that my foreign key con
On Fri, Dec 09, 2005 at 10:00:45AM +0100, Rafael Martinez Guerrero wrote:
> On Fri, 2005-12-09 at 08:45, gabor wrote:
> [...]
> >
> > are there any cases, where a normal vacuum is unable to reclaim some
> > space
>
> Hello
>
> We have det same problem in some databases running 7.4.8. Hav
Hi,
I noticed that sometimes we seem to have a problem with simple queries
that take a long time to execute. For example "select * from config
where key='abc'" which normally only takes a few milliseconds, but in
some rare cases suddenly takes 10-30 seconds.
It is a production system, so the
Hello, I'm having problems compiling pgsql 8.1.0 for
Solaris 10 using Sun Studio 11.
I'm giving configure the following arguments:
OS: Solaris 10
Hardware: SunFire V100
PATH (the /usr/ucb/cc was renamed to /usr/ucb/cc.old
and chmod 000)
/opt/SUNWspro/bin:/usr/ccs/bin:/usr/bin:/usr/sbin:/sbin:/us
> You could write a one trigger for the table to handle both.
>
Something like this :
-
CREATE OR REPLACE FUNCTION multi_tsearch2() RETURNS TRIGGER AS '
DECLARE
BEGIN
NEW.fti_title = to_tsvector(''default'', NEW.title);
NEW.fti_author_list = to_tsvector(''simple'', NEW.author_list);
On Friday 09 December 2005 09:22, Jan Wieck wrote:
> On 12/8/2005 9:12 PM, Luca Pireddu wrote:
> > I wrote a trigger function with the intent of preventing the deletion of
> > a parent record when a referencing record would not allow it. However,
> > the result is that the referencing record stays
William wrote:
> configure:2295: checking whether we are using the GNU
> C compiler
> configure:2319: cc -c conftest.c >&5
> "conftest.c", line 18: undefined symbol: choke
> "conftest.c", line 18: syntax error before or at: me
> cc: acomp failed for conftest.c
> configure:2325: $? = 2
>
> configu
1239
Hello, I'm having problems compiling pgsql 8.1.0 for
Solaris 10 using Sun Studio 11.
I'm giving configure the following arguments:
OS: Solaris 10
Hardware: SunFire V100
PATH (the /usr/ucb/cc was renamed to /usr/ucb/cc.old
and chmod 000)
/opt/SUNWspro/bin:/usr/ccs/bin:/usr/bin:/usr
Hi there,
The other day, a coworker who loves mysql was complaining to me because
he had a hard time to find out why this query didn't work on PostgreSQL:
SELECT
AR.artifact_id,
AT.type_nm,
AR.title,
U.dept,
FROM
Artifact_Revisions AR,
Revis
William <[EMAIL PROTECTED]> writes:
> checking test program... failed
> configure: error:
> *** Could not execute a simple test program. This may
> be a problem
> *** related to locating shared libraries. Check the
> file 'config.log'
> *** for the exact reason.
> $ more config.log
You need to r
On Fri, Dec 09, 2005 at 09:16:15AM -0800, David Rio Deiros wrote:
> The other day, a coworker who loves mysql was complaining to me because
> he had a hard time to find out why this query didn't work on PostgreSQL:
...
> FROM
> Artifact_Revisions AR,
> Revisions_to_Types RTT,
>
Thanks, I figured that was as far as I had to go for
the error.
Turned out readline was searching for GCC (Sun's
Companion) version. Disabled readline and went
without a hitch.
Thanks!
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> William <[EMAIL PROTECTED]> writes:
> > checking test program... fa
Yep, I'm aware, I've had a 8.0.2 custom built pkgadd
package for Solaris 10 with SMF support for awhile
now. Just didn't remembre how I got it going.
Till I know what version Sun is going with and how
they got it setup, I prefer to use my own package.
Thanks!
-William
--- Wes Williams <[EMAIL
On 12/9/05, David Rio Deiros <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> The other day, a coworker who loves mysql was complaining to me because
> he had a hard time to find out why this query didn't work on PostgreSQL:
>
[..select..]
>FROM
>Artifact_Revisions AR,
>Revisions_to_T
Jaime Casanova <[EMAIL PROTECTED]> writes:
> On 12/9/05, David Rio Deiros <[EMAIL PROTECTED]> wrote:
>> I am sure there is a good reason why you have to swap the relations
>> in PostgreSQL. Anyone?
> Because PostgreSQL is not broken...
> What i see in this SELECT is an LEFT JOIN between AT and U
On Fri, Dec 09, 2005 at 12:47:19PM -0500, Tom Lane wrote:
> Right. MySQL apparently thinks that JOIN has the same precedence as
> comma in a FROM-list, but anyone who has bothered to read the SQL
> standard knows that JOIN is supposed to bind tighter than comma.
> Your coworker is depending on a f
Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Fri, Dec 09, 2005 at 12:47:19PM -0500, Tom Lane wrote:
>> Your coworker is depending on a flat-out-incorrect behavior of MySQL.
> Hmm...I get errors in MySQL 5.0.16 with the query as posted so I
> have to wonder what the real query was.
(tries it...)
On Fri, Dec 09, 2005 at 02:17:59PM -0500, Tom Lane wrote:
> Michael Fuhr <[EMAIL PROTECTED]> writes:
> > Hmm...I get errors in MySQL 5.0.16 with the query as posted so I
> > have to wonder what the real query was.
>
> (tries it...) After removing the bogus comma, MySQL 4.1.14 swallows
> the query
On Fri, Dec 09, 2005 at 12:29:02PM -0700, Michael Fuhr wrote:
> On Fri, Dec 09, 2005 at 02:17:59PM -0500, Tom Lane wrote:
> > Michael Fuhr <[EMAIL PROTECTED]> writes:
> > > Hmm...I get errors in MySQL 5.0.16 with the query as posted so I
> > > have to wonder what the real query was.
> >
> > (tries
"Andrus Moor" <[EMAIL PROTECTED]> writes:
> I have a table containing month column in format mm.
>
> create table months ( tmkuu c(7));
> insert into months values ('01.2005');
> insert into months values ('02.2005');
>
> How to create select statement which converts this column to date type
On Fri, 2005-12-09 at 15:27 -0500, Chris Browne wrote:
> "Andrus Moor" <[EMAIL PROTECTED]> writes:
>
> > I have a table containing month column in format mm.
> >
> > create table months ( tmkuu c(7));
> > insert into months values ('01.2005');
> > insert into months values ('02.2005');
> >
> >
>> "Andrus Moor" <[EMAIL PROTECTED]> writes:
>>
>>> I have a table containing month column in format mm.
>>>
>>> create table months ( tmkuu c(7));
>>> insert into months values ('01.2005');
>>> insert into months values ('02.2005');
>>>
>>> How to create select statement which converts this
[Andrew, sorry for the PM - I pressed the wrong button.]
Andrew J. Kopciuch wrote:
>>You could write a one trigger for the table to handle both.
>
> Something like this :
[...]
> You can modify the function to be slightly more configurable with parameters
> taking the column names, and config
Hi,
I am trying to write a general update command where
there might be "bytea" fields involved.
The update command is generated programatically.
I am having some problems when a bytea field is
involved.
A generated command might look like:
update pics set info='moof.jpg', byteafield='moof.jpg
On Fri, Dec 09, 2005 at 02:29:02PM +0100, Baldur Norddahl wrote:
> I noticed that sometimes we seem to have a problem with simple queries
> that take a long time to execute. For example "select * from config
> where key='abc'" which normally only takes a few milliseconds, but in
> some rare case
On Fri, Dec 09, 2005 at 08:46:17PM -0500, Jerry LeVan wrote:
> I am trying to write a general update command where
> there might be "bytea" fields involved.
>
> The update command is generated programatically.
>
> I am having some problems when a bytea field is
> involved.
What language are you
On Dec 9, 2005, at 9:35 PM, Michael Fuhr wrote:
On Fri, Dec 09, 2005 at 08:46:17PM -0500, Jerry LeVan wrote:
I am trying to write a general update command where
there might be "bytea" fields involved.
The update command is generated programatically.
I am having some problems when a bytea fie
Begin forwarded message:
From: Jerry LeVan <[EMAIL PROTECTED]>
Date: December 9, 2005 10:45:35 PM EST
To: Michael Fuhr <[EMAIL PROTECTED]>
Cc: Postgres General
Subject: Re: [GENERAL] Update and bytea problem...
On Dec 9, 2005, at 9:35 PM, Michael Fuhr wrote:
On Fri, Dec 09, 2005 at 08:46:
36 matches
Mail list logo
