On 2008-02-21 19:59, Tom Lane wrote:
You can set client_encoding in postgresql.conf if you want to, but I'm having a
hard time understanding why you think that'd be a good idea --- *particularly*
if your database encodings aren't all the same.
regards, tom lane
Act
On 2/22/08, Tom Lane <[EMAIL PROTECTED]> wrote:
> tuanhoanganh <[EMAIL PROTECTED]> writes:
> > ... But when I dump database and restore to 8.3 this function change to
>
> > CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24))
>
> It works as expected for me. Please provide a *complete* test case,
On Thursday 21 February 2008 17:07, Andrew Sullivan wrote:
> On Thu, Feb 21, 2008 at 04:35:28PM -0500, Geoffrey wrote:
> > How might we find out which release it was fixed in? Back patching
> > 7.4.19 with the fix might be easier then trying to move up to the fixed
> > version.
>
> According to HI
tuanhoanganh <[EMAIL PROTECTED]> writes:
> ... But when I dump database and restore to 8.3 this function change to
> CREATE OR REPLACE FUNCTION post_ctpt1(ud_stt_rec(24))
It works as expected for me. Please provide a *complete* test case,
including the specific dump and reload procedures you are
I have function in PostgreSQL 8.2
CREATE OR REPLACE FUNCTION post_ctpxd(ud_stt_rec)
RETURNS void AS
$BODY$DECLARE
...
BEGIN
END
$BODY$
LANGUAGE 'plpgsql' VOLATILE;
My domain in 8.2
CREATE DOMAIN ud_stt_rec
AS character(20)
DEFAULT ''::bpchar
NOT NULL;
But when I dump databa
On Thu, Feb 21, 2008 at 8:09 PM, Dean Gibson (DB Administrator)
> Mail to my list address MUST be sent via the mailing list.
> All other mail to my list address will bounce.
Totally uncool. There's settings in the mail server software that
will change your outgoing messages to not be from you
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> If I "ALTER DATABASE ... SET client_encoding TO DEFAULT", is the default
> the "client_encoding" in postgresql.conf when the server was last
> started, or the value at the time the "ALTER DATABASE ... SET
> client_encoding TO DEFAULT
Pascal Cohen wrote:
Hello
Are there users of PL/Java ?
I would like to get some feedback on using it.
As we could use triggers and as we have already some kinds of
'applicative' triggers written in Java, I was wondering if I could just
reuse the code and plug it
Pascal, yes, many people emplo
If I "ALTER DATABASE ... SET client_encoding TO DEFAULT", is the default
the "client_encoding" in postgresql.conf when the server was last
started, or the value at the time the "ALTER DATABASE ... SET
client_encoding TO DEFAULT" statement is executed?
In other words, if I "ALTER DATABASE ... S
Yeah - I reckon that would do it ;)
And it did break just about every website on our systems! Though the
change is understandable
Alex
On Thu, Feb 21, 2008 at 8:15 PM, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On Thu, 21 Feb 2008 19:49:29
On 2008-02-21 13:37, Justin wrote:
... I'm wondering if there is a way to create this in a single select
statement??
I can't think of a way to do it???
Break down your problem using VIEWs. Create a VIEW that gets just ONE
of the averages, based on a starting date. Then create a SELECT that
John Tiedeman wrote:
When I upgraded to Kubuntu 7.10 I opted to install 8.3 rather than
stick with 8.2. I knew to dump my 8.2 files first. After I finished
installing, I got (and still get) a message that I should have an
8.3.0-client. I don't see any separate downloads listed so assume
it's in t
John Tiedeman wrote:
When I upgraded to Kubuntu 7.10 I opted to install 8.3 rather than stick
with 8.2. I knew to dump my 8.2 files first.
After I finished installing, I got (and still get) a message that I
should have an 8.3.0-client. I don't see any separate downloads listed
so assume it's in
When I upgraded to Kubuntu 7.10 I opted to install 8.3 rather than stick with
8.2. I knew to dump my 8.2 files first.
After I finished installing, I got (and still get) a message that I should have
an 8.3.0-client. I don't see any separate downloads listed so assume it's in
the standard package.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 21 Feb 2008 19:49:29 -0500
"Alex Turner" <[EMAIL PROTECTED]> wrote:
> Yeah - I pressed tab to indent my code, and of course it tabbed to the
> next element on the page, which was the send button, then I hit a key,
> and it sent the message bef
Yeah - I pressed tab to indent my code, and of course it tabbed to the
next element on the page, which was the send button, then I hit a key,
and it sent the message before I was ready. I tested my hypothesis,
but it was wrong. I haven't quite figured it out yet. Something to
do with casting a c
OK. The first level explanation is that my default config is "simple".
This explains the different query results as "english" reduces "database" to
"databas" while "simple does not reduce it at all.
The "document" is parsed/indexed using "english" explicitly so my queries nedd
to be explicit als
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Thu, 21 Feb 2008 17:53:35 -0500
"Alex Turner" <[EMAIL PROTECTED]> wrote:
> Upgrading to Postgres 8.3 broke virtually every site we host, and I
> finally figured out why. In 8.2 you could do this:
>
> create table foo (
No that would fail.
Did y
Upgrading to Postgres 8.3 broke virtually every site we host, and I
finally figured out why. In 8.2 you could do this:
create table foo (
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Thanks for the response. I checked the event viewer. The main error it reports
is:
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7005
Date:2/21/2008
Time:3:20:25 PM
User:N/A
Computer:DEV
Description:
The LoadUserPro
On Thu, Feb 21, 2008 at 04:35:28PM -0500, Geoffrey wrote:
> How might we find out which release it was fixed in? Back patching
> 7.4.19 with the fix might be easier then trying to move up to the fixed
> version.
According to HISTORY, there was a significant fix in this area in 8.1:
* Add "
need to write a query for sales order table where we get the qty order *
price for all line items by week then average then create a moving
Average past 10 weeks of entered sales orders line items.
So what will happen is some one will enter a date range going back 6
month from the present dat
Tom Lane wrote:
Andrew Sullivan <[EMAIL PROTECTED]> writes:
On Thu, Feb 21, 2008 at 11:44:25AM -0500, Terry Lee Tucker wrote:
table where, when the given trigger does fire, it checks for an entry in the
table at the top of the trigger and takes the appropiate action. The problem
is that the sol
I did not follow the past threads, but have you looked at what the event
viewer has to report?
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dee
Sent: Thursday, February 21, 2008 8:36 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Install problem w/8.3 on w
> Hmm, it certainly should be there somewhere, but the path might be
> either of these:
>.../lib/pgxs/src/makefiles/pgxs.mk
>.../lib/postgresql/pgxs/src/makefiles/pgxs.mk
> depending on exactly how the build was done. If it's not there at
> all this is an installer bug.
>
>
Anyone have any suggestions?
I have tried different versions and everything I can think of but have run out
of ideas. It is frustrating. I really would like to use postgresql.. if I
could only get it to install! ;-)
Dee <[EMAIL PROTECTED]> wrote:
I am trying to install version 8.3.0.1 on an
On Thu, 2008-02-21 at 12:01 -0500, Tom Lane wrote:
> Pascal Cohen <[EMAIL PROTECTED]> writes:
> > The fact is that works on Linux and win but under Mac I always get the
> > ordering with 'default' C locale (I displayed all the lc_* and all are
> > right set)
>
> Yeah, this has been complained of
"A.M." <[EMAIL PROTECTED]> writes:
> On Feb 21, 2008, at 12:01 PM, Tom Lane wrote:
>> It seems to be a deficiency in Apple's locale support. The second
>> message is interesting since it indicates that "smart" sorting is
>> available somewhere/somehow under OS X, but nobody here knows how
>> to ge
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> My questions is this: how would I go about changing my function so
> that all the triggers EXCEPT the Slony trigger would be disabled?
> Any ideas?
..
> PostgreSQL 7.4.19 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
This won't he
On Thursday 21 February 2008 13:05, Andrew Sullivan wrote:
>
>
> > Unless I get a better idea, I'm going to change the disable_triggers
> > function to duplicate all the records in pg_trigger belonging to a given
> > table, delete the records except for the Slony trigger, update pg_class
> > settin
I found the RPMs for postgresql8.3 suse here
http://software.opensuse.org/search
just type postgresql and choose your O.S
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
(After dealing a while with this, and learning a little, I though of
post this as comment in the docs, but perhaps someone who knows better
can correct or clarify)
=
The issues of charset encodings
On Feb 21, 2008, at 12:01 PM, Tom Lane wrote:
Pascal Cohen <[EMAIL PROTECTED]> writes:
The fact is that works on Linux and win but under Mac I always get
the
ordering with 'default' C locale (I displayed all the lc_* and all
are
right set)
Yeah, this has been complained of before, eg her
On Thursday 21 February 2008 12:56, Scott Marlowe wrote:
> On Thu, Feb 21, 2008 at 9:20 AM, Terry Lee Tucker <[EMAIL PROTECTED]>
wrote:
> > Greetings:
> >
> > We have been working diligently toward integrating Slony into our
> > production databases. We've been having trouble with various tables,
On Thu, Feb 21, 2008 at 01:03:13PM -0500, Tom Lane wrote:
> to disable just some triggers. I think the bug you are remembering is
> that there's always been a pg_trigger.tgenabled field, but it wasn't
> always honored everywhere,
You're quite right. My apologies. (Especially since I've now repe
On Thu, Feb 21, 2008 at 12:49:48PM -0500, Terry Lee Tucker wrote:
>
> Thanks for the input. I've been using the reltriggers in pg_class for a long
> time and it does work; however, I did notice in the documentation on
> pg_trigger that tgenabled is not checked properly and using that will give
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Thu, Feb 21, 2008 at 11:44:25AM -0500, Terry Lee Tucker wrote:
>> table where, when the given trigger does fire, it checks for an entry in the
>> table at the top of the trigger and takes the appropiate action. The problem
>> is that the solution for
On Thu, Feb 21, 2008 at 9:20 AM, Terry Lee Tucker <[EMAIL PROTECTED]> wrote:
> Greetings:
>
> We have been working diligently toward integrating Slony into our production
> databases. We've been having trouble with various tables, although being
> replicated perfectly in the initial replication
On Thursday 21 February 2008 12:20, Andrew Sullivan wrote:
>
> Well, you could try rewriting the function to disable all but the Slony
> trigger. But there's something else wrong here.
>
> I seem to recall that we found some code path where reltriggers wasn't
> checked properly anyway, so disablin
On Thu, Feb 21, 2008 at 11:44:25AM -0500, Terry Lee Tucker wrote:
> table where, when the given trigger does fire, it checks for an entry in the
> table at the top of the trigger and takes the appropiate action. The problem
> is that the solution for disabling all triggers is used in several uti
Mike Leahy <[EMAIL PROTECTED]> writes:
> I'm trying to build the PL/R module on Win32 with PostgreSQL 8.3. I've
> done this before with no trouble using several 8.2.x versions of
> PostgreSQL (from the win32 installer). However, now that I'm trying to
> update things for 8.3, it seems that the
Pascal Cohen <[EMAIL PROTECTED]> writes:
> The fact is that works on Linux and win but under Mac I always get the
> ordering with 'default' C locale (I displayed all the lc_* and all are
> right set)
Yeah, this has been complained of before, eg here
http://archives.postgresql.org/pgsql-general/2
On Thursday 21 February 2008 11:26, A.M. wrote:
> On Feb 21, 2008, at 10:20 AM, Terry Lee Tucker wrote:
> > Greetings:
> >
> > We have been working diligently toward integrating Slony into our
> > production
> > databases. We've been having trouble with various tables, although
> > being
> > replic
On Feb 21, 2008, at 10:20 AM, Terry Lee Tucker wrote:
Greetings:
We have been working diligently toward integrating Slony into our
production
databases. We've been having trouble with various tables, although
being
replicated perfectly in the initial replication stage, afterwards,
gettin
Greetings:
We have been working diligently toward integrating Slony into our production
databases. We've been having trouble with various tables, although being
replicated perfectly in the initial replication stage, afterwards, getting
out of sync.
I have finally figured out what the problem i
Greetings:
We have been working diligently toward integrating Slony into our production
databases. We've been having trouble with various tables, although being
replicated perfectly in the initial replication stage, afterwards, getting
out of sync.
I have finally figured out what the problem i
On Feb 20, 2008, at 2:12 PM, Douglas McNaught wrote:
Alternatively, is there a better way to streamline the duplication
of a
database?
How about:
CREATE DATABASE newdb TEMPLATE olddb;
The template DB has to have no open connections during the entire copy
process, so it is not always
am Thu, dem 21.02.2008, um 12:42:51 + mailte Howard Wilkinson folgendes:
> SO I can do something like this?
>
> select character_maximum_length from information_schema.columns where
> table_name='rr' and column_name='data';
>
> Yes?
Yes.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 0
http://www.email.it/f
Sponsor:
Polizze per vacanze e settimane bianche. Acquista online!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7598&d=20080221
On Thursday 21 February 2008 00:17:56 Chris wrote:
> pc wrote:
> > My php code is creating temporary table named mytemp,but when I run a
> > selec * from mytemp I cannot see the table.How can I see the table
> > from postgresql command prompt?
>
> temp tables are automatically deleted when the conn
Richard Huxton wrote:
Howard Wilkinson wrote:
I am working on some upgrades to the MyDNS open source product. I
have some expertise in MySQL but am not overly familiar with
PostgreSQL and need some guidance on how to query the schema for the
maximum size of data a column can hold.
Unless you
Stephen Davies wrote:
I just spotted the difference between your test and mine.
My query says:
select ts_headline(abstract,to_tsquery('english','database'),'minWords = 99,
maxWords = 999') from document where id=21;
where your equivalent does not include the 'english' arg.
If I take out the
I just spotted the difference between your test and mine.
My query says:
select ts_headline(abstract,to_tsquery('english','database'),'minWords = 99,
maxWords = 999') from document where id=21;
where your equivalent does not include the 'english' arg.
If I take out the 'english' from this quer
Stephen Davies wrote:
Interesting. I hadn't seen that section before.
As I said in my original post: "Is this a bug or am I missing some
configuration option".
I shall investigate the stuff in 12.8.
Any suggestions as to where to start?
Well, no-one has been using 8.3 for more than a few we
am Thu, dem 21.02.2008, um 10:44:32 + mailte Howard Wilkinson folgendes:
> I am working on some upgrades to the MyDNS open source product. I have
> some expertise in MySQL but am not overly familiar with PostgreSQL and
> need some guidance on how to query the schema for the maximum size of
Interesting. I hadn't seen that section before.
As I said in my original post: "Is this a bug or am I missing some
configuration option".
I shall investigate the stuff in 12.8.
Any suggestions as to where to start?
Thanks,
Stephen Davies
On Thursday 21 February 2008 20:50, Richard Huxton wrot
Howard Wilkinson wrote:
I am working on some upgrades to the MyDNS open source product. I have
some expertise in MySQL but am not overly familiar with PostgreSQL and
need some guidance on how to query the schema for the maximum size of
data a column can hold.
Unless you're after PG-specific s
I am working on some upgrades to the MyDNS open source product. I have
some expertise in MySQL but am not overly familiar with PostgreSQL and
need some guidance on how to query the schema for the maximum size of
data a column can hold.
In MySQL I can do either: a "DESCRIBE" command or do "SELE
Stephen Davies wrote:
Attached is the "document" in question.
Searches for "norwegian", "thesaurus" and "statement" give good results. A
search for "database" gives the plain text from the beginning.
Seems OK here - might need to look at your configuration settings.
http://www.postgresql.org/
On Feb 20, 4:03 am, [EMAIL PROTECTED] (hewei) wrote:
> table:
> CREATE TABLE price (
> TIMESTAMP Timestamp NULL,
> idnumeric(5,0) NOT NULL,
> price numeric(10,3) NULL,
> primary key (id)
> );
> sql:
> update price set price=* where id=*;
>
> On Feb 20, 2008 11:56 AM, We
Hello.
I'd like to use ORDER BY in any specified order and LIMIT, OFFSET for paging
query results.
The query is FULL OUTER JOIN of two tables by field id. I think the results of
Merge Full Join
to be ordered by some "combined id". And there is no need in extra Sort if I
specify ORDER BY
that "c
Hello list,
I'm trying to build the PL/R module on Win32 with PostgreSQL 8.3. I've
done this before with no trouble using several 8.2.x versions of
PostgreSQL (from the win32 installer). However, now that I'm trying to
update things for 8.3, it seems that the pgxs.mk file needed by the PL/R
Hi,
I am indexing a 100 million record table composed of varchar(255) as the
field to be indexed. I have always seen that examples of pg_trgm are
based on text type fields. Is this by any special reason?.
My computer is creating the index since 5 hours ago so I guess there
must be something
Attached is the "document" in question.
Searches for "norwegian", "thesaurus" and "statement" give good results. A
search for "database" gives the plain text from the beginning.
Cheers and thanks,
Stephen Davies
On Thursday 21 February 2008 20:08, Richard Huxton wrote:
> Stephen Davies wrote:
>
Stephen Davies wrote:
G'day Richard.
I don't think so. A sample command is:
ts_headline(abstract,to_tsquery('english','database'),'minWords = 99, maxWords
= 999')
I have also tried with smaller maxwords without any visible effect.
Hmm - a simple test seems to work OK.
SELECT ts_headline(
G'day Richard.
I don't think so. A sample command is:
ts_headline(abstract,to_tsquery('english','database'),'minWords = 99, maxWords
= 999')
I have also tried with smaller maxwords without any visible effect.
Cheers,
Stephen
On Thursday 21 February 2008 19:19, Richard Huxton wrote:
> Stephen
Hi,Scott Marlowe:
Following your said:
1.Can i update the postgres's update stragety to that :when update one row
,then load all table rows to memory?
2.If do that, then mean random update 's cost(time) =order update?
On Thu, Feb 21, 2008 at 3:23 PM, Scott Marlowe <[EMAIL PROTECTED]>
wrote:
Stephen Davies wrote:
I am a bit puzzled by the output of ts_headline (V8.3) for different queries.
It seems that the difference is in the number of occurrences of the criterion
words. If the number of hits is less than some number, the ts_headline result
is "correct" but if the number of hit
Hello
Are there users of PL/Java ?
I would like to get some feedback on using it.
As we could use triggers and as we have already some kinds of
'applicative' triggers written in Java, I was wondering if I could just
reuse the code and plug it
Thanks for any advice
---(
Hello
We are using different OS (Mac, win (with a small w!) and Linux).
We had some problems when doing some ordering on names.
I found that it seemed to be related on locale, While on Linux it used
default locales (en_US.UTF-8 or something like that), I had a nice
behavior).
I learned to check
70 matches
Mail list logo
