RE: [GENERAL] Inheritance and Referencing troubles... (confusing problem)

Thanks for your help... Inheritance seem to be useless to me now ;) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[GENERAL] No reference to inherited columns?

Can it be that I cannot reference to any inherited columns? Or is there a special way to do it? The manual doesn't seem to cover this one... Thx Chris ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Thank you:)

Thanks to all who helped me with my questions... I sometimes forget / loose track so I'll do it this way ;)You know who you are :) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.

[GENERAL] RE: [ADMIN] Primary Keys

I'll quote Thomas F.O'Connell on this one as it has been discussed just some days ago: first of all, i recommend checking out the syntax for the CREATE TABLE command. it's available here: http://postgresql.readysetnet.com/users-lounge/docs/7.1/postgres/sql-cre atetable.html for a quick exampl

RE: [GENERAL] Unique or Primary Key?

> Besides, I couldn't see much use in creating it as a primary > key. How > would I ever reference it from another table? What does this have to do with beeing a primary key? Well you reference to primary keys as you do with others?!? When you have for example user ids you shouldn't have a cu

[GENERAL] Strange SERIAL / Sequence error

I create a table with: CREATE TABLE "tab" ("asdf" SERIAL, "asdf2" char (20) NOT NULL ); Then I try to insert some data: INSERT INTO "tab" ("asdf", "asdf2") VALUES (NEXTVAL('""tab_asdf_seq""'::text), 'asdf') ERROR: Relation '"tab_asdf_seq"' does not exist (done with phpPgAdmin 2.3) --

RE: [GENERAL] Ideal hardware configuration for pgsql

> Tomorrow I'd like to place an order for something more > robust... looking > into dual PIII, gig of ram and SCSI Raid. Planning on > running Red Hat 7.1 > on this machine. Maybe a AMD Athlon 1.33GHZ would be better.. It's a very fast CPU and I don't know if PostgreSQL runns faster on dual

[GENERAL] RE: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?

2001 7:59 PM > To: Christian Marschalek > Cc: PostgreSQL-General > Subject: Re: NOTICE: CREATE TABLE will create implicit > trigger(s) for FOREIGN KEY check(s) ? > > > > Can anyone tell me what this notice means? > > > > NOTICE: CREATE TABLE will create impli

[GENERAL] NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?

Can anyone tell me what this notice means? NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ? greetings ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] RE: Supertypes?

Oh yeah we've learned about the normal forms too :) It's all flying back into my mind right now ;o) Thx! > -Original Message- > From: Gregory Wood [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 27, 2001 5:04 PM > To: Christian Marschalek > Subject: Re: S

RE: [GENERAL] PostgreSQL under Windows?

Thx for your help > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > Vince Vielhaber > Sent: Monday, March 26, 2001 9:41 PM > To: Christian Marschalek > Cc: 'Peter Eisentraut'; [GENERAL] PostgreSQL > Subje

[GENERAL] PostgreSQL under Windows?

Is it possible to compile and run PostgreSQL under Windows2000 ? TIA Legshot ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

RE: [GENERAL] Views...

Well I think I can do it without updating... Thanks to both of you :o) > -Original Message- > From: Richard Huxton [mailto:[EMAIL PROTECTED]] > Sent: Sunday, March 25, 2001 2:14 PM > To: Brett W. McCoy > Cc: Christian Marschalek; [GENERAL] PostgreSQL > Subject: R

[GENERAL] Views...

Hi! I can't find the desciption of "views" in the PostgreSQL docs. Could somebody please point me out or explain database views to me? Thanks and regards Chris ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

[GENERAL] Prefered programs and utils?

Hi there :o) Would you mind replying with a list of your favourite programs with guis? (for postgresql of cause;) Tia! (and thanks for the answers to my last question, about shutting down the database) Regards, Chris ---(end of broadcast)--- T

RE: [GENERAL] Re: Compiling / TCL error

: [EMAIL PROTECTED] > Subject: [GENERAL] Re: Compiling / TCL error > > > Christian Marschalek <[EMAIL PROTECTED]> wrote: > >I get the followig error although TK is installed > > Did you install the development files (headers) for Tk? (The > runtime files aren'

[GENERAL] $PGDATA problem

Should be selv explainable: postgres@Server:/home/legshot > initdb initdb: You must identify where the the data for this database system will reside. Do this with either a --pgdata invocation option or a PGDATA environment variable. postgres@Server:/home/legshot > echo $PGDATA /mnt/hdb/usr/loca

RE: [GENERAL] ssl connections with psql

> For those reading this and assuming that using SSL is always a good thing, > SSL data connections are up to 100 times slower, as all of the data has > to be encrypted and decrypted by the server and the client. Running SSL > connections to the same server you're hosting the web pages on would be

[GENERAL] Comipling error plz help

I get the followig error although TK is installed -start make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgaccess' make[2]: Entering directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh' gcc -I../../include -I../../backe

[GENERAL]

I get the followig error although TK is installed -start make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgaccess' make[2]: Entering directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh' gcc -I../../include -I../../backe