Re: [GENERAL] Initdb panic: invalid record offset at 0/0 creating

2006-01-25 Thread Agnes Bocchino
Tom, finally I tried with only this option CC=icc, as there is an another error (error: Could not open %files file /home/postdev/BUILD/postgresql-8.1.1/debugfiles.list), I dont know where this debugfiles.list coming from. I prefered to stop for now , I'll will try later, so I have used gcc and

Re: [GENERAL] Which table(s) in the catalog define the tables and views?

2006-01-25 Thread Michael Glaesemann
On Jan 26, 2006, at 15:17 , Chris Velevitch wrote: I'm want to write a query to list definitions of all the fields in my tables and which table it belongs to. And similarly for views and tables. This is so I can check for table and column name consistency, extra tables and column type consiste

[GENERAL] Which table(s) in the catalog define the tables and views?

2006-01-25 Thread Chris Velevitch
I'm want to write a query to list definitions of all the fields in my tables and which table it belongs to. And similarly for views and tables. This is so I can check for table and column name consistency, extra tables and column type consistency. Chris -- Chris Velevitch Manager - Sydney Flash

Re: [GENERAL] Trigger question: ROW or STATEMENT?

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 02:47:45PM -0800, Patrick Hatcher wrote: > Would I gain any advantage by changing to it to fire after the insert? If you're modifying the row then the trigger must fire before the insert. An after trigger can abort the operation by raising an error and it can perform actio

Re: [GENERAL] Wiki Site for the PostgreSQL Newbie

2006-01-25 Thread Redefined Horizons
That earlier e-mail won't do anyone much good with out the link to the site. Sorry. That's what happens when I work late in the middle of the week. Link: http://www.bluwiki.org/go/PostgreSQL_Tips_From_The_Sunburned_Surveyor Scott Huey On 1/25/06, Redefined Horizons <[EMAIL PROTECTED]> wrote: >

[GENERAL] Wiki Site for the PostgreSQL Newbie

2006-01-25 Thread Redefined Horizons
I have started a wiki site for the PostgreSQL newbie. I'm actually a noob myself, but I thought I would take the time to document my mistakes and also provide some tips that I hope will help others. I welcome suggestions and correcions from more experience PostgreSQL and pgAdmin 3 users. I hope th

Re: [GENERAL] pgstattuple output?

2006-01-25 Thread Michael Crozier
> > Why is there so much free space with no dead tuples? This table has > > likely had serveral columns added over time, is that part of the problem? > > Indexes? > > An ordinary vacuum frees space for PostgreSQL's use but it doesn't > shrink the table's file(s) and return space to the operating

Re: [GENERAL] pgstattuple output?

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 03:40:38PM -0800, Michael Crozier wrote: > Why is there so much free space with no dead tuples? This table has likely > had serveral columns added over time, is that part of the problem? Indexes? An ordinary vacuum frees space for PostgreSQL's use but it doesn't shrink th

[GENERAL] xml_valid function

2006-01-25 Thread George Pavlov
Not sure what the correct forum for pgxml/xml2 questions is. I was wondering what is the definition of "valid" that the xml_valid(text) function that is part of that module uses? It seems different from the W3C definition of "valid" XML (is there an implicit DTD?) Maybe it is more akin to "well-for

[GENERAL] Implimenting an XPath engine in PostgreSQL / Staircase Join

2006-01-25 Thread Jim C. Nasby
I ran across http://www.vldb.org/conf/2004/DEMP14.PDF while googling for something else; I haven't seen this before so I thought I'd post it. Anyone dealing with XML data should take a look, though it might have other uses too. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Per

[GENERAL] pgstattuple output?

2006-01-25 Thread Michael Crozier
Hi, I have an aging 7.3 database on Solaris 9/Sparc. We are on the verge of upgrading Postgresql, but we first need to reclaim some disk space. I was looking for tables that may have become fragmented when I saw this pgstattuple output that confused me: table_len 21773516800 tu

Re: [GENERAL] Trigger question: ROW or STATEMENT?

2006-01-25 Thread Patrick Hatcher
Would I gain any advantage by changing to it to fire after the insert? thanks again for the help Patrick Hatcher Development Manager Analytics/MIO Macys.com 415-422-1610 Doug McNaught

Re: [GENERAL] My very first PL/pgSQL procedure...

