[GENERAL] connectby usage question

Hi all, We're trying to use connectby to transform a tree into an ordered set of rows, specifically requirements rows. We have data stored in a table with keyid and parent_id, as described in the examples for keyid is also the primary key of a table A, which has the field A.seq_number. We

[GENERAL] Problem getting postmaster PID in pg_regress

Hi all, I'm trying to run pg_regress as part of a build of Postgres 8.1 on Suse Linux Enterprise Server 9. I keep getting the following error: ./pg_regress: line 264: kill: (25049) - No such process I chased the problem down to the following lines in pg_regress: $bindir/postmaster -D

Re: [GENERAL] Problem getting postmaster PID in pg_regress

, but any thoughts would be very welcome. Thanks, EE Tom Lane wrote: Eric E [EMAIL PROTECTED] writes: I chased the problem down to the following lines in pg_regress: $bindir/postmaster -D $PGDATA -F $postmaster_options $LOGDIR/postmaster.log; 21

Re: [GENERAL] Upcalls (sort of) from the database

Don Y wrote: Hi, I wasn't prepared to ask this question, yet : but all the talk of stored procedures, etc. suggests this might be a good time to venture forth... Humor me: assume I have done the analysis and *know* this to be correct for my situation : I want to embed a good deal of the

Re: [GENERAL] Arrays

I second that, and I'd love to have someone clarify the appropriate time to use arrays vs. more columns or an referenced tabled. I've always found that confusing. Thanks, Eric Karsten Hilbert wrote: And why would that be undesirable ? On Thu, Jan 26, 2006 at 10:15:22AM -0800, Bob Pawley

Re: [GENERAL] Arrays

I second that, and I'd love to have someone clarify the appropriate time to use arrays vs. more columns or an referenced tabled. I've always found that confusing. Thanks, Eric Karsten Hilbert wrote: And why would that be undesirable ? On Thu, Jan 26, 2006 at 10:15:22AM -0800, Bob Pawley

Re: [GENERAL] Triggers and Audit Trail

Hi Marcus, Marcus Couto wrote: Hi all. I'm new with PostgreSQL and this is my first post, so easy on me... :) I'm thinkingof using the native procedural language and triggers to keep an audit trail. Forediting changes, we only keepa log of the modified fields and we create a

Re: [GENERAL] Toolkit for creating editable grid

Has anyone used OpenOffice Base? Just a thought. Or Rekall - it's a bit immature, but it might do what you want. The dreaded MS Access can do what you describe in about 4 minutes... EE I'm in progress of selecting development platform. pgAdmin3 is written in C++, using the cross-plattform

[GENERAL] Preventing or controlling runaway queries

Hi all, I've recently had a couple worrisome experiences with runaway queries in postgres 7.4 and 8.0, and I'm wondering what I can do to control or prevent these. When I ran a query against a large table, I accidentally omitted mistyped a table name, and a table was automatically added,

Re: [GENERAL] Preventing or controlling runaway queries

. Thanks for pointing me in the right direction. Cheers, Eric Tom Lane wrote: Eric E [EMAIL PROTECTED] writes: I've recently had a couple worrisome experiences with runaway queries in postgres 7.4 and 8.0, and I'm wondering what I can do to control or prevent these. When I ran a query

Re: [GENERAL] Preventing or controlling runaway queries

Tom Lane wrote: Eric E [EMAIL PROTECTED] writes: Here's the test function: ... my $data_handle = spi_exec_query('SELECT * FROM schema1.table_of_approximately 3 rows;'); Well, the plperl documentation does point out that spi_exec_query should only be used when you know

Re: [GENERAL] How: single db, multiple users

Postgres' users are not specific to a database, they are shared across all databases on a particular server. At the database level, you can assign creation and other permissions to users, but (AFAIK) you cannot deny users to a database. However, you can effectively control users' access to a

Re: [GENERAL] to create a database...

Can you describe the versatility you're looking for? Why does your application need to run on multiple DB's? Is the user going to be selecting a backend database? I'd consider how compelling your reasons for supporting multiple databases are, because it will be quite a bit of work even with

[GENERAL] Partial foreign keys, check constraints and inheritance

Hi all, In my database application, I've repeatedly encountered a particular issue, and I'm not sure I'm addressing it well, so I'd like suggestions on how to deal with it. The problem is that I need something like a partial foreign key - a foreign key where, based on field1, in some rows

