On Fri, 4 May 2001, Robert wrote:
> I write the same application for the same reasons - we're three
> partners and we all want to be able to create invoices and also see what
> others create.
Have you looked at SQL-Ledger? THough I disagree with some of the
table designs it is a pretty good
> Possibly you are running into the LIKE-at-end-of-memory bug identified
> last July (see rev 1.37 at
> http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/utils/adt/like.c).
> Please update to 7.0.3 ... or even better, 7.1, but 7.0.3 wouldn't force
> you into a database dump/reload ... and
On Fri, 4 May 2001, Roderick A. Anderson wrote:
> On Fri, 4 May 2001, Robert wrote:
>
> > I write the same application for the same reasons - we're three
> > partners and we all want to be able to create invoices and also see what
> > others create.
>
> Have you looked at SQL-Ledger? THough I
On 4 May 2001, Tony Grant wrote:
> On 03 May 2001 17:05:44 -0700, Paul Ramsey wrote:
> >
> > There are a couple good solutions to this:
> > - use PDFLib to generate printable format directly then pipe it directly
> > to the browser. There are PHPLib hooks in PHP and also a perl module
> > which h
Hi Guys,
I don't know if this has any bearing, but I remember someone recently
saying that Sun's JDK 1.3 has a memory leak bug in one of it's releases,
and our JDBC driver is affected by that.
Not sure of it's present status though.
Regards and best wishes,
Justin Clift
Doug McNaught wrote:
>
> "RH" == Robert Hentosh <[EMAIL PROTECTED]> writes:
RH> select * from t1 where (sel_a & b'11' <> b'00' );
Yep. That solution hit me just as the head hit the pillow last night,
too!
Thanks.
---(end of broadcast)---
TIP 1: subscribe a
On 04 May 2001 23:38:04 +1000, Justin Clift wrote:
> When I checked the Promise site about a week and a half ago, there
> wasn't any mention of Linux support, and doing a quick search for it
> around the Net didn't find any Linux support for this controller either.
>
> Does anyone know of workin
Here is all the information about the system and the steps I took. If you
can tell me or point me in the right direction I would appreciate it. There
are 624306 records in this table, so it only takes a few seconds, but this
is going to grow to 5M rows/month when this works properly.
Clinton Jam
=?iso-8859-1?Q?Micha=EBl_Fiey?= <[EMAIL PROTECTED]> writes:
> I have a problem with a case sensitive 'order by'.
> On my development platform, the 'order by' clauses are insensitive
Apparently you've discovered a feature that the developers didn't know
existed ;-). Seriously, I don't think I bel
Vince Vielhaber wrote:
>
> On Fri, 4 May 2001, Roderick A. Anderson wrote:
>
> > On Fri, 4 May 2001, Robert wrote:
> >
> > > I write the same application for the same reasons - we're three
> > > partners and we all want to be able to create invoices and also see what
> > > others create.
> >
>
On 04 May 2001 23:32:12 +1000, Justin Clift wrote:
> I don't know if this has any bearing, but I remember someone recently
> saying that Sun's JDK 1.3 has a memory leak bug in one of it's releases,
> and our JDBC driver is affected by that.
JDK1.3.0_2 fixed that for me. When I moved from 7.0.3 t
Dariusz Pietrzak <[EMAIL PROTECTED]> writes:
> but select oid FROM "jednostka" where "brcd" = 222; works fine. for
> update clause makes the difference.
What PG version is this?
regards, tom lane
---(end of broadcast)---
T
Maybe someone will know what's going on here.
I'm running 7.1 and vacuuming the db regularly at 4am each day. But
these last few days as it vacuums it hangs reaping dead processes.
2001-05-04 04:00:09 [27285] DEBUG: --Relation personnel--
2001-05-04 04:00:09 [27285] DEBUG: Pages 0: Changed 0
> As for those OS wars - are there any serious Linux sysadmins who don't
> have a copy of "Linux System Security" next to the server?
I run Linux on everything, and I don't have a copy of that book next to
any of my machines. Then again, I don't run Redhat.
John
--
# John Madden [EMAIL
> "BM" == Bruce Momjian <[EMAIL PROTECTED]> writes:
BM> [ Charset ISO-8859-1 unsupported, converting... ]
>> I think I heard about a script that would convert mysql dump files to Pgsql
>> dumps. Can someone remind me where they are?
BM> In 7.1 /contrib.
I started with trying several script
"Clinton James" <[EMAIL PROTECTED]> writes:
> # explain select * from ld where cust_num = '10102899';
> NOTICE: QUERY PLAN:
> Seq Scan on ld (cost=0.00..20810.83 rows=8989 width=128)
The reason it's not using an indexscan is that it thinks it's going to
find 8989 matches (and if that were true
Tony Grant wrote:
>
> On 04 May 2001 23:32:12 +1000, Justin Clift wrote:
>
> > I don't know if this has any bearing, but I remember someone recently
> > saying that Sun's JDK 1.3 has a memory leak bug in one of it's releases,
> > and our JDBC driver is affected by that.
>
> JDK1.3.0_2 fixed tha
> > A note about SCSI vs IDE... I have recently tried both on a dual
P3 with
> > 1gb of ram running Mandrake 7.2. I was amazed the idle CPU's were
> > running near 20-23% with nothing other then a bash shell running
on 2
> > IBM IDE ATA 100 drives. I converted to 2 IBM SCSI U2 drives and
the idle
Ashley Clark <[EMAIL PROTECTED]> writes:
> 2001-05-04 04:00:09 [27285] DEBUG: Analyzing...
> /usr/lib/postgresql/bin/postmaster: reaping dead processes...
> /usr/lib/postgresql/bin/postmaster: CleanupProc: pid 27299 exited with stat=
> us 0
> /usr/lib/postgresql/bin/postmaster: reaping dead proc
"Clinton James" <[EMAIL PROTECTED]> writes:
> True, using a different cust_num, it is possible there may be a couple of
> cust_num where that would be true. The majority will not have even near
> that many. In this case there are only 13 matching records. Is VACUUMDB
> ANALYZE using the worst cas
> > As for those OS wars - are there any serious Linux sysadmins who
don't
> > have a copy of "Linux System Security" next to the server?
>
> I run Linux on everything, and I don't have a copy of that book next
to
> any of my machines. Then again, I don't run Redhat.
I don't have a copy of it ei
>
>Raymond Chui <[EMAIL PROTECTED]> wrote:
>> 2) Use batched update. Requires a JDBC 2 compliant driver.
>> The purpose is to reduce the number of server roundtrips.
>What is batched update?
PreparedStatement.addBatch() and PreparedStatement.executeBatch().
Something like this:
PreparedStat
Folks,
I am new to postgresql 7.1 and like what I see so far. How is datetime
arithmatic performed in postgres. I have a table with start date/time
and end date/time(datetime data type) fields and want to set the default
end time to 1 hour later than the start time. Is there a way to d
hello
is there a human readable tutorial on how to install postgresql on windows
platforms? i have no clue what cygwin is, but when i download it, it
downloads a bunch of other stuff on my machine! how do i know what i have to
choose in order to be able to install postgresql later?
thanks/erick
There is a Slashdot article and discussion about OO database vs.
relational databases. They mentioned OID right at the beginning.
They guy mentions six advantages of OO databases and only one
disadvantage, but it is an interesting read to see how the PostgreSQL
features match some of the OO feat
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, May 04, 2001 at 09:57:02AM -0400,
Tom Lane <[EMAIL PROTECTED]> wrote:
> =?iso-8859-1?Q?Micha=EBl_Fiey?= <[EMAIL PROTECTED]> writes:
> > I have a problem with a case sensitive 'order by'.
> > On my development platform, the 'order by' clauses are insensitive
Could this be a locale issue?
"Othman Laraki" <[EMAIL PROTECTED]> writes:
> For the running out of memory part, there seem to be two aspects to it:
> 1) I tried running the application on a separate machine to make sure that
> it was not my code that was eating up all the memory but that did not help.
> However, I suspe
Hi all,
I'm wondering if anyone has scripts or knows of any tools which will detect
the next DST change, and setup a cronjob to be run just before it?
This is so we can have certain types of data which are stored in the database
as localtime, updated to still be correct during DST and after.
On Fri, 27 Apr 2001 01:34:45 + (UTC), [EMAIL PROTECTED]
(Justin Clift) wrote:
>Hi guys,
>
>Does anyone have experience with report writers? It's not something I
>know much about yet.
>
>Regards and best wishes,
>
>Justin Clift
Please have a look at ReportLab. The free API will almost certa
Bill Barnes wrote:
>
> Does anyone know of a package for 7.0.3 or 7.1 that
> will install in SuSE's latest release.
>
> How about the Red Hat 7.1 RPMS?
>
I work with Suse 6.4, but installed PostgreSQL 7.0.3 and later 7.1 quite
easily from source. So if waiting for a RPM is holding you, I'd s
On Wed, 2 May 2001, sathya wrote:
> If possible kindly get me any alternate methods to get it done.
>
> My platforms are
> Visual Basic, SQL server.
An excellent alternative method to getting this done would be:
1) Delete SQL server from your system.
2) Install PostgreSQL, a very nice
Setup is postres on one machine, java client on another, very simple code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class SimpleConnection {
static public void main (String args[]) {
Connection connection = null;
if (ar
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 get this error when trying to start postgres with a block size > the
default of 64...
[postgres@roam pgsql]$ /usr/local/pgsql/bin/postmaster -B 2000 -D
/usr/local/pgsql/data
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
size=33652736, permission=600
This type of error is usuall
hallo,
i am using php with postgres and using open a persistent connection.
But the limit on open connection is reached very fast, because the idle
connection aren't close.
My question:
How can idle connection automatically closed ?
thanks
Torsten Krämer
---(end of
Jeff Meeks wrote:
>
> Hi,
> I am trying to join 3 tables
> with this query
> select a.id, a.name, sum(b.qty), sum(c.qty)
> from a, b, c
> where a.id=xxx and b.id=a.id and c.id=a.id
>
> what the sums that get returned look as if they are a cross products of
> the
> I have 4 columns in a table, id, sub_id, timestamp and value.
> The primary key is id, sub_id and timestamp combine.
> I need to insert many rows (may be 10 thousands every 4 minutes)
> as fast as I can to the same host, same port, same database, same table.
Hi Raymond,
you might like to consi
I'm trying to store anywhere from a few words to a half page of text as a
field in my table. A fellow db programmer told me that better than using a
varchar is to break the message up into n pieces of size m (let's say m=100),
and make n (or n+1) varchar(m)s, and relate them together.
He is
On Fri, 4 May 2001 [EMAIL PROTECTED] wrote:
> It _is_ quite trivial to write a safe perl
> trigger especially because I control both client
> and server end of postgres. With C it
> will be whole new game for me.
I didn't quite follow the original explanation
of what you're doing, but the safen
Hi!
What is the format of data type money? I tried 0.00 0,00 $0.00 ... and
tied :)
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can
Hallo!
> How do I create an autoincrement field in a postgresql table???
> What are the correct field type and parameters
Well, what about using sequences?
create sequence tralalala;
create table huibui
(
id integer primary key default nextval('tralalala'),
field1 references table1,
and
Hi all,
I'm trying to figure out how DST change times will affect a running database?
For example, if I'm running a PostgreSQL 7.1 server through a DST changeover
period, how does the database handle this?
Apparently linux automatically does some kind of update during the changeover
period, b
You *really* should go glance over the manual.. There is the field type
SERIAL and things called sequences, both could be what you're talking
aboutThe rest I'll leave up to you :-)
Good luck!!!
-Mitch
- Original Message -
From: "Clay & Judi Kinney" <[EMAIL PROTECTED]>
To: <[EMAIL PR
On Fri, May 04, 2001 at 12:59:54PM -0700, Stephan Szabo wrote:
> The problem is that you have the problem in reverse then, unless what's
> done by the trigger is "optional" sortof. What happens if there is an
> error, and you can't do the outside operation? You once again end up
> out of sync wit
James Thornton wrote:
> I get this error when trying to start postgres with a block size > the
> default of 64...
>
> [postgres@roam pgsql]$ /usr/local/pgsql/bin/postmaster -B 2000 -D
> /usr/local/pgsql/data
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> size=33652736, permiss
People, saying that it is easy to install Pg on NT
using Cygwin environment does not assume that *using*
Pg on win32 can be done the way a MS product is
-- that is, clicking on an icon and playing with the
toy without never ever reading any doc.
You must initb, then create your databases, etc. Do
What do the commit_delay and commit_siblings options do?
I am unable to find any documentation on them in Chap 3 or 9
of the Admin manual or in the man page for postmaster.
--
John CoersIntrinsity, Inc.
[EMAIL PROTECTED] Austin, Texas
---(end of br
Clay & Judi Kinney writes:
> How do I create an autoincrement field in a postgresql table???
See FAQ.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
John Coers wrote:
>
> What do the commit_delay and commit_siblings options do?
>
> I am unable to find any documentation on them in Chap 3 or 9
> of the Admin manual or in the man page for postmaster.
>
> --
> John CoersIntrinsity, Inc.
> [EMAIL PROTECTED] Austin, Texas
D'oh! I
On Tue, 1 May 2001, Clay & Judi Kinney wrote:
> How do I create an autoincrement field in a postgresql table???
>
> What are the correct field type and parameters
>
> Any help would be appreciated.
CREATE TABLE foo (
id SERIAL,
...
)
it comes out as an int4 or integer type.
--
J
> I'm trying to store anywhere from a few words to a half page of text as a
> field in my table. A fellow db programmer told me that better than using a
> varchar is to break the message up into n pieces of size m (let's say
m=100),
>
> and make n (or n+1) varchar(m)s, and relate them together.
I
On Fri, 4 May 2001, Chris Jones wrote:
> On Fri, May 04, 2001 at 12:59:54PM -0700, Stephan Szabo wrote:
>
> > The problem is that you have the problem in reverse then, unless what's
> > done by the trigger is "optional" sortof. What happens if there is an
> > error, and you can't do the outside
On Fri, May 04, 2001 at 12:47:02PM -0400, Joel Burton wrote:
>
> Hmmm... this raises an interesting question.
>
> Would it be possible to hook into (via trigger or other mechanism) so that
> we could execute a function on commit? There are PG triggers to do things
> like send email, etc., which,
Bill <[EMAIL PROTECTED]> writes:
> I have some data in dBase III compatible files (created with Alpha
> Four, v4) that I want to move to Postgresql. I have already read the
> Admin pages of the manual and didn't see anything that would point
> the way.
>
> Does anyone else have any suggestio
* Tom Lane in "Re: VACUUM is hanging" dated 2001/05/04 22:05 wrote:
> > I also seem to have found the culprit. I have Apache::DBI set up
> > and it's holding something open. Restarting Apache let the vacuum
> > finish normally.
>
> Try not to leave open transactions hanging around in your Apache
> Try not to leave open transactions hanging around in your Apache code.
> An idle database connection couldn't block VACUUM like that; it'd have
> to have been in the middle of a BEGIN block, or maybe even an unfinished
> query.
It's possible that the JDBC library always creates a new transactio
Ashley Clark <[EMAIL PROTECTED]> writes:
>> Try not to leave open transactions hanging around in your Apache
>> code. An idle database connection couldn't block VACUUM like that;
>> it'd have to have been in the middle of a BEGIN block, or maybe even
>> an unfinished query.
> That appears to be t
Hi John,
> Try to do this...
>
> SELECT * FROM pg_language ;
>
yes i've already done this
> If you don't have plpgsql listed in there.. Then I would suggest that
> you put it in the table...;-)
and yes i don't have it
>
> via
>
> CREATE PROCEDURAL LANGUAGE 'PL/PGSQL' or something..;-)
>
b
On Fri, May 04, 2001 at 09:44:10PM -0500, Ashley Clark wrote:
> * Tom Lane in "Re: VACUUM is hanging" dated 2001/05/04 22:05 wrote:
>
> > > I also seem to have found the culprit. I have Apache::DBI set up
> > > and it's holding something open. Restarting Apache let the vacuum
> > > finish normall
"Muhammad Rusydi" <[EMAIL PROTECTED]> writes:
> > CREATE PROCEDURAL LANGUAGE 'PL/PGSQL' or something..;-)
> >
> but there's an error when i do this one
> parse error near ";" it says
> would you or anyone here help me again?
Easiest way to do this is to use the 'createlang' shell script that
sh
Hi,
if i have created this tables:
create table lab (
kd_lab varchar(4) check (kd_lab ~'[0][1-4][0-9][0-9]'),
name varchar(10),
primary key (kd_lab));
create table tb2 (
kd_lab varchar(4) references lab (kd_lab),
tb2 varchar(10),
primary key (kd_lab));
the questions is if i want to change the ch
[ Charset ISO-8859-1 unsupported, converting... ]
> > > Perhaps someone should write a platform-specific FAQ for Linux that
> > > answers this question, so that the link provided would actually be
> useful.
> >
> >
> http://www.ca.postgresql.org/devel-corner/docs/postgres/kernel-resources.h
> tm
> > Perhaps someone should write a platform-specific FAQ for Linux that
> > answers this question, so that the link provided would actually be
useful.
>
>
http://www.ca.postgresql.org/devel-corner/docs/postgres/kernel-resources.h
tml#SYSVIPC
Perhaps it should be put in the platform-specific F
Steve Wolfe writes:
> Perhaps someone should write a platform-specific FAQ for Linux that
> answers this question, so that the link provided would actually be useful.
http://www.ca.postgresql.org/devel-corner/docs/postgres/kernel-resources.html#SYSVIPC
--
Peter Eisentraut [EMAIL PROTECTED]
> I get this error when trying to start postgres with a block size > the
> default of 64...
>
> [postgres@roam pgsql]$ /usr/local/pgsql/bin/postmaster -B 2000 -D
> /usr/local/pgsql/data
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> size=33652736, permission=600
> This type of
66 matches
Mail list logo