[GENERAL] Postgres Library natively available for Mac OSX Intel?

Hello! I would like to know if somebody already has a Mac OSX Intel 10.4.5 pg-Library (for C, C++, Objective C) or knows how to compile it? Or even better, a fat-library (powerpc, i386) would be even better :-) Thanks for any information, regards Philipp Ott ---(end o

[GENERAL] configure: error: file 'tclConfig.sh' is required for Tcl

hi! I configure postgresql-8.1.3 on fedora core 4 with "./configure --with-perl --with-python --enable-nls --with-openssl --enable-debug --enable-cassert --with-tcl" and being root. I've got this error: [snip configure output] checking for tclsh... /usr/bin/tclsh checking for tclConfig.sh... no

Re: [GENERAL] configure: error: file 'tclConfig.sh' is required for Tcl

Hi! Being a Debian-user I haven't really got a clue about Fedora Core, but have you tried installing the tcl-devel-package? Kind regards Markus Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Teresa Noviello Gesendet: Freit

Re: [GENERAL] configure: error: file 'tclConfig.sh' is required for Tcl

I've installed tcl-devel-package!!! NOW IT WORKS!... (in my honest opinion it had to work also without it, but that's another story!) THANKS!!! TeryOn 3/31/06, Markus Wollny <[EMAIL PROTECTED]> wrote: Hi!Being a Debian-user I haven't really got a clue about Fedora Core, but have you tried insta

Re: [GENERAL] FAQ 1.1

Bruce Momjian schrieb: Douglas McNaught wrote: Michael Talbot-Wilson <[EMAIL PROTECTED]> writes: How, really, do people pronounce PostgreSQL? "Postgres" The first sentence of the FAQ is: PostgreSQL is pronounced Post-Gres-Q-L, and is also sometimes referred to as just P

Re: [GENERAL] FAQ 1.1

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Tino > Wildenhain > Sent: 31 March 2006 09:51 > To: Bruce Momjian > Cc: Douglas McNaught; Michael Talbot-Wilson; > pgsql-general@postgresql.org > Subject: Re: [GENERAL] FAQ 1.1 > > Bruce Momjian s

Re: [GENERAL] How to concat strings so that trailing spaces remain

> If you think that trailing spaces are significant data, you should > probably be using VARCHAR not CHAR datatype. I have existing database where there are only CHAR columns, no any VARCHAR column. I'm not sure will my appl work if I change all char columns to varchar columns . Is it reasonable

Re: [GENERAL] PANIC: heap_update_redo: no block

""Alex bahdushka"" <[EMAIL PROTECTED]> wrote > > (@)<2006-03-18 23:30:33.035 MST>[3791]PANIC: heap_update_redo: no block > According to the discussion in pgsql-hackers, to finish this case, did you turn off the full_page_writes parameter? I hope the answer is "yes" ... Regards, Qingqing ---

[GENERAL] How to delete all operators

Hi, I have a database with operators and functions in plpgsql. To update the data to the latest version I would like to drop all operators. There might be some, that I don't know. I don't have access to the database, but have to write a script, that will update the data. Is there any way to drop

[GENERAL] pgsql continuing network issues

Hey all, I wrote a few days ago regarding networking issues I'm having. At this point, I'm at my wit's end and am hoping someone can help me. I am running postgres 8.1.0 on Windows XP w\SP2. I currently have PGSQL configured to accept connections from my local IP, 192.168.0.100 using the listen_a

Re: [GENERAL] Performance Killer 'IN' ?

Joshua D. Drake wrote: > Kai Hessing wrote: >> 1.) 21.5 seconds >> 2.) 363.7 seconds >> >> But it is still a significant difference. > > Can you provide an explain analyze of each query? There isn't an explain analyze of the first variant, because there are just 2000 SQL-Updates. The explain ana

[GENERAL] How to use result column names in having cause

CREATE TEMP TABLE foo( bar integer ); SELECT 123 AS x FROM foo GROUP BY 1 HAVING x> AVG(bar) causes ERROR: column "x" does not exist Why ? How to make this working ? In real application I have long expression instead of 123 and do'nt want repeat this expression in HAVING clause. In VF

Re: [GENERAL] How to use result column names in having cause

On 3/31/06, Andrus <[EMAIL PROTECTED]> wrote: > CREATE TEMP TABLE foo( bar integer ); > > SELECT 123 AS x > FROM foo > GROUP BY 1 > HAVING x> AVG(bar) > > causes > > ERROR: column "x" does not exist > > Why ? How to make this working ? > > In real application I have long expression instead o

[GENERAL] how to use pg_dump in windows xp

hi   i have to create a database script file using pg_dump ,but i do not understant how to run it under windows enviornment plz hep me and replay mee soon...  

