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
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
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
Maybe my hopes are misguided. =)
Thanks,
Fran
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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]
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
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]
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
the
trigger once per connection.
Thanks,
Fran
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
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,
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
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
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/
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
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
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
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
--
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
> 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
-
19 matches
Mail list logo