Re: [GENERAL] stored procedure revisited

On Wed, 13 Oct 1999, amy cheng wrote: fact that it doesn't do something that most, if not all, commercially available db systems do can work against us, i.e., portability and upgradability: imagine you want to change that M$ system into Pg, or, I hate to say this, but somehow if your

Re: [GENERAL] stored procedure revisited

On Tue, 12 Oct 1999, Yin-So Chen wrote: [snip] I don't know how SP is implemented since none of the commercial RDBMS publishes their sources, but they've all claimed that SP saves parsing time and saves query plan time (it's generated once and stored). Need some database experts to verify

Re: [GENERAL] Connect PostgreSQL 6.0 Server with php4b

Moin, thank you for your reply but the problem remain. The fallowing line is in my pg_hba.conf: host moon192.168.153.0 255.255.255.0 trust The hole network with the given number has access to the database moon. The Webserver has the IP 192.168.153.9. But the no connection

Re: [GENERAL] questing using array

You might want to look into the contrib/array directory which has _some_ helpers with arrays. But in general, using arrays in cases like yours is a bad idea because, a) It has nothing to do with relational database design b) Arrays were not designed for this kind of stuff, so you won't get very

Re: [GENERAL] stored procedure revisited

Howie wrote: actually, one would hope that the system has its db independence in the application layer rather than the database layer. for instance, using something like NeXT's Enterprise Objects Framework to fetch rows from the db and translate the rows into objects, you only deal with

Re: [GENERAL] How do I activate and change the postgres user'spassword?

On Oct 13, Lincoln Yeoh mentioned: Then I have problems logging in as ANY user. Couldn't figure out what the default password for the postgres user was. Only after some messing around I found that I could log on as the postgres user with the password \N. Not obvious, at least to me. There

Re: [GENERAL] stored procedure revisited

Peter Mount wrote: Well, for me it would allow the current kludge that the JDBC driver uses for PreparedStatement. Having SP would allow that class to temporarily store the procedure, then only the data would need to be transfered to the backend. This would improve the majority of JDBC

Re: [GENERAL] stored procedure revisited

1) EOF is an app server that complys corba/tkom/ejb, or it is another "standard"? if the latter, it should/will die! (I wish tkom die also, seems impossble now though :-( 2) app tier is good, but if SP is forbidden, the cost is that you have to write or buy more for things that comes with dbms

Re: [HACKERS] Re: [GENERAL] How do I activate and change the postgresuser's password?

On Oct 13, Lincoln Yeoh mentioned: Then I have problems logging in as ANY user. Couldn't figure out what the default password for the postgres user was. Only after some messing around I found that I could log on as the postgres user with the password \N. Not obvious, at least to me.

Re: [HACKERS] Re: [GENERAL] How do I activate and change the postgres user's password?

Hi, followin this thread, I think It would be useful to allow user to connect to database he owned (created) without password even if pg_hba.conf is configured with password requirement to this database. Or owner of database could maintain list of users/groups whom he granted trusted connection.

Re: [HACKERS] Re: [GENERAL] How do I activate and change the postgresuser'spassword?

Bruce Momjian wrote: There is a todo item for the postgres user to have a password by default. I'm not sure though how that would be done. Probably in initdb. (?) We could enabled it as part of initdb. Prompt them for it there, and assign it. Seems like there should be one on that

Re: [GENERAL] stored procedure revisited

amy cheng wrote: C is good, and in a sense, for OSS we should encourage more C "scripting" and "hacking" than script scripting. (perl and PL/pgSQL actually is "bad" in this sense). Because IF everybody use C, the use and development will inherently related and the dev. speed will accelate

Re: [GENERAL] stored procedure revisited

datamart is important for web. That is why HISTORICALLY, mySQL is so popular. BTW, I withdraw the opinion on mySQL, IMHO, it is too limited, no mention its not-generous-enough license. IF I have time, I will do it myself *sigh*. From: Yin-So Chen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject:

[GENERAL] Can you write into a view?

Hello, I'm a new into the postgres's world, and I was seeing the User's Guide from V.6.4 and I saw that you can write into a View. In the new versions can you? If not, have any body any idea of when it would be reality? Thanks Fernando Dougnac =

[GENERAL] insert explanation

Dear all, mydb= create table rtext (rtext varchar(10)); CREATE mydb= insert into rtext values ('hello'); INSERT 17681 1 What do "17681" and "1" mean? Could someone help me to understand this please? Regards, Chai

[GENERAL] FATAL 1: palloc failure: memory exhausted

Hi, My php3 interface to postgres6.4 on BSDI 3.0 intel machine says: Warning: PostgresSQL query failed: pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. in /usr/home/jrh/public_html/cam/cam.php3

[GENERAL] FATAL 1: palloc failure: memory exhausted

Hi, Sorry, RTFM Have a nice day JohnH

Re: [GENERAL] insert explanation

On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote: Dear all, mydb= create table rtext (rtext varchar(10)); CREATE mydb= insert into rtext values ('hello'); INSERT 17681 1 What do "17681" and "1" mean? Could someone help me to understand this please? Regards, Chai 17681: oid

Re: [GENERAL] insert explanation

Simon Drabble wrote: On Thu, 14 Oct 1999, Chairudin Sentosa Harjo wrote: Dear all, mydb= create table rtext (rtext varchar(10)); CREATE mydb= insert into rtext values ('hello'); INSERT 17681 1 What do "17681" and "1" mean? Could someone help me to understand this please?