Re: [GENERAL] how to use pg_dump in windows xp

am 31.03.2006, um 18:08:55 +0530 mailte deepak pal folgendes: > hi > i have to create a database script file using pg_dump ,but i do not > understant how to run it under windows enviornment plz hep me and replay mee > soon... execute it via psql, start psql and then \i your_scri

Re: [GENERAL] How to use result column names in having cause

>> In real application I have long expression instead of 123 and do'nt want >> repeat this expression in HAVING clause. > > You have to repeat the expression. "AS" changes the output name, it > can't be used either in the where clause or any other limiting factor > like 'having': Doc about HAVING

Re: [GENERAL] How to use result column names in having cause

Here is my problematic query which runs OK in other DBMS. Only way to run this in Postgres is to duplicate reatasum expression two times in HAVING clause, right ? Andrus. SELECT 'z' as doktyyp, r1.dokumnr, r1.kuluobjekt as objekt, r1.rid2obj, r1.rid3obj, r1.rid4obj, r1.rid5obj,

Re: [GENERAL] How to use result column names in having cause

On 3/31/06, Andrus <[EMAIL PROTECTED]> wrote: > >> In real application I have long expression instead of 123 and do'nt want > >> repeat this expression in HAVING clause. > > > > You have to repeat the expression. "AS" changes the output name, it > > can't be used either in the where clause or any

Re: [GENERAL] pgsql continuing network issues

On Friday 31 March 2006 02:55 am, David Bernal wrote: > Hey all, > > I wrote a few days ago regarding networking issues I'm having. At this > point, I'm at my wit's end and am hoping someone can help me. > > I am running postgres 8.1.0 on Windows XP w\SP2. I currently have > PGSQL configured to acc

[GENERAL] unsubscribe from pgsql-de-allgemein

unsubscribe from pgsql-de-allgemein ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] pgsql continuing network issues

Adrian Klaver wrote: On Friday 31 March 2006 02:55 am, David Bernal wrote: Hey all, I wrote a few days ago regarding networking issues I'm having. At this point, I'm at my wit's end and am hoping someone can help me. I am running postgres 8.1.0 on Windows XP w\SP2. I currently have PGSQL co

Re: [GENERAL] How to use result column names in having cause

On Friday 31 March 2006 08:30, chris smith wrote: > On 3/31/06, Andrus <[EMAIL PROTECTED]> wrote: > > >> In real application I have long expression instead of 123 and do'nt > > >> want repeat this expression in HAVING clause. > > > > > > You have to repeat the expression. "AS" changes the output na

Re: [GENERAL] configure: error: file 'tclConfig.sh' is required for Tcl

