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
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
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.
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...
insert table=person
id3493/id
givenClark/given
familyEvans/family
/insert
update table=person
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
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)
);
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
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
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
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
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
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'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:
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
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
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
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
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', [ ]);
then
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
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 file
command for the query buffer ).
Thanks .
___
Do You Yahoo!? -- Un e-mail gratuit @yahoo.fr !
Yahoo! Courrier :
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
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
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:
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
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~
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
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
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
-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 advantages.
I'm just
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
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
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
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
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 I
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
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 there's a
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 the
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] [text]
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 the
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
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
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 structure
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 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
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
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 6:
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:
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 Evans
48 matches
Mail list logo