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:
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
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 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
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
[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
>> "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
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 column to date type
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
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
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 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
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 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
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
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
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,
>
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
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
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
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
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
> 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);
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
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
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
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
"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
>
> 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
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,
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 !
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
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
-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, 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
36 matches
Mail list logo
