On Wed, Oct 04, 2006 at 07:50:12AM +0800, stevegy wrote:
My testing database is initdb -E UTF8. And i guess the solaris can
not handle the UTF-8 sorting with the LC_COLLATE=zh_CN.GB18030. But
i need to prove this.
A locale can only handle one charset, usually the one given by locale
charset.
This is the original message from october 2 that didn't appear in the
list. I don't know if someone received it.
X-Gmail-Received: c62ada517ba59dc1cb70c46da86fdd974cd80c63
Received: by 10.70.35.9 with HTTP; Mon, 2 Oct 2006 10:59:43 -0700 (PDT)
Message-ID: [EMAIL PROTECTED]
Date: Mon, 2 Oct 2006
I did not see this go through.Chris-- Forwarded message --From: Chris Hoover [EMAIL PROTECTED]
Date: Oct 3, 2006 4:49 PMSubject: Help with functionTo: pgsql-general@postgresql.orgI need some help with writing a plpgsql function. I want to return multiple items from the function.
am Wed, dem 04.10.2006, um 9:31:28 -0400 mailte Chris Hoover folgendes:
Here is my attempt at the function (note, this is a simple example that could
obviously be done via a view, but I am trying to learn more about writing
plpgsql functions):
create or replace function
Just curious but since which version these IN/OUT parameters are supported?
-- Matthias
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of A. Kretschmer
Sent: Wednesday, October 04, 2006 4:01 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL]
Hi Martijn,Thank you for the reply.I think the locale settings is a diffrent in my case, and in the logical way, I guess the locale environs should be used by the program in the system C run-time library for the string operating functions such like comparing or something else like that.I have
am Wed, dem 04.10.2006, um 16:06:40 +0200 mailte [EMAIL PROTECTED] folgendes:
Just curious but since which version these IN/OUT parameters are supported?
I'm not sure, 8.0 or 8.1
[ silly fullquote deleted ]
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47215, D1: 0160/7141639
am Wed, dem 04.10.2006, um 16:06:40 +0200 mailte [EMAIL PROTECTED] folgendes:
Just curious but since which version these IN/OUT parameters are supported?
Since 8.1:
http://developer.postgresql.org/pgdocs/postgres/release-8-1.html
E.6.3.8. General Server-Side Language Changes
Allow SQL
On Wed, Oct 04, 2006 at 09:45:26PM +0800, stevegy wrote:
So, now i stop the postgres: pg_ctl stop -D ./data_euc_cn and start
it use the UTF-8 encoding data directory: pg_ctl start -D
./data_utf8. But the sort result for the Chinese characters is still
wrong. And I notice that the sort result
Hello Archie,
We approach the problem slightly differently then others. Given an aggregate
function comma_list which simply creates a comma seperated list, we use
distinct to remove duplicates.
test=# select comma_list(col) from test;
comma_list
a, b, a, c
(1 row)
test=#
I have a similar question,
I receive payments, but not every day (or even every week),
and I would like see how much I receive per week and/or per
month. I also need to compare different years.
I also would like to see what the (accumulated) sum of the
payments is at the end of a given week,
I want to move the data directory to another disk and mantain the
config files in the same place. I will change the data_directory
parameter in postgresql.conf.
I could just copy everything under /var/lib/pgsql/data to the other
disk but I also want to clean the diretory now used thus I need to
I am newbie in postgres.
But I think that the value is stored correctly because when select and cast
the column to float8 the postgres return the correct value and when I
insert, no overflow or other error occur.
Thanks Martijn
Martijn van Oosterhout kleptog@svana.org escribió en el mensaje
Martijn van Oosterhout wrote:
On Sun, Oct 01, 2006 at 07:48:14PM -0700, rlee0001 wrote:
snip For example, if I key employee by Last Name, First Name, Date
of Hire and Department, I would need to store copies of all this data
in any entity that relates to an employee (e.g. payroll, benefits
Hi all,
Ive been studying the whole evening and dont seem to find an answer:
I want to store transactions on the server- like views, or, (sorry) as in M$
SQL Server CREATE OR REPLACE TRANSACTION xyz()
Is this possible with postgres or do I have to store all these at the client
I need some help with writing a plpgsql function. I want to return multiple items from the function. How do I do this?Here is my attempt at the function (note, this is a simple example that could obviously be done via a view, but I am trying to learn more about writing plpgsql functions):
create
Marc Evans wrote:
Hello -
I have a schema setup which I want to use partitions with. The intent is
to partition based on the created_at column, seperating based on the
year/month. What I am struggling with is a rule that I can use to
automatically determine which partition data should be
Hi
Friends,
I am using postgres
7.4.2 in Ubuntu linux...
when I run psql -l
command, it says the following error
[EMAIL PROTECTED]:~$ psql -lpsqll: could not
connect to server: Connection
refused Is the server running
locally and accepting connections
on Unix domain socket
guys,
is there a way to run various programs like (pg_config, pg_restore,
dropdb etc) from within pgadmin or from within my java code. i mean can
i perform database administration from within postgres that is without
using literal commands. so from within my java code i can execute a
query like
Hello,
I think I'm about to ask a traditional (almost
religious) question, but I haven't been able to find a
crystal clear answer in the mailing lists so far.
Thus, here is my question:
I need to store a large number of images in a
PostgreSQL database. In my application, this
represents a few
You can save your transactions in an sql file and then run that file whenever you need to run those transactions.
Regards
Talha Khan
On 10/3/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Hi all,I've been studying the whole evening and don't seem to find an answer:I want to "store" transactions
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
In this context, what is a transaction?
On 10/04/06 14:32, Talha Khan wrote:
You can save your transactions in an sql file and then run that file
whenever you need to run those transactions.
Regards
Talha Khan
On 10/3/06, [EMAIL
Eberhard Lisse wrote:
I receive payments, but not every day (or even every week),
and I would like see how much I receive per week and/or per month. I
also need to compare different years.
I also would like to see what the (accumulated) sum of the payments
is at the end of a given week,
Hello,
I think I'm about to ask a traditional (almost
religious) question, but I haven't been able to find a
crystal clear answer in the mailing lists so far.
Thus, here is my question:
I need to store a large number of images in a
PostgreSQL database. In my application, this
represents
TIJod wrote:
I need to store a large number of images in a
PostgreSQL database. In my application, this
represents a few hundreds of thousands of images. The
size of each image is about 100-200 Ko. There is a
large turnover in my database, i.e. each image stays
about 1 week in the database,
Run the followingpg_ctl -D data folder path statusto see if you have the db server running or not?As these seems to me you dont have the database server running on port 5432.Thanks,
---Shoaib MirEnterpriseDB (www.enterprisedb.com)On 10/3/06, Ravindran Vijaykumar R-AVR025
[EMAIL PROTECTED] wrote:
Ziff Davis Media eSeminars: The Online Seminar Standard
Realizing the Value of Enterprise Open Source Databases:
How Sony Online Entertainment Replaced Oracle with EnterpriseDB
October 12, 2006 @ 12:00 p.m. Eastern/9:00 a.m. Pacific
Duration: 60 minutes
Register Attend Online
On Oct 4, 2006, at 12:56 PM, Guy Rouillier wrote:
TIJod wrote:
I need to store a large number of images in a
PostgreSQL database. In my application, this
represents a few hundreds of thousands of images. The
size of each image is about 100-200 Ko. There is a
large turnover in my database,
On 10/4/06, TIJod [EMAIL PROTECTED] wrote:
I think I'm about to ask a traditional (almost
religious) question, but I haven't been able to find a
crystal clear answer in the mailing lists so far.
I think the key in deciding this, in your case, is your requirement for space
reclamation:
There
Hello,I am a bit sorry to come back on that topic but I just cannot get it right. How comes that select now() at time zone 'EST'returns "2006-10-04 15:59:26.713623"when it is actually 16:59 on the east coast? Can it be that the server where the PostgreSQL database is located is not properly
On Wed, Oct 04, 2006 at 02:01:18PM -0700, Jean-Christophe Roux wrote:
Hello,
I am a bit sorry to come back on that topic but I just cannot get it right.
How comes that
select now() at time zone 'EST'
returns
2006-10-04 15:59:26.713623
when it is actually 16:59 on the east coast?
Yes you are right, that's what I have just realized; I should be using EDT instead of EST. Sorry for the botherJCR- Original Message From: Martijn van Oosterhout kleptog@svana.orgTo: Jean-Christophe Roux [EMAIL PROTECTED]Cc: pgsql-general@postgresql.orgSent: Wednesday, October 4, 2006
Jean-Christophe Roux [EMAIL PROTECTED] writes:
I am a bit sorry to come back on that topic but I just cannot get it right.
How comes that
select now() at time zone 'EST'
returns
2006-10-04 15:59:26.713623
when it is actually 16:59 on the east coast?
USA east coast is currently on
On Mon, 2006-10-02 at 22:56 -0700, pd wrote:
guys,
is there a way to run various programs like (pg_config, pg_restore,
dropdb etc) from within pgadmin or from within my java code. i mean can
i perform database administration from within postgres that is without
using literal commands. so
Given a table def something like: create table mytbl (id int8 default
nextval('myseq') primary key...
I have data I'm extracting from a legacy database. I want to assign
newly-generated synthetic keys. I would like to use copy to get the data in.
If I put an explicit null in the data file to be
Scott Ribe [EMAIL PROTECTED] writes:
I have data I'm extracting from a legacy database. I want to assign
newly-generated synthetic keys. I would like to use copy to get the data in.
If I put an explicit null in the data file to be imported, pg won't generate
a key, right?
Right. Instead,
Hi Martijn,
I have changed the locale to LANG=zh_CN.UTF-8;export LANGfirst, stop the pgsql, and issue the command:
initdb -D ./data -E UTF8 --locale=zh_CN.UTF-8 --lc-collate=zh_CN.UTF-8 -U postgres -W
so i get a fresh new data cluster in this ./data, then I pg_ctl start -D ./data, psql to create
stevegy [EMAIL PROTECTED] writes:
I really want to know why the server side encoding for GB18030 is not
supported?
Because it overlaps the ASCII character set, ie, it has multibyte
characters in which some of the bytes don't have the high bit set.
That creates too many parsing risks for us to
38 matches
Mail list logo