Re: Tru64 experience? Was Re: [GENERAL] [Fwd: PostGreSQL information]

2003-06-20 Thread Mark Kirkwood
I built and ran Pg on Tru64 about a year ago. I recall having to edit pg_ctl a bit... Does that count as experience? regards Mark Richard Huxton wrote: On Thursday 19 Jun 2003 12:23 pm, Justin Clift wrote: Hi everyone, Does someone feel like saying Hi to Brad here, and assisting him with

Re: [pgsql-advocacy] [GENERAL] MySQL gets $19.5 MM

2003-06-20 Thread Tom Lane
Michael Meskes <[EMAIL PROTECTED]> writes: [ quoting Andrew Sullivan ] >>> I disagree. I think what PostgreSQL really needs is a few companies >>> who are willing to underwrite a developer or two a piece. Or, maybe >>> more precisely, _several_ companies to do that. The only thing >>> currently

Re: [GENERAL] Unable to create or drop plpgsql

2003-06-20 Thread Tom Lane
"Jason Underdown" <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] jason]$ createlang plpgsql esi > ERROR: function plpgsql_call_handler already exists with same argument > types > createlang: language installation failed > [EMAIL PROTECTED] jason]$ > [EMAIL PROTECTED] jason]$ droplang plpgsql esi

Re: [GENERAL] dropping sequences

2003-06-20 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Fri, Jun 20, 2003 at 11:14:25AM -0600, scott.marlowe wrote: >> Actually, template0 is the "oh dear god, what have I done to template1" >> recovery database that the initdb script (now program) creates when run. > I think template0 is also used to co

Re: [GENERAL] Looking for PERL documentation (fwd)

2003-06-20 Thread Teresa Hasheminejad
On Fri, 20 Jun 2003, Andrew Perrin wrote: > You should read Bunce & Descartes' _Programming the Perl DBI_ which will > give you everything you need to get started. The relevant module is at > http://www.cpan.org/modules/by-module/DBD/DBD-Pg-1.22.tar.gz Thank you very much :)

Re: [GENERAL] Looking for PERL documentation (fwd)

2003-06-20 Thread Andrew Perrin
You should read Bunce & Descartes' _Programming the Perl DBI_ which will give you everything you need to get started. The relevant module is at http://www.cpan.org/modules/by-module/DBD/DBD-Pg-1.22.tar.gz Cheers, Andy -- Andrew J

[GENERAL] Looking for PERL documentation (fwd)

2003-06-20 Thread Teresa Hasheminejad
I am a new user of PostgreSQL. I have installed it and composed my database as required, however, I am interested in building a web interface with PERL, and I was hoping that someone out there has come across a PERL/PostgreSQL site that discusses how to make the two interact. I've looked at the do

Re: [GENERAL] debugging C functions

2003-06-20 Thread Tom Lane
"Nigel J. Andrews" <[EMAIL PROTECTED]> writes: > ... I might not have tried the LOAD then attach gdb sequence. I think you need the "sharedlibrary" command to get gdb to know the symbols in a shlib that was loaded into the process after gdb first attached to it. If you do the LOAD, then attach, y

Re: [pgsql-advocacy] [GENERAL] MySQL gets $19.5 MM

2003-06-20 Thread The Hermit Hacker
On Fri, 20 Jun 2003, Michael Meskes wrote: > There are some, but I still disagree. The biggest advantage of > PostgreSQL in my opinion has always been that it's a community project > and not driven by some commercial interests. I also do not agree that > IBM is so important for Linux. IBM helps ye

Re: [GENERAL] Database geeks

2003-06-20 Thread David Olbersen
Perhaps this is a result of the cost of failure? What I mean to say is that very often database apps have to deal with *huge* volumes of data. As such, you could end up wasting *hours* if your app doesn't work correctly. With PHP dev, for the most part, you refresh your browser to test. If it do

[GENERAL] Database geeks

2003-06-20 Thread Dennis Gearon
One thing I've noticed about this group versus the php group; You guys don't work 16 hours a day, or live, each, and s**t this subject, like the PHP guys do. I make the assumption that most of you are more mature, steady eddie types who do throrough planning in your projects and have less emergenc

[GENERAL] Unable to create or drop plpgsql

2003-06-20 Thread Jason Underdown
Hi everyone, This is my first post to this group, so please be kind. My database used to have support for plpgsql, that is I used the createlang command line tool to add the language to the database and then added functions, and they worked. Since then I have moved the database to a new machine

Re: [GENERAL] JDBC in PostgreSql for Linux

2003-06-20 Thread Dmitry Tkach
You've got your url wrong - it should be "://" after postrgesql instead of "@" I hope, it helps... Dima Kallol Nandi wrote: Hi, This is the code that I am using for native JDBC Driver to connect to PostgreSql in Linux. BTW the version of Postgres is 7.2.2 and the jar file is jdbc7.1-1.2.jar.

Re: [GENERAL] Sort memory not being released

