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.html
[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 example, though: create table foo ( bar int4, baz int4, ola int4, primary key( bar, baz ) ); this statement will make the columns bar and baz coincidentally the primary key for the table foo. -tfo > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Brian Z > Sent: Monday, April 30, 2001 11:21 PM > To: [EMAIL PROTECTED]@postgresql.org > Subject: [ADMIN] Primary Keys > > > How can you create a Primary Key which contains multiple > columns on for a table. > > > > > ---(end of > broadcast)--- > TIP 3: if posting/reading through Usenet, please send an > appropriate subscribe-nomail command to > [EMAIL PROTECTED] so that your message can get through > to the mailing list cleanly > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
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 customer without a number.. So a primary key would be a good idea, wouldn't it? ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[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)
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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 since I don't know if it can handle the load balancing? Well.. GIG of Ram is never bad... :) SCSI Raid should secure your data also. You should use IBM HDs. They never brake in a million years ;) Well and if.. You habe 5 years garantie... > You're input is tremendously appreciated! Don't know if sun machines help in your case since I don't know suns ;) But I guess others could help you better if they knew some more details about the use of the server. greets ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[GENERAL] RE: NOTICE: CREATE TABLE will create implicit trigger(s) for FOREIGN KEY check(s) ?
Got it... It seams those triggers were created to handle the types I used for the columns: int2 and bytea... I realy should check out the types section in the postgres docu :)) > -Original Message- > From: Gregory Wood [mailto:[EMAIL PROTECTED]] > Sent: Thursday, April 26, 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 implicit trigger(s) for > FOREIGN KEY > > check(s) ? > > It means that PostgreSQL will automatically create triggers > to perform your foreign key checks :) > > Seriously though, PostgreSQL has to have some mechanism to > check that your foreign key values exist (or not), and it > does that by using a feature already built into PostgreSQL: > triggers. Nothing you really need to worry about unless you > are doing something fancy (for instance, disabling all > triggers on either table to accomplish some action... in such > a case your foreign key relationship might be broken). > > Greg > > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[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: Supertypes? > > > > Well we've learned that when you have lets say five tables > which all > > contain name, adresse, city and so on you also have a form of > > redundancy... Can be wrong, though ;o) > > When dealing with relational databases, that redundancy (or > the process of eliminating it) is called normalization. This > usually involves breaking tables apart into smaller tables. > There are several 'normal forms' which database designers > strive for... each normal form is closer to the 'ideal' > database, although most designers don't bother with much > beyond 3rd normal form. Of course, it can be wise to break > the rules for performance reasons... > > Anyway, I highly recommend reading up on the topic... I > didn't when I first started playing with SQL and look back on > those days as my little database 'Dark Ages'. > > Greg > > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
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 > Subject: RE: [GENERAL] PostgreSQL under Windows? > > > On Mon, 26 Mar 2001, Christian Marschalek wrote: > > > Hm... I can only find how to compile the libraries under visual c++ > > http://www.postgresql.org/related.html > > Vince. > > > > > > regards > > > > > -Original Message- > > > From: Peter Eisentraut [mailto:[EMAIL PROTECTED]] > > > Sent: Monday, March 26, 2001 9:04 PM > > > To: Christian Marschalek > > > Cc: [GENERAL] PostgreSQL > > > Subject: Re: [GENERAL] PostgreSQL under Windows? > > > > > > > > > Christian Marschalek writes: > > > > > > > Is it possible to compile and run PostgreSQL under Windows2000 ? > > > > > > Yes. See installation instructions. (Requires Cygwin.) > > > > > > -- > > > Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/ > > > > > > > > > > > > ---(end of > > broadcast)--- > > TIP 4: Don't 'kill -9' the postmaster > > > > -- > == > > Vince Vielhaber -- KA8CSHemail: [EMAIL PROTECTED] http://www.pop4.net 56K Nationwide Dialup from $16.00/mo at Pop4 Networking Online Campground Directoryhttp://www.camping-usa.com Online Giftshop Superstorehttp://www.cloudninegifts.com == ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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: Re: [GENERAL] Views... > > > "Brett W. McCoy" wrote: > > > > Briefly, a view is a 'virtual' table -- you create a view with a > > select statement that can relate data between different > tables or use > > a subset of data from a specific table. You can think of them as a > > 'saved query'. Once you create a view, you can then query them just > > like a normal table. You cannot, as of yet, update views in > > PostgreSQL, they are read only. > > Not by default, but you can of course define your own rules > to allow updating. > > - Richard Huxton > ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[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 command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
[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)--- TIP 4: Don't 'kill -9' the postmaster
RE: [GENERAL] Re: Compiling / TCL error
Recompiled tk, tcl and postgresql and no it works... Strange but true :o) Anyway, thx for your response! > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of > J.H.M. Dassen (Ray) > Sent: Wednesday, March 21, 2001 11:14 AM > To: [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't enough to compile against it) Did > "configure" find them and state that it could use Tk? > > >gcc -I../../include -I../../backend -O2 -Wall -Wmissing-prototypes > [cut] > >-o pgtksh pgtkAppInit.o \ > > -L../../interfaces/libpgtcl -lpgtcl -L../../interfaces/libpq -lpq > >-L/usr/X 11R6/lib -L/usr/local/lib -ltk8.3 -L/usr/X11R6/lib > -lX11 -ldl > >-lieee -lm \ > > -L/usr/local/lib -ltcl8.3 -lX11 -lcrypt -lnsl -ldl -lm -lutil > >-lreadline -lncurses -export-dynamic > > >pgtkAppInit.o(.text+0x11): undefined reference to `Tk_Main' > > No surprising, given that there is no '-ltk' or similiar, so > probably "configure" didn't find Tk or couldn't use it. Rerun > "configure" (with a "-v" just for good luck) and pay close > attention to what it says about Tk. > > HTH, > Ray > -- > USDoJ/Judge Jackson: "Microsoft has performed an illegal > operation and will be shut down." > James Turinsky in alt.sysadmin.recovery > > > ---(end of > broadcast)--- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to > [EMAIL PROTECTED]) > ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[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/local/pgsql/data --- PGDATA is set and still initdb claims about it? Any help? Tia and regrads Chris ---(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] 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 > a fairly interesting way of shooting yourself in the foot, but not useful > for much else. I'm not assuming SSL is always a good thing, but sometimes security is more important than speed, and in this case SSL does excatly what it should :o) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[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../../backend -O2 -Wall -Wmissing-prototypes -Wmissi ng-declarations -I/usr/X11R6/include -I../../interfaces/libpgtcl -DHAVE_UNIS TD_H=1 -DHAVE_LIMITS_H=1 -DSTDC_HEADERS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SY S_TIME=1 -DHAVE_PW_GECOS=1 -o pgtksh pgtkAppInit.o \ -L../../interfaces/libpgtcl -lpgtcl -L../../interfaces/libpq -lpq -L/usr/X 11R6/lib -L/usr/local/lib -ltk8.3 -L/usr/X11R6/lib -lX11 -ldl -lieee -lm \ -L/usr/local/lib -ltcl8.3 -lX11 -lcrypt -lnsl -ldl -lm -lutil -lreadline -lncurses -export-dynamic pgtkAppInit.o: In function `main': pgtkAppInit.o(.text+0x11): undefined reference to `Tk_Main' collect2: ld returned 1 exit status make[2]: *** [pgtksh] Error 1 make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh' make[1]: *** [all] Error 2 make[1]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin' make: *** [all] Error 2 end--- thx for any help cm ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[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../../backend -O2 -Wall -Wmissing-prototypes -Wmissi ng-declarations -I/usr/X11R6/include -I../../interfaces/libpgtcl -DHAVE_UNIS TD_H=1 -DHAVE_LIMITS_H=1 -DSTDC_HEADERS=1 -DHAVE_SYS_TIME_H=1 -DTIME_WITH_SY S_TIME=1 -DHAVE_PW_GECOS=1 -o pgtksh pgtkAppInit.o \ -L../../interfaces/libpgtcl -lpgtcl -L../../interfaces/libpq -lpq -L/usr/X 11R6/lib -L/usr/local/lib -ltk8.3 -L/usr/X11R6/lib -lX11 -ldl -lieee -lm \ -L/usr/local/lib -ltcl8.3 -lX11 -lcrypt -lnsl -ldl -lm -lutil -lreadline -lncurses -export-dynamic pgtkAppInit.o: In function `main': pgtkAppInit.o(.text+0x11): undefined reference to `Tk_Main' collect2: ld returned 1 exit status make[2]: *** [pgtksh] Error 1 make[2]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin/pgtclsh' make[1]: *** [all] Error 2 make[1]: Leaving directory `/mnt/hdb/src/postgresql-7.0.3/src/bin' make: *** [all] Error 2 end--- thx for any help cm ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
