Re: [GENERAL] unbalanced indexes -> fixed via dump/restore?

will trillich <[EMAIL PROTECTED]> writes: > A) > pg_dump -c mydb > db.out.sql > and then > psql mydb < db.out.sql > periodically? > or is it better to > B) merely 'reindex' on occasion? Plain old DROP INDEX / CREATE INDEX is probably the best-trodden path. Your (A) seems like vastly

Re: [GENERAL] How robust is postgresql ?

Thanks for the answer, (and thanks to adb too) > > 7.1 has write-ahead logging (WAL), which does what you are looking for. > See http://www.postgresql.org/devel-corner/docs/admin/wal.html > > The fsync mode also helps with data integiry, but it *really* slows down > the system, unfortunately. Loo

Re: [GENERAL] Update through views?

[EMAIL PROTECTED] writes: > Nope - and I'm not sure how Postgres is ever going to figure out how to > update/insert on a view in the general case. The view might use UNION, > GROUP BY and CASE and effectively be read-only. I can guarantee that we won't ever support these things on an arbitrary

[GENERAL] Data types?

How do i find out what data types are available in PostgreSQL. I know there are more that the ones in the docs, and i ones saw a command to list all the data types. And there was a lot more than the ones from the docs. \Flemming ---(end of broadcast)-

Re: [GENERAL] explain -> how to optimize?

On Wed, Mar 07, 2001 at 11:24:34AM -0600, will trillich wrote: > here's an EXPLAIN on a VIEW which links a few tables: Can you give us the definition of the VIEW? Also, what kinds of data are you dealing with? Stuff like the # of rows. Are the planner estimate's below reasonable? [...] > okay,

[GENERAL] inheritance and primary/foreign keys

Question 1: If table A has as its primary key "a_pk" and table B inherits table A, then table B also has as its primary key a_pk. Is that correct? Question 2: If I want table C to have a foreign key on both A and B, is the following syntax correct? (I'm using 7.0.3) CREATE TABLE c (

Re: [GENERAL] inheritance and primary/foreign keys

On Wed, 7 Mar 2001, Daniel J. Kressin wrote: > Question 1: If table A has as its primary key "a_pk" and table B > inherits table A, then table B also has as its primary key a_pk. Is > that correct? I don't believe so currently. > Question 2: If I want table C to have a foreign key on both A an

Re: [GENERAL] Data types?

On Thu, 08 Mar 2001 12:29, Flemming Frøkjær wrote: > How do i find out what data types are available in PostgreSQL. > I know there are more that the ones in the docs, and i ones saw a > command to list all the data types. And there was a lot more than the > ones from the docs. Look in the regress

Re: [GENERAL] Data types?

Christopher Sawtell <[EMAIL PROTECTED]> writes: > On Thu, 08 Mar 2001 12:29, Flemming Frøkjær wrote: >> How do i find out what data types are available in PostgreSQL. > Look in the regression tests. Interesting stuff. And there's always "select * from pg_type" ... not to mention the source code

[GENERAL] Paradox, dbf and PostgreSQL ?

Hi, I'm from Nantes, France and I've started learning PostgreSQL a few weeks ago. I've read the manual, but I'm still new, so just tell me if I write nonsense. My Brother is still on winchose, and he has sent to me some *.dbf and paradox data files that he made with Delphi or something like th

Re: [GENERAL] SELECT performance drop v 6.5 -> 7.0.3

"Creager, Robert S" wrote: > > I've a question. I have often seen the 'trick' of dropping an index, > importing large amounts of data, then re-creating the index to speed the > import. The obvious problem with this is during the time from index drop to > the index finishing re-creation, a large

[GENERAL] How to check if a database exists

Hi, How can I programmatically check if a database exists using c lib? Thank you ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] How to check if a database exists

Hi, How can I programmatically check if a database exists using c lib? Thank you ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[GENERAL] How to check if a table exists

Also how to programmatically check if a table exists in the database? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] How to check if a table exists

On Wed, 07 Mar 2001, Jeff wrote: > Also how to programmatically check if a table exists in the database? I think the easiest way is to attach to one of the default database like "Template0" i think, then query the system tables. pg_database and pg_class are theones you will be after i think. (

[GENERAL] Re: Paradox, dbf and PostgreSQL ?

At 02:17 08.03.2001 +0100, Thomas Nagy wrote: >Hi, > >I'm from Nantes, France and I've started learning PostgreSQL a few weeks >ago. I've read the manual, but I'm still new, so just tell me if I write >nonsense. > >My Brother is still on winchose, and he has sent to me some *.dbf and >paradox d