2003-06-20 Thread Mike Castle
In article <[EMAIL PROTECTED]>, Jim C. Nasby <[EMAIL PROTECTED]> wrote: >Of course I wasn't planning on sucking down a bunch of memory and >holding on to it. :) What are you worried about? The unused portions will eventually be paged out to disk. On the next sort, you'll spend a little less time

Re: [GENERAL] [HACKERS] psql

2003-06-20 Thread Nailah Ogeer
Well here's the thing. Before i was trying to use ShmemInitStruct in buf_init.c. The problem with this is that you can't shrink or grow shared memory. That is why i switched over and just used malloc. So i seem to be in a big dilemma, on one hand, if i use malloc, i can't keep this info i need; and

Re: [GENERAL] [HACKERS] psql

2003-06-20 Thread Tom Lane
Nailah Ogeer <[EMAIL PROTECTED]> writes: > So what is happening is that i enter the relation ids into the BP cluster > linked list fine and every time i call psql, it automatically deletes. Sounds to me like you are trying to keep stuff in backend-local memory that needs to be in shared memory.

Re: [GENERAL] [HACKERS] psql

2003-06-20 Thread Nailah Ogeer
what i was trying to do was maintain an array of Buffer pool clusters. What i did previously was change the pointers around in the freelist so instead of one i have 4. Now each buffer pool is called a BP cluster. Within this BP cluster i have things like cluster id, freelist descriptor etc, and a l

[GENERAL] JDBC in PostgreSql for Linux

2003-06-20 Thread Kallol Nandi
I am running a Java application on Linux which connects to the Postgresql on Linux using jdbcodbc bridge. But this is the error I am getting : sun.jdbc.odbc.JdbcOdbcDriver java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver at 0x4028115f: java.lang.Throwable.Throwable(java.lang.Str

[GENERAL] Lotus Domino and PostgreSql in Linux

2003-06-20 Thread Kallol Nandi
I am running an agent in the domino server that connects to a database in Postgresql through odbc dsn. I am getting an error "Error Creating product object" at the line Set con = New ODBCConnection Here is the code : Option Public Uselsx "*LSXODBC" Sub Initialize Dim con As ODBCConnect

[GENERAL] Strange trouble with pg_dump import

2003-06-20 Thread Hervé Piedvache
Hi, Since two days we have a trouble with the importation of our database dump import ... In fact, it's not a real trouble of the import ... because there is not really any error message during the importation of the data ... But after we do some queries on the database ... and we, ONLY on all

Re: [GENERAL] A creepy story about dates. How to prevent it?

2003-06-20 Thread Peter Haworth
Tom Lane writes: > It would make sense to offer a "strict" mode in which the date order > has to be what DateStyle suggests. Something like this? set datestyle='iso,strict'; I could live with that. -- Peter Haworth [EMAIL PROTECTED] AD&D Lesson #4: In a Crisis, everyones' alignme

Re: [GENERAL] Getting one row for each subquery row...?

2003-06-20 Thread Nigel J. Andrews
[Damn, didn't notice the lack of list address in the headers until I'd already sent this reply. The OP's address is elsewhere in the thread, obviously.] On Fri, 20 Jun 2003, Együd Csaba wrote: > Thank you Nigel, > > > > > > > select > > > t_stockchanges.productid, > > > (select > > >

Re: [GENERAL] A creepy story about dates. How to prevent it?

2003-06-20 Thread Peter Eisentraut
Tom Lane writes: > It would make sense to offer a "strict" mode in which the date order > has to be what DateStyle suggests. I'm astonished that no one seems > to get the point that there are also good uses for "lax" parsing. There are different kinds of lax parsing. Lax parsing is great if you

Re: [GENERAL] Incremental backups, and backup history

2003-06-20 Thread Nigel J. Andrews
On Thu, 19 Jun 2003, Matthew Nuzum wrote: > Regarding backup history: > > I have an application designed for novices. Apparently it's easy to hit the > "Delete" button, and then say yes to the "Are you sure you want to delete > this?" question even when they don't want to. Therefore I simply mar

[GENERAL] How to get subscribe-nomail to working ?

2003-06-20 Thread Ivar
Hi, How to subscribe-nomail working or disable to send all messages to email ? Where is more info about newsgroup flags ? Sending subscribe-nomail newsgroup_ is rejected by server ??? Seems I'm only dumb who can't find it. ---(end of broadcast)---

Re: [GENERAL] Is there any way to make post to newsgroups faster ?

2003-06-20 Thread Ivar
Damn can't get working, all messages will come to email. "Ivar" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Testing "set nomail" > > "Ivar" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > Yee works ok > > > > "Ivar" <[EMAIL PROTECTED]> wrote in message >

Re: [GENERAL] Is there any way to make post to newsgroups faster ?

2003-06-20 Thread Ivar
Testing "set nomail" "Ivar" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Yee works ok > > "Ivar" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > Test > > > > "Jeff Eckermann" <[EMAIL PROTECTED]> wrote in message > > news:[EMAIL PROTECTED] > > > --- Ivar <[