Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

On 09/10/2013, at 11:03 PM, Tony Theodore wrote: > On 09/10/2013, at 8:39 PM, raghu ram wrote: >> >> ETL Tools for PostgreSQL:: >> >> Definition: An ETL process data to load into the database from a flat file >> >> A. Extract >> B. Transform >> C. Load > > Not exactly an ETL tool, but I've

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

On 09/10/2013, at 8:39 PM, raghu ram wrote: > > On Mon, Oct 7, 2013 at 8:32 PM, sunpeng wrote: > Hi, Friends, are there any ETL tools (free or commercial) available for > PostgreSQL? > > > ETL Tools for PostgreSQL:: > > Definition: An ETL process data to load into the database from a flat

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

On Mon, Oct 7, 2013 at 8:32 PM, sunpeng wrote: > Hi, Friends, are there any ETL tools (free or commercial) available for > PostgreSQL? > > *ETL Tools for PostgreSQL::* Definition: An ETL process data to load into the database from a flat file A. Extract B. Transform C. Load 1. PGLoader - Load

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

http://kettle.pentaho.com/ works pretty good to. On Mon, Oct 7, 2013 at 11:39 AM, Michal TOMA wrote: > Talend? > http://talend.com/ > But usually all major ETL tools do work with any database including > PostgreSQL > > On Monday 07 October 2013 17:54:36 Vick Khera wrote: > > http://lmgtfy.com/

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

Talend? http://talend.com/ But usually all major ETL tools do work with any database including PostgreSQL On Monday 07 October 2013 17:54:36 Vick Khera wrote: > http://lmgtfy.com/?q=postgres+ETL+tools > > On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote: > > Hi, Friends, are there any ETL tools (fr

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

Talend? http://talend.com/ But usually all major ETL tools do work with any database including PostgreSQL On Monday 07 October 2013 17:54:36 Vick Khera wrote: > http://lmgtfy.com/?q=postgres+ETL+tools > > On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote: > > Hi, Friends, are there any ETL tools (fr

