"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 u
Hi Martijn,
I have changed the locale to LANG=zh_CN.UTF-8;export LANG first, 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 creat
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
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 im
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.
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 cur
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 To: Jean-Christophe Roux <[EMAIL PROTECTED]>Cc: pgsql-general@postgresql.orgSent: Wednesday, October 4, 2006 5:06:42 PMSubject: R
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
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 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
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, i.e.
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
http://ct.enews.e
Run the followingpg_ctl -D 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:
Hi
Frien
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 datab
> 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
> re
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 wee
-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
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" transaction
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 hun
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 se
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 dom
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
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
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
side?
Martijn van Oosterhout wrote:
> On Sun, Oct 01, 2006 at 07:48:14PM -0700, rlee0001 wrote:
> > 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, benef
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" escribió en el mensaje
news:[EMAIL PROT
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
k
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, mont
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=# select
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 resul
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 a
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 (m
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 login
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: [GEN
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 dba.active_tran
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.
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
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
char
38 matches
Mail list logo