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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
> >
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
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
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
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
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
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
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)
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
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
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
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
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
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
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 <<<<<<<&
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?
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
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
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
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
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
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
44 matches
Mail list logo