Re: [GENERAL] Database Corruption - last chance recovery options?

Michael Best <[EMAIL PROTECTED]> writes: > Set your memory requirement too high in postgresql.conf, reload instead > of restarting the database, it silently fails sometime later? Yeah, wouldn't surprise me, since the reload is going to ignore any changes related to resizing shared memory. I thin

Re: [GENERAL] More activity in pg_stat_activity

Erik Jones <[EMAIL PROTECTED]> writes: > Before migrating to 8.2, even during peak times, unless queries were > seriously stacking (not completing in a timely manner), we'd see at most > 50 - 100 queries active at any given time (we did have > stats_command_string = on). Since the migration, du

Re: [GENERAL] Database Corruption - last chance recovery options?

Thomas F. O'Connell wrote: On Jan 4, 2007, at 11:24 PM, Michael Best wrote: When I finally got the error report in the morning the database was in this state: $ psql dbname dbname=# \dt ERROR: cache lookup failed for relation 20884 Do you have your error logs, and were there any relevant

Re: [GENERAL] losing my large objects with Postgresql 8.1.4 and 8.1.5

Eric Davies <[EMAIL PROTECTED]> writes: > Some of my custom server functions/data types that work correctly > under Postgresql 8.0.1 are having trouble with lost large objects > under Postgresql 8.1.4 and Postgresql 8.1.5, but only in particular > usages. > When I execute the following sequenc

Re: [GENERAL] Database versus filesystem for storing images

Andrew Chernow <[EMAIL PROTECTED]> writes: > depends on how you do it. not everything has to go in a database to be > reliable. Part of good engineering is realizing when to use a tool and when > not to. > > I think a 10K view of the issue is in order. The bigger picture is being > missed, or I

Re: [GENERAL] GUI tool that can reverse engineering schemas

John McCawley wrote: Here's a little tool I wrote: http://www.hardgeus.com/projects/pgdesigner/ I have a Windows binary up there. The build process is currently a mess, sorry. It's a pretty decent little tool for quick-and-dirty visualization, which is all I really use it for. nyenyec wrot

[GENERAL] losing my large objects with Postgresql 8.1.4 and 8.1.5

Some of my custom server functions/data types that work correctly under Postgresql 8.0.1 are having trouble with lost large objects under Postgresql 8.1.4 and Postgresql 8.1.5, but only in particular usages. I'm hoping somebody familiar with the changes made to Postgresql since 8.0.X can su

Re: [GENERAL] upgrading and pg_restore versions

On Jan 4, 2007, at 2:42 PM, Angva wrote: Dear Postgres gurus, I come seeking advice on upgrading my 8.1.2 databases to 8.2. My environment in a nutshell: I have a master database on one server that is used to process large amounts of data. This data is replicated daily to several destinatio

Re: [GENERAL] Database versus filesystem for storing images

Andrew Chernow <[EMAIL PROTECTED]> writes: > I wasn't saying to do this each time you run a backup, geez that would be > horrible. Pickup from where you left off the last time you backed up > data/records. How many images and how much data is being generated in a 60 > second period? I dought 3

Re: [GENERAL] Database versus filesystem for storing images

> And introducint more failing points. depends on how you do it. not everything has to go in a database to be reliable. Part of good engineering is realizing when to use a tool and when not to. I think a 10K view of the issue is in order. The bigger picture is being missed, or I am not com

Re: [GENERAL] Database Corruption - last chance recovery options?

On Jan 4, 2007, at 11:24 PM, Michael Best wrote: When I finally got the error report in the morning the database was in this state: $ psql dbname dbname=# \dt ERROR: cache lookup failed for relation 20884 Do you have your error logs, and were there any relevant errors in them preceding

Re: [GENERAL] Database versus filesystem for storing images

Andrew Chernow <[EMAIL PROTECTED]> writes: >>> Or am >>>I the only one that is thinking about referential integrity with those files? > Not at all. I'm not sure how 3rd party tools like apache, `ls`, `gzip`, > `find`, nfs, etc... are breaking integrity. Any php, jsp, C or shell script For gzip,

Re: [GENERAL] Continue sequence

Wilton <[EMAIL PROTECTED]> writes: > Hi, > > Which is the correct way to obtain a continue sequence without fail (hole/gap) > for a composite-id ? http://www.google.com.br/search?q=gapless+sequence+postgresql Since the first hits -- at Varlena -- aren't accessible you can use google's cache: ht

