On 04.07.2007 11:20, Joshua N Pritikin wrote:
Sometime in the future, I anticipate storing other languages in addition
to English in my database to be indexed with tsearch2. set_curcfg()
seems to be per-session. Will I need to call set_curcfg() every time I
switch languages?
You *should* crea
On 7/5/07, Andreas 'ads' Scherbaum <[EMAIL PROTECTED]> wrote:
Hello,
On Wed, 4 Jul 2007 18:04:35 -0400 Alvaro Herrera wrote:
> Most likely it is worried about XID wraparound, and those are precisely
> the tables that need urgent vacuumed because they haven't been vacuumed
> in a long time.
N
I am doing a project using Ruby On Rails with PostgreSQL as the
database. I have not seen the term polymorphic used with databases
except with Rails so I will quickly describe it.
Instead of holding just an id as a foreign key, the record holds a
"type" field which is a string and an id.
Tom Lane wrote:
Chris Travers <[EMAIL PROTECTED]> writes:
Is there a way to accept localized numbers as input?
i.e. '1,39'::numeric?
See to_number().
Thanks! I somehow missed that function in the docs.
Best Wishes,
Chris Travers
---(end of broadcast)
Chris Travers <[EMAIL PROTECTED]> writes:
> Is there a way to accept localized numbers as input?
> i.e. '1,39'::numeric?
See to_number().
regards, tom lane
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> I think display depends on whether or not you configured Postgres
> with or without --enable-nls.
No, to_char understands numeric locales regardless of enable-nls.
There is no provision for locale-dependent output from a plain
numeric column; you
Michael Fuhr wrote:
I think you'll need to use to_char():
test=> set lc_numeric to 'es_ES.UTF-8';
SET
test=> select to_char(1.234, '9D999');
to_char
-
1,234
(1 row)
The file src/backend/utils/adt/pg_locale.c in the PostgreSQL source
code has comments about how various LC_* sett
On Jul 5, 2007, at 19:47 , Michael Glaesemann wrote:
I don't believe you'll see numbers *as numbers* displayed with the
formatting you desire unless you somehow tell your client (e.g.,
psql) which locale you want to use. I haven't figured out how to do
this yet, though.
I think display d
On Thu, Jul 05, 2007 at 05:10:57PM -0700, Chris Travers wrote:
> I am trying to find a way to select the number format at runtime for
> textual representation of numbers. I am currently running 8.1.4 built
> from source on Fedora Linux core 5.
>
> I have been trying to use set lc_numeric = vari
On Jul 5, 2007, at 19:10 , Chris Travers wrote:
I have been trying to use set lc_numeric = various country codes
(for example es_EC), but I am not able to get the format to change
from 1.00 to 1,00.
Any hints as to what I could be doing wrong?
Does this correspond to what you're seeing?
Hi all;
I am trying to find a way to select the number format at runtime for
textual representation of numbers. I am currently running 8.1.4 built
from source on Fedora Linux core 5.
I have been trying to use set lc_numeric = various country codes (for
example es_EC), but I am not able to g
John DeSoi wrote:
>
> On Jul 5, 2007, at 1:34 PM, Nykolyn, Andrew wrote:
>
> >Is it possible to nest transactions within a stored procedure? I
> >have a stored procedure that calls many other stored procedures and
> >what happens it that after a certain amount of time the server runs
> >ou
On Jul 5, 2007, at 1:34 PM, Nykolyn, Andrew wrote:
Is it possible to nest transactions within a stored procedure? I
have a stored procedure that calls many other stored procedures and
what happens it that after a certain amount of time the server runs
out of shared memory. I know I can i
Why not have a table type that writes no WAL and is truncated whenever
postgres starts? Such a table could then be put in a ramdisk tablespace
and there would be no transaction atomicity repercussions. Is there
something I'm missing?
Is this not in the TODO (if not already schedul
On Thu, Jul 05, 2007 at 01:39:31PM -0400, Kenji Morishige wrote:
> I would like to create a query that returns a column with an integer
> 1 through (row_count) to use as the index while used in conjunction with
> DBI's selectall_hashref($sql,$key) function. In the past I'd usually just
> write a w
Original Message
Subject: [GENERAL] Working with dates
From: Ranieri Mazili <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org, [EMAIL PROTECTED]
Date: 5/7/2007 16:00
Hello,
I need to do the following select:
Number of days of month - weekends - holydays
So this query will
Hello,
I need to do the following select:
Number of days of month - weekends - holydays
So this query will return the number of days that people can work
Look that I have the holydays in one table, it's bellow:
CREATE TABLE holidays
(
id_holidays serial NOT NULL,
dt_holiday date,
holiday_d
Jeff Amiel <[EMAIL PROTECTED]> writes:
> Is there some magic way of determining the number of bytes in an index
> 'row' and then comparing the size on disk of the index file?
In recent releases contrib/pgstattuple/ has a function for obtaining
stats about an index.
regard
A.M. wrote:
On Jul 5, 2007, at 13:20 , Andrew Sullivan wrote:
On Sun, Jul 01, 2007 at 11:11:30PM +0200, Alexander Todorov wrote:
The question was is there something else that exists in PostgreSQL and
will do the same job.
Why not have a table type that writes no WAL and is truncated wheneve
Is it possible to nest transactions within a stored procedure? I have a
stored procedure that calls many other stored procedures and what
happens it that after a certain amount of time the server runs out of
shared memory. I know I can increase the PostgreSQL shared memory.
However, that would be
I would like to create a query that returns a column with an integer
1 through (row_count) to use as the index while used in conjunction with
DBI's selectall_hashref($sql,$key) function. In the past I'd usually just
write a wrapper around selectrow_hashref and put all those results in an
array. I
On Jul 5, 2007, at 13:20 , Andrew Sullivan wrote:
On Sun, Jul 01, 2007 at 11:11:30PM +0200, Alexander Todorov wrote:
The question was is there something else that exists in PostgreSQL
and
will do the same job.
Why re-invent the wheel, and make it square? But also, if you don't
care whethe
Got a bit of a rude surprise when I rebuilt a slony subscriber node from
scratch and noticed the indexes for some tables using significantly less
space than on their master-node counterpart.
In once case, it was 2 gigabytes versus 9 gigabytes for the same table
indexs on the master node. I'm as
On Sun, Jul 01, 2007 at 11:11:30PM +0200, Alexander Todorov wrote:
> The question was is there something else that exists in PostgreSQL and
> will do the same job.
Why re-invent the wheel, and make it square? But also, if you don't
care whether you keep your data, why on earth are you putting it
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Gabriele
> Sent: Tuesday, July 03, 2007 2:43 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Design Tool
>
> I need a design tool to design my database.
>
> Back in past I use
You are right. I have now corrected that and
I believe that should fix the problem.
>
>AFAICS it would not be issuing that unless you'd made template0
>connectable on t
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
[EMAIL PROTECTED] writes:
> time? Why won't pg_dump include a line to accept connection for
> template0 just before it writes "\connect template0" and then remove
> the permission after it is done with template0?
AFAICS it would not be issuing that unless you'd made template0
connectable on the s
On Thu, Jul 05, 2007 at 01:17:13PM +0100, E.J. Moloney wrote:
> I have a database with a table that adds 3 records a day, I am
> delete records older than 2 days.
> I am vacuuming it once a day , I am having an issue that the disk usage
> is continually rising. i.e. the space been flagged as
> OK. If you're not in a hurry, and can wait a few months 8.3 will be out.
I am moving the database to a new physical server and it makes sense to move to
the latest version now.
>>for template0 all the
>> time? Why won't pg_dump include a line to accept connection for
>> template0 just before
On Thu, Jul 05, 2007 at 02:11:24PM +0200, Artur Rataj wrote:
> But I want the server to use the C locale. I set the locale to C and
> run postmaster. I supposed it uses C locale, but -d 5 shows in log:
The locale is decided when you run initdb. Once the cluster has been
created you can't change it
On 7/5/07, Artur Rataj <[EMAIL PROTECTED]> wrote:
But I want the server to use the C locale. I set the locale to C and
run postmaster. I supposed it uses C locale, but -d 5 shows in log:
The locale for indexing is set during initdb:
initdb --no-locale
The ~ operator does consider using btree r
I have a database with a table that adds 3 records a day, I am
delete records older than 2 days.
I am vacuuming it once a day , I am having an issue that the disk usage
is continually rising. i.e. the space been flagged as free by the vacuum
process isn't being reused.
Please find below a
But I want the server to use the C locale. I set the locale to C and
run postmaster. I supposed it uses C locale, but -d 5 shows in log:
DEBUG: /usr/bin/postmaster: PostmasterMain: initial environ dump:
.
.
.
DEBUG: LC_COLLATE=pl_PL.UTF-8
DEBUG: LC_CTYPE=pl_PL.UTF-8
DEBUG:
Hi,
Le jeudi 05 juillet 2007, Artur Rataj a écrit :
> Hello, I want to have pg use fast indexing for ~ operator. Is setting
> C locale for this is still necessary? If yes, is it enough to
> initdb/createdb with C locale? If it is not enough, why setting locale
> to C and starting postmaster still
Hello, I want to have pg use fast indexing for ~ operator. Is setting
C locale for this is still necessary? If yes, is it enough to
initdb/createdb with C locale? If it is not enough, why setting locale
to C and starting postmaster still gives other locale, for example,
pl_PL, in
postmaster log "i
I would use Java and possibly OLEDB/ADO/ADO.Net form the public side as the
consumers of this info will want it nice and easy and I dont want to spend
hours developing a bespoke interface but put the onus on the consumers of
the service to get what they need.
Thanks for your comments, much apprec
Patrick Carroll wrote:
There has got to be some persistence, there will be a lot of tables and
metadata and it may have to handle validation requirements for other apps
doing secure file transfer and a bespoke secure http proxy and it's
going to
be a speculative buffer against protocol based wo
There has got to be some persistence, there will be a lot of tables and
metadata and it may have to handle validation requirements for other apps
doing secure file transfer and a bespoke secure http proxy and it's going to
be a speculative buffer against protocol based worms crossing into the
prod
Patrick Carroll wrote:
I am architecting a solution for an interface between a highly secure
production environment and a corporate network which involves transfer of
records from Oracle and SQL Server through an intermediary "firewall DB", a
Postgres Instance, to SQL Server/ Oracle. I anticipate
[EMAIL PROTECTED] wrote:
Dear List,
As many of you know every time one wants to upgrade to a major server
version, as I want to do now, there is a need for pg_dumpall and
restore. This is a huge undertaking and requires lots of testing and
planning. I do hope that in the future this requiremen
On 04.07.2007 17:14, Andrus wrote:
How to backup whole cluster so that huge temprary file containing all
data in uncompressed form is not created in Windows temporary directory
( equivalent to pg_dumpall -c | gzip >backup in Linux ) ?
Pipe in windows creates huge temprary file.
pg_dumpall ha
41 matches
Mail list logo