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]
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
allready
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 /contrib/tsearch2/
gmake
gmake install
then
psql -f /cont
Achilleas Mantzios 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"
> in /contrib/tsearch2/
Στις Wednesday 19 October 2011 16:46:55 ο/η Tom Lane έγραψε:
> Achilleas Mantzios 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-co
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 KEY
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 def
On Wed, Oct 19, 2011 at 9:32 AM, erhaminus 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 link
On 18 Oct 2011, at 20:17, Tom Lane wrote:
> =?ISO-8859-1?Q?Fr=E9d=E9ric_Rejol?= 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
> dumpable objects. I s
Greg Jaskiewicz 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
>> instead of im
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
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 AS
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
>> 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
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 tha
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 runni
On Wed, Oct 19, 2011 at 12:40 PM, Jeff Adams 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 and day
> value
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
via
On Oct 19, 2011, at 19:17, Jake Stride 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 within the sa
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: pgsq
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
b
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.
Thi
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 da
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 PsqlO
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 000100010
30 matches
Mail list logo