Re: [GENERAL] Database versus filesystem for storing images

Ragnar <[EMAIL PROTECTED]> writes: > for that matter, what happens if one transaction is using or > even reading an image while another is updating it? I believe that this also depends on how the file is updated. Some applications create a temporary file with the new (or changed) content and the

Re: [GENERAL] Database versus filesystem for storing images

> copying 3 billion files and a few hundred terabytes while still maintaining an > adequate service rate with part of its infra-structure down, just to use your I wasn't saying to do this each time you run a backup, geez that would be horrible. Pickup from where you left off the last time you b

Re: [GENERAL] Database versus filesystem for storing images

> what happens if you rollback a transaction that just updated > an image file? > > for that matter, what happens if one transaction is using or > even reading an image while another is updating it? One thing I mentioned was about a point in time backup, not updating the image. This would rollb

Re: [GENERAL] Continue sequence

Hi, On Fri, 2007-01-05 at 11:13 -0200, Wilton wrote: > Which is the correct way to obtain a continue sequence without fail > (hole/gap) for a composite-id ? http://www.varlena.com/GeneralBits/130.php may help you. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 Post

Re: [GENERAL] GUI tool that can reverse engineering schemas

Here's a little tool I wrote: http://www.hardgeus.com/projects/pgdesigner/ I have a Windows binary up there. The build process is currently a mess, sorry. It's a pretty decent little tool for quick-and-dirty visualization, which is all I really use it for. nyenyec wrote: Hi, Can anyone

Re: [GENERAL] Database versus filesystem for storing images

On fös, 2007-01-05 at 15:49 -0500, Andrew Chernow wrote: > I 100% agree. Use the database as a lookup into the filesystem. Don't load > the > database up with terabytes of non-searchable binary data? not sure how that > would help you? > > >I mean, how do you handle integrity with data >

[GENERAL] PyGreSQL Install

