Re: [GENERAL] Why is it not using the other processor?

2001-07-10 Thread Alex Pilosov
On Thu, 5 Jul 2001, Tom Lane wrote: > Ryan Mahoney <[EMAIL PROTECTED]> writes: > > Re: killing a process from browser, I don't think what you're trying to do > > is really possible. > > If the client-side code were programmed to send a Cancel request to the > backend when the user loses interes

Re: [GENERAL] Deployment of PostgreSQL Applications

2001-08-31 Thread Alex Pilosov
On Fri, 31 Aug 2001, Mike Arace wrote: > 1) Is it legal to bundle Postgresql with another commercial application, > assuming the database will have to be significantly reconfigured and tuned? > (at the application level, not the source code level) I read over the > licenses I could find on th

Re: [GENERAL] PL/java?

2001-08-31 Thread Alex Pilosov
On Thu, 30 Aug 2001, Marshall Spight wrote: > This was a major issue in 1996. It's been solved for several years now, but > the perception of Java having a speed problem remains. > > Java stored procedures are the #1 most-desired-by-me feature for PostgreSQL. > Oracle and Sybase are examples of

Re: [GENERAL] Ridicolus Postgresql review

2001-09-11 Thread Alex Pilosov
On 11 Sep 2001, Gunnar [iso-8859-1] Rønning wrote: > * Peter Eisentraut <[EMAIL PROTECTED]> wrote: > > | server. PostgreSQL supports both of these things just fine. A whole > | 'nother thing is the ability to return result sets from functions. > | > | OK, other vendors may call the latter for

Re: [GENERAL] Practical Cursors

2001-09-17 Thread Alex Pilosov
On Mon, 17 Sep 2001, Command Prompt, Inc. wrote: > However, using something like PHP will not allow this because HTTP is > stateless and PostgreSQL will not know from one transaction to the next > that the results of the connection are related. > > Is this truly the case, or is there a way for P

Re: [GENERAL] PostgreSQL capabilities

