how can I set the client_encoding to what I need?
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the m
Hello dear postgres community, I'm having a bad time with an issue
that I haven't been able to solve with my database, the problem is
this:
Whenever I try to save a word containing "special" characters in it
(for example áéíóú) I get the following django error:
"invalid byte sequence for encoding "
ch better. I believe that 'rich text' is essentially HTML,
although I might be mistaken. I know that 'GMail' users have that
problem all the time. Of course 'GMail' users have lots of other
problems also.
--
Gerard
Having a wonderful wine, wish you were beer.
signature.asc
Description: PGP signature
gt; Can you give some examples of this? It's not that I don't believe
> you, I'd just like some concrete examples from someone in your
> situation.
Erik, would it be possible for you to post in 'plain text' and not HTML?
This is a mail forum, not a web page.
Thanks!
--
Gerard
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
, although not always, not happen
when I next boot the system.
Any ideas on how to correct this problem would be welcomed.
--
Gerard
A man is known by the company he organizes.
A. Bierce
signature.asc
Description: PGP signature
g the array of double to
text ?
Pailloncy Jean-Gerard
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Le 11 sept. 06 à 05:57, Michael Fuhr a écrit :On Sun, Sep 10, 2006 at 09:39:59PM -0600, Michael Fuhr wrote: On Mon, Sep 11, 2006 at 02:32:26AM +0200, Jean-Gerard Pailloncy wrote: 1) Is it possible to use the SSL authentification done by apache with PostgreSQL ? I'm not aware of a way for A
/password.I plan to add the same SSL setup to PostreSQL.1) Is it possible to use the SSL authentification done by apache with PostgreSQL ?2) How the DN of the certificate is match against an PostgreSQL role ?Any help is welcomed.Pailloncy Jean-Gerard
smime.p7s
Description: S/MIME cryptographic
Hi,
I wonder how to have a sort of "uniq" index on date interval, such
that there is no date interval overlaping in the table.
exemple:
create table test (start timestamp, end timestamp);
with the constraint: end > start
Cordialement,
Jean-Gérard Pailloncy
---(end o
Can I be removed from this mailing list.
Thanks
Gerard
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marc G.
Fournier
Sent: 31 October 2005 04:48
To: pgsql-announce@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: [ANNOUNCE] PostgreSQL 8.1.0
Hi,
With PostgreSQL 7.4.6.
I have a table aaa (id serial, maj timestamp without time zone)
I defined to function from_timestamp and to_timestamp to do
conversion between text and timestamp with few checks and tricks.
I defined a view aab (id serial, maj text) as "SELECT id,
from_timestamp(
Hi,
I have a drive with a bad zone inside the file pgsql/pg_xlog/
005D00A1.
After trying to start few time pg, I get the follwing message in log:
2005-06-14 23:35:44 LOG: database system shutdown was interrupted at
2005-06-14 12:20:42 CEST
2005-06-14 23:35:44 LOG: checkpoint recor
You do realize that any multimaster replication system, that is
designed to avoind complex business process structure based conflict
resolution mechanisms, necessarily has to be based on 2 phase commit
or similar? So your global write transaction throughput will be
limited by the latency of you
De: [EMAIL PROTECTED]
Objet: Rép : [GENERAL] Extended unit
Date: 28 janvier 2005 18:18:18 GMT+01:00
À:[EMAIL PROTECTED]
I have done a new version with
- a new conversion function
- possibility to enter value as fraction
- addition of the operator + -
Hi,
Some word from my test work.
I try first to just have a parser that can manage a string of unit.
like 'm s-1 kg2.5 A3.5/7.2'
The parser accept :
- any letters for the unit
- a + or - or nothing before the power
- a fractional power
- the unit separator is space ;-/
The system normalize the frac
ision range you need), but does not allow
to be added with anything else than "amper". Any other interaction
with
other units (read data types) would be achieved by defining the needed
operators on the respective data types (read units).
You'd have to create a postgres datatype for every variatio
If you allow multiplication and division, you'd need to store not
only one type, but an expression like m.s^-2, etc. You'll end up with
something with Maple. Isn't there some free open source algebraic
computation toolkit with equations and units somewhere ?
Yes and no.
I am in the (slow) proce
It strikes me that the right level of constraint is the quantity being
represented: length / mass / time / velocity.
Then you could store any of: '1inch', '2m', '3km', '4light-years' in a
"length" column.
Ofcourse, only one of those is in SI units :) Just like the interval
type, all this could be h
... none of which require any extensions to the core type system.
AFAICS this could easily be implemented as a user-defined type, along
the lines of
CREATE TYPE measurement AS (value double, units text);
and if you want to constrain a particular column to contain only one
value of units, us
Is CREATE TYPE what you're looking for?
http://www.postgresql.org/docs/8.0/static/sql-createtype.html
No. I'll try to give an exemple of what I want:
I suppose I have the following table
CREATE TABLE experiment (
distanceDOUBLE,
timeDOUBLE,
speed DOUBLE
)
Hi,
My question is purely theoretical.
I add use in my time in University some software that use "extended
type".
For each variable, we define the mandatory "classic type" as integer,
float, double array of.
And we define an optional "extended type" as the unit in the MKSA
system (Meter, Kilogra
possible to create a "connection pool" sort of have an array
of connections go pgsql, and mark one of them as "in use" right before
you fork?
You may have to stick the "in use" marks in shared memory, so that after
the fork-ed process is done with the pgsql connection
22 matches
Mail list logo
