[ADMIN] Cascade on update statement, not on table definition

Hi, I saw I can define a table that specifies a ON UPDATE CASCADE for a Foreign Key. I have a lot of tables with FK´s, and a lot of others with others FK\'s for the firts ones, and so on, and I haven´t defined the ON CASCADE clause on the FK´s tables. Now I need to update a primary key on the \

Re: [ADMIN] Re: pgadmin

t; We want to install the client at Windows machine. We had downloaded > > the pgadmin and installed in in windows2000 machine through windows > > installer. But we could not configure the DSN and get going. kindly > > help by pointing further documentation Regards, T.G.Sekhar,Raghav > > Infotech Limited,Chennai,India, -- Bill MacArthur Webmaster DHS Club

[ADMIN] PG 7.0.3 & RH 7 IPC problems?

.version = #1 SMP Mon Feb 5 14:36:22 EST 2001 kernel.osrelease = 2.2.17-14smp -- Bill MacArthur Webmaster DHS Club ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddr

Re: [ADMIN] PG 7.0.3 & RH 7 IPC problems?

- key semid owner perms nsems status -- Message Queues key msqid owner perms used-bytes messages bash-2.04$ Tom Lane wrote: > > DHSC Webmaster <[EMAIL PROTECTED]> writes: > > [postgres@atl01371 data]$ nohup postmaster -D /usr/loc

Re: [ADMIN] PG 7.0.3 & RH 7 IPC problems?

-9 on anything. :) Tom Lane wrote: > > DHSC Webmaster <[EMAIL PROTECTED]> writes: > > It would appear that either my icps is not working or that everything is > > alright. > > Try it as root. I think on Linux, ipcs won't show shm segments that you > do not have read

Re: [ADMIN] PG 7.0.3 & RH 7 IPC problems?

Gracias, merci' & Thank You Tom! After shutting down the entries were still there. I rebooted and restarted and voila!, we're in business. Tom Lane wrote: > > DHSC Webmaster <[EMAIL PROTECTED]> writes: > > [root@atl01371 linux]# ipcs > > > -

Re: [ADMIN] pg_clog & vacuum oddness

ng except sit there. > > regards, tom lane > > ---(end of broadcast)--- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match -- Bill MacArthur Webmaster DHS

Re: [ADMIN] pg_clog & vacuum oddness

tage correctly. Either that or during our data import, there was something in the import file that referenced template1 which created a need for vacuuming. Whatever the case, this was an interesting exercise which I'm sure will prove useful in the future. Thank you. -- Bill MacArthur Webmaster

[ADMIN] dropped users appear as numbers in ACL

perform this same procedure for ACLs? Are there any plans to handle these issues transparently when a user is dropped? -- Bill MacArthur Webmaster DHS Club ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[ADMIN] bizarre AGE behaviour

and I just missed it, but is there a simple fix for this problem? Thanks. -- Bill MacArthur Webmaster The DHS Club, Inc. The Best Is Yet To Come! ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] bizarre AGE behaviour

ckle whatever problem he was having secure in the knowledge that PG > was working correctly. > > Cheers, > Steve > > ---(end of broadcast)--- > TIP 9: the planner will ignore your desire to choose an index scan if your >

[ADMIN] performance issues

g top gives me 2 - 3. Does this sound typical? If my information is insufficient to give a ballpark quess, perhaps you could give me some normal types of performance figures. Thank you for your feedback. -- Bill MacArthur Webmaster DHS Club ---(en

Re: [ADMIN] performance issues

is if some is good, more must be better. :) Also I noticed in this artice: http://www.ca.postgresql.org/docs/faq-english.html#3.7 mention of another memory parameter (-S), however the elephant book refers to -S as silent mode. Could you clarify this? Tom Lane wrote: > > DHSC Webmaster <[E

[ADMIN] 7.1.3 & ODBC

tables won't show. Any suggestions? All our our database and table permissions are identical to the previous machine setup. -- Bill MacArthur Webmaster DHS Club ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [

Re: [ADMIN] Bad Date field

y with no success. The table I'm copying into has a datestamp of > type DATE. > > Any suggestions would be greatly appreciated. > > ---(end of broadcast)--- > TIP 2: you can get off all lists at once with the unregister comma

Re: [ADMIN] copy command

ewline (3 rows) Here is the export file I copied out from tmp2 100|bill|456 harmony ln.\ hickup, NH 200|Sam|Is linebreak here?\ ewline This file imported correctly to another table with the newlines embedded in the data. > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Bill MacArthur Webmaster DHS Club ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Maximum Performance

Jean Huveneers > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster -- Bill MacArthur Webmaster DHS Club ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Indexes on separate disk ?

e on > a single disk. > > Thanks > Charlie > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- Bill MacArthur Webma

[ADMIN] best OS suggestions / ease my doubts

Bill MacArthur Webmaster DHS Club ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [ADMIN] How do I select the last Id in a column???

> > > ---(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 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) -- Bill MacArthur Webmaster DHS Club ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] Many idle processes?

tored as utf-8, but the http header says it is something other than utf-8. If you are seeing a '?' where there should be an accented character, then it is probably stored as plain ascii but the http header says it is supposed to be utf-8. -- Bill MacArthur Webmaster The DHS Club, Inc. The