Hi,
With postgresql 9.1, the last two entries of unaccent.rules are
ё е
Ё Е
0xd191 = 0xd0b5
0xd081 = 0xd095
Shouldn't these be translated into 0x45 and 0x65 instead?
--
Eld på åren og sol på eng gjer mannen fegen og fjåg. [Jøtul]
demo 2011 Tore Halvorsen || +052 0553034554
Hi there,
this is my first post to this list..
I have been a casual user of postgres for the past 2-3 years but was never
involved in installation and such.
Now I must help the migration of a 8.3 system to 9.1.
The problem we face is that the actual system is using tsearch-2 which was
tsearch2 support is included in the 9.1 distribution. No need for any
additional packages.
However, if you need to use the old functions, then you will have to install
the
Backwards-compatibility package for old contrib/tsearch2 API
in path_to_your_source/contrib/tsearch2/
gmake
gmake install
Achilleas Mantzios ach...@matrix.gatewaynet.com writes:
tsearch2 support is included in the 9.1 distribution. No need for any
additional packages.
However, if you need to use the old functions, then you will have to install
the
Backwards-compatibility package for old contrib/tsearch2 API
Στις Wednesday 19 October 2011 16:46:55 ο/η Tom Lane έγραψε:
Achilleas Mantzios ach...@matrix.gatewaynet.com writes:
tsearch2 support is included in the 9.1 distribution. No need for any
additional packages.
However, if you need to use the old functions, then you will have to
install
Hi,
Is a way to define DEFAULT, NOT NULL and REFERENCES for members of composite
type?
For example:
-- type
CREATE TYPE bibl.bibliography AS
(
edition TEXT,
publisher_id BIGINT
);
-- table def
create table bibl.monograph
(
id BIGSERIAL PRIMARY
Hi,
I have installed psqlODBC and I can see the dll files in the bin folder. But
what shall I do next to connect My ASP page? Please help.
Thanks,
Mamatha
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of erhaminus
Sent: Wednesday, October 19, 2011 10:33 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Composite type, DEFAULT, NOT NULL, REFERENCES
Hi,
Is a way to
On Wed, Oct 19, 2011 at 9:32 AM, erhaminus erhami...@o2.pl wrote:
Hi,
Is a way to define DEFAULT, NOT NULL and REFERENCES for members of composite
type?
For example:
-- type
CREATE TYPE bibl.bibliography AS
(
edition TEXT,
publisher_id BIGINT
);
-- table def
create
Greetings,
I have to write a query on a fairly large table of data (100 million rows)
where I need to check to see if a date (epoch) falls between a range of
values. The catch is that the range is defined only by month and day values.
For example the record containing the epoch value will be
On 18 Oct 2011, at 20:17, Tom Lane wrote:
=?ISO-8859-1?Q?Fr=E9d=E9ric_Rejol?= frederic.re...@sescoi.fr writes:
I created a custom CAST to cast from one table type to another.
pg_dump does not include my custom CAST.
Hmm. The reason for that is that the table types aren't considered
Greg Jaskiewicz gryz...@gmail.com writes:
On 18 Oct 2011, at 20:17, Tom Lane wrote:
Hmm. The reason for that is that the table types aren't considered
dumpable objects. I suppose we need to fix that, but in the meantime
you'd have better luck if you created the types as composite types
On 19/10/2011 07:26, mamatha_kagathi_c...@dell.com wrote:
Hi,
I have installed psqlODBC and I can see the dll files in the bin
folder. But what shall I do next to connect My ASP page? Please help.
I moved away from ASP a long time ago, so memory is rusty, but here goes:
(i) Go to the
Em 19-10-2011 15:08, Raymond O'Donnell escreveu:
On 19/10/2011 07:26, mamatha_kagathi_c...@dell.com wrote:
Hi,
I have installed psqlODBC and I can see the dll files in the bin
folder. But what shall I do next to connect My ASP page? Please help.
On 19/10/2011 18:15, Edson Richter wrote:
Em 19-10-2011 15:08, Raymond O'Donnell escreveu:
On 19/10/2011 07:26, mamatha_kagathi_c...@dell.com wrote:
Hi,
I have installed psqlODBC and I can see the dll files in the bin
folder. But what shall I do next to connect My ASP page? Please help.
On 10/19/11 4:57 AM, senthilnathan wrote:
How to recover a standalone postgres setup using archive files alone? What
are the steps/config involved?
'archive files' ? you mean a WAL archive? you need the base backup
*and* all WAL files since to recover with that.
--
john r pierce
I have some scripts that upload some images to the DB, specifically to
a bytea column. For that I use PHPs (all scripts are in PHP)
pg_escape_bytea (and pg_unescape_bytea after extraction) before
inserting. Images go good in the DB and are shown correctly after
extraction, so it looks like there
Is it possible to do a full file system level backup of the data
directory, say once a week, and differentials or incrementals daily?
I'd love to be able to do this, but you can't do it usefully at a
file-system level. There's too much churn in the data files for even a
binary diff to be
I can not find a way to log ALL output from a psql session when running a
script. Basically, I'm running a large deployment script that has thousands of
SQL statements and I need to know which statements fail. I want the output
generated when running the script to be saved to a log file so
On 19/10/2011 22:10, Bobby Dewitt wrote:
I can not find a way to log ALL output from a psql session when running
a script. Basically, I'm running a large deployment script that has
thousands of SQL statements and I need to know which statements fail. I
want the output generated when running
On Wed, Oct 19, 2011 at 12:40 PM, Jeff Adams jeff.ad...@noaa.gov wrote:
Greetings,
I have to write a query on a fairly large table of data (100 million rows)
where I need to check to see if a date (epoch) falls between a range of
values. The catch is that the range is defined only by month
I am writing a function that is called by a trigger after insert and update but
it is not returning all the rows I want it to with a SELECT.
This trigger is called within a transaction and looks for a row inserted
previously within the same transaction - it works when the trigger is called
On Oct 19, 2011, at 19:17, Jake Stride j...@stride.me.uk wrote:
I am writing a function that is called by a trigger after insert and update
but it is not returning all the rows I want it to with a SELECT.
This trigger is called within a transaction and looks for a row inserted
previously
How about storing the transaction ID of the inserting/updating transaction in a
column of your table? You could query that against the current transaction ID
in your trigger function. See txid_current() in the docs
(http://www.postgresql.org/docs/9.1/interactive/functions-info.html)
From:
On Wed, 2011-10-19 at 14:30 -0300, Martín Marqués wrote:
The only concern I have is that on insertion, I get this WARNING:
WARNING: nonstandard use of \\ in a string literal at character 41
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
Should I worry? What does it
On Wed, 2011-10-05 at 15:35 +0200, thomas veymont wrote:
hello,
let's say that each rows in a table contains a start time and a end
time (timeinterval type),
but the index are not ordered nor consecutive, e.g :
I think your question has already been answered, but I thought you might
be
On 10/19/2011 01:52 PM, Wendi Adrian wrote:
I installed Windows 7 Professional on my workstation which connect with
office network.
OK, it's on the network, that's fine. What I need to know is whether
it's part of a Windows domain, or whether it's running in standalone
workstation mode.
On 10/20/2011 02:00 AM, Bob Hatfield wrote:
Is it possible to do a full file system level backup of the data
directory, say once a week, and differentials or incrementals daily?
I'd love to be able to do this, but you can't do it usefully at a
file-system level. There's too much churn in the
Hi Ray,
Thanks for the help. Since I am using classic ASP this is exactly what I am
looking for. But there is a problem here. When I go the Create New Data
Source window as mentioned in step ii, Ifind only sql server and Oracle
drivers. I do not see PostgreSQL ODBC driver. But I am sure
Thanks John.,
Yes its from WAL Archives. I dont have the basebackup instead i am having
all the WAL files that are archived right from the server start. My question
is how(steps?) to to build whole setup(postgres server)by replaying all WAL
files
(from
30 matches
Mail list logo
