On 24/05/11 14:30, jasmin.dizdare...@gmail.com wrote:
> We had trbls with our drupal site, because some settings are stored in bytea
> columns. I think lobs are a problem too, but pls see the pg_dump docs for
> details.
Is it possible that you are referring to the `bytea_output' setting in
Postg
On Monday, May 23, 2011 9:53:47 am Dean le Roux wrote:
> postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new
> install)
Did the OO version change also?
>
> I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and other
> updates have been effected. I used webmin to rest
On 24/05/2011 6:39 AM, Tarlika Elisabeth Schmitz wrote:
Indeed. However, the situation is not quite as bleak as it appears:
- I am only dealing with 50 countries (Luxemburg and Vatican are not
amongst them)
- Only for two countries will city/region be displayed instead of
country.
- Ultimately,
On 23/05/2011 11:19 PM, jasmin.dizdare...@gmail.com wrote:
Just be careful with pg_dump, if you have binary data stored in your 8.4 db. In
default mode it just export text.
Er ... what?
Can you elaborate on that?
Do you mean large objects? bytea fields? Something else?
--
Craig Ringer
Tech
On Mon, 23 May 2011 13:11:24 +1200
Andrej wrote:
>On 23 May 2011 10:00, Tarlika Elisabeth Schmitz
> wrote:
>> On Sun, 22 May 2011 21:05:26 +0100
>> Tarlika Elisabeth Schmitz wrote:
>>
>>>A column contains location information, which may contain any of the
>>>following:
>>>
>>>1) null
>>>2) count
Here is the sql statements. We don't pass update, I guess base or the relevant
programmes does that. Some transactions that are based on forms seem to
update, but sometimes they don't, and it would seem that certain constraints
are not met, causing holes in the database. This didn't happen prior
On Mon, May 23, 2011 at 9:53 AM, Dean le Roux wrote:
> postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new
> install)
>
> I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and other
> updates have been effected. I used webmin to restore the databases.
>
> Since migrat
postgres 8.3 to 8.4 Open office base 3.2 Ubuntu 9.04 to 10.04 (new install)
I recently upgraded from Ubuntu 9.04 to Ubuntu 10.04. Security and other
updates have been effected. I used webmin to restore the databases.
Since migrating to Linux around 2006 we were successful in converting our mdb
On Mon, 23 May 2011 00:25:16 -0400
Lew wrote:
>That isn't a table structure, that's a freeform text structure. You
>didn't state your question, Tarlika, but your database structure is
>terrible. For example, "region" and "country" should be different
>columns.
I presume you are referring to m
Just be careful with pg_dump, if you have binary data stored in your 8.4 db. In
default mode it just export text.
Jasmin
A1 präsentiert BlackBerry® von Vodafone
-Original Message-
From: Gavin Baumanis
Sender: pgsql-sql-owner@postgresql.orgDate: Sun, 22 May 2011 09:10:17
To: Gavin Bauma
I would think that changing the location column to hold a FK to a location
table, and setting up the location table with various columns for city, region,
country and whatever else might be required would be the way to go. It reduces
column bloat on the main table, provides reuse of location dat
On 05/22/2011 09:42 PM, Craig Ringer wrote:
On 23/05/2011 9:11 AM, Andrej wrote:
On 23 May 2011 10:00, Tarlika Elisabeth Schmitz
wrote:
On Sun, 22 May 2011 21:05:26 +0100
Tarlika Elisabeth Schmitz wrote:
A column contains location information, which may contain any of the
following:
1) null
Just thought I would update this myself.
Last night I managed to have a chat with some people about this on IRC.
Turns out we're in pretty good shape.
We already know about the changes to implicit casting and we have always used
UTF-8 for encoding, too.
So the changes from 8.4 don't seem to be o
13 matches
Mail list logo
