[GENERAL] postmaster does not shut down

 when i grep for postmaster ps -aef | grep postmaster   it says: /usr/bin/postmaster -D /export/home1/sdc_image_pool/dbx -p 5432   when i try to stop postmaster doing   /usr/bin/pg_ctl -D /export/home1/sdc_image_pool/dbx/ stop the following is displayed: waiting for postmaster to shut down..

Re: [GENERAL] Query Question

SELECT c.name, w.ib, c.vbp, c.year_balance FROM clients c LEFT JOIN workers w ON (w.client_id = c.id) ; Will do the trick. BTW, I suggest not using 'bareword' id's for field names. It's very easy to get confused with larger queries. So instead of clients.id, do clients.client_id. I do

[GENERAL] DBLINK on WINDOWS?

Hi,   I am trying to get some information on using DBLINK on windows?    I am not having much luck searching the forums/google. Has anyone been using DBLINK on Windows. I am Using 8.03 on Windows 2000.   Ideally I would like to be able to send data from postgres to and from ODBC compliant

Re: [GENERAL] DBI/DBD::Pg mem. use goes exponential

Hi, You cannot actually say that "do" is more correct than prepare/execute (for a non-select statement), because "do" is just a shortcut. According to the DBI documentation, it does a prepare and execute for you. In fact, if you look at the DBI.pm code, that is what it is doing. I do agree that

Re: [GENERAL] insertion becoming slow

On Tue, Sep 27, 2005 at 03:09:43PM +0530, surabhi.ahuja wrote: > is it some logging information that is being written into some file at the > end of some transactions > (each intsall is one transaction for me) > > the data directory is containing these folders.. > > base/pg_clog/ pg_i

Re: [GENERAL] [SQL] add column if doesn't exist (fwd)

On Mon, Sep 26, 2005 at 07:16:53PM -0700, Qingqing Zhou wrote: > > ""Brandon Metcalf"" <[EMAIL PROTECTED]> wrote > > > > Is there a way to check for the existence of a column in a table other > > than, say, doing a SELECT on that column name and checking the output? > > > > Take a look at pg_attr

Re: [GENERAL] Performance woes relating to DISTINCT (I think)