2006-01-25 Thread Jim Buttafuoco
why not just use setval(), see docs for arguments. -- Original Message --- From: Philippe Ferreira <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Sent: Wed, 25 Jan 2006 22:11:11 +0100 Subject: Re: [GENERAL] My very first PL/pgSQL procedure... > Hi, > > The only solution I'

Re: [GENERAL] Trigger question: ROW or STATEMENT?

2006-01-25 Thread Doug McNaught
Patrick Hatcher <[EMAIL PROTECTED]> writes: > Here is the trigger the way it is currently written. I add some additional > information from another table: If you're modifying each row before it goes in, it should definitely be a FOR EACH ROW trigger. -Doug ---(end of br

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Aly Dharshi
Hello Ben, Unless I am wrong there is a set of RPMs available via the PostgreSQL site for 8.1.1/2 http://www.postgresql.org/ftp/binary/v8.1.2/linux/rpms/ Aly. Benjamin Smith wrote: Version: postgresql-8.1.0-4.c4 I'll have to see about getting an update... Thanks a TON, -Ben

Re: [GENERAL] user defined function

2006-01-25 Thread Tom Lane
andrew <[EMAIL PROTECTED]> writes: > Sorry, I modified the parser code and forgot abt it. Now there is no > problem in creating the function. But there is another problem. I > create a function to accept record type parameter. But when I call it > on a specific composite type, error is reported. Th

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Benjamin Smith
Version: postgresql-8.1.0-4.c4 I'll have to see about getting an update... Thanks a TON, -Ben On Wednesday 25 January 2006 13:11, you wrote: > Benjamin Smith <[EMAIL PROTECTED]> writes: > > Aha, yep. Sorry: > > Program received signal SIGSEGV, Segmentation fault. > > 0x0043c82c in h

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Tom Lane
Benjamin Smith <[EMAIL PROTECTED]> writes: > Aha, yep. Sorry: > Program received signal SIGSEGV, Segmentation fault. > 0x0043c82c in heap_modifytuple () > (gdb) bt > #0 0x0043c82c in heap_modifytuple () > #1 0x0043c8f5 in slot_getattr () > #2 0x0047a50a in FormIn

Re: [GENERAL] My very first PL/pgSQL procedure...

2006-01-25 Thread Philippe Ferreira
Hi, The only solution I've found to get the same reliable result, but without locking, is the dirty way (loops) : - CREATE OR REPLACE FUNCTION seq_min(sequence_name varchar, minva

Re: [GENERAL] Trigger question: ROW or STATEMENT?

2006-01-25 Thread Patrick Hatcher
Here is the trigger the way it is currently written. I add some additional information from another table: CREATE TRIGGER item_cost_trig BEFORE INSERT ON cdm.cdm_ddw_tran_item FOR EACH ROW EXECUTE PROCEDURE cdm.insert_cost_to_tranitem_sub(); CREATE OR REPLACE FUNCTION cdm.insert_cost_to_

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Benjamin Smith
Tom, Since we host customer data, I have to get OK from the company attorney before I can give you a full "howto create". I've been unable to recreate it without a full database dump. I'm waiting for a call back on that. I also can't recreate it on IA32. I tried to replicate the issue on a u

Re: [GENERAL] Trigger question: ROW or STATEMENT?