Re: [GENERAL] Partial foreign keys, check constraints and inheritance

full field maybe it's not as bad a way of doing it as I thought. EE Jaime Casanova wrote: On 11/17/05, Eric E [EMAIL PROTECTED] wrote: Hi all, In my database application, I've repeatedly encountered a particular issue, and I'm not sure I'm addressing it well, so I'd like suggestions

Re: [GENERAL] Partial foreign keys, check constraints and inheritance

Eric E wrote: maybe you can solve it adding a new col and allow both to contain null values. if these are not mutually exclusive you can avoid a check if they are check that if one has a non-null value other has null... I did think about that, but I disliked the idea of two fields of nulls

Re: [GENERAL] Partial foreign keys, check constraints and inheritance

Scott Marlowe wrote: On Thu, 2005-11-17 at 13:36, Eric E wrote: Eric E wrote: maybe you can solve it adding a new col and allow both to contain null values. if these are not mutually exclusive you can avoid a check if they are check that if one has a non-null value other has null

Re: [GENERAL] return next and pl/perl

, or in the select statement? It would be helpful to me, but it's not a dealkiller. Anyway, thanks a lot for your help, it's much appreciated. Eric On Fri, Jun 10, 2005 at 07:24:49PM -0400, Eric E wrote: Hi all, I'm working on implementing a function in PL/PERL that will ready many rows. As such I'd like

[GENERAL] return next and pl/perl

Hi all, I'm working on implementing a function in PL/PERL that will ready many rows. As such I'd like to use return_next to keep memory usage down. When I call return next, I get the following error message: ERROR: error from Perl function: Can't call method return_next on unblessed

[GENERAL] Fabrica a record in PL/PGSQL

Hi all, I'm trying to write a function that takes the following records |Field1|Field2 |Field3 |Field 4 | A | P |Name1 | 51 | A | P |Name2 | 20.143 | A | P |Name3 |

[GENERAL] View definition truncated in information_schema

Hi all, I'm trying to retrieve the SQL definition of a view from information_schema via: SELECT view_definition FROM information_schema.views WHERE table_name = 'viewname'; It appears the definition returned is truncated at a fixed number of characters - for this view it's 7650. Does

Re: [GENERAL] [ODBC] ODBC (win32) X PostgreSQL(Linux)

can I configure the connection to do so? Thanks a lot. Em (12:21:40), Eric E escreveu: Hi Fabricio, To provide any detailed help, folks will need to know more specifically what the problem is. However, some things I've come across are: + making sure the PG server is set to accept

Re: [GENERAL] PL/TCL functions won't run - resolved

, in my case (C:\Tcl\lib\tcl8.4) After rebooting (not sure if just restarting postgres will work), TCL functions run. The key is for postgres to be able to find the file init.tcl. Hope this is useful. Cheers, Eric Eric E wrote: Hi all, In working through some problems with rows

Re: [GENERAL] Retrieving a field from the NEW record

stable on Windows yet? If that's the case I will indeed submit a bug report with a test case. Many thanks, Eric Michael Fuhr wrote: On Tue, Jan 18, 2005 at 04:21:51PM -0500, Eric E wrote: I'm tearing my hair out trying to solve the following problem. I want to be able to retrieve the value

[GENERAL] PL/TCL functions won't run

Hi all, In working through some problems with rows and variables, I installed PL/TCL into my Postgres 8.0 installation on Windows XP. Unfortunately, when I try to run any PL/TCL functions, I get the response: ERROR: could not create normal interpreter I have ActiveTCL 8.4.9 installed,

[GENERAL] Retrieving a field from the NEW record

Hi all, I'm tearing my hair out trying to solve the following problem. I want to be able to retrieve the value of the primary key in a trigger function. I have tried using PL/PGSQL and PL/PERL, but a PL/PERL trigger function crashes the postgress process. I am able to use TG_RELNAME and

[GENERAL] pg_dump dependencies

Hi all, I have a question about pg_dump. I am backing up a database using pg_dump in text mode, which works perfectly for me, with one exception. I have a view vwDependentView which references another view, vwIndependentView. However, when I feed my dump script to psql, it is attempting

Re: [GENERAL] pg_dump dependencies

will also poke around in my database to see if perhaps something else is blocking a proper dump. Thanks, EE Michael Fuhr wrote: On Thu, Jan 06, 2005 at 12:10:26PM -0500, Eric E wrote: I have a question about pg_dump. I am backing up a database using pg_dump in text mode, which works