Re: [GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

http://lmgtfy.com/?q=postgres+ETL+tools On Mon, Oct 7, 2013 at 11:02 AM, sunpeng wrote: > Hi, Friends, are there any ETL tools (free or commercial) available for > PostgreSQL? > Thanks! > peng >

[GENERAL] Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL?

Hi, Friends, are there any ETL tools (free or commercial) available for PostgreSQL? Thanks! peng

Re: [GENERAL] Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

On 8/6/12 3:31 AM, Magnus Hagander wrote: On Mon, Aug 6, 2012 at 11:22 AM, sunpeng wrote: Hi,Frirends, Are there any commands in pgsql/bin/ corresponding "create tablespace"? I know: createuser<==> create role createdb<==>create database Hi! No, but you can always use: psql -c

Re: [GENERAL] Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

On Mon, Aug 6, 2012 at 11:22 AM, sunpeng wrote: > Hi,Frirends, > Are there any commands in pgsql/bin/ corresponding "create tablespace"? > I know: > createuser <==> create role > createdb <==>create database Hi! No, but you can always use: psql -c "create tablespace foo..." -- Magnus

[GENERAL] Hi,Frirends, are there any commands in pgsql/bin/ corresponding "create tablespace"?

Hi,Frirends, Are there any commands in pgsql/bin/ corresponding "create tablespace"? I know: createuser <==> create role createdb <==>create database Thanks! peng

Re: [GENERAL] Hi,are there any other open source parallel query engine like pgpool?

Hello http://www.postgresql.org/about/news/1351/ Regards Pavel Stehule 2012/2/8 sunpeng : > Hi,Friends, >   I would like to study parallel query, also hope to implement a parallel > db, are there any other open source parallel query engine like pgpool? >   Thanks! > peng -- Sent via pgsql-gen

[GENERAL] hi, firends, what's the difference between using PostgreSQL's share buffer and os's file buffer?

hi, firends, I have a 64bit 128GB machine, I have two choices: 1. I could set PostgreSQL share_buffer to a large value, such as 100GB, let os uses the remaining 28G memory for file system buffer 2. I also could set PostgreSQL share_buffer to a small value, such as 10GB, l

Re: [GENERAL] hi, friends. are there any performance tuning materials for postgreSQL recommended?

On Mon, Oct 24, 2011 at 9:38 PM, Craig Ringer wrote: > On 25/10/11 11:00, sunpeng wrote: > > Hi, friends. >  Are there any performance tuning resouces for postgreSQL recommended, such > as ppt, books or articles? > Thanks! > peng > > http://wiki.postgresql.org/wiki/Performance_Optimization > > htt

Re: [GENERAL] hi, friends. are there any performance tuning materials for postgreSQL recommended?

On 25/10/11 11:00, sunpeng wrote: > Hi, friends. > Are there any performance tuning resouces for postgreSQL recommended, > such as ppt, books or articles? > Thanks! > peng http://wiki.postgresql.org/wiki/Performance_Optimization http://www.postgresql.org/docs/books/ ... of which the most recent

[GENERAL] hi, friends. are there any performance tuning materials for postgreSQL recommended?

Hi, friends. Are there any performance tuning resouces for postgreSQL recommended, such as ppt, books or articles? Thanks! peng

[GENERAL] hi, is that the standard:ISO/IEC 13249-6:2006 if I investigate the data mining extension for SQL language?

Recently I noticed there are only 1-4, 9-14 parts in SQL:2008 standard: ISO/IEC 9075-1:2008. Here is: http://www.iso.org/iso/iso_catalogue/catalogue_tc/catalogue_detail.htm?csnumber=45498 why don't they define 5-8 parts in this standard? I also noticed there is a standard for data mining: ISO

Re: [GENERAL] hi, how to let the inserted tuple visible to other backend when current backend hasn't finish?

On Sun, Sep 12, 2010 at 3:02 AM, sunpeng wrote: > hi, These codes are in the postgresql engine, just assume they are in > PortalRun() function: > //1.create table structure > char *relname = "test"; > ... > relOid = heap_create_with_catalog(relname, ); > CommandCounterIncrement(); > ... > //2.

[GENERAL] hi, how to let the inserted tuple visible to other backend when current backend hasn't finish?

hi, These codes are in the postgresql engine, just assume they are in PortalRun() function: //1.create table structure char *relname = "test"; ... relOid = heap_create_with_catalog(relname, ); CommandCounterIncrement(); ... //2.then i can use SPI_execute to create index on this created table SP

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

sunpeng writes: > hi,i write a function in postgresql source code, how to register this > function? See src/include/catalog/pg_proc.h But you should *really* consider making it a loadable module. That's the way it makes sense for any code you want to add in the server unless you're preparing a

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

Hi, On Wednesday 16 June 2010 18.42:25 sunpeng wrote: > hi,i write a function in postgresql source code, how to register this > function? > it is not an aggregate function. > i don't use 34.3"User-Defined Functions" described in > http://www.postgresql.org/docs/8.4/interactive/xfunc.html, i just w

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

It's just in postgresql 8.4 source code,e.g in /backend/executor/functions.c, not in sql,not in pl/pgsql 2010/6/16 Raymond O'Donnell > On 16/06/2010 17:42, sunpeng wrote: > > hi,i write a function in postgresql source code, how to register this > > function? > > it is not an aggregate function.

Re: [GENERAL] hi,i write a function in postgresql source code, how to register this function?

On 16/06/2010 17:42, sunpeng wrote: > hi,i write a function in postgresql source code, how to register this > function? > it is not an aggregate function. > i don't use 34.3"User-Defined Functions" described in > http://www.postgresql.org/docs/8.4/interactive/xfunc.html, i just write > it in postgr

[GENERAL] hi,i write a function in postgresql source code, how to register this function?

hi,i write a function in postgresql source code, how to register this function? it is not an aggregate function. i don't use 34.3"User-Defined Functions" described in http://www.postgresql.org/docs/8.4/interactive/xfunc.html, i just write it in postgresql sourcecode, how to register this function t

[GENERAL] Re: [GENERAL] Re: [GENERAL] hi，for help!

hi ,it turn out i indeed deleted the postgres , and with the command "psql template1 create database postgres; " i got my postgres. Scott , Ashesh ,thanks for your both help . 2010/5/30 Scott Marlowe > On Sat, May 29, 2010 at 6:35 PM, zhenyang guo > wrote: > > hi ,i got a problem , kinda

[GENERAL] Re: [GENERAL] Re: [GENERAL] hi，for help!

On Sat, May 29, 2010 at 6:35 PM, zhenyang guo wrote: > hi ,i got a problem , kinda don't know how to deal with it ,hoping can get > help here ,thanks ! >  also to Ashesh  ,firstly, thanks for every favor you did. and  the postgres > must exist ,maybe just present itself for some reason. when i giv

[GENERAL] Re: [GENERAL] hi，for help!

Hi, Looks like, you accidentally deleted the postgresql database. It can work without the postgres database, you just need to specify the database name to work with. i.e. psql test1 -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On

[GENERAL] Re: [GENERAL] hi，for help!

hi ,i got a problem , kinda don't know how to deal with it ,hoping can get help here ,thanks ! also to Ashesh ,firstly, thanks for every favor you did. and the postgres must exist ,maybe just present itself for some reason. when i give the command " psql -l template1 " it was there. <<<

[GENERAL] Re: [GENERAL] hi，for help!

[Adding pgsql-general...] Please CC to pgsql-general.. (Use reply-all...) On Sat, May 29, 2010 at 2:31 PM, zhenyang guo wrote: > hi,Ashesh, i did as you said ,it still gives problem. information from the > terminal is following: > > " postg...@guo-desktop:~$ psql -l > > psql: FATAL: databa

[GENERAL] Re: [GENERAL] hi，for help!

What is the output of the following commands? psql -l psql --version -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise Postgres Company On Fri, May 28, 2010 at 7:11 PM, zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwi

Re: [GENERAL] hi，for help!

You need to "initdb" first. Am Freitag, 28. Mai 2010 15:41:38 schrieb zhenyang guo: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql:

Re: [GENERAL] hi，for help!

zhenyang guo wrote: > hi, i have a problem not knowing how to fix . the follwing are error > information: > > " > g...@guo-desktop:~$ su > Password: > r...@guo-desktop:/home/guo# su - postgres > postg...@guo-desktop:~$ psql > psql: FATAL: database "postgres" does not exist > postg...@guo-desk

[GENERAL] hi，for help!

hi, i have a problem not knowing how to fix . the follwing are error information: " g...@guo-desktop:~$ su Password: r...@guo-desktop:/home/guo# su - postgres postg...@guo-desktop:~$ psql psql: FATAL: database "postgres" does not exist postg...@guo-desktop:~$ createdb test createdb: could not c

Re: [GENERAL] hi, trying to compile postgres 8.3.11

erobles wrote: >> Do you need the Pg server to run on SCO OpenServer? > > Yes, i need it :-P Of course it's none of my business, but whenever I had a supplier insisting on some idosyncratic or obsolete OS I started thinking hard about replacing the supplier and their product. Even worse if

Re: [GENERAL] hi, trying to compile postgres 8.3.11

On 05/27/2010 10:29 AM, Craig Ringer wrote: On 27/05/2010 10:42 PM, erobles wrote: hi, i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7 Possibly stupid question: Why? Do you need the Pg server to run on SCO OpenServer? Yes, i need it :-P Before i have running pg 7.2 after we

Re: [GENERAL] hi, trying to compile postgres 8.3.11

On 27/05/2010 10:42 PM, erobles wrote: hi, i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7 Possibly stupid question: Why? Do you need the Pg server to run on SCO OpenServer? Or just a client? Have you considered running your (presumably SCO-based) client with a network connection

Re: [GENERAL] hi, trying to compile postgres 8.3.11

erobles writes: > i have been using gcc 2.95.2 to compile At least get onto 2.95.3 ;-). I've been using that version on HPPA for quite awhile and haven't tripped across any bugs. But in any case these are stone-age versions. regards, tom lane -- Sent via pgsql-

