...
> Java stored procedures are the #1 most-desired-by-me feature for PostgreSQL.
> Oracle and Sybase are examples of databases that have this feature already.
...
How does java manage its resources when it is an embedded component?
When it is standalone, the Sun JDK seems to want to have a fixe
i've got it installed and running on osx on an imac :)
james
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECTED]>
To: "Israel Evans" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 31, 2001 1:17 PM
Subject: Re: PostgreSQL On the Mac? OS9 or OSX?
> Israel Ev
Shaun Thomas wrote:
>
> On Tue, 28 Aug 2001, Bhuvaneswari wrote:
>
> > hi,
> > I am getting the following error while doing vacuumdb,
> >
> > ERROR: mdopen: couldn't open test1: No such file or directory
> > vacuumdb: database vacuum failed on db1.
>
> We got this error a lot in 6.5. Usually i
I think you need to double the single quotes around the sequence name:
(''seq1'').
Statements inside function definitions go through an extra level of parsing,
which strips off one set of single quotes.
- Original Message -
From: "Ron S" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: M
> > 2) More importantly, is it possible to prevent a customer from peeking
into
> > said database once it is deployed on their machine?
ROT13 it, then threaten them with the DMCA.
(Yes, that was a joke.)
steve
---(end of broadcast)---
TIP
Before doing anything so drastic, you may want to check the archives for
recent messages on a similar error. IIRC, this problem can be caused by
rolling back a "drop table" command. The effect is that the table structure
in the database remains, but the physical file is gone.
The fix is to crea
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
Hi -
I set up a user and database using psql. Then when I added the DSN
connection for PgAdmin and tried it out with my new user id, it told me I
had to log in as superuser. So, I did. Then I disconnected and logged in
again as the new user I had created. The second time, it worked. Anybody
On Fri, Aug 31, 2001 at 08:59:53AM -0400, Mike Arace wrote:
> 2 questions:
I'll let someone else handle the first one.
> 2) More importantly, is it possible to prevent a customer from peeking into
> said database once it is deployed on their machine? A large part of what
> makes my applicatio
> we need to control database changes within BEFORE triggers.
> There is no problem with triggers called by update, but there is
> a problem with triggers called by insert.
>
> We strongly need to know the oid of a newly inserted tuple.
> In this case, we use tg_newtuple of the TriggerData struct
Israel Evans writes:
> In looking over the documentation, I haven't seen any evidence of PostgreSQL
> working on the Mac. Is this the case, or am I missing something.
You're missing something. ;-)
7.1 works on MacOS X. See the installation instructions.
--
Peter Eisentraut [EMAIL PROTECTE
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 Fri, Aug 31, 2001 at 08:59:53AM -0400,
Mike Arace <[EMAIL PROTECTED]> wrote:
>
> 2) More importantly, is it possible to prevent a customer from peeking into
> said database once it is deployed on their machine? A large part of what
> makes my application proprietary is the data model in t
On Tue, Aug 28, 2001 at 06:52:36AM -, satish rao wrote:
> Hi
>
> Entered below is the SQL create table syntax:
>
> CREATE TABLE lists (
> [listid] [int] IDENTITY (1, 1) NOT NULL ,
> [listname] [varchar] (200) NULL ,
> [listcreator] [varchar] (200) NULL ,
> [listdesc]
"Mike Arace" <[EMAIL PROTECTED]> writes:
> 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
"Lee Crampton" <[EMAIL PROTECTED]> writes:
> If anyone could supply me with a plpgsql.so for postgres 6.4.2 I would be
> very grateful indeed.
> I need it for my planned triggers to work and have tried a later version of
> the lib but it doesn't work.
Ummm, I hate to break it to you, but if ther
On Tue, 28 Aug 2001, Bhuvaneswari wrote:
> hi,
> I am getting the following error while doing vacuumdb,
>
> ERROR: mdopen: couldn't open test1: No such file or directory
> vacuumdb: database vacuum failed on db1.
We got this error a lot in 6.5. Usually it means your table has somehow
been corru
Israel Evans <[EMAIL PROTECTED]> writes:
> In looking over the documentation, I haven't seen any evidence of PostgreSQL
> working on the Mac. Is this the case, or am I missing something. Has
> anyone heard of it ever being used on a mac?
It runs on OS X just fine from what I've heard, thought
Sequential scans are always going to be faster than using the index if a
large number of rows are going to be returned. Consider this: if you
are doing regular DELETEs, will there be that many rows selected for
deletion each time? Probably not, so Postgres will most likely use the
index for tho
Indeed, on OSX.
http://www.pgmac.com
Israel Evans wrote:
>
> In looking over the documentation, I haven't seen any evidence of PostgreSQL
> working on the Mac. Is this the case, or am I missing something. Has
> anyone heard of it ever being used on a mac?
>
> Thanks,
>
> ~Israel~
>
> -
On Fri, 24 Aug 2001, uncleleo wrote:
> I am attemping to create multiple databases with Postgresql ver. 7.0.3
> running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0.
>
> Can someone tell me how I can connect to different databases in a single
> select statement? Such as,
I'm having a hard time not chuckling on this end as this response continues
to be received and then I think about the subject.
Geoff
-Original Message-
From: Alex Knight [mailto:[EMAIL PROTECTED]]
Sent: Sunday, August 26, 2001 4:08 PM
To: Gowey, Geoffrey; [EMAIL PROTECTED]
Subject: Re: [
> 2) More importantly, is it possible to prevent a customer from peeking
into
> said database once it is deployed on their machine? A large part of what
> makes my application proprietary is the data model in the database, and
it'd
> be tough to maintain a competative edge when everyone can see e
[EMAIL PROTECTED] writes:
> How can i create variable case data bases ?
Double quote the database name:
psql -c 'create database "MiXeD";'
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
> I've got a database where I've lost the WAL files. Since PG
> won't start with
> bad WAL files, is there anyway I can get the data out of the
> actual database
> files?
contrib/pg_resetxlog. Please read README.
Could you tell us how did you lose WAL files?
Vadim
Does anyone know of what market share Postgresql is in the RDBM market
including Mysql along with Oracle, msql, etc.?
Thanks
Matt
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi everybody ,
I' d like to know if there's a way to store the result
of a pl/pgsql function in a file (like the \w
command for the query buffer ).
Thanks .
___
Do You Yahoo!? -- Un e-mail gratuit @yahoo.fr !
Yahoo! Courrier : http://
On Thu, 30 Aug 2001, Christian MEUNIER wrote:
> got the following happened yesterday:
>
> postmaster: StreamConnection: accept: Too many open files in system
> postmaster: StreamConnection: accept: Too many open files in system
> postmaster: StreamConnection: accept: Too many open files in system
On Wed, 29 Aug 2001, A. Snelders wrote:
> I have the next problem:
>
> I open an table with
>
> select dnkey, Max(dvnaam) as dvnaam2, Max(dvpersoonnr) as dvpersoonnr from
> tbmedewerker
> group by dnkey
>
> When I want to locate like
>
> TblTbPGSMedew.Locate( 'dvnaam2', 'Hallo', [ ]);
>
My company had a old program with written by Powerbuilder. It work
fine in MSSQL 6.5.
Now, my boss required to use another SQL server. Someone told me
PostgreSQL is totally free and powerful. I installed it in a Linux
machine (RedHat 7 + PostgreSQL 7.1.2), and transfer the old data from
MSSQL 6.
Hello,
Here is 2 tables:
airport
-
airport_id
name
code
city_id
destination
---
destination_id
dest_name
...
airport_dep_id // using airport.airport_id (departure)
airport_arr_id // using airport.airport_id has well (arrival)
I have 2 columns in the second table that uses th
Hi,
I've got a database where I've lost the WAL files. Since PG won't start with
bad WAL files, is there anyway I can get the data out of the actual database
files?
Thanks
GB
--
GB Clark II | Roaming FreeBSD Admin
[EMAIL PROTECTED] | General Geek
CTHULU for Presiden
Hi,
I recently had a similar problem (7.1.2) and I suspect you are suffering
the same. It turned out to (probably) be a compiler optimzation problem.
I could do
select int4(4::int8/4::int8);
and it would work on a machine compiled under gcc 2.95.2 but failed with
"int8 conversion to in
>> -Original Message-
>> From: Dr. Evil [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, August 25, 2001 7:38 PM
>> To: [EMAIL PROTECTED]
>> Subject: [GENERAL] PL/java?
>>
>>
>> What do you think of having java as a procedural language available in
>> PG? It seems like java has many advantag
these 2 questions are actually unrelated...
1. what version of pg do i need to go to in order to eliminate the '16
parameter maximum' restraint?
2. can i pass an array of integers to a function? can i return an array of
integers? if so, what would the function definition look like?
thanks
Hi all,
I had create a database that encoded as unicode.
And then, I put some data into the database by two different
machine(win2000), but using different character set used, Traditional &
Simplified Chinese.
But I cannot read all chinese in right format. like, on traditional
windo
I have a sequence called seq1.
In psql I am trying to create a function which simply calls this
sequence with the nextval() function.
CREATE FUNCTION testid()
RETURNS INTEGER
AS 'SELECT NEXTVAL('seq1');'
LANGUAGE 'SQL';
I get the following error
ERROR: parser: parser error at or near "seq
In looking over the documentation, I haven't seen any evidence of PostgreSQL
working on the Mac. Is this the case, or am I missing something. Has
anyone heard of it ever being used on a mac?
Thanks,
~Israel~
---(end of broadcast)---
TIP 3:
Hi,
we would anyway use a microdrive. We have quite large DICOM images so
only a few would fit into RAMdisk/Flash on the iPAQ. We could use
DICOMDIR then although it's not very performant. Maybe this situtation
changes with 32MB of FlashROM and 64MB of RAM as proposed in future iPAQ
releases.
Ti
I have a table called session:
Table "session"
Attribute | Type | Modifier
+--+--
sessionid | character(32)| not null
usernumber | integer | not null
timestamp | timestamp with time
hi,
I am getting the following error while doing vacuumdb,
ERROR: mdopen: couldn't open test1: No such file or directory
vacuumdb: database vacuum failed on db1.
Here 'db1' is the database and 'test1' is a table. When, displaying the
structure of the
table 'test1', it comes correctly. But I can'
Whenever i create a database with command :
psql -h HostName -p PortName -c "create database DATABASENAME "
template1
The database is created with small case .
How can i create variable case data bases ?
regards
AMBIKA
---(end of broa
I am attemping to create multiple databases with Postgresql ver. 7.0.3
running on Mandrake 8.0 rpm. The tool that I am using is Pgadmin ver 7.1.0.
Can someone tell me how I can connect to different databases in a single
select statement? Such as, I have a database named "Customer" and another
n
I'm getting the following error from my application log file. I'm using
Postgres 7.1.2 running on HP-UX 11.0. These errors are results from our
Java servlet programs using the postgresql driver:
"Something unusual has occured to cause the driver to fail.
Please report this exception: java.sql.
There is an IRC channel already on EFnet... Visit #postgresql.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Gowey, Geoffrey
Sent: Saturday, August 25, 2001 8:35 PM
To: '[EMAIL PROTECTED]'
Subject: [GENERAL] speed of communication and pgsql development
I have a problem with apache authentication.
I recently upgrade to postgresql v7.1, upgrading debian distribution
(to woody, testing distribution)
and i discovered that the pakage for apache authentication is
no longer there.
(may be they suggest to use PAM instead)
This is really a problem for
Hi everyone,
I'm working on a (sorry) closed source application which consists of Java
servlets, beans, and client applications talking to a postgresql database.
Now, lets say I'm interested in bundling this all together and selling it to
customers.
2 questions:
1) Is it legal to bundle Pos
Hi!
Where I can find m4 macro for pgsql for auto* ?
Code reviews are like sex, just anyone can do it, but skill and training
can make you a lot better at it." - LJ
Thomas
---(end of broadcast)---
Hi
Entered below is the SQL create table syntax:
CREATE TABLE lists (
[listid] [int] IDENTITY (1, 1) NOT NULL ,
[listname] [varchar] (200) NULL ,
[listcreator] [varchar] (200) NULL ,
[listdesc] [text] NULL)
We need to know that this syntax will work properly in
I just finished reading Bruce M's book, so this thread confuses me,
esp. Jan's posts. I take full heed of the need for application level
user/thread management, but I was interested in using a parallel
set-up in PG (however redundant that might be). Now that Jan has
discounted "SELECT...FOR UPDA
Hi,
For reasons beyond my control I really need a binary version of Postgres
6.5.3. for WinNT. Could anyone please tell me where I can find it? I'd
compile it myself, but I have a lousy modem connection and downloading
the sources would take forever.
Any help will be appreciated. TIA ;-)
--
> It seems to me that SELECT ... FOR UPDATE is not the way to go if
> it is possible that the selected record may be held for any length
> of time.
But transactions are supposed to occur very quickly.
> For instance, say you are storing web pages in the database, and you
> want a number of devel
I have the next problem:
I open an table with
select dnkey, Max(dvnaam) as dvnaam2, Max(dvpersoonnr) as dvpersoonnr from
tbmedewerker
group by dnkey
When I want to locate like
TblTbPGSMedew.Locate( 'dvnaam2', 'Hallo', [ ]);
then 'Hallo' isn't find
but when I open the table without Max(
I am converting my PostgreSQL database to 7.1.2. I dumped my
database
out of the old server, then dumped it into the new one. Everything
takes
okay, but my Indexes are not working. When I do a "\d" it lists the
Name,
Type, and Owner, but when I try and do a \d on a specific table, I get
thi
You have to escape the ' inside of your function definition:
CREATE FUNCTION testid()
RETURNS INTEGER
AS 'SELECT nextval(\'seq1\');'
LANGUAGE 'SQL';
The quotationmark in front of seq1 terminated the literal string that
should contain your
SQL statement and the parser was confused to find an 's'
For one specific label:
select TableB.label from TableA, TableB where TableA.idA=TableB.idA and
TableA.name='test2';
To get a list of name-label pairs:
select TableA.name, TableB.label from TableA, TableB where TableA.idA=TableB.idA
order by TableA.name, TableB.label;
"G.L. Grobe" <[EMAIL
I keep hearing all this talk about Java being slow, and how compiled Java is
nearly as slow as interpreted languages... If Java was _that_ slow, do you
think it would be powering a majority of the Enterprise level sites out there?
Java is really more than just hype. Surely it isn't nearly as fast
I was thinking that for the application I'm
working on, it'd be nice to have a journal
(as an XML fragment) which describes the
interactions within the database...
3493
Clark
Evans
Cameron
I was wondering if anyone has done
something simi
yeah, by the way, doing dump/restore not such a bad thing, as mysql may
say. supporting old stuff is sometimes horrible. look at micro$oft,
which carries all the sh.t through its OSs...
--
Denis A. Doroshenko [GPRS engineer] .-._|_ |
[Omnitel Ltd., T.Sevcenkos st. 25,
how that can come, that table locking is faster than versioning? from
how i understand versioning it can't be slower. and saying that "possible
access problems" with table can be avoided be specially designing
application. God! i must design specially for mysql, being locking whole
tables.
this p
> I'm just wondering if people have thoughts or ideas on this, and if
> someone is actually working on it, that would be cool.
Why would that be cool? Because it's an OO language? If that's
the criteria for cool, check out pl/Ruby. It's a pure OO language (java
isn't) and is a joy to w
Corn wrote:
There is a comma missing. The Statement must be
CREATE TABLE usersright (
userid INTEGER NOT NULL,
rightid INTEGER NOT NULL,
allow BOOLEAN NOT NULL DEFAULT FALSE,
^^^
CONSTRAINT pk_usersright PRIMARY KEY (userid, rightid)
);
62 matches
Mail list logo