I'm crossposting this one with comp.lang.python, since it's a bit of a crisis (I'm going on a 3 week trip for work with only my laptop so I need to get this running!). I'm trying to get the pgdb module working in python 2.5 on my macbook, 2ghz intel core duo, running os x 10.4.8. I didn't have po

Re: [GENERAL] PyGreSQL Install

Someone over at comp.lang.python answered my question. I was just being an idiot and forgot that the PATH additions I'd made to my own account don't apply to root, so "python" gave my python2.3 instead of python2.5 like in my account. ---(end of broadcast)

Re: [GENERAL] Index vacuum improvements in 8.2

>From 8.2 release notes: Speed up vacuuming of B-Tree indexes (Heikki Linnakangas, Tom) >From "2. Vacuum is now done in one phase, scanning the index in physical order. That significantly speeds up index vacuums of large inde

[GENERAL] PgSQL Monitoring( Please let me know the table details )

Hi, I am working on database monitoring tool using Java, JDBC. We plan to monitor pgSQL also. But i need some details like, where i can get information such as Connection time, Connection statistics, Database Information, Transaction statistics, Cache details from pgSQL and what are the metric

Re: [GENERAL] Any form of connection-level "session variable" ?

In article <[EMAIL PROTECTED]>, John McCawley <[EMAIL PROTECTED]> wrote: % Is there any way I could establish this ID initially in some sort of % connection-level variable, and from this point on reference that % variable? We do this sort of thing using a custom C function, but I've been thinki

Re: [GENERAL] Using duplicate foreign keys

> The problem I see with that is that any value of accountnumber in > public.commontable would need to be in both company1.chartoffaccounts and > company2.chartoffaccounts. One key referencing two completely sets of > data? That sounds broken. Can you give a more detailed example of how > yo

[GENERAL] Continue sequence

Hi, Which is the correct way to obtain a continue sequence without fail (hole/gap) for a composite-id ? Example: CREATE TABLE nf ( number INTERGER NOT NULL, serie VARCHAR(2) NOT NULL, CONSTRAINT pky_nf PRIMARY KEY (number,serie) ) number serie 1 A 2 A

[GENERAL] GUI tool that can reverse engineering schemas

Hi, Can anyone suggest a free GUI tool that can reverse engineer a postgresql schema and show it as a diagram? It doesn't have to be very sophisticated, I just need to get a quick understanding of schemas that I'm not familiar with. Thanks, nyenyec ---(end of broadcast)

[GENERAL] upgrading and pg_restore versions

Dear Postgres gurus, I come seeking advice on upgrading my 8.1.2 databases to 8.2. My environment in a nutshell: I have a master database on one server that is used to process large amounts of data. This data is replicated daily to several destination databases, each on a separate server. There ar

Re: [GENERAL] Database versus filesystem for storing images

Referential integrity would be one positive for storing the files in the database. I wasn't responding to that. I'm simply saying that browsing them with third-party tools, updating, compressing/archiving, etc. is easier if they are not in the database. Those are all actions that I've found usef

[GENERAL] configure; make on cygwin doesn't produce DLLs

[After posting this on the postgresql-cygwin mailing list I realized it has had very low traffic in 2006. I hope it's ok to re-post my question here.] Hi, I'm trying to compile postgres-8.2.0 from source on WinXP-SP2, for use with libpqxx. At first I was able to compile in cygwin with ./confi

Re: [GENERAL] Database versus filesystem for storing images

Andrew Chernow <[EMAIL PROTECTED]> writes: >> And how do you guarantee that after a failure? You're restoring two >> different sets of data here: > >> How do you link them together on that specific operation? Or even on a daily >> basis, if you get corrupted data... > > I answered that already.

Re: [GENERAL] Database versus filesystem for storing images

>> Or am >>I the only one that is thinking about referential integrity with those files? Not at all. I'm not sure how 3rd party tools like apache, `ls`, `gzip`, `find`, nfs, etc... are breaking integrity. Any php, jsp, C or shell script you write would be doing the same thing, accessing the da

Re: [GENERAL] More activity in pg_stat_activity

Erik Jones wrote: > Hi, this question is mostly born of curiosity: when monitoring our > database I often use the following queries to get a current query count > and listing of individual queries: > > select count(*) > from pg_stat_activity > where current_query not ilike ''; > > select proc

Re: [GENERAL] Database versus filesystem for storing images

If you end up storing the pictures on a separate database server for performance reasons, Jorge's argument regarding integrity becomes moot...And his argument so far is the strongest case I've seen for storing the files in the database. Scott Marlowe wrote: On Fri, 2007-01-05 at 15:54, Jerem

Re: [GENERAL] Database versus filesystem for storing images

"Jeremy Haile" <[EMAIL PROTECTED]> writes: > Another thing to consider is that storing them in the file system makes > it much easier to browse the images using third-party tools, update > them, archive them (by gzipping or whatever). This is much more > difficult if they are stored in the databa

Re: [GENERAL] [ADMIN] vacuum fails with 'invalid page header' message

On Fri, 2007-01-05 at 16:19, Geoffrey wrote: > Geoffrey wrote: > > We had a vacuum fail recently with the following error: > > > > invalid page header in block 846 of relation "move_pkey" > > > > Anyone have an idea what could cause this problem and what we need to do > > to resolve it? > > >

Re: [GENERAL] Slony across platforms

On Fri, 2007-01-05 at 15:54, Raymond O'Donnell wrote: > Hi all, > > Would there be any problem with using Slony-I to replicate from a > Windows server to Linux? Has anyone done this? > > Also, is there a mailing list for Slony? Should work. Try to have them run with the same locale setting (an

Re: [GENERAL] [ADMIN] vacuum fails with 'invalid page header' message

Geoffrey wrote: We had a vacuum fail recently with the following error: invalid page header in block 846 of relation "move_pkey" Anyone have an idea what could cause this problem and what we need to do to resolve it? Running on Red Hat Enterprise 3, postgres 7.4.13 Regarding the issue abo

Re: [GENERAL] Slony across platforms

That's great - thanks. Ray. -- Raymond O'Donnell Director of Music, Galway Cathedral, Galway, Ireland [EMAIL PROTECTED] -- ---(end of

Re: [GENERAL] Database versus filesystem for storing images

On Fri, 2007-01-05 at 15:54, Jeremy Haile wrote: > Yeah - it can make it easier to implement transactional semantics by > storing them in the database, although for simple operations it wouldn't > be hard to replicate this manually. And you are going to incur a > performance penalty by storing the

Re: [GENERAL] Slony across platforms

Hi, On Fri, 2007-01-05 at 21:54 +, Raymond O'Donnell wrote: > Would there be any problem with using Slony-I to replicate from a > Windows server to Linux? Has anyone done this? I haven't tried this; but it should work, I think. > Also, is there a mailing list for Slony? http://gborg.postg

Re: [GENERAL] Slony across platforms

On Fri, 2007-01-05 at 21:54 +, Raymond O'Donnell wrote: > Hi all, > > Would there be any problem with using Slony-I to replicate from a > Windows server to Linux? Has anyone done this? In theory this should work. > > Also, is there a mailing list for Slony? http://www.slony.info/ Joshua

Re: [GENERAL] Database versus filesystem for storing images

Yeah - it can make it easier to implement transactional semantics by storing them in the database, although for simple operations it wouldn't be hard to replicate this manually. And you are going to incur a performance penalty by storing them in the database. Another thing to consider is that s

[GENERAL] Slony across platforms

Hi all, Would there be any problem with using Slony-I to replicate from a Windows server to Linux? Has anyone done this? Also, is there a mailing list for Slony? Thanks, Ray O'Donnell -- Raymond O'Donnell Director of Music,

Re: [GENERAL] Database versus filesystem for storing images

On Fri, Jan 05, 2007 at 15:26:45 -0500, James Neff <[EMAIL PROTECTED]> wrote: > "... and Moses said unto them, 'The eleventh commandment : thou shalt > store images in a database!'..." > > What if you had another database where you stored just the images and > not back it up if you don't want

Re: [GENERAL] vacuum v. vacuumdb

On Friday 05 January 2007 21:05, Erik Jones wrote: > Quick question, when running a VACUUM query through the postmaster, > does it use the external vacuumdb tool? No, quite the opposite; the 'vacuumdb' simply invokes the VACUUM command in the postmaster. vacuumdb along with reindexdb, createdb,

Re: [GENERAL] Database versus filesystem for storing images

> And how do you guarantee that after a failure? You're restoring two > different sets of data here: > How do you link them together on that specific operation? Or even on a daily > basis, if you get corrupted data... I answered that already. > Not counting that depending on your choice of fi

[GENERAL] vacuum fails with 'invalid page header' message

We had a vacuum fail recently with the following error: invalid page header in block 846 of relation "move_pkey" Anyone have an idea what could cause this problem and what we need to do to resolve it? Running on Red Hat Enterprise 3, postgres 7.4.13 -- Until later, Geoffrey Those who would

Re: [GENERAL] Deleting From View?

On Fri, Jan 05, 2007 at 10:22:38AM -0600, Jeanna Geier wrote: > Interestingly enough... he doesn't have an INSERT rule... > > The INSERTs all appear to be done using the JDBC and prepared statements in > the code. Well, I think that's going to make your job difficult then. Obviously whatever is h

Re: [GENERAL] Database versus filesystem for storing images

Andrew Chernow <[EMAIL PROTECTED]> writes: >>I mean, how do you handle integrity with data >> outside the database? > You don't, the file system handles integrity of the stored data. Although, > one must careful to avoid db and fs orphans. Meaning, a record with no > corresponding file or a file

Re: [GENERAL] Database versus filesystem for storing images

John McCawley <[EMAIL PROTECTED]> writes: > This is a web app, so in my example all of the images live on a web server, > and our data lives on a separate database server. We have a completely > duplicated setup offsite, and mirror images of every server at the backup > site. Every night we use

Re: [GENERAL] vacuum v. vacuumdb

Nope - the other way around. The vacuumdb tool simply executes the VACUUM command through postmaster. On Fri, 05 Jan 2007 15:05:44 -0600, "Erik Jones" <[EMAIL PROTECTED]> said: > Quick question, when running a VACUUM query through the postmaster, > does it use the external vacuumdb tool? > >

Re: [GENERAL] Database versus filesystem for storing images

How does it make it easier to control access and security? If your web app makes a decision about allowing access to the database, it can just as easily make a decision about allowing access to the filesystem. Storing the images on the file system doesn't mean that there isn't a piece of code tha

[GENERAL] vacuum v. vacuumdb

Quick question, when running a VACUUM query through the postmaster, does it use the external vacuumdb tool? -- erik jones <[EMAIL PROTECTED]> software development emma(r) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please

Re: [GENERAL] Database versus filesystem for storing images

My comment about stark raving madmen was somewhat tongue-in-cheek. There is certainly a case to be made for images in a database under some circumstances. However, for the average Joe web developer, and certainly someone new to the whole problem, I think storing them on the filesystem is goin

Re: [GENERAL] Database versus filesystem for storing images

We use WebDAV and Apache's Slide to store our images and, as someone pointed out earlier, store the links to the images in our database. WebDAV has provided us with excellent access control and security... http://www.webdav.org/ http://jakarta.apache.org/slide/index.html Just my 1/2 cents, -Jean

Re: [GENERAL] Database versus filesystem for storing images

This is a web app, so in my example all of the images live on a web server, and our data lives on a separate database server. We have a completely duplicated setup offsite, and mirror images of every server at the backup site. Every night we use rsync to duplicate everything offsite. Also, a

Re: [GENERAL] Database versus filesystem for storing images

>> Don't store your images in the database. Store them on the filesystem and >> store their path in the database I 100% agree. Use the database as a lookup into the filesystem. Don't load the database up with terabytes of non-searchable binary data? not sure how that would help you? Here i

Re: [GENERAL] Database versus filesystem for storing images

"... and Moses said unto them, 'The eleventh commandment : thou shalt store images in a database!'..." What if you had another database where you stored just the images and not back it up if you don't want to? As an application developer, I like the idea of storing files and images in the d

Re: [GENERAL] Database versus filesystem for storing images

John McCawley <[EMAIL PROTECTED]> writes: > Don't store your images in the database. Store them on the filesystem and > store their path in the database. Anyone that tells you otherwise is a stark > raving madman :) > > My system is very heavily used, and our pg_dump is only a few gigs. Meanwhi

Re: [GENERAL] Interrupted pg_dump / pg_restore Upgrade

On Jan 4, 2007, at 7:03 PM, Tom Lane wrote: "Thomas F. O'Connell" <[EMAIL PROTECTED]> writes: My big question is: Is there anything that happens late in the game in a pg_dumpall that affects system catalogs or other non-data internals in any critical ways that would make an interrupted pg_dump

Re: [GENERAL] Continue sequence

On Fri, Jan 05, 2007 at 09:30:46 -0800, Wilton Wonrath <[EMAIL PROTECTED]> wrote: > > I think that I will need to use LOCK TABLE or SELECT FOR UPDATE, but in > both cases if the client terminal shutdown suddenly the tuple/table > stays locked on the server for a indeterminate time. You need t

Re: [GENERAL] Database versus filesystem for storing images

Don't store your images in the database. Store them on the filesystem and store their path in the database. Anyone that tells you otherwise is a stark raving madman :) My system is very heavily used, and our pg_dump is only a few gigs. Meanwhile our images/documents storage is well over a h

Re: [GENERAL] Database versus filesystem for storing images

It's almost always better to store the images on the file system and just store the filename or relative path in the database. This is more efficient, doesn't bloat the database by storing files in it, and is easier to get proper browser caching behavior (depending on how your app is setup). I

Re: [GENERAL] Database versus filesystem for storing images

5 Jan 2007 06:59:18 -0800, imageguy <[EMAIL PROTECTED]>: I think I know the answer, If you know the answer please tell it as I have read some discussions on the web and although I have decided on a solution I'm still not sure about the best answer, if there is a best answer after all. but if

[GENERAL] More activity in pg_stat_activity

Hi, this question is mostly born of curiosity: when monitoring our database I often use the following queries to get a current query count and listing of individual queries: select count(*) from pg_stat_activity where current_query not ilike ''; select procpid, (now() - query_start) as query

[GENERAL] Continue sequence

Hi, Which is the correct way to obtain a continue sequence without fail (hole/gap) for a composite-id ? Example: CREATE TABLE nf ( number INTERGER NOT NULL, serie VARCHAR(2) NOT NULL, CONSTRAINT pky_nf PRIMARY KEY (number,serie) ) number serie 1 A 2

Re: [GENERAL] Deleting From View?

Interestingly enough... he doesn't have an INSERT rule... The INSERTs all appear to be done using the JDBC and prepared statements in the code. -Original Message- From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED] Sent: Friday, January 05, 2007 10:16 AM To: Jeanna Geier Cc: pgsql-gene

Re: [GENERAL] Deleting From View?

On Fri, Jan 05, 2007 at 09:59:34AM -0600, Jeanna Geier wrote: > Thanks for the quick reply; that's one of the many reasons why this list is > so awesome... > > I'm taking this project over from somebody else and am new to the DB side of > things, so I'm still learning - you're responses and though

Re: [GENERAL] Deleting From View?

Thanks for the quick reply; that's one of the many reasons why this list is so awesome... I'm taking this project over from somebody else and am new to the DB side of things, so I'm still learning - you're responses and thoughts are greatly appreciated! Definition: Create view "elementdata"."me

Re: [GENERAL] Deleting From View?

Jeanna Geier <[EMAIL PROTECTED]> schrieb: > > Hello List! > > I'm having an issue with my program; it's inserting into one record into a > view (named 'measurement') twice ,which it's not supposed to be - so, I'm You can't insert data into a view. My guess: you have a RULE for this VIEW to hand

Re: [GENERAL] Deleting From View?

On Fri, Jan 05, 2007 at 09:42:09AM -0600, Jeanna Geier wrote: > > Hello List! > > I'm having an issue with my program; it's inserting into one record into a > view (named 'measurement') twice ,which it's not supposed to be - so, I'm > attempting to put a delete statement in the code to remove one

Re: [GENERAL] Deleting From View?

Hello List! I'm having an issue with my program; it's inserting into one record into a view (named 'measurement') twice ,which it's not supposed to be - so, I'm attempting to put a delete statement in the code to remove one of these records, but am getting an error. (Will track down the real ins

Re: [GENERAL] Any form of connection-level "session variable" ?

> ...and you don't need to worry about cleanup... What cleanup? Temp tables are dropped on connection close. -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---(end of broadcast)--- TIP 2: Don't 'kill -9' the pos

Re: [GENERAL] Any form of connection-level "session variable" ?

On Thu, Jan 04, 2007 at 06:53:09PM -0700, Scott Ribe wrote: > What about: > > create function set_emp_id() returns void as $$ > begin > drop table if exists emp_1_id; > select emp_id into temp emp_1_id from secureview.tbl_employee where > username = current_user; > end; > $$ language

Re: [GENERAL] [JDBC] PgSQL Monitoring( Please let me know the table details )

On Fri, Jan 05, 2007 at 09:55:05AM +0530, sbaskar wrote: > Hi, > I am working on database monitoring tool using Java, JDBC. We plan > to monitor pgSQL also. But i need some details like, where i can > get information such as Connection time, Connection statistics, > Database Information, Transacti

Re: [GENERAL] Database versus filesystem for storing images

Scott Ribe wrote: > Personally, I'd put them on the file system, because then backup software > can perform incremental backups. In the database, that becomes more of a > difficulty. One suggestion, don't use a file name from a hash to store the > image, just use the serial id, and break them up b

Re: [GENERAL] Table inheritance implementation.

On pią, 2007-01-05 at 10:55 +0100, Martijn van Oosterhout wrote: > On Fri, Jan 05, 2007 at 09:27:31AM +0100, Grzegorz Nowakowski wrote: > > Well, I never used partitioning and I don't know what it's worth but > > just after sending my original mail I got another variant of the idea: > > to duplicat

Re: [GENERAL] Table inheritance implementation.

On Fri, Jan 05, 2007 at 09:27:31AM +0100, Grzegorz Nowakowski wrote: > Well, I never used partitioning and I don't know what it's worth but > just after sending my original mail I got another variant of the idea: > to duplicate columns (parent(p), child(p,c)), so inserts into child > update both pa

Re: [GENERAL] pg_dump problems

Im using Red Hat Enterprise Linux 4. Thing is it worked before christmas but doesn't now. I've just moved the data across by hand so its not too much of a problem anymore. Might need to use dump again though so would be nice to get the problem fixed Tom Lane-2 wrote: > > JTyrrell <[EMAIL PROT

Re: [GENERAL] Dependency conflicts on CentOS 4.4

Hi, On Fri, 2007-01-05 at 07:33 +0100, Gunnar Wagenknecht wrote: > Thanks, it worked. But I had to remove > compat-postgresql-libs-4-2PGDG.rhel4.i686.rpm for this one to work. > What if some client needs libpq.so.4? I had the same issue in my box a few days before. I had to do rpm -ivh --force .

Re: [GENERAL] Table inheritance implementation.

On czw, 2007-01-04 at 10:44 -0500, Tom Lane wrote: > Grzegorz Nowakowski <[EMAIL PROTECTED]> writes: > > But I have another question: why can't be > > inheritance implemented as implicit JOIN? > > Interesting thought, but joins are expensive --- this would be quite a > lot slower than the current