On Tue, Sep 27, 2005 at 09:07:41AM -0500, boinger wrote: > -> Index Scan using strafe_group on tasks_applied > (cost=0.00..6.02 rows=1 width=22) (actual time=0.042..0.043 rows=0 > loops=1188) > > Index Cond: ((("outer".modcode)::text = > (tasks_applied.modcode):

Re: [GENERAL] DBI/DBD::Pg mem. use goes exponential

On Sep 29, 2005, at 1:23 PM, Keary Suska wrote: You should always finish() every "select" statement handle, or both DBI and libpq will leak: $sth->finish; after the closing bracket of the while() loop. No, you don't need to call finish() if you fall off the end of a while $sth->fet

Re: [GENERAL] Does copy abort on a failed insertion?

On Thu, 2005-09-29 at 14:28, Reid Thompson wrote: > If i have a pg_dump that is using COPY, and midway through the copy an > insert fails due to a unique constraint, will the COPY continue with the > rest of the records, or will it abort? If it aborts, will it perform a > rollback on the inserts u

[GENERAL] security documentation

The security documentation available in the official documentation is rather sparse. Is there a more detailed document I should be aware of? As an example, I'd like to prevent a a user from being able to get a list of existing databases. Presumably, I can limit access to various system catalogs to

Re: [GENERAL] pl/pgsql function debugging

am 29.09.2005, um 20:08:17 +0200 mailte Craig folgendes: > Hi > > What is the best tool for debugging pl/pgsql functions? > Any suggestions would be appreciated RAISE NOTICE 'foo %', bar; Read: http://www.postgresql.org/docs/8.0/static/plpgsql-structure.html Regards, Andreas -- Andreas Kretsc

Re: [GENERAL] pl/pgsql function debugging

On Thu, Sep 29, 2005 at 08:08:17PM +0200, Craig wrote: > Hi > > What is the best tool for debugging pl/pgsql functions? Any > suggestions would be appreciated For now, it's RAISE NOTICE aka "debugging by printf", and I'm checking out EMS HiTech's debugger, which is part of their toolset.

[GENERAL] Many-To-Many Bridge Table Index

Hi guys, I'd really appreciate if you could clarify this to me. Let's say I have a table named TABLE_A that is a bridge to many-to-many relationship between TABLE_B and TABLE_C, as such here is my declaration: CREATE TABLE table_a ( table_b_id INT4NOT NULL REF

Re: [GENERAL] 8.0.1 SRPM on RHEL v.3

Devrim GUNDUZ wrote: On Thu, 29 Sep 2005, Shane Dawalt wrote: I'm attempting to build the srpm (postgresql-8.0.1-2PGDG.src.rpm), but am running into a snag with krb5.h. The configure script doesn't see it although I have krb5-devel installed and the file exists in /usr/kerberos/include/. A

[GENERAL] Does copy abort on a failed insertion?

If i have a pg_dump that is using COPY, and midway through the copy an insert fails due to a unique constraint, will the COPY continue with the rest of the records, or will it abort? If it aborts, will it perform a rollback on the inserts up to that point? thanks, reid --

Re: [GENERAL] insertion becoming slow

On Tue, Sep 27, 2005 at 10:24:02AM +0200, Csaba Nagy wrote: > Hi all, > > I've recently asked a similar question, which received no useful answer > yet, so I'll drop in too. > > In my case, the table I was inserting to was a quite big one already to > start with (and analyzed so), so I was expect

[GENERAL] pl/pgsql function debugging

Hi   What is the best tool for debugging pl/pgsql functions? Any suggestions would be appreciated   Thanks Craig

Re: [GENERAL] How many insert + update should one transaction handle?

On Tue, Sep 27, 2005 at 01:34:37PM +0200, Yonatan Ben-Nes wrote: > >Based on http://lnk.nu/developer.postgresql.org/44b.c, line 1478 on, > >there's not a lot that happens during the ALTER TABLE. Likewise DROP > >(line 517) doesn't do much either. So basically, anything trying to > >access the old t

Re: [GENERAL] DBI/DBD::Pg mem. use goes exponential

on 9/29/05 6:38 AM, [EMAIL PROTECTED] purportedly said: > Any ideas please? This seems well weird to me, but... Assuming the code snippet is representative, a couple things: 1. $dbh->prepare($stmt)->execute () || die; This is mostly a point of protocol, but I can't resist pointing it out. Altho

Re: [GENERAL] Triggers after a rule

On 9/28/2005 5:44 AM, Wijnand Wiersma wrote: Hi list, I am currently trying to give normal users some read access to some tables in the database. I also need to give update access to one column of one table. I have the table contact, the user should not be able to read or update anything in it

Re: [GENERAL] How can I check if my cursor statement is using index

=?UTF-8?B?RHJhZ2FuIE1hdGnEhw==?= <[EMAIL PROTECTED]> writes: > I have a program that reads data from Postgresql database (version > 8.0.3) through ODBC, but data retrieval is pretty slow. When I type the > same SQL sentence in pgadmin III or any other sql tool it is much > faster, and typing 'ex

Re: [GENERAL] Perl regular expressions

> "Scott" == Scott Marlowe <[EMAIL PROTECTED]> writes: Scott> And you can use perl regex in PHP as well, since it supports the PCRE Scott> lib. Well, *almost* Perl. Despite its name, PCRE is a misnomer, since it's not really Perl and it's not entirely compatible. :) Yes, it's a powerful regu

Re: [GENERAL] 8.0.1 SRPM on RHEL v.3

Hi, On Thu, 29 Sep 2005, Shane Dawalt wrote: I'm attempting to build the srpm (postgresql-8.0.1-2PGDG.src.rpm), but am running into a snag with krb5.h. The configure script doesn't see it although I have krb5-devel installed and the file exists in /usr/kerberos/include/. Anyone have a clue w

[GENERAL] 8.0.1 SRPM on RHEL v.3

I'm attempting to build the srpm (postgresql-8.0.1-2PGDG.src.rpm), but am running into a snag with krb5.h. The configure script doesn't see it although I have krb5-devel installed and the file exists in /usr/kerberos/include/. Anyone have a clue what I should do? (I'm using rpmbuild --rebui

Re: [GENERAL] DBI/DBD::Pg mem. use goes exponential

On Sep 29, 2005, at 8:38 AM, Bob Parkinson wrote: Upgraded PG to 8.0.3, DBI to 1.48 and DBD::Pg to 1.43 this morning, but made no difference. FreeBSD 5.4 (they'll get it right RSN :- )), perl 5.8.2 I've had bad mem leaks on FreeBSD with perl < 5.8.6. Try upgrading that as well. --

Re: [GENERAL] Perl regular expressions

On Thu, 2005-09-29 at 08:30, Tino Wildenhain wrote: > A. Kretschmer schrieb: > > am 28.09.2005, um 22:25:29 - mailte [EMAIL PROTECTED] folgendes: > > > >>Is there any support for perl regular expressions > >>in Postgresql? > > > > > > Yes, you can use perl regex in plperl. > > http://www.po

Re: [GENERAL] Perl regular expressions

am 29.09.2005, um 9:14:39 -0400 mailte Sean Davis folgendes: > On 9/28/05 6:25 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > > Is there any support for perl regular expressions > > in Postgresql? > > You might want to look at this section of the documentation: > > http://www.postgresq

Re: [GENERAL] DBI/DBD::Pg mem. use goes exponential

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 > Any ideas please? This seems well weird to me, but... I could not duplicate this. Can you provide a self-contained test case? It's not useful if we don't know what's actually in the table and what the table structure looks like. - -- Greg Sabino

Re: [GENERAL] Problems creating view

On Thu, Sep 29, 2005 at 07:38:38AM -0300, Martín Marqués wrote: > Just for the record, and put some closure, today I finaly got unstable > packages for postgresql-8.0 (up to yesterday the unstable package was the > same as the testing one on SPARC) and this problem creating views is gone. > From

Re: [GENERAL] Perl regular expressions

A. Kretschmer schrieb: am 28.09.2005, um 22:25:29 - mailte [EMAIL PROTECTED] folgendes: Is there any support for perl regular expressions in Postgresql? Yes, you can use perl regex in plperl. http://www.postgresql.org/docs/current/static/plperl.html And in plpythonu too ;) Part of th

Re: [GENERAL] Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails

> Hi folks at pgsql.admin, > > I've Postgres 8.0.1 running natively under Windows XPpro SP2. > I would like to update to 8.0.3 using the upgrade-batchfile > coming with the zipped download file. > The installation stops when trying to install the service, > saying the Postgres 8.0 Database Serv

Re: [GENERAL] Perl regular expressions

On 9/28/05 6:25 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Is there any support for perl regular expressions > in Postgresql? You might want to look at this section of the documentation: http://www.postgresql.org/docs/8.0/interactive/functions-matching.html Sean

Re: [GENERAL] Perl regular expressions

am 28.09.2005, um 22:25:29 - mailte [EMAIL PROTECTED] folgendes: > Is there any support for perl regular expressions > in Postgresql? Yes, you can use perl regex in plperl. http://www.postgresql.org/docs/current/static/plperl.html Regards, Andreas -- Andreas Kretschmer(Kontakt: siehe H

[GENERAL] Postgres/Win32- Upgrade from 8.0.1 to 8.0.3 fails

Hi folks at pgsql.admin, I've Postgres 8.0.1 running natively under Windows XPpro SP2. I would like to update to 8.0.3 using the upgrade-batchfile coming with the zipped download file. The installation stops when trying to install the service, saying the Postgres 8.0 Database Service could not be

[GENERAL] Perl regular expressions

Is there any support for perl regular expressions in Postgresql? -- http://www.spinics.net/yosemite/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] DBI/DBD::Pg mem. use goes exponential

Hi, I'd really like to aviod another list (ie. interfaces) if at all possible, so... Got a script (trimmed version below) that starts to have exponential memory use after a number of iterations around the while(($sth->fetch())) { } struct. Table is quite small (520 odd rows) and the row siz

Re: [GENERAL] Setting up a fine-grained permission system

David Garamond <[EMAIL PROTECTED]> writes: > Hi, > > Our current project requires a fine-grained permission system (row-level > and possibly column-level as well). We have a pretty large (tens of > thousands) of users in the 'party' table. I'm thinking of choosing > Unix-style security for now (ad

Re: [GENERAL] Problems creating view

Just for the record, and put some closure, today I finaly got unstable packages for postgresql-8.0 (up to yesterday the unstable package was the same as the testing one on SPARC) and this problem creating views is gone. From the changelog it looks like a bus error: postgresql-8.0 (8.0.3-16) uns

Re: [GENERAL] pg_restore error

Partners - Majolee InfoTech wrote: Hello, We use i686 based linux RH9.0 system and our postgresql is 8.0.3 But while restoring it gives too many errors and that is because it uses $_$ for plpgsql function body separator which the pg_restore and psql [dbname] < [file] both does not seem to und

Re: [GENERAL] How can I check if my cursor statement is using index

Dragan Matić wrote: I have a program that reads data from Postgresql database (version 8.0.3) through ODBC, but data retrieval is pretty slow. When I type the same SQL sentence in pgadmin III or any other sql tool it is much faster, and typing 'explain' clearly shows that it is using index. Ho

Re: [GENERAL] Hardware requirements

On Thu, Sep 29, 2005 at 09:20:00AM +0200, Rafael Montoya wrote: > Ok, there are about 15 concurrent clients inserting and updating data, and > 20 concurrent clients only consulting. > I dont need all data in ram, of course, hehe, but i really have no idea > what's the minimum of ram for having f

Re: [GENERAL] Hardware requirements

am 29.09.2005, um 9:20:00 +0200 mailte Rafael Montoya folgendes: > Ok, there are about 15 concurrent clients inserting and updating data, and > 20 concurrent clients only consulting. > I dont need all data in ram, of course, hehe, but i really have no idea > what's the minimum of ram for havin

[GENERAL] How can I check if my cursor statement is using index

I have a program that reads data from Postgresql database (version 8.0.3) through ODBC, but data retrieval is pretty slow. When I type the same SQL sentence in pgadmin III or any other sql tool it is much faster, and typing 'explain' clearly shows that it is using index. However the program is r

[GENERAL] pg_restore error

Hello,   We use i686 based linux RH9.0 system and our postgresql is 8.0.3   We use following command su -c '/usr/local/pgsql/bin/pg_dump -d -O -x [DBNAME] > [file withpath]' postgres to generate dump.   But while restoring it gives too many errors and that is because it uses $_$ for plpgsql

Re: [GENERAL] Hardware requirements

Ok, there are about 15 concurrent clients inserting and updating data, and 20 concurrent clients only consulting. I dont need all data in ram, of course, hehe, but i really have no idea what's the minimum of ram for having fast answers for about 2000 transactions in a day. Almost all queries n