Re: [GENERAL] MPI interface

2003-09-26 Thread Andreas Fromm
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ramkrishna Chakrabarty wrote: | Hi, | | Is there a MPI interface to PostgreSQL ? Has anybody used. | If yes could please send me some links about the same. | | Regards | RC | What do you mean with a MPI interface? Do you want to access a DB from a mpi-p

Re: [GENERAL] A conditional DROP TABLE function

2003-09-26 Thread Peter Childs
On Thu, 25 Sep 2003, David Link wrote: > Hi All, > > Here's a Conditional drop_table func for those interested. There was a > thread on this a long time back. > > We do this all the time : > > DELETE TABLE sales; > CREATE TABLE sales (...); > > But nobody likes > > ERROR: table "sales

[GENERAL] how to include equalfuncs.c?

2003-09-26 Thread 博? 翟
Hello,       I want to include /src/backend/nodes/equalfuncs.c   but I cannot find the ".h" file   could you tell me why??    thanks!!      your sincerely  zhai    Do You Yahoo!? 启用电邮帐号，领会雅虎通[身临其境聊电影]的动感魅力，还有网络摄像头+雅虎通收音机等你来拿

[GENERAL]

2003-09-26 Thread zhuangjifeng
hello,i wonder how and where i can find the part of source codes about how to create catalogs. i meanhow to create the structure of pg_class and so on,not just insert the tuple of system attributes ofuser-defined table into it. thanks!

Re: [GENERAL]

2003-09-26 Thread Nigel J. Andrews
On Fri, 26 Sep 2003, [gb2312] zhuangjifeng wrote: > > hello, > i wonder how and where i can find the part of source codes about how to create > catalogs. i mean > how to create the structure of pg_class and so on,not just insert the tuple of > system attributes of > user-defined table into i

Re: [GENERAL] populate table with large csv file

2003-09-26 Thread Dave [Hawk-Systems]
>> aside from parsing the csv file through a PHP interface, what isthe >easiest way >> to get that csv data importted into the postgres database. thoughts? > >Assuming the CSV file data is well formed, use psql and >the COPY command. > >In psql, create the table. Then issue command: > >copy from

Re: [GENERAL] Good way to insert/update when you're not sure of duplicates?

2003-09-26 Thread Curtis Stanford
On September 25, 2003 11:27 am, Richard Huxton wrote: > On Thursday 25 September 2003 02:23, Curtis Stanford wrote: > > I'm in a situation where I need to load an ASCII file into a database. No > > sweat so far right? The records are indexed by date and I have a unique > > index on date. The ASCII

Re: [GENERAL] sequence's plpgsql

2003-09-26 Thread Tim McAuley
I see from a previous email on the list that someone was able to get decent debug out of the locks, i.e. Aug 10 14:19:36 thunder postgres[18735]: [2-1] ERROR: deadlock detected Aug 10 14:19:36 thunder postgres[18735]: [2-2] DETAIL: Proc 18735 waits for AccessExclusiveLock on relation 18028 of

Re: [GENERAL] populate table with large csv file

2003-09-26 Thread Ron Johnson
On Fri, 2003-09-26 at 06:58, Dave [Hawk-Systems] wrote: [snip] > Unfortunately processing the 143mb file which would result in a database size of > approx 500mb takes an eternity. As luck would have it we can get away with just Something's not right, then. I loaded 30GB in about 8 hours, on a sl

[GENERAL] Escape sequence for unicode characters

2003-09-26 Thread Didier Bretin
Hello, Is there some escape sequence for using unicode characters in command line psql ? For example in HTML there is e; for the c-cedilla. Is there the same thing with postgresql ? Regards. -- .. .^. | Didier Bretin, France | [

Re: [GENERAL] Good way to insert/update when you're not sure of duplicates?

2003-09-26 Thread Dennis Gearon
Shridhar Daithankar wrote: In addition to that, you can try inserting from multiple backends simaltenously to speed up the whole process. And I don't like the modes idea OP gave. I would rather follow insert->if-error-update mode in a transaction for each record. And fork over say 20/40 parall

Re: [GENERAL] Good way to insert/update when you're not sure of duplicates?

2003-09-26 Thread Shridhar Daithankar
On Friday 26 September 2003 20:48, Dennis Gearon wrote: > Shridhar Daithankar wrote: > > In addition to that, you can try inserting from multiple backends > > simaltenously to speed up the whole process. > > > > And I don't like the modes idea OP gave. I would rather follow > > insert->if-error-upd

Re: [GENERAL] Good way to insert/update when you're not sure of duplicates?

2003-09-26 Thread Shridhar Daithankar
On Friday 26 September 2003 21:08, Dennis Gearon wrote: > corruption of the databases, if I'm correct. > Shridhar Daithankar wrote: > >On Friday 26 September 2003 20:48, Dennis Gearon wrote: > >>I didn't think mulitple backends worked. > > > >Why? Why can't you insert using multiple backends? I me

Re: [GENERAL] Good way to insert/update when you're not sure of duplicates?

2003-09-26 Thread Dennis Gearon
Well, I may have my merms tixed up! There is ONE component of Postgres that can only be accessing the database by itself. Maybe it's not the 'backend', it's probably the postmaster. Are they the same? I don't know. Shridhar Daithankar wrote: On Friday 26 September 2003 21:08, Dennis Gearon wro

Re: [GENERAL] Good way to insert/update when you're not sure of

2003-09-26 Thread scott.marlowe
On Fri, 26 Sep 2003, Shridhar Daithankar wrote: > On Friday 26 September 2003 21:08, Dennis Gearon wrote: > > corruption of the databases, if I'm correct. > > > Shridhar Daithankar wrote: > > >On Friday 26 September 2003 20:48, Dennis Gearon wrote: > > >>I didn't think mulitple backends worked. >

Re: [GENERAL] About GPL and proprietary software

2003-09-26 Thread Joshua D. Drake
Look, guys, this is way off topic for the Postgres lists. Postgres is not a GPL project and will never be one. If you want to engage in either defending or bashing the GPL, take it someplace else. Please. Ahmen! regards, tom lane ---(end of broadcast)-

[GENERAL] CASE tools

2003-09-26 Thread Iassen Hristov
FYI I have found 2 CASE tools that support PostgreSQL CASE Studio 2 DDS-Lite However, they are both for Windows. Can you point me to others? Hopefully multi-platform ones. --- Iassen Hristov ---(