Re: [GENERAL] hi, trying to compile postgres 8.3.11

i have been using gcc 2.95.2 to compile On 05/27/2010 10:02 AM, Tom Lane wrote: erobles writes: i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ... when the xlog.o is being compiled i have the next error: /usr/tmp/ccihgiYL.s: 1113: syntax error at name

Re: [GENERAL] hi, trying to compile postgres 8.3.11

erobles writes: > i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ... > when the xlog.o is being compiled i have the next error: > /usr/tmp/ccihgiYL.s: 1113: syntax error at name f > /usr/tmp/ccihgiYL.s: 1113: syntax error at integer constant: 1 Looks like a compiler bug. Ge

Re: [GENERAL] hi, trying to compile postgres 8.3.11

On Thu, May 27, 2010 at 10:42 AM, erobles wrote: > hi, > i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ... when > the xlog.o is being compiled  i have the next error: > > /usr/tmp/ccihgiYL.s: 1113: syntax error at name f > /usr/tmp/ccihgiYL.s: 1113: syntax error at integer consta

[GENERAL] hi, trying to compile postgres 8.3.11

hi, i tried to compile postgres 8.3.11 on SCO OpenServer 5.0.7, but ... when the xlog.o is being compiled i have the next error: /usr/tmp/ccihgiYL.s: 1113: syntax error at name f /usr/tmp/ccihgiYL.s: 1113: syntax error at integer constant: 1 i dont have copy of that assembly file because