2000-05-31 Thread Alex Pilosov
It means Postgres can do a reliable backup (a consistent snapshot) of a database without shutting down the database. What you are asking for is replication, which is not easy to implement, and almost damn impossible to get it RIGHT. (*curse at both Sybase and Oracle replication servers*). (i.e.

Re: [GENERAL] PostgreSQL capabilities

2000-05-31 Thread Alex Pilosov
See archives of this mailing list. WAL is write-ahead logging, more conventional way of assuring atomicity. (I.E. before a transaction is written to database, it is written to transaction log, which can be replayed). Replication can be achieved by streaming transaction log toyour replicated compu

Re: [GENERAL] Re: Anyone using ReiserFS in production work? (oradvise against it?)

2000-07-05 Thread Alex Pilosov
On Tue, 4 Jul 2000 [EMAIL PROTECTED] wrote: > "Randall Parker" <[EMAIL PROTECTED]> writes: > > > The title says it all: Is this a foolhardy or prudent and wise move > > at this time? > > > > Has anyone run Postgres databases on ReiserFS volumes under heavy > > enough load and for long enough to

Re: [GENERAL] libperl.so

2000-08-06 Thread Alex Pilosov
Yeah, openbsd ld/ld.so for example will bitch and moan when its asked to do this. (nonPIC code loaded as so). So this is to be used as last resort. On Sat, 5 Aug 2000, Lamar Owen wrote: > Charles Tassell wrote: > > There is also a way to recompile a .a library into a shared > > library. Someth

Re: [GENERAL] Pg.pm question

2000-10-10 Thread Alex Pilosov
Have you ran 'make install' for Pg module? While you are on it, I'd suggest using DBD::Pg instead of Pg. -alex On Tue, 10 Oct 2000, KMiller wrote: > When I run a perl script named enc.pl I get this error. It looks like Pg.pm can't >resolve something when it reaches the line: bootstrap Pg $VE

Re: Re[2]: [GENERAL] Pg.pm question

2000-10-11 Thread Alex Pilosov
Then you probably didn't install the binary shared library (Pg.so) to the proper directory. On Wed, 11 Oct 2000, Kurt Miller wrote: > The code in question is Pg.pm > > The script is failing inside Pg.pm, not in the script that uses it. > > I tracked the error down to the line in Pg.pm that fa

Re: [GENERAL] CREATE FUNCTION LANGUAGE C

2000-10-11 Thread Alex Pilosov
Yes, that is why only superusers have access to 'create function language c' -alex On Wed, 11 Oct 2000, Marc SCHAEFER wrote: > Hi, > > CREATE FUNCTION LANGUAGE C (and maybe others) allow to load shared > libraries. However the path can be specified arbitrarily by the user. Is > that a way for

Re: [GENERAL] Re: [HACKERS] My new job

2000-10-12 Thread Alex Pilosov
On 13 Oct 2000, Gunnar R|nning wrote: > "Adam Lang" <[EMAIL PROTECTED]> writes: > > > May bad... sometimes it is too easy assuming everything open source is GPL. > > > > > > > correct?, so it can't really be proprietised unless they make an add-on > > Of course both lincenses can be the basis

Re: [GENERAL] PL/Perl compilation error

2000-10-17 Thread Alex Pilosov
On Tue, 17 Oct 2000, Tom Lane wrote: > Gilles DAROLD <[EMAIL PROTECTED]> writes: > >> The problem is this will break on older copies of Perl. > > > This problem is solved by perl itself ! > > Yeah, it is: there is a module called Devel::PPPort that isolates > user C code from the incompatibilit

Re: [GENERAL] Selects in server side functions

2000-10-27 Thread Alex Pilosov
On Fri, 27 Oct 2000, Neil Davis wrote: > Hello, > I am trying to figure out how to return more than one field using "SETOF". SETOF is to return more than one record, not more than one field. Also, SETOF is only currently working for SQL language functions. What you probably need is following: c

Re: [GENERAL] A question about PL/pgSQL

2000-10-27 Thread Alex Pilosov
On Fri, 27 Oct 2000, Warren Vanichuk wrote: > > Greetings. > > I am writting up a function in PL/pgSQL to automate a couple of multi-table > updates, and I have a question. > > I need to check to see if the data is already in the database, and if it is, > perform and update, or if it's not, pe

Re: [GENERAL] Conversion MySql -> PostgresSQL

2000-10-29 Thread Alex Pilosov
On Sat, 28 Oct 2000, William H. Geiger III wrote: > Hi, > > I am new to PostgreSQL and I am trying to convert a MySQL database over. > There are a couple of basics I need to clear up: > > On the numeric INT types can they be set to unsigned? I have 32-bit & > 64bit unsigned integers that I need

Re: [GENERAL] extra spaces

2000-12-14 Thread Alex Pilosov
Make your fields to be varchar(x), not char(x) -alex On Thu, 14 Dec 2000, Soma Interesting wrote: > I'm using PHP & PostgreSQL. > > All values called from the database are still padded with extra spaces from > the column size in the database. Is this normal - I don't remember this > happenin

DBD::Pg and NOTIFY (was Re: [GENERAL] Synchronous LISTEN/NOTIFY?)

2001-01-05 Thread Alex Pilosov
On Thu, 4 Jan 2001, Tom Lane wrote: > Lincoln Yeoh <[EMAIL PROTECTED]> writes: > > Uhoh, since I'm using perl does that mean I have to patch DBI and Pg::DBD? > > Couldn't say. I didn't have much trouble setting up a Tcl application > to work smoothly with NOTIFY events, but I've never tried suc

Re: [GENERAL] running pgsql 7 under Jail'ed virtual machine onFreeBSD 4.2

2001-01-05 Thread Alex Pilosov
Here's the story about pgsql and jail: 1. FreeBSD shared memory is _really_ shared across all jail VMs. I think its not going to change, as this seems like a great way for processes to exchange data...But I could be wrong. :) 2. Postgres uses some funky math to determine which shmid to use for d

[GENERAL] SHM ids (was running pgsql 7 under Jail'ed virtual machine on FreeBSD4.2)

2001-01-05 Thread Alex Pilosov
te the input... the best description so far from the pgsql > pov regarding the situation... have been working almost entirely from > the fbsd pov up until not and running out of options. May be a wash > for using pgsql in this situation. > > Dave > > -Original Message

Re: [GENERAL] SHM ids (was running pgsql 7 under Jail'ed virtualmachine on FreeBSD 4.2)

2001-01-05 Thread Alex Pilosov
On Fri, 5 Jan 2001, Tom Lane wrote: > Alex Pilosov <[EMAIL PROTECTED]> writes: > > I'd suggest you do this: add a global backend_shmid_offset in ipc.c, > > initialized to current default, and an option to postgres to put a value > > there. > > Don

Re: [GENERAL] SHM ids (was running pgsql 7 under Jail'ed virtualmachine on FreeBSD 4.2)

2001-01-05 Thread Alex Pilosov
What'd happen is: Operation not permitted (EPERM, -1), so its not a problem... -alex On Fri, 5 Jan 2001, Tom Lane wrote: > I said: > > Alex Pilosov <[EMAIL PROTECTED]> writes: > >> I'd suggest you do this: add a global backend_shmid_offset in ipc.c, > >

Re: [GENERAL] MySQL file system

2001-01-16 Thread Alex Pilosov
Hehe, very amusing. (albeit vaporware for now) I guess they want to it with KOrbit, and some software translating cobra->mysql (mysql doesn't have corba bindings yet, to my knowledge). The same should be possible with postgres, and it actually DOES have corba bindings (albeit they are broken AFA

Re: [GENERAL] MySQL -> pgsql

2001-01-20 Thread Alex Pilosov
My script does essentially the same thing, unfortunately, its hard to merge since we use different ways to "parse" the SQL. The script in contrib is good enough and not much different from what I have, so just keep it ;) -alex On Fri, 19 Jan 2001, Bruce Momjian wrote: > > We have added contrib

Re: [GENERAL] Too many open files! how do I fix on linux?

2001-01-26 Thread Alex Pilosov
On Fri, 26 Jan 2001, adb wrote: > I understand that I need to up the max number of open files in the linux > kernel but I'd like to know what's a good number to set it to for a high > traffic postgres server and what's the best way to set it in linux so > it's permanent? I set to 16384. with abou

Re: [GENERAL] Transactions inside plpgsql?

2001-01-28 Thread Alex Pilosov
Basically, answer is: you can't do it, no matter how you slice it, for a simple reason: postgres doesn't support nested transactions [yet?]. On Sun, 28 Jan 2001, Alan Turner wrote: > Hi > > I've been searching the web/mailing lists/web boards for the answer to a > question I have regarding pos

[GENERAL] PostgreSQL profiling?

2001-02-02 Thread Alex Pilosov
A quick question: Have someone made effort to do profiling of pgsql during execution of certain things (inserts, selects, sorting, indices)? I have a feeling (based on stopping postgres from gdb periodically), that a lot of time is used in strcoll() (if table and index has string columns). Col

Re: [GENERAL] recovery from media failure

2001-02-02 Thread Alex Pilosov
On Fri, 2 Feb 2001, adb wrote: > Is there any way to have up to the minute recovery from a disk > failure in postgres? RAID1? :) > Is there a timeframe for the recover from WAL feature? If you are asking if WAL logs can be reapplied to an database dump, the answer is currently no. I think it'd

plpgsql rowsupdated Re: [GENERAL] Verifying transaction success

2001-02-02 Thread Alex Pilosov
Not 'transaction'. If previous operation _failed_, you won't even get to next instruction. What you are asking whether previous statement updated any rows. I _think_ in 7.1 you can do that, but I don't remember how. -alex On Fri, 2 Feb 2001, Alfonso Peniche wrote: > Is there a way (in plpgsql)

Re: [GENERAL] Re: timestamp goober

2001-02-08 Thread Alex Pilosov
Yes, and that's a feature :) If you want a wall clock time, use timenow() -alex On Thu, 8 Feb 2001, Gregory Wood wrote: > > columns with default timestamp('now') see to be > > defaulting to the time I started posgresql! > > I noticed that timestamps (in my case CURRENT_TIMESTAMP) are taken fr

Re: [GENERAL] what's wrong with this query

2001-02-11 Thread Alex Pilosov
On Sun, 11 Feb 2001, Thomas T. Thai wrote: > still trying to port this app from mysql to pgsql, but getting this error: > > Database error: Invalid SQL: select > t_stories.heading,t_stories.rid,count(*) as cmts from t_stories,t_comments > where t_comments.toprid = t_stories.rid and t_stories.ve

Re: [GENERAL] last comma inside "CREATE TABLE ()" statements

2001-04-22 Thread Alex Pilosov
On Sun, 22 Apr 2001, Louis-David Mitterrand wrote: > Is it against the SQL standard to accept a trailing comma in a table > declaration? Yes it is. > CREATE TABLE "currency" ( > currency_id varchar(3), > rate float, < BOOM! parse error > ); > > As in perl, it would m

[GENERAL] semi-stupid question (index on OID)

2001-05-04 Thread Alex Pilosov
Hi, I though that searches on a table based on oid should be very fast (select * from table where oid=), however, this doesn't appear to be the case. My assumption was that essentially, if there is no clustering on the table, it is physically ordered by OID. Is that correct? Or vacuum may re

Re: [GENERAL] debugging Pl/Tcl

2001-05-04 Thread Alex Pilosov
On Fri, 4 May 2001, Andy Koch wrote: > Finally - I've asked this before - I've checked the "changes" list for > Postgres 7.1 because I'm wondering if maybe I can abandon Tcl for Perl - > but that would require that Postgres 7.1 supporting triggered pl/Perl > functions - and I see no mention of

[GENERAL] index doesn't work for null?

2001-05-15 Thread Alex Pilosov
I have a bit of a problem: 'select from xx where field=null' will always result in seq scan even when there's a [btree] index on the field. Is this a known issue? -alex ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [GENERAL] Re: index doesn't work for null?

2001-05-15 Thread Alex Pilosov
ent should be "select from xx where field IS NULL;". > > Perhaps it will be handled better (or not). > > Best regards > Per-Olof Pettersson > > >>>>>>>>>>>>>>>>>> Original Message <<<<<<<&

[GENERAL] binary data & LOBs

2000-03-04 Thread Alex Pilosov
Hi, Am I correct in impression that the only way you can store binary data (meaning data that could have all control characters including \0 in it) is using Large Objects interface? I have tried bytea and text, both truncate string on receipt of \0... Also, what's physical storage size of a LOB?

Re: [GENERAL] Date problem

2000-03-12 Thread Alex Pilosov
now() is a function, and you should use it as now() -alex On Sun, 12 Mar 2000, edNET System Admin wrote: > Hi, I'm trying to do something with dates which is proving to be a bit > tricky. > > I'm trying to get the current "date" and add 3 days to this. > > > I've tried: > > $date = "(now::d

Re: pg_recvbuf: unexpected EOF on client connection

2000-03-14 Thread Alex Pilosov
Sounds like you are running of filedescriptors That can be due to following factors: 1. Kernel limit is exhausted (not likely, i think default is 1024fds/process), and needs to be adjusted 2. You are exceeding your ulimit for fds. type ulimit -a and see what's it set to. 3. Postgres is leaking FDs

Re: [GENERAL] Performance Question ODBC vs C

2000-03-19 Thread Alex Pilosov
On Sun, 19 Mar 2000, martin wrote: > Hi there, I have been doing some performance testing with ODBC and have > found that > ODBC is much slower than using C to call the Psql API > I don't understand why the results are like this, I thought ODBC would > slow things down a bit but not my much, all

Re: [GENERAL] How to use bytea type?

2000-03-19 Thread Alex Pilosov
Afaik, not possible, at least I couldn't get any \0s into bytea column from psql nor from perl DBI interface. You need blobs if you want to store data which contains embedded nulls. Or so I think. -alex On Sun, 19 Mar 2000, Radhesh Mohandas wrote: > Hi, > Can somebody give me an example of

Re: [GENERAL] Connecting website with SQL-database.....

2000-04-18 Thread Alex Pilosov
On 18 Apr 2000, Manuel Lemos wrote: > I may be mistaken, but the last time that I looked at Perl DBI, it didn't > seem to a complete database abstraction layer than it is needed. For > instance, you want retrieve data from date fields the results come > formatted in a database dependent way. Th

Re: [GENERAL] plperl extensions

2000-05-23 Thread Alex Pilosov
On Tue, 23 May 2000, Louis-David Mitterrand wrote: > How mature is the plperl language for writing functions and triggers? You cannot write triggers in plperl yet. > Is it fast? (ie: does the interpreter pre-compiles functions and > persists?) Yes. -alex