[GENERAL] designating a column as primary key after creation

Why does postgres choke on the following: alter table mytable add constraint mycolumn_pk primary key(mycolumn); is this possible in a postgres database? if not, what's an easy workaround, i really need to have this column as primary key. Thanks! -Fran

[GENERAL] getting the currval of a sequence

Hi all, I need to do the equivalent of: select my_sequence.CURRVAL from Sys.dual; so I'm guessing its: select currvar('my_sequence') from ???; Can anyone fill in the ???? Thanks! -Fran

[GENERAL] installing DBD::Pg without installing postgres

27;m turning up appears geared towards the assumption that you also want postgres installed locally. Am I looking in the wrong places? Thanks, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/us

Re: [GENERAL] installing DBD::Pg without installing postgres

Maybe my hopes are misguided. =) Thanks, Fran ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] installing DBD::Pg without installing postgres

having MySQL locally, but DBI::Proxy may be an even cleaner solution. Thanks everyone for the dialogue, it has been very useful! -Fran ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[GENERAL] DBI/AutoCommit/Postgres

chine are: Pentium III 733Mhz, 512 megs memory, 7 gigs free on the partition. Seems like I should be getting a lot more horsepower. I really need to speed this up somehow. Does anyone see anything in the trigger or otherwise that would cause this to be so slow? Thank you very much, Fran ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] Re: Stranger than fiction - EXPLAIN results

imestamp | Indices: status_5_column_index, status_host_id_key, status_site_id_key monitoring=# So it's puzzling me why it's still doing a Seq. Scan vs. an Index Scan. Any ideas? Thanks, Fran ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [GENERAL] select off of a view going slowly

ime and learn about views, and relational databases in general, more deeply. Then maybe I can help out around here some more! =) Thanks, Fran monitoring=# select * from error_log; count | site_id | host_id ---+-+- 8 | 34 | 88 8 | 34 | 110 (2 rows) The q

[GENERAL] Trigger only firing once

the trigger once per connection. Thanks, Fran ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[GENERAL] formatting a date

I'm looking all over the place in the Pg docs and Momjian book and having no luck finding any functions that would turn a timestamp such as 2001-05-08 23:59:59-04 into May 8, 2001. (i.e. do what date_format() was doing for me in MySQL.) Is there equivalent functionality in Pg? Thanks,

[GENERAL] Trigger only firing once

procedure from a text file of sql which hasn't changed in weeks. It worked perfectly in postgresql 7.0, but now that I think about it, I can't confirm it ever working correctly in 7.1 since I upgraded earlier in the week. Thanks, Fran ---(end of

Re: [GENERAL] Trigger only firing once

x27;), upper('INFO'), '1 medssld(s) running.', '20010513 00:00:00'); 2001-05-14 12:05:47 DEBUG: ProcessQuery 2001-05-14 12:05:47 DEBUG: query: SELECT now() 2001-05-14 12:05:47 DEBUG: query: SELECT * from sites s where s.fqdn = $1 2001-05-14 12:05:47 DEBUG: query: SE

[GENERAL] Calling external programs

all a procedure written in say PLPERL? Is PLPERL capable of calling external programs or better yet forming the mail and calling sendmail itself? Thanks, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/

Re: [GENERAL] "trigger"ing a procedure every X minutes

7;d like to try it someday, when I know a lot more about Pg. My current project has an ever-growing number of cron jobs (up to 6 now) and was just thinking about various ways to tidy it up. Thanks for the info, Fran > Fran Fabrizio <[EMAIL PROTECTED]> writes: > > Is the preferred

[GENERAL] do i need a view or procedure?

ng out how to even approach this, so any feedback at all would be greatly appreciated! Thanks for reading this far :-) Sincerely, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [GENERAL] do i need a view or procedure?

particular host, we then use this table to say which of those they already have installed and remove those from the result set. So, it does work very nicely for that. Thanks for the input, if nothing else, it gets the brain thinking about it in different ways. Thanks, Fran ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[GENERAL] replication?

mething if that will work. I looked through the docs but didn't see anything about replication in the Administrator manual, where I assume it'd be discussed. I did see a vague reference to a replication toolkit in the release notes, is this what I'm looking for? Thanks, Fran --

[GENERAL] Error Codes?

o insert too many columns into a row, and a 1 if the connection fails. What's the scoop, and if error codes really do exist, is there a list of such codes? Thanks, Fran ---(end of broadcast)--- TIP 5: Have you checked our extensi

Re: [GENERAL] Error Codes?

> Rob Arnold wrote: > > > Look at $db->errstr That has the text version of the error code. > > > > --rob Yes, but I want to know about the codes, not the text. If the codes exist, they are easier to work with than the text. -Fran -