Re: [GENERAL] hi,is it dangerous to only use tuple pointer through heap_getnext()?

Excerpts from sunpeng's message of vie may 14 19:15:47 -0400 2010: > hi,i use these codes to store only pointer of tuple : > HeapTuple *tuple; > tuple = heap_getnext(pHeapScanDesc,ForwardScanDirection); > while(tuple){ > //[1#]here i only store the pointer of tuple in an array for l

[GENERAL] hi,is it dangerous to only use tuple pointer through heap_getnext()?

hi,i use these codes to store only pointer of tuple : HeapTuple *tuple; tuple = heap_getnext(pHeapScanDesc,ForwardScanDirection); while(tuple){ //[1#]here i only store the pointer of tuple in an array for later using,that means i don't retrive attribute data from this tuple ,is this

Re: [GENERAL] hi all

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Grzegorz Jaśkiewicz wrote: > just outside of your question, you should read about normalization. > it is in general very bad idea to have a table that holds all > information possible . > I wouldn't say this table is not normalized. The only fields y

Re: [GENERAL] hi all

Kusuma Pabba wrote: when creating tables, in my sql i have used create table By "my SQL" I assume you mean MySQL? It took me a minute to figure out that you didn't mean "in my sql code" but rather "in the product MySQL". Having read your proposed table definition: I very strongly recommend

Re: [GENERAL] hi all

On Tue, Feb 17, 2009 at 5:54 AM, Kusuma Pabba wrote: > while in pgsql i am thinking of to use the same as follows: > > CREATE TABLE users ( > user_id int(11) NOT NULL serial, I see this construct in mysql all the time. Funny thing is most mysql users think it means an 11 character wide int, i.e

Re: [GENERAL] hi all

On Tue, Feb 17, 2009 at 04:40:58PM +, Sam Mason wrote: > > user_name varchar(50) NOT NULL, > > As a general design question; should user_name have a UNIQUE > constraint on it? i.e. > > user_name VARCHAR(50) NOT NULL UNIQUE, Yes, it's good to have a UNIQUE constraint, but not this one

Re: [GENERAL] hi all

a few further comments: On Tue, Feb 17, 2009 at 06:54:53PM +0530, Ashish Karalkar wrote: > CREATE TABLE users ( > user_id serial NOT NULL , It's common to combine this with the PRIMARY KEY constraint from below to be: user_id SERIAL PRIMARY KEY, the NOT NULL check is implicit in this and

Re: [GENERAL] hi all

Kusuma Pabba, 17.02.2009 13:54: while in pgsql i am thinking of to use the same as follows: CREATE TABLE users ( user_id int(11) NOT NULL serial, user_name varchar(50) NOT NULL, first_name varchar(50) default NULL, middle_name varchar(50) default NULL, last_name varchar(50) default NULL, p

Re: [GENERAL] hi all

Kusuma Pabba wrote: when creating tables, in my sql i have used create table CREATE TABLE `users` ( `user_id` int(11) NOT NULL auto_increment, `user_name` varchar(50) NOT NULL, `first_name` varchar(50) default NULL, `middle_name` varchar(50) default NULL, `last_name` varchar(50) default NUL

Re: [GENERAL] hi all

just outside of your question, you should read about normalization. it is in general very bad idea to have a table that holds all information possible . -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/p

[GENERAL] hi all

when creating tables, in my sql i have used create table CREATE TABLE `users` ( `user_id` int(11) NOT NULL auto_increment, `user_name` varchar(50) NOT NULL, `first_name` varchar(50) default NULL, `middle_name` varchar(50) default NULL, `last_name` varchar(50) default NULL, `password` varcha

Re: [GENERAL] Hi iam the beginner

Scott Marlowe wrote: > On Mon, Dec 15, 2008 at 11:02 PM, sai srujan wrote: >> Hi >> This is srujan and I am beginner of postgresql 8.1 and I have >> just stopped using mysql and i would like to use the dump (.sql file) >> created in it. I would like transfer the databases in my

Re: [GENERAL] Hi iam the beginner

On Dec 18, 2008, at 10:19 PM, Star Liu wrote: On Tue, Dec 16, 2008 at 2:02 PM, sai srujan wrote: Hi This is srujan and I am beginner of postgresql 8.1 and I have just stopped using mysql and i would like to use the dump (.sql file) created in it. I would like transfer the

Re: [GENERAL] Hi iam the beginner

On Tue, Dec 16, 2008 at 2:02 PM, sai srujan wrote: > Hi > This is srujan and I am beginner of postgresql 8.1 and I have > just stopped using mysql and i would like to use the dump (.sql file) > created in it. I would like transfer the databases in my sql to postgresql > 8.1. Ple

Re: [GENERAL] Hi iam the beginner

(sorry all, I *couldn't* resist!) Scott ... In all these years that's the 1st time I've ever 'heard' the term "massage you data" !!! All sorts of deviant thoughts come to your mind! LOL BR, Pedro Doria Meunier GSM: +351961720188 Skype: pdoriam On Friday 19 December 2008 12:03:26 am Scott Mar

Re: [GENERAL] Hi iam the beginner

On Mon, Dec 15, 2008 at 11:02 PM, sai srujan wrote: > Hi > This is srujan and I am beginner of postgresql 8.1 and I have > just stopped using mysql and i would like to use the dump (.sql file) > created in it. I would like transfer the databases in my sql to postgresql > 8.1. Pl

[GENERAL] Hi iam the beginner

Hi This is srujan and I am beginner of postgresql 8.1 and I have just stopped using mysql and i would like to use the dump (.sql file) created in it. I would like transfer the databases in my sql to postgresql 8.1. Please do reply. I am waiting for it. Thanks in Advance

[GENERAL] Hi

Hi, First of all a big thank you for all the guys at Postgres . I love you all for the whole system you have to put up ! I just have one problem that I can't get to set my general mailing list to weekly or monthly. I want to have it as a digest ; any digest upwards of weekly

[GENERAL] hi 5 mess...

Hello, I'm sorry about that email you received earlier about hi5... it was a mess (I've sent it to my whole gmail contact list :-s). Please forget about it. All apologize. andy petrella

Re: [GENERAL] Hi there, new here and have question

|> |> -Original Message- |> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hendra |> Sent: 8 juillet 2008 02:59 |> To: pgsql-general@postgresql.org |> Subject: [GENERAL] Hi there, new here and have question |> |> Hi Everyone. |> I'm just subs

Re: [GENERAL] Hi there, new here and have question

CREATE OR REPLACE FUNCTION listofemployeebasedondepartment(_id_dept int) RETURNS SETOF record AS $BODY$ DECLARE empdata record; BEGIN RETURN QUERY SELECT e.*, d.department_name FROM employee e, dept d WHERE e.id_dept = d.id AND e.id_dept = _id_dept; RETURN; END; $BODY$ LANGUAGE 'plpg

Re: [GENERAL] Hi there, new here and have question

Any suggestion everyone? Sorry, i was to fast sending this email out ;-) change the first parameter in the first line to '_id_depth' CREATE OR REPLACE FUNCTION listofemployeebasedondepartment(_id_dept int) RETURNS SETOF employee AS $BODY$ BEGIN RETURN QUERY SELECT * F

Re: [GENERAL] Hi there, new here and have question

Hi Hendra, create function listofemployeebasedondepartment(id_dept int) $$ declare resultset ??; begin select * into resultset from employee where id_dept = id_dept; return resultset; end $$ language 'plpgsql'; I believe you get what I want But I just couldn't finish the code since I mi

[GENERAL] Hi there, new here and have question

Hi Everyone. I'm just subscribe to the mailing list I'm new to Postgresql and I have a question I intend to make a function that returns more than a row I tried something like below create function listofemployeebasedondepartment(id_dept int) $$ declare resultset ??; begin select * into res

Re: [GENERAL] Hi, For the UTF-8 encoding

patch?      -- Steve Yao       -原始邮件-发件人:"Martijn van Oosterhout" 发送时间:2006-10-04 17:42:00收件人:"stevegy" <[EMAIL PROTECTED]>抄送:pgsql-general@postgresql.org主题:Re: [GENERAL] Hi, everOn Wed, Oct 04, 2006 at 07:50:12AM +0800, stevegy wrote: > My testing database is

Re:  [GENERAL] Hi, ever

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

Re:  [GENERAL] Hi, ever

.I think I post 2 questions in one post and it's a bad idea. So I post another mail for the convert function error.Thank you and have a nice day.-- Steve Yao -原始邮件-发件人:"Martijn van Oosterhout" 发送时间:2006-10-03 21:51:25收件人:"stevegy" 抄送:pgsql-general@

Re: [GENERAL] Hi, everyone. can i ask a question for th e server side encoding GB18030 and sort order?

On Tue, Oct 03, 2006 at 04:16:36PM +0800, stevegy wrote: > I have published my application since a month and I notice the appcation > server report a few jdbc errors that says : > org.postgresql.util.PSQLException: ERROR: character 0xe28094 of encoding > "UTF8" has no equivalent in "EUC_CN" > I t

[GENERAL] Hi, everyone. can i ask a question for th e server side encoding GB18030 and sort order?

Hi,   I have set up a postgreSQL on a x86 Solaris 10 box with compiling the source code 8.1.4. My application is need to store the characters encoding with GB18030 or GBK. My Solaris box is installed the locale code zh_CN.GB18030 but I fail to initdb -E GB18030 so I have to use the EUC_CN to initd

Re: [GENERAL] hi, what is wrong with my newbie sql?

"Ronin" <[EMAIL PROTECTED]> writes: > k = 10; > FOR k IN 1..10 LOOP > k = k +1; > END LOOP; > return k; An integer for-loop implicitly declares its control variable, so the "k" inside the loop is unrelated to the "k" ou

Re: [GENERAL] hi, what is wrong with my newbie sql?

Ronin <[EMAIL PROTECTED]> schrieb: > Hi, the following sql returns "10" and not "20" as would be expected. > > Where is the error? This would for sure work in any programming > language, why is this different? > > CREATE FUNCTION test () RETURNS INTEGER AS ' > > DECLARE > k

[GENERAL] hi, what is wrong with my newbie sql?

Hi, the following sql returns "10" and not "20" as would be expected. Where is the error? This would for sure work in any programming language, why is this different? CREATE FUNCTION test () RETURNS INTEGER AS ' DECLARE k integer; BEGIN k = 10;

Re: [GENERAL] Hi,

On Thu, 2006-03-23 at 13:03, Brian Kitzberger wrote: > Hi Tom, > > I decided to test your theory that I had an old version of Postgres on > my system when I installed version 8.1.3. By the way, the Linux install > we a fresh one to start with. So this morning I first did a search on OK, assumin

Re: [GENERAL] Hi,

Brian Kitzberger wrote: Hi Tom, I decided to test your theory that I had an old version of Postgres on my system when I installed version 8.1.3. By the way, the Linux install we a fresh one to start with. So this morning I first did a search on my system for all pg_dump files, and wrote the lo

Re: [GENERAL] Hi,

Hi Tom, I decided to test your theory that I had an old version of Postgres on my system when I installed version 8.1.3. By the way, the Linux install we a fresh one to start with. So this morning I first did a search on my system for all pg_dump files, and wrote the locations down. I them remo

Re: [GENERAL] Hi,

"Brian Kitzberger" <[EMAIL PROTECTED]> writes: > When I did I get "pg_dump: server version: 8.1.3; pg_dump version: > 7.4.8" Apparently you already had a 7.4.8 postgres installed on your machine. Most versions of Linux do have PG in them. You probably want to remove the 7.4.8 files to avoid con

[GENERAL] Hi,

Hi, I am a new user testing this open-source database and I have a few questions. I was able to install PostgreSQL version 8.1.3 on Linux version 9 using the simple install script provided. I created a simple database and populated the database with some data. The inserts, select, delete, drop,

Re: [GENERAL] hi problem with installing postgresql8.1

Firstly, the existence of the Path would be there from previous installation, of which PG thinks data is already present. Secondly you should have logged in as another user and not administrator, e.g postgres which can be even a part of domain.   Luckys   Data directory error:  The specified data

[GENERAL] hi problem with installing postgresql8.1

Hi all,    I am new to pgsql family.I had a problem with installing postgres8.1 i was getting the following error at the 4th step of installation the error is as follows:Data directory error:  The specified data directory is not empty    If you have an existing database with teh same major version

[GENERAL] hi problem again with installing postgres8.1

Hi Tino Wildenhain, Sorry for irritating you with my problems.Every time i run my installing it gives different problems and rolls back.Once when i move with account name as postgres it gives problem as "user account exists" and rollsback. If i try with different user it gives problem a

Re: [GENERAL] hi problem with installing postgresql8.1

venu gopal schrieb: > Hi all, > I am new to pgsql family.I had a problem with > installing postgres8.1 i was getting the following > error at the 4th step of installation the error is as > follows: > > Data directory error: > The specified data directory is not empty > >If you have an e

[GENERAL] hi problem with installing postgresql8.1

Hi all, I am new to pgsql family.I had a problem with installing postgres8.1 i was getting the following error at the 4th step of installation the error is as follows: Data directory error: The specified data directory is not empty If you have an existing database with teh same major ver

Re: [GENERAL] hi all......................!!

AKHILESH GUPTA schrieb: > hello everybody > i am new to this mailing list. this is my first mail to this group. > i jussst want to confirm that whether is it possible to update a view or > not?? > i think you all help me in solving my queries in future...!! Yes it is. All you have

[GENERAL] hi all......................!!

hello everybody i am new to this mailing list. this is my first mail to this group. i jussst want to confirm that whether is it possible to update a view or not?? i think you all help me in solving my queries in future...!! -- Thanks & Regards, Akhilesh DAV Institute of Managem

[GENERAL] hi

Norman Virus Control a supprimé la pièce-jointe game_xxo.txt.exe qui contenait le virus [EMAIL PROTECTED] Here is it! Attachment: No Virus found F-Secure AntiVirus - www.f-secure.com ---(end of broadcast)--- TIP 2: you can get off all

Re: [GENERAL] Hi

Alexander Lohse <[EMAIL PROTECTED]> writes: > What would I need to do to run 2 Versions of Postgres on the RaQ3? Should be the same deal as for running 2 versions anyplace else: give them separate install directories, separate data directories, and separate port numbers. If you compile from sour