Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> On Wed, 2006-09-27 at 14:58 -0400, Tom Lane wrote:
>> LANG=en_US locale charmap
> The working machine says: ISO-8859-1
> The not working machine says: ISO-8859-1
OK, so the problem is that you have a locale that expects ISO-8859-1
encoding, but the
Hi Tom,
Thanks for putting up with the questions.
On Wed, 2006-09-27 at 14:58 -0400, Tom Lane wrote:
> LANG=en_US locale charmap
>
I have done this on both machines:
The working machine says: ISO-8859-1
The not working machine says: ISO-8859-1
I still do not understand what is happening and ma
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> On Wed, 2006-09-27 at 12:10 -0400, Tom Lane wrote:
>> What you need to find out next is
>> what character set encoding that locale implies on your machine. I'm
>> betting it's not utf8 though :-(
> If this is not what you mean, could you help me in
On Wed, 2006-09-27 at 12:10 -0400, Tom Lane wrote:
> Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> > On Wed, 2006-09-27 at 11:00 -0400, Tom Lane wrote:
> >> But have they got the same locale settings (lc_collate, lc_ctype)?
>
> > According to the postgresql.conf of the *working* database the l
Joost Kraaijeveld <[EMAIL PROTECTED]> writes:
> On Wed, 2006-09-27 at 11:00 -0400, Tom Lane wrote:
>> But have they got the same locale settings (lc_collate, lc_ctype)?
> According to the postgresql.conf of the *working* database the locales
> are:
> lc_messages = 'C'
> lc_monetary = 'C'
>
Hi Tom,
On Wed, 2006-09-27 at 11:00 -0400, Tom Lane wrote:
> "Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> > I have 2 database, both created with:
> > CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE
> > = pg_default;
>
> But have they got the same locale settings (
"Joost Kraaijeveld" <[EMAIL PROTECTED]> writes:
> I have 2 database, both created with:
> CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE =
> pg_default;
But have they got the same locale settings (lc_collate, lc_ctype)?
regards, tom lane
-
Hi Joost. (hoe gaat het ermee?)
I would like to test this too. Could you please provide the data you are
inserting into the database.
Regards,
Gevik
On Wed, 2006-09-27 at 13:13 +0200, Joost Kraaijeveld wrote:
> Hi,
>
> I have a strange problem.
>
> I have 2 database, both created with:
> CRE
Hi,
I have a strange problem.
I have 2 database, both created with:
CREATE DATABASE muntdev WITH OWNER = postgres ENCODING = 'UTF8' TABLESPACE =
pg_default;
Running the queries below on the first database is OK and do what I expect.
If I create a backup of the first datase and restore that b
HI tom
A few days back i had bugged this list about the seemingly impossible
select queries results..
##RECAP##
select distinct site_section as "distinct site sections" from
exhibit_distributions ;
distinct site sections
ARCHIVED
ARTETC
CALENDAR
GALLERY
POSTCARD
(5 rows
Hi tom
The table description is as follows
arttoday=> \d exhibit_distributions
Table "exhibit_distributions"
Attribute | Type | Modifier
--+---+-
Anand Raman <[EMAIL PROTECTED]> writes:
> The second query is not priniting out site_section column.
Odd. What is the exact definition of table exhibit_distributions?
Does it have any indices? What plan is printed by EXPLAIN for the
problem query?
regards, tom lane
hi guys
I am trying out some relativly simple queries against my database..
select distinct site_section as "distinct site sections" from exhibit_distributions ;
distinct site sections
ARCHIVED
ARTETC
CALENDAR
GALLERY
POSTCARD
(5 rows)
select site_section, count(*) fr
Igor Khanjine <[EMAIL PROTECTED]> writes:
> select datop from mytable where date_trunc('month',datop)
> =date_trunc('month',abstime '02.05.00')
> it returns operations which were made in february !
> I'm running PGSQL 7.0 ,
> SET DATESTYLE ='GERMAN'
> SET TIME ZONE 'EUROPE/MOSCOW'
FWIW, I
Hi!
Help me please to resolve my problem.
I cann't understand why my query returns very strange results.
select datop from mytable where date_trunc('month',datop)
=date_trunc('month',abstime '22.05.00')
it returns a strings with operations which were made in May,
but similar query
se
15 matches
Mail list logo