2006-01-25 Thread Doug McNaught
Patrick Hatcher <[EMAIL PROTECTED]> writes: > Attempting to do my first trigger and I'm confused about which FOR EACH I > should use: ROW or STATEMENT. I import about 80K rows into an existing > table each day. If I do a STATEMENT, will the changes only happen on the > new 80K rows I inserted or

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Tom Lane
Benjamin Smith <[EMAIL PROTECTED]> writes: > OK, here's the output: > (gdb) continue > Continuing. > Program received signal SIGSEGV, Segmentation fault. > 0x0043c82c in heap_modifytuple () > (gdb) > // not very hopeful, I'd think // You forgot the

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Tom Lane
Stephen Frost <[EMAIL PROTECTED]> writes: > * Tom Lane ([EMAIL PROTECTED]) wrote: >> ps auxww | grep postgres: >> ... eyeball determination of correct PID ... > You can also do 'select pg_backend_pid();' from psql... I know that's > there on 8.1, though I recall this was an 8.0 discussion and I *

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Benjamin Smith
OK, here's the output: (gdb) continue Continuing. Program received signal SIGSEGV, Segmentation fault. 0x0043c82c in heap_modifytuple () (gdb) // not very hopeful, I'd think // Can I get a RHES/CENTOS PG 8.1 RPM with the symbols enabled? Unfortuna

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 10:51:23AM -0800, [EMAIL PROTECTED] wrote: > I am in version 7.3 and it will not let me cast, I get message "ERROR: > Cannot cast type boolean to integer". I will save this for when I upgrade. You can create casts with CREATE CAST. http://www.postgresql.org/docs/7.3/stati

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread MargaretGillon
>Martijn van Oosterhout wrote on 01/25/2006 10:20:40 AM: > On Wed, Jan 25, 2006 at 09:55:58AM -0800, [EMAIL PROTECTED] wrote: > > Parhaps something like: > > CHECK((CASE WHEN evenid1 IS NOT NULL THEN 1 ELSE 0 END) + >       (CASE WHEN evenid2 IS NOT NULL THEN 1 ELSE 0 END) + >       (CASE WHEN

[GENERAL] Trigger question: ROW or STATEMENT?

2006-01-25 Thread Patrick Hatcher
Attempting to do my first trigger and I'm confused about which FOR EACH I should use: ROW or STATEMENT. I import about 80K rows into an existing table each day. If I do a STATEMENT, will the changes only happen on the new 80K rows I inserted or will it be for all rows in the table - currently ab

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread MargaretGillon
>Michael Fuhr <[EMAIL PROTECTED]> wrote on 01/25/2006 10:25:38 AM: > In 8.1, and in earlier versions if you create a cast from boolean > to integer, you could do this: > > ALTER TABLE event > ADD CONSTRAINT two_nulls_1 CHECK ( > (evenid1 IS NOT NULL)::int + > (evevid1 IS NOT NULL)::int + > (evrei

Re: [GENERAL] My very first PL/pgSQL procedure...

2006-01-25 Thread Philippe Ferreira
you need to use EXECUTE to do the dynamic lock table. sql = 'LOCK TABLE ' || sequence_name || 'IN ACCESS EXCLUSIVE MODE'; EXECUTE sql; Thank you for your help ;-) I've been able to rewrite my procedure as follows : ---

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 09:55:58AM -0800, [EMAIL PROTECTED] wrote: > You are correct, in each group of three columns, one needs to have an > integer and the other two need to be NULL. So I need to modify the > constraint to be > > ALTER TABLE event > ADD CONSTRAINT two_nulls_1 CHECK > ((eve

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread Martijn van Oosterhout
On Wed, Jan 25, 2006 at 09:55:58AM -0800, [EMAIL PROTECTED] wrote: > ALTER TABLE event > ADD CONSTRAINT two_nulls_1 CHECK > ((evenid1 IS NULL) AND (evevid1 IS NULL) and (evreid1 IS NOT NULL)) OR > ((evenid1 IS NULL) AND (evevid1 IS NOT NULL) and (evreid1 IS NULL)) OR > ((evenid1 IS NOT NULL) AND (

[GENERAL] xml support on win32 postgres

2006-01-25 Thread [EMAIL PROTECTED]
Ok, I decided to upgrade my postgress version to 8.1, I am using a win32 distribution, where can I find the xml2 extension? I got the pgxml distribution from http://www.u-moe.org/pgxml/ and I followed all tips from George • From: George Weaver • To: pgsql-novice ( at ) postgresql

Re: [GENERAL] My very first PL/pgSQL procedure...

2006-01-25 Thread Jim Buttafuoco
you need to use EXECUTE to do the dynamic lock table. sql = 'LOCK TABLE ' || sequence_name || 'IN ACCESS EXCLUSIVE MODE'; EXECUTE sql; -- Original Message --- From: Philippe Ferreira <[EMAIL PROTECTED]> To: pgsql-general@postgresql.org Sent: Wed, 25 Jan 2006 18:37:21 +0100 Subje

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
sorry, mistakenly leave out another try: backend> select *, complete(CAST (Person AS record)) from Person QUERY: select *, complete(CAST (Person AS record)) from Person ERROR: Relation reference "person" cannot be used in an expression On 1/25/06, andrew <[EMAIL PROTECTED]> wrote: > Sorry, I mo

[GENERAL] filtering after join

2006-01-25 Thread andrew
I want to use a UDF to filter tuples t that are generated after a join. More specifially, I have a UDF foo(record), which computes a value for a given tuple. I can do the filtering before the join. e.g.: select * from A, B where foo(A)<2 and A.a=B.b; But I want to apply foo() to the tuples gener

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread MargaretGillon
>Michael Fuhr wrote: > ALTER TABLE event >  ADD CONSTRAINT two_nulls_1 CHECK (evenid1 IS NULL) AND (evevid1 IS > NULL)) OR ((evevid1 IS NULL) AND (evreid1 IS NULL))) OR ((evenid1 IS NULL) > AND (evreid1 IS NULL; > >Is there a requirement that exactly one column be NOT NULL?  If so >then

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Stephen Frost
* Tom Lane ([EMAIL PROTECTED]) wrote: > Benjamin Smith <[EMAIL PROTECTED]> writes: > > What's the best way to do this? Take PG down (normally started as a > > service) > > and run directly in a single-user mode? > > No, just start a psql session in one window, then in another window > determine

Re: [GENERAL] table is not a table

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 11:26:39AM -0500, Tom Lane wrote: > "Ilja Golshtein" <[EMAIL PROTECTED]> writes: > > postgres=# create table ddd(f1 int4); > > CREATE TABLE > > postgres=# drop table ddd; > > ERROR: "ddd" is not a table > > That's just plain bizarre. Would you try it with \set VERBOSITY v

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
Sorry, I modified the parser code and forgot abt it. Now there is no problem in creating the function. But there is another problem. I create a function to accept record type parameter. But when I call it on a specific composite type, error is reported. The followings are what I have done: backend

[GENERAL] My very first PL/pgSQL procedure...

2006-01-25 Thread Philippe Ferreira
Hi, I've got a problem with my very first PL/pgSQL procedure ! I created the following procedure, that should reconfigure a sequence : - CREATE OR REPLACE FUNCTION seq_min(sequenc

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 08:39:00AM -0800, [EMAIL PROTECTED] wrote: > I have taken your suggestion and changed the values to NULL for the empty > foreign keys. Thank you for the constraint. I modified it to check for > NULL and it works great. > > ALTER TABLE event > ADD CONSTRAINT two_nulls_1

Re: [GENERAL] user defined function

2006-01-25 Thread Tom Lane
andrew <[EMAIL PROTECTED]> writes: > ERROR: parser: parse error at or near "record" at character 21 > in Warn_restart code > What is the problem here? Did you test it on 7.3? Yeah, 7.3.13 to be exact. (There have been a couple of changes in the parser in the 7.3 branch, according to the CVS log

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
The following is just copied from the screen. backend> create function foo(record) returns int4 as '$libdir/bar' language C QUERY: create function foo(record) returns int4 as '$libdir/bar' language C ERROR: parser: parse error at or near "record" at character 21 in Warn_restart code What is the

Re: [GENERAL] Missing database entry in pg_database

2006-01-25 Thread Tom Lane
Robert Korteweg <[EMAIL PROTECTED]> writes: > I have a problem with a database i'm maintaining. I first noticed the > problem because i could not make a backup of the database i got the > following error: > pg_dump: missing pg_database entry for database "xxx" > I verified this by selecting the

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread MargaretGillon
Richard, I have taken your suggestion and changed the values to NULL for the empty foreign keys. Thank you for the constraint. I modified it to check for NULL and it works great. ALTER TABLE event  ADD CONSTRAINT two_nulls_1 CHECK (evenid1 IS NULL) AND (evevid1 IS NULL)) OR ((evevid1 IS NUL

Re: [GENERAL] user defined function

2006-01-25 Thread Tom Lane
andrew <[EMAIL PROTECTED]> writes: > I use 7.3 and use RECORD as the input data type of the function by > "create function foo(record) returns int4 as '$libdir/bar' language > C". But I got this error msg:" ERROR: parser: parse error at or near > "record" at character". What is the problem? Sur

Re: [GENERAL] table is not a table

2006-01-25 Thread Tom Lane
"Ilja Golshtein" <[EMAIL PROTECTED]> writes: > postgres=# create table ddd(f1 int4); > CREATE TABLE > postgres=# drop table ddd; > ERROR: "ddd" is not a table That's just plain bizarre. Would you try it with \set VERBOSITY verbose so we can see exactly where the error is coming from? Has this i

Re: [GENERAL] Alternative to knoda, kexi and rekall?

2006-01-25 Thread Leif B. Kristensen
On Wednesday 25 January 2006 17:01, Martijn van Oosterhout wrote: >Anyone know any other non-text based clients? I'm using PHP with plain old HTML forms. That way, I can slap together a custom interface in no time. And it even works in links2 :) -- Leif Biberg Kristensen | Registered Linux User

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Jaime Casanova
On 1/25/06, Tom Lane <[EMAIL PROTECTED]> wrote: > Jaime Casanova <[EMAIL PROTECTED]> writes: > > On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote: > >> How can I determine if one of the above relations is a temporary > >> table in the current session (one of them, the first in ns 2200, is a > >> n

Re: [GENERAL] pgxml

2006-01-25 Thread Scott Marlowe
On Tue, 2006-01-24 at 21:34, Tom Lane wrote: > "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> writes: > > I’ am looking for pgxml module for postgres 7.2.1, someone can help me > > to find it? > > *Please* tell me you are not still using PG 7.2.1. > > There are seven subsequent releases in the 7.2 seri

Re: [GENERAL] FW: deleted records

2006-01-25 Thread Michael Fuhr
On Wed, Jan 25, 2006 at 11:42:04AM +0100, H.J. Sanders wrote: > When I do this I get the message > > relation pgstattuple does not exist. pgstattuple is a function, not a relation, so I suspect the query isn't referring to it correctly. What's the exact query you ran? It should look like this:

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Tom Lane
Jaime Casanova <[EMAIL PROTECTED]> writes: > On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote: >> How can I determine if one of the above relations is a temporary >> table in the current session (one of them, the first in ns 2200, is a >> normal permanent table)? > SELECT n.nspname as "Schema", c

Re: [GENERAL] Alternative to knoda, kexi and rekall?

2006-01-25 Thread Martijn van Oosterhout
On Wed, Jan 25, 2006 at 04:43:18PM +0100, Michelle Konzack wrote: > Hello, > > I am using PostgreSQL since more then 6 years now and for 1 1/2 years > "rekall". Now there is a problem with the crapy QT and I have no > Frontend anymore which works WITHOUT (!!!) KDE or GNOME which I hate! You mean

Re: [GENERAL] Alternative to knoda, kexi and rekall?

2006-01-25 Thread Peter Eisentraut
Michelle Konzack wrote: > Does anyone know a Frontend for PostgreSQL which I can use to design > and admin a very huge Database OpenOffice 2? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 2: Don't 'kill

Re: [GENERAL] Postgresql Segfault in 8.1

2006-01-25 Thread Tom Lane
Benjamin Smith <[EMAIL PROTECTED]> writes: > What's the best way to do this? Take PG down (normally started as a service) > and run directly in a single-user mode? No, just start a psql session in one window, then in another window determine the PID of the backend process it's connected to, and

[GENERAL] Alternative to knoda, kexi and rekall?

2006-01-25 Thread Michelle Konzack
Hello, I am using PostgreSQL since more then 6 years now and for 1 1/2 years "rekall". Now there is a problem with the crapy QT and I have no Frontend anymore which works WITHOUT (!!!) KDE or GNOME which I hate! Currently I am using "pgAccess" to check my PostgreSQL but it is very limited. Does

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Jaime Casanova
On 1/25/06, James Croft <[EMAIL PROTECTED]> wrote: > > On 25 Jan 2006, at 14:17, Jaime Casanova wrote: > > >> How can I determine what temporary tables exist in my session, > >> bearing in mind that other sessions contain temp tables using the > >> same names? > >> > > > > just the ones you have cr

[GENERAL] Missing database entry in pg_database

2006-01-25 Thread Robert Korteweg
Hi, I have a problem with a database i'm maintaining. I first noticed the problem because i could not make a backup of the database i got the following error: pg_dump: missing pg_database entry for database "xxx" I verified this by selecting the pg_database. It was indeed gone. I did some m

Re: [GENERAL] Shared Database across multiple servers using OCFS2

2006-01-25 Thread Bricklen Anderson
Kleynhans, Hendrik wrote: ___ “The information contained in this e-mail is confidential and may contain proprietary information. It is meant solely for the intended recipient. Access to this e-mail

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread James Croft
On 25 Jan 2006, at 14:17, Jaime Casanova wrote: How can I determine what temporary tables exist in my session, bearing in mind that other sessions contain temp tables using the same names? just the ones you have created in your session, temporary tables in other sessions are invisible to you

Re: [GENERAL] user defined function

2006-01-25 Thread andrew
I use 7.3 and use RECORD as the input data type of the function by "create function foo(record) returns int4 as '$libdir/bar' language C". But I got this error msg:" ERROR: parser: parse error at or near "record" at character". What is the problem? I look up the 7.3 manual. it seems record is a

Re: [GENERAL] Temporary table visibility

2006-01-25 Thread Jaime Casanova
> How can I determine what temporary tables exist in my session, > bearing in mind that other sessions contain temp tables using the > same names? > just the ones you have created in your session, temporary tables in other sessions are invisible to you... -- regards, Jaime Casanova (DBA: DataBase

[GENERAL] 2 instances of postmaster with different data directories

2006-01-25 Thread surabhi.ahuja
 Hi,   I am going to integrate my dtabase into a system. That system also has another database and uses postgres.   However they have their own data directory and start postmaster by specifying that.   I have seen that it is possible to run multiple postmasters on multiple ports by specifying di

Re: [GENERAL] FATAL: terminating connection due to administrator command

2006-01-25 Thread surabhi.ahuja
Title: Re: [GENERAL] FATAL: terminating connection due to administrator command  is it also possible that someone was doing an operation on the database for instance inserting manyr rows and suddenly a command to stop the postmaster arrived?   thanks, regards Surabhi From: Tom Lane [ma

[GENERAL] Tsearch 2

2006-01-25 Thread Marcos
Hi, How the tsearch2 work? I can use it in my project that is language Português (Brasil)? Thanks. Marcos. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PR

Re: [GENERAL] Does this look ethical to you?

2006-01-25 Thread Sergiusz Jarczyk
Andrew Maclean napisał(a): I can't agree more. -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Wednesday, 25 January 2006 15:16 To: Tony Caduto Cc: Magnus Hagander; Dave Page; pgsql-general@postgresql.org Subject: Re: Does this look ethical to you? The people

[GENERAL] table is not a table

2006-01-25 Thread Ilja Golshtein
Hello! Could you please help me with an issue I have on a PG installation. The problem is it is impossible to drop any table. Looks like this. == [EMAIL PROTECTED] bin]$ ./psql postgres ilejn Welcome to psql 8.1.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms

Re: [GENERAL] Does this look ethical to you?

2006-01-25 Thread Andrew Maclean
I can't agree more. -Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: Wednesday, 25 January 2006 15:16 To: Tony Caduto Cc: Magnus Hagander; Dave Page; pgsql-general@postgresql.org Subject: Re: Does this look ethical to you? The people who develop, package, and host

[GENERAL] Temporary table visibility

2006-01-25 Thread James Croft
Hi all, I've had a look at through the list archives but haven't found an answer to this one. Any suggestions appreciated (aside from ones suggesting that I should not need to do this ;-)... - A normal table foo is created in a database. - Clients connect to the database, some create a tem

Re: [GENERAL] NOT HAVING clause?

2006-01-25 Thread Alban Hertroys
Andrew - Supernews wrote: On 2006-01-24, Will Glynn <[EMAIL PROTECTED]> wrote: You might try: SELECT some_column FROM some_table GROUP BY some_column HAVING SUM(CASE WHEN sort_order=1 THEN 1 ELSE 0 END) = 0; SELECT some_column FROM some_table GROUP BY some_column HAVING every(sort_ord

Re: [GENERAL] Please, help! About database cluster and adding to

2006-01-25 Thread Devrim GUNDUZ
Hi, On Wed, 2006-01-25 at 12:40 +0300, Sergey Karin wrote: > We create database cluster (via initdb) on some disk. Then we create > and use a database that can be very large. In some moment the database > occupy all disk space allicated to cluster. > The question is: are there any abilities in Po

Re: [GENERAL] Shared Database across multiple servers using OCFS2

2006-01-25 Thread Michael Glaesemann
On Jan 25, 2006, at 18:43 , Kleynhans, Hendrik wrote: If I am looking to access large amounts of data, such as in a data center, would it be better to run a/several database servers and accessing them across the network? If you want *access* (i.e., select only, not modifying data), you migh

Re: [GENERAL] Shared Database across multiple servers using OCFS2

2006-01-25 Thread Richard Huxton
Kleynhans, Hendrik wrote: Hi Richard, : Are you: : 1. Looking to spread disk-accesses over several machines, or : 2. Looking to run multiple PostgreSQL server against the same : database? : : You might be ok with #1, but not #2. Thanks for the quick response. I am looking at #2, but I cou

Re: [GENERAL] Please, help! About database cluster and adding to

2006-01-25 Thread Richard Huxton
Sergey Karin wrote: Hi, List! Lets suppose the next situation... We create database cluster (via initdb) on some disk. Then we create and use a database that can be very large. In some moment the database occupy all disk space allicated to cluster. The question is: are there any abilities in Po

Re: [GENERAL] Shared Database across multiple servers using OCFS2

2006-01-25 Thread Kleynhans, Hendrik
Hi Richard, : Are you: : 1. Looking to spread disk-accesses over several machines, or : 2. Looking to run multiple PostgreSQL server against the same : database? : : You might be ok with #1, but not #2. Thanks for the quick response. I am looking at #2, but I could not find anything from my s

Re: [GENERAL] Please, help! About database cluster and adding to it additional disk space

2006-01-25 Thread Martijn van Oosterhout
On Wed, Jan 25, 2006 at 12:40:36PM +0300, Sergey Karin wrote: > Hi, List! > > Lets suppose the next situation... > > We create database cluster (via initdb) on some disk. Then we create and use > a database that can be very large. In some moment the database occupy all > disk space allicated to c

[GENERAL] Please, help! About database cluster and adding to it additional disk space

2006-01-25 Thread Sergey Karin
Hi, List! Lets suppose the next situation... We create database cluster (via initdb) on some disk. Then we create and use a database that can be very large. In some moment the database occupy all disk space allicated to cluster. The question is: are there any abilities in PostgreSQL to use for c

Re: [GENERAL] Quoted NULLs with COPY FROM (and pgAdmin export data

2006-01-25 Thread Richard Huxton
George Pavlov wrote: This is actually turning into a bit of a pgAdmin issue: pgAdmin lets you export data in a format that seems to be unimportable back into the same table. If in the "Export data to file" form you check "all columns" under "Quoting" you will get quotes around your numeric NULLs

Re: [GENERAL] Shared Database across multiple servers using OCFS2

2006-01-25 Thread Richard Huxton
Kleynhans, Hendrik wrote: Hi there, Does anyone know if it is possible to share a single database across multiple machines each running a database server using OCFS2? Are you: 1. Looking to spread disk-accesses over several machines, or 2. Looking to run multiple PostgreSQL server against the

Re: [GENERAL] Constraint that compares and limits field values

2006-01-25 Thread Richard Huxton
[EMAIL PROTECTED] wrote: I have a table that I am using to hold keys for M:M relationships. I have six fields that can hold the keys and I do this because I validate the key with a foreign key constraint. Fields evevid1, evevid2 hold keys from the event table, evreid1, evreid2 hold keys from

Re: [GENERAL] [SQL] hi all......................!!

2006-01-25 Thread Markus Schaber
Hi, Akilesh, AKHILESH GUPTA wrote: > i am new to this mailing list. this is my first mail to this group. > i jussst want to confirm that whether is it possible to update a view or > not?? > i think you all help me in solving my queries in future...!! Do you think about issuing UP

Re: [GENERAL] [SQL] hi all......................!!

2006-01-25 Thread Richard Huxton
AKHILESH GUPTA wrote: hello everybody i am new to this mailing list. this is my first mail to this group. i jussst want to confirm that whether is it possible to update a view or not?? There is no automatic updating of views at present. You can write your own RULES though to do updates - see t

Re: [GENERAL] Installing Postgres 8.1 on Windows Server 2003 R2

2006-01-25 Thread Richard Huxton
Carl Conard wrote: Connections are through localhost. We've also connected via a client machine through a router to insure it is not something on the server. No, I meant what client library: odbc, jdbc .net libpq? By drop connections, I mean Task Manager is showing additional postgres.exe

[GENERAL] Shared Database across multiple servers using OCFS2

2006-01-25 Thread Kleynhans, Hendrik
Hi there, Does anyone know if it is possible to share a single database across multiple machines each running a database server using OCFS2? Thanks in advance, Kind regards, Henry ___ “The informati

Re: [GENERAL] Are indexes used with LIKE?

2006-01-25 Thread Kovács Péter
Thank you for the answer! Sure, the possiblity of having a separate column for each flag was considered, but a common columnn is preferred -- I do not remember exactly why. (I do not directly make that decision.) I guess the main reason is that adding new columns to the table complicates the u