[GENERAL] Auditing with shared username

Hi all, Like many folks who use three-tier design, I would like to create an audit trail in my Postgres database, and I would like to do so without having to create a database user for each audit. As I see it, there are two ways to do this, and I can't see a clear way to do either of them.

Re: [GENERAL] Auditing with shared username

that useless. PG doesn't have connection pooling, that is a higher level application function. Eric E [EMAIL PROTECTED] 12/06/04 8:58 AM Hi all, Like many folks who use three-tier design, I would like to create an audit trail in my Postgres database, and I would like to do so without

Re: [GENERAL] Auditing with shared username

. Eric E [EMAIL PROTECTED] 12/06/04 8:58 AM Hi all, Like many folks who use three-tier design, I would like to create an audit trail in my Postgres database, and I would like to do so without having to create a database user for each audit. As I see it, there are two ways to do

Re: [GENERAL] Pl/Perl w/ Postgres 8.0 on Windows

Thanks to both of you gentlemen. I actually had to restart Postgres after installing ActiveState Perl before I could successfully run createlang and add the language. Seems to be working now, though. Cheers, Eric Magnus Hagander wrote: Hi all, I am throughly enjoying using Postgres 8.0 on

[GENERAL] Pl/Perl w/ Postgres 8.0 on Windows

Hi all, I am throughly enjoying using Postgres 8.0 on Windows, so I can develop my Windows client against Postgres. I would like to write some pl/perl functions, and I'm a little stumped. Now comes the sad confession - I installed PG from the Windows installer rather than building it. Can

[GENERAL] ODBC driver troubles

Hi all, I've had a couple issues with the ODBC driver that ships with Postgres. I am using Access 2000 to link tables Postgres. Of the two issues, one is small: after I enabled row version in the ODBC driver - to fix a problem updating certain tables - the column xmin began appearing in

[GENERAL] Rows created by a stored proc prompt Access' dreaded write conflict

Hi all, I am using an Access client linked to a PG 7.4 server via ODBC. I have a stored proc on the server that inserts rows into a table.particular table, accomplished via an INSERT within the body of the stored proc. The procedure does not explicitly commit this data, as no transactions

[GENERAL] SELECT a value from various tables depending on a column value

Hi, I'm trying to write a recordset-returning function that returns a values from a base table, and one column from a joined table, where the joined table varies according to a field of the base table. I'm looking for an efficieint way to do this, and I don't think I know enough about

[GENERAL] PlPERL and shared libraries on Suse

Hi, I have an installation of Postgres 7.4.2 on SuSE 9.1. This version of SuSE comes with a binary for plperl and several other postgres procedural languages. All the others, including plpgsql install without a problem, but executing: createlang -u postgres plperl template1 produces the

Re: [GENERAL] PlPERL and shared libraries on Suse

Hi Steve and Tom, Thanks for the tip, I was clearly not reading the error message closely enough. I copied libperl.so into /lib, and now everything works. Many thanks, Eric Steve Atkins wrote: On Fri, Oct 22, 2004 at 12:13:12PM -0400, Eric E wrote: Hi, I have an installation of Postgres 7.4.2

[GENERAL] Sequence question

Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in order. My users will draw a number or numbers from the sequence and write to the field. Sometimes, however, these sequence numbers will be discarded

[GENERAL] Sequence question

Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in order. My users will draw a number or numbers from the sequence and write to the field. Sometimes, however, these sequence numbers will be

Re: [GENERAL] Sequence question

for any ideas. Cheers, Eric Tino Wildenhain wrote: Hi, On Tue, 2004-10-19 at 01:16, Eric E wrote: Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in order. My users will draw a number or numbers from

Re: [GENERAL] Sequence question

Andrew Sullivan wrote: On Tue, Oct 19, 2004 at 11:19:05AM -0400, Eric E wrote: My users will draw a number or numbers from the sequence and write to the field. Sometimes, however, these sequence numbers will be discarded (after a transaction is complete), and thus available for use. During

Re: [GENERAL] Sequence question

Hmm that's a really intesting idea, Tino. Since we're probably talking about 100 numbers max, a query on this table would work fairly fast, and operationally simple. I'll think about that. Thanks, Eric Tino Wildenhain wrote: Hi, Am Mi, den 20.10.2004 schrieb Eric E um 19:52: Hi