"Teresa Noviello" <[EMAIL PROTECTED]> writes: > I've installed tcl-devel-package!!! > NOW IT WORKS!... > (in my honest opinion it had to work also without it, but that's another > story!) Why do you think that? In general, the point of a foo-devel package is to carry the files needed to build (

Re: [GENERAL] How to use result column names in having cause

On Fri, 31 Mar 2006, Andrus wrote: > >> In real application I have long expression instead of 123 and do'nt want > >> repeat this expression in HAVING clause. > > > > You have to repeat the expression. "AS" changes the output name, it > > can't be used either in the where clause or any other limi

Re: [GENERAL] [Slightly OT] data model books/resources?

On Thursday 30 March 2006 03:03, Aaron Glenn wrote: > Anyone care to share the great books, articles, manifestos, notes, > leaflets, etc on data modelling they've come across? Ideally I'd like > to find a great college level book on data models, but I haven't come > across one that even slightly ho

Re: [GENERAL] Performance Killer 'IN' ?

On 3/31/06, Kai Hessing <[EMAIL PROTECTED]> wrote: > The second one (UPDATE xyz WHERE id IN (xyz1, xyz2, ) AND > status>-1;) returns: > -- > Seq Scan on phon (cost=0.00..1573304.58 rows=105931 width=148) (actual > time=369563.565..369563.565 rows=0 loops=1) Just a shot in the

Re: [GENERAL] Performance Killer 'IN' ?

Kai Hessing <[EMAIL PROTECTED]> writes: > Index Scan using phon_phon_idx on phon (cost=0.00..5193.83 rows=530 > width=148) (actual time=0.146..0.146 rows=0 loops=1) > ... > Seq Scan on phon (cost=0.00..1573304.58 rows=105931 width=148) (actual > time=369563.565..369563.565 rows=0 loops=1) You ne

Re: [GENERAL] How to use result column names in having cause

"chris smith" <[EMAIL PROTECTED]> writes: > I assume it's this way because the standard says so.. Right. From a logical point of view, the HAVING clause has to be evaluated before the output expressions are computed, so it doesn't make any sense to expect the output expressions to be available in

Re: [GENERAL] pgsql continuing network issues

On Mar 31, 2006, at 2:55 AM, David Bernal wrote: Hey all, I wrote a few days ago regarding networking issues I'm having. At this point, I'm at my wit's end and am hoping someone can help me. I am running postgres 8.1.0 on Windows XP w\SP2. I currently have PGSQL configured to accept connectio

Re: [GENERAL] [Slightly OT] data model books/resources?

Robert Treat wrote: On Thursday 30 March 2006 03:03, Aaron Glenn wrote: Anyone care to share the great books, articles, manifestos, notes, leaflets, etc on data modelling they've come across? Ideally I'd like to find a great college level book on data models, but I haven't come across one that e

[GENERAL] Recovery with pg_xlog

You can usually get the directory name by doingSELECT dataname, oid FROM pg_databases;To get the file name do:SELECT relname, relfilenode FROM pg_class WHERE relname = 'tblName';The relfilenode will tell you what numbed file belongs to the talbe.  It's not always OID, but it often is (don't just as

Re: [GENERAL] PANIC: heap_update_redo: no block

On 3/31/06, Qingqing Zhou <[EMAIL PROTECTED]> wrote: > > ""Alex bahdushka"" <[EMAIL PROTECTED]> wrote > > > > (@)<2006-03-18 23:30:33.035 MST>[3791]PANIC: heap_update_redo: no block > > > > According to the discussion in pgsql-hackers, to finish this case, did you > turn off the full_page_writes p

[GENERAL] giving users access to specific databases

Hi, I'm hoping someone can tell me how to go about this, or if a solution is even possible with my current set up. I realize this question may go beyond pure postgres topics and have to do more with how my hosting company has their servers configures, but this group seemed like my best option fo

Re: [GENERAL] pg 8.1.2 performance issue

On Sunday March 26 2006 9:16 am, Tom Lane wrote: > "Ed L." <[EMAIL PROTECTED]> writes: > > I see what appear to be many single transactions holding > > RowExclusiveLocks for sometimes 40-50 seconds while their > > query shows " in transaction". > > ... > > I'm thinking that means the client is simp

Re: [GENERAL] pgsql continuing network issues

> What IP address are you trying to connect to? If you're trying to > connect to 127.0.0.1 and it's listening on 192.168.0.100 then > that won't work. I'm trying to connect to 192.168.0.100 > 10107 is WSASYSCALLFAILURE. A pretty generic message, but I've > seen it when some broken software has ins

Re: [GENERAL] pgsql continuing network issues

> You should for sure change the listen_addresses to * because you may > have two NICs in the server or PC and somehow the external connections > are connecting to the other nic. I tried this as well, but it didn't change anything. ---(end of broadcast)

Re: [GENERAL] best practice in upgrading db structure

On Mar 28, 2006, at 8:40 PM, Robert Treat wrote: Depends on how much data you need to modify. For small tables, I stick with ALTER TABLE because it's a lot cleaner/easier. For larger tables, you might want to CREATE TABLE AS SELECT ..., or maybe copy out and copy back in. This seems back

Re: [GENERAL] updategram in pg

No, but you should be able to build something similar using a language that understands XML. You could then pass something like this to the database: SELECT updategram.update('big-ole XML string'); If you wanted to get even more fancy, you could create a daemon that would accept connection

Re: [GENERAL] best practice in upgrading db structure

On Mar 29, 2006, at 3:25 AM, Csaba Nagy wrote: Could somebody explain me, or point me to a resource where I can find out what is the recommended practice when a live db needs to be replaced with a new version of it that has a slightly different structure? Our development infrastructure inc

Re: [GENERAL] PostgreSQL x Sybase

> A commonly overlooked comparison for "always on" systems is to compare > what sorts of operations you can do to databases without needing to > restart the server or drop tables, lock out users etc. > We use Sybase Adaptive Server Anywhere 8 here and the thing that annoys me about it is exactly t

[GENERAL] about partitioning

dear all, i created a master table and a sub table which inherits the main table. and then i made a trigger and a function that want to keep the master table empty. but the trigger didn't work anyway.when i inserted data into the table "news",both the master table and the sub table were inserted.

Re: [GENERAL] [Slightly OT] data model books/resources?

On Mar 30, 2006, at 2:03 AM, Aaron Glenn wrote:Anyone care to share the great books, articles, manifestos, notes,leaflets, etc on data modelling they've come across? Ideally I'd liketo find a great college level book on data models, but I haven't comeacross one that even slightly holds "definitive

Re: [GENERAL] [Slightly OT] data model books/resources?

On Thursday 30 March 2006 03:03, Aaron Glenn wrote: Anyone care to share the great books, articles, manifestos, notes, leaflets, etc on data modelling they've come across? Ideally I'd like to find a great college level book on data models, but I haven't come across one that even slightly holds "d

[GENERAL] How to use views&rules to dynamically choose which table to update

I'm still relatively new to Postgres (at least when it comes to clever stuff - especially rules) so I hope I've missed something here. Basically I'm still trying to combine multiple databases with identical schemas into one schema, adding a column to each table to indicate which schema it c

Re: [GENERAL] How to use views&rules to dynamically choose which table to update

On Sat, Apr 01, 2006 at 12:04:26AM +0100, Ashley Moran wrote: > I'm still relatively new to Postgres (at least when it comes to > clever stuff - especially rules) so I hope I've missed something here. > > Basically I'm still trying to combine multiple databases with > identical schemas into on

[GENERAL] pg_hba.conf errors

Hi, Does anyone know if there were any updates to this issue? http://archives.postgresql.org/pgsql-hackers/2003-06/msg00195.php As it is now our web server running PHP attempts to connect to the DB using SSL (which is off), the server rejects the connection, logs it, then the client successfully

Re: [GENERAL] pgsql continuing network issues

> > IF I change the listen_addresses directive to localhost, I > can connect > > fine and everything works EXCEPT I get the message "NOTICE: Unknown > > win32 socket error code: 10107" repeatedly anytime I do something. > > This would be acceptable, except that I need to be able to > access thi

Re: [GENERAL] How to use views&rules to dynamically choose which table to update

Hi David On Apr 01, 2006, at 12:13 am, David Fetter wrote: Wow. That's confusing. You're telling me! :D How about using table partitioning for this? Thanks for your suggestion. I've had a look at partitioning but the

Re: [GENERAL] giving users access to specific databases

On 4/1/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi, > > I'm hoping someone can tell me how to go about this, or if a solution is > even possible with my current set up. I realize this question may go beyond > pure postgres topics and have to do more with how my hosting company has > thei

Re: [GENERAL] How to use views&rules to dynamically choose which

On Sat, 1 Apr 2006, Ashley Moran wrote: > I'm still relatively new to Postgres (at least when it comes to > clever stuff - especially rules) so I hope I've missed something here. > > Basically I'm still trying to combine multiple databases with > identical schemas into one schema, adding a column

Re: [GENERAL] How to use views&rules to dynamically choose which table to update

On Apr 01, 2006, at 12:57 am, Stephan Szabo wrote: What should it do if you try to insert something that is neither french nor english? I think an unconditional instead nothing rule might work to supplement the two conditional ones if doing nothing is okay, but I haven't tried. Wahey! The

Re: [GENERAL] about partitioning

On 4/1/06, fufay <[EMAIL PROTECTED]> wrote: > dear all, > i created a master table and a sub table which inherits the main table. > and then i made a trigger and a function that want to keep the master table > empty. > but the trigger didn't work anyway.when i inserted data into the table > "news",

[GENERAL] WAL Archiving frequency

Hi,I've setup WAL file archiving to my SAN storage over the network (using an NFS mount to the file server).I've noticed that it's archiving the 16 MB wal files about once every minute. Is this normal? There's a huge number of files in my wal_archives directory now.Is there a parameter to tell it n

Re: [GENERAL] PostgreSQL x Sybase

Thanks Mark, You gave me very good tips.. The main reason of my question is that we have a ERP software house client with many customers running PostgreSQL and one of their big customers is trying go buy another ERP system that uses Sybase instead of PostgreSQL. Now I´m sure it´s only a poli

Re: [GENERAL] pg_hba.conf errors

"Bradley W. Dutton" <[EMAIL PROTECTED]> writes: > Does anyone know if there were any updates to this issue? > http://archives.postgresql.org/pgsql-hackers/2003-06/msg00195.php That was fixed in 7.4, see sslmode connection option and PGSSLMODE environment variable. regards,

Re: [GENERAL] WAL Archiving frequency

Brendan Duddridge <[EMAIL PROTECTED]> writes: > I've noticed that it's archiving the 16 MB wal files about once every > minute. Is this normal? There's a huge number of files in my > wal_archives directory now. > Is there a parameter to tell it not to archive so frequently? Or is > this nothi

Re: [GENERAL] WAL Archiving frequency

Thanks Tom, I just didn't know if that was normal or not. I actually saw 4 WAL files / minute today. I set checkpoint_segments = 128, so maybe that will help. Thanks, Brendan Duddridge | CTO | 403-277-5591 x24 | [EMAIL P

[GENERAL] pgpool ABORT + no transaction warning

A while back, I posted about seeing a number of warnings from pgpool: http://archives.postgresql.org/pgsql-admin/2005-03/msg00305.php A typical pair of statements in my postgres logs looks like this: WARNING: there is no transaction in progress STATEMENT: ABORT Tatsuo Ishii declared that the