Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
I'm not convinced that PLs are more tied to the core than say OpenFTS,
and if we can't maintain that kind of thing externally, then this whole
extension thing sounds like a failure to me.
It's *possible* to do it. Whether it's a net
Hi,
I'm experiencing some strange problems with a Java application which I
have made.
Suddently it looses connection with the database, and in the server log
i can find:
2005-04-02 00:09:01 ERROR: invalid string enlargement request size
1358954492
2005-04-02 00:09:01 WARNING:
- Original Message -
From: Zitan Broth [EMAIL PROTECTED]
To: Michael Fuhr [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Friday, April 01, 2005 9:00 PM
Subject: Re: [GENERAL] SELECT INTO Array?
Hi Michael,
Good question :-)
I am writing a function that has a row of data passed
In the past couple of years a lot of stuff has been removed from the
core - even the ODBC driver (which is ways more important than, let's
say, PL/PHP) has been removed from the core - so why should a new PL be
integrated now if considerably more important components will remain
external?
Greg Stark wrote:
Tom Lane [EMAIL PROTECTED] writes:
Alvaro Herrera [EMAIL PROTECTED] writes:
On Fri, Apr 01, 2005 at 10:14:07PM -0500, Paul Tillotson wrote:
...
Well, at that point you need to take a lock in order to be able to
manage locks. Managing not to step on your
pl-j ( the other java procedural language ) is definately interested in
being in core.
Dave
Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
On Fri, 1 Apr 2005, Joshua D. Drake wrote:
Are we interested in having plPHP in core?
Is there a reason why it can no longer
Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
Also, since plPerlNG is maintained on PgFoundry, are the changes you are
making to core getting migrated back to the main project itself?
I don't know, and not being a maintainer of the pgfoundry project,
it is *definitely* not my
Marc G. Fournier wrote:
One key point to note here is Joshua already saying they wish, like
plPerl, to continue maintaining the core code outside of the core
distribution ... the way I read that is they just want to be 'in core'
to piggy back on the distribution, not to make
Dave Cramer wrote:
pl-j ( the other java procedural language ) is definately interested
in being in core.
Is it actively developed? Not being rude... I just haven't heard much
(almost nothing) about it.
Sincerely,
Joshua D. Drake
Dave
Tom Lane wrote:
Marc G. Fournier [EMAIL PROTECTED] writes:
Hans-Jürgen Schönig wrote:
In the past couple of years a lot of stuff has been removed from the
core - even the ODBC driver (which is ways more important than, let's
say, PL/PHP) has been removed from the core - so why should a new PL
be integrated now if considerably more important components
On Fri, Apr 01, 2005 at 11:02:36PM -0500, Tom Lane wrote:
[Cc: to -hackers]
We currently store tuple locks on the same page as the tuples (ie, in
the tuple headers) and need no extra locks to do so. Certainly it
still has to have a spill mechanism, but the thought that is attractive
to me
Very actively, http://plj.codehaus.org
Dave
Joshua D. Drake wrote:
Dave Cramer wrote:
pl-j ( the other java procedural language ) is definately interested
in being in core.
Is it actively developed? Not being rude... I just haven't heard much
(almost nothing) about it.
Sincerely,
Joshua D.
Tom Lane [EMAIL PROTECTED] writes:
Greg Stark [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] writes:
I looked at Paul's first message and thought nah, that won't work
because ... because ... hmm ... hmmm ...
For what it's worth, this would be very similar to how Oracle handles
I'm using bit and bit varying datatypes to store chemical
fingerprints and need various functions to operate on
these datatypes. The logical operators (and, or, not)
and the shift operators, as well as length and octet-length
all work fine on bit types. I was hoping for a manual entry
that
=?UTF-8?B?UG91bCBNw7hsbGVyIEhhbnNlbg==?= [EMAIL PROTECTED] writes:
I'm experiencing some strange problems with a Java application which I
have made.
Suddently it looses connection with the database, and in the server log
i can find:
2005-04-02 00:09:01 ERROR: invalid string enlargement
2005-04-02 00:09:01 ERROR: invalid string enlargement request size
1358954492
2005-04-02 00:09:01 WARNING: AbortTransaction and not in in-progress
state
2005-04-02 00:09:01 FATAL: invalid frontend message type 82
This indicates the client code didn't follow the
On Sat, 2 Apr 2005, Joshua D. Drake wrote:
This argument doesn't hold too much weight. Namely because there are only
3-5 really popular languages out there. They are marketing languages.
The are languages you include because your database doesn't sound
complete with out them. Regardless if you
Thomas Hallgren wrote:
Tom Lane wrote:
are a few features shy of a load already. I'm pretty sure pl/r and
pl/java will need changes to support this feature too. If they were in
core CVS then I'd consider it part of my responsibility to fix 'em
... but they aren't, so it isn't my problem, so it
On Sat, 2 Apr 2005, Thomas Hallgren wrote:
b) I've been forced to do pull some tricks in PL/Java to work around things
that I consider lacking in the interfaces. Having PL/Java in core would make
it possible to work together more tightly in order to find good
solutions/API's that can benefit
On Sat, 2 Apr 2005, Dave Cramer wrote:
pl-j ( the other java procedural language ) is definately interested in
being in core.
Yet anothre good reason *not* to be including PLs ... similar to why we
moved libpq++ out of core ... I may be wrong, but I doubt that pl-j has
the same feature set as
Marc G. Fournier wrote:
d) Bringing PL/Java into core will force a consistent documentation
and, I imagine, a chapter of it's own in the main docs. I'm happy
to write most of it but English is not my native language. Whatever
I put into print will always benefit from a review.
There is
On Sat, 2005-04-02 at 21:48 +0200, Peter Eisentraut wrote:
Marc G. Fournier wrote:
d) Bringing PL/Java into core will force a consistent documentation
and, I imagine, a chapter of it's own in the main docs. I'm happy
to write most of it but English is not my native language. Whatever
please ignore
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Rod Taylor wrote:
There is nothing stopping additional links to documentation from
being added to the PostgreSQL website in the documentation section.
That is true, but that does not foster consistent documentation, which
is what Thomas Hallgren wanted.
--
Peter Eisentraut
Dear List,
I'm new to Psql and very eager to learn the differences between these two
RDBMS.
Any help is greatly appreciated.
Thanks
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 4/1/2005
Martha Stewart called it a Good Thing when [EMAIL PROTECTED] (YL) wrote:
Dear List,
I'm new to Psql and very eager to learn the differences between these two
RDBMS.
Well, you can find the documentation for PostgreSQL at
http://www.postgresql.org/, and you can find the documentation for
A significant difference, and something that might be frustrating, is
listing databases and database objects and describing tables. To list
databases, type
\l
...and hit RETURN. To list tables in the database you've logged in to, type
\dt
If you've got some familiarity with MySQL then querying
Clients aside, and as Christopher wrote, there are lots of differences
between the two systems. PostgreSQL supports higher-end Enterprise-level
RDBMS features. MySQL tends to be quicker. For example, and as just one
example, PostgreSQL can store and handle GIS data through PostGIS. MySQL's
On 03/31/2005 01:59:02 PM, Michael Fuhr wrote:
I think this has been fixed for 8.0.2:
http://archives.postgresql.org/pgsql-committers/2005-02/msg00012.php
Here's a test in 8.0.2beta1:
CREATE FUNCTION foo() RETURNS integer[] AS $$
DECLARE
y integer[];
BEGIN
y[1] := 1;
y[2] := 2;
I think he's trying to exploit ON UPDATE CASCADE so he can execute
a single UPDATE on the referenced table instead of having to write
multiple UPDATE statements, one for each referencing table. The
problem is that he's trying to change the referenced value from 2
to 1 but 1 already exists,
Howdy Gents-
I'm sure I'm having an oh duh! moment, but can anyone tell me what is going
on here.
I am multiplying two columns it doesn't matter what their data type is not does
it seem to matter if I explicitly cast these
values to some other data type every time they are multiplied I am
Dear list,
I'm new to pgsql and hope pgsql can solve my
problemswith mysql. Is there some documents
have comparisons between these 2
RDBMS?
I found mysql becomes unreasonablly slow when using
subqueries.
Thanks
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version:
Hi
I am Srikanth. I want to
get the information about all tables in the existing postgresql . I want list
all the tables and its columns information by executing a simple SQL statement like
in oracle. We have a view like user_tab_columns in oracle to get
all the information of the
[EMAIL PROTECTED] (Bruno Wolff III) writes:
Using domains is a good way to keep column constraints in just one place.
Speaking of domains, how do you find out what the range of a domain
is?
eg:
test=# create domain fruit as text
check( value in ('apple', 'orange', 'banana', 'pear'));
CREATE
Title: RE: [GENERAL] plperl doesn't release memory
The function is a little big, so i put it in an enclosure file.
The function write regularly in a file to empty the variable theClob. The fact the written is done all 10 has no signification, it's just to empty theClob before it's full.
I want sample ERP database schema and sample data.
I read from www.postgres.org news that Compriere is ported to Postgres.
I followed the link
http://www.e-evolution.com.mx/login.html
After filling 3 separate forms this site stops responding. Sometimes this
page it is not responding at all.
I
Florian,
Or you create a classifier_1 and a classifier_2 table, each containing
only the column code. Then you can drop the category1 and category2
fields from info, and just point the foreign keys to the correct table.
Thank you.
I will probably go by this way.
You can, optionally,
If there was idea to implement a .NET support in Windows version of PostgreSQL?
Like existing Pl/Java
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED]
Devrim GUNDUZ wrote:
PostgreSQL RPM Building Project[1] has built RPMs for 8.0.2beta1. RPMs
for Red Hat Linux 9, Red Hat Enterprise Linux Enterprise Server 3.0,
Fedora Cor 1,2,3 are now available, and more to come later.
Are the Fedora Core packages compatible with packages from Fedora Core
I just found out one strange behavior of the SQL engine. This may be
fixed.
table 1
create table table1 ( id integer, something text);
create table table2 (id integer, otherthing text);
select *
from table1 t1, table2 t2
where t1.id=table2.id;
-- here I made a mistake in the where clause I
You may add a product to the awards at:
http://www.sys-con.com/linux/readerschoice2004/addentry.cfm
Best Regards,
Robert
Joshua D. Drake wrote:
On Mon, 2005-03-28 at 11:03 -0700, Ed L. wrote:
On Thursday March 24 2005 7:07, [EMAIL PROTECTED] wrote:
Thank you
We have a system that archives data to a postgres database. The raw
data is confined to one table. Each record in the table is generally
1500 bytes. Each record is also associated with a volume name. During
normal operations, many millions of rows are written to this table.
After sometime
On Mar 28, 2005, at 1:40 PM, Joshua D. Drake wrote:
I don't see PostgreSQL either. That seems very odd as we are the second
widest used OSS database on Linux.
Yeah, they might as well just put up a graph of advertising dollars by
database instead of these poll results ;-)
Kevin Murphy
Hello,
I am trying to find a suitable FTI component.
I am aware of tsearch2, but as far as I understand it doesn't really suit my
purposes. I want to be able to run a search on a huge TEXT column, where the the
column's content is made of words (each 'word' is an email address) seperated by
I have a ODBC client which uses empty dates in its native data engine.
Unfortunately, empty data causes error if trying to store it.
This is serious Postgres limitation.
For a partial fix ODBC driver or postgres should convert empty dates to
NULLs automatically. This is better that producing
SELECT * FROM information_schema.tables;
SELECT * FROM information_schema.columns;
These should have most of the information you need.
Regards,
Paul Tillotson
Srikanth Utpala (Virinchi) wrote:
Hi
I am Srikanth. I want to get the information about all tables in the
existing postgresql . I want
On Sun, 27 Mar 2005 01:34:23 -0500, Madison Kelly [EMAIL PROTECTED] wrote:
Dan Sugalski wrote:
At 12:31 AM -0500 3/27/05, Madison Kelly wrote:
What I am trying to do is turn off autocommit for one particular
task in my program. I realize I can turn off AutoCommit when I connect
to the
You can query the information schema:
http://www.postgresql.org/docs/8.0/static/information-schema.html
More specifically:
http://www.postgresql.org/docs/8.0/static/infoschema-columns.html
Hope that answers your question.
Sean
- Original Message -
From:
Srikanth Utpala
Dave Horn [EMAIL PROTECTED] writes:
If I perform
select col1 * col2, 213.1086 * .833 from tableA
I get the following values
177.519464 and 177.583396
Works for me ... you *sure* it hasn't got something to do with the
datatypes you're using? Specifically, float4 is only good to about
six
Stanislaw Tristan wrote:
If there was idea to implement a .NET support in Windows version of
PostgreSQL? Like existing Pl/Java
We have a .Net client. You want server-side .Net? No one has ever
talked about that, sorry.
--
Bruce Momjian| http://candle.pha.pa.us
On Wed, Mar 30, 2005 at 02:46:37PM -0800, Kemin Zhou wrote:
I just found out one strange behavior of the SQL engine. This may be fixed.
table 1
create table table1 ( id integer, something text);
create table table2 (id integer, otherthing text);
select *
from table1 t1, table2 t2
- Original Message -
From: Avishai Weissberg [EMAIL PROTECTED]
To: pgsql-general@postgresql.org
Sent: Monday, March 28, 2005 2:00 PM
Subject: [GENERAL] general purpose full text indexing
Hello,
I am trying to find a suitable FTI component.
I am aware of tsearch2, but as far as I
On Sat, 2 Apr 2005, Bruce Momjian wrote:
Stanislaw Tristan wrote:
If there was idea to implement a .NET support in Windows version of PostgreSQL? Like existing Pl/Java
We have a .Net client. You want server-side .Net? No one has ever
talked about that, sorry.
not knowin gmuch about .Net ... what
On 3/30/05 12:09 PM, Adam Siegel [EMAIL PROTECTED] wrote:
How can we physically recover real disk space for the rows that were
deleted from the table?
vacuum full
Wes
---(end of broadcast)---
TIP 8: explain analyze is your friend
Marc G. Fournier wrote:
On Sat, 2 Apr 2005, Bruce Momjian wrote:
Stanislaw Tristan wrote:
If there was idea to implement a .NET support in Windows version of
PostgreSQL? Like existing Pl/Java
We have a .Net client. You want server-side .Net? No one has ever
talked about that,
On Sat, 2 Apr 2005, Bruce Momjian wrote:
Marc G. Fournier wrote:
On Sat, 2 Apr 2005, Bruce Momjian wrote:
Stanislaw Tristan wrote:
If there was idea to implement a .NET support in Windows version of PostgreSQL? Like existing Pl/Java
We have a .Net client. You want server-side .Net? No one has
On Fri, Apr 01, 2005 at 09:27:40AM -0700, Edmund Bacon wrote:
Speaking of domains, how do you find out what the range of a domain
is?
I'm not sure if there's a better way, but this appears to work:
SELECT pg_get_constraintdef(oid, TRUE)
FROM pg_constraint
WHERE contypid = 'fruit'::regtype;
d) Bringing PL/Java into core will force a consistent documentation
and, I imagine, a chapter of it's own in the main docs. I'm happy
to write most of it but English is not my native language. Whatever
I put into print will always benefit from a review.
There is nothing stop'ng a chapter being
[Originally sent to pgsql-committers; I'm replying to pgsql-general.]
On Tue, Mar 29, 2005 at 01:20:02AM -0800, joseph antonyraj wrote:
I need your help to copy a table from a table through copy command
using PostGresql command. Just for your information, both the tables
will exists and
I think he means PL C#
I thought I saw a project started for PL C# or PL Mono on Gborg.
not knowin gmuch about .Net ... what is a 'server-side .Net'? Like a
PL/.Net?
Marc G. Fournier Hub.Org Networking Services
(http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!:
[EMAIL PROTECTED] wrote:
On Sun, Mar 27, 2005 at 12:54:28AM -0600, Guy Rouillier wrote: []
The service_plane table is a reference table, i.e., a fixed set of
values used only to validate foreign keys. So the code doesn't have
any update statements on that table.
And idea that just came up
Adam Siegel wrote:
We have a system that archives data to a postgres database. The raw
data is confined to one table. Each record in the table is generally
1500 bytes. Each record is also associated with a volume name.
During normal operations, many millions of rows are written to this
62 matches
Mail list logo
