f you want to access the users_user_id_seq value
within the same transaction, then after the insert into mytable you can
use currval.
Michael Schmidt
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
. Creating reports
isn't any harder than Crystal Reports. In my GUI, I use an xml file for a
report list, so I can add, edit, and delete reports easily without altering
program code.
Michael Schmidt
- Original Message -
From: Reid Thompson<mailto:[EMAIL PROTECTED]>
T
r reply on this list - but there isn't
any message - again this appears to be spam. I get a daily reminder to address
this. I've tried to log on as mailing list administrator but the password I
was assigned doesn't work. Oh woe! Who can I contact for help?
Michael Schmidt
d for a
specific purpose - is available on pgFoundry (the Komo project) and you can use
it to get started. Have a look!
For output, I added JasperReports to my GUI and that works fine. Note that
PostgreSQL, Eclipse, and JasperReports are all open source.
Good luck!
Michael Schmidt
Ted,
Google the publisher's name to get to its site.
mike
- Original Message -
From: Ted Byers<mailto:[EMAIL PROTECTED]>
To: Michael Schmidt<mailto:[EMAIL PROTECTED]> ;
pgsql-general@postgresql.org<mailto:pgsql-general@postgresql.org>
Sent: Thursday,
Jan,
There are a lot of resources available. Each database program has a different
dialect of SQL, and I find the PostgreSQL on-line manual has an excellent
introduction of SQL and even some theoretical issues. I would start there (its
free and directly applicable to using PostgreSQL).
Sear
ump section and not the others? Perhaps those not mentioned can't be used
by pg_dump?
Given the above ambiguities, I was not able to conclude that pg_dump would
accept the PGPASSFILE environment variable.
Michael Schmidt
this matter.
Michael Schmidt
as a bug? How to un-break my Java app
(and other Java apps that may be doing similar things)?
Michael Schmidt
tabase design for mere mortals" 2nd ed. by M. J. Hernandez, published by
Pearson Education in (I think) 2003.
As you begin working with PostgreSQL, I think you will find these Internet
forums to be quite helpful. There is a great bunch of people who are very
willing to help.
Michael Schmidt
, it seems to be a
false alarm and the good news is that PostgreSQL is back to being its usual,
reliable self.
Thanks for the response and sorry to bother.
Michael Schmidt
- Original Message -
From: Michael Fuhr
To: Michael Schmidt
Cc: PostgreSQL General
Sent: Monday, May 2
ere deleted, it
did. Has something been changed in pl/pgsql for version 8.1.3? Here
is the statement.
IF (NEW.is_individual) THEN ...
where is_individual is a boolean field
Michael Schmidt
And then there is PG Lightning Admin (which I like quite a bit). EMS
has a GUI, although it has some limitations and I've heard that the folks that
do the MySQL GUI have developed one for PostgreSQL. Almost an
embarrassment of riches!
Michael Schmidt
- Original Me
pgFoundry (Komo PostgreSQL Client).
On the second question, I also like to have the database do as much of the
work as possible.
Michael Schmidt
seen
mention that it is being used by the Wisconsin court of appeals and I believe I
saw a European government had selected it for their census data (perhaps the
Netherlands?).
Michael Schmidt
It doesn't look
terribly hard.
However, having said that, I wonder if someone could answer
something. How do pg_dump and pg_restore use stdout and stderr? I
saw a very old post that indicated -v caused all output to go to stderr. I
couldn't find anything recent and nothing in the
Include a "Limit" in your query.
Michael Schmidt
n in a dialog with a
progress indicator or it can be run in the background. In either case, a
"cancel" button is available.
Threading is also available in "standard" Java, but I am not as familiar
with how to set this up.
Michael Schmidt
- Original Message -
Perhaps others can comment on encoding versus type of data. I would
add that the manner in which data are accessed may also be a
consideration. Specifically, UTF-8 is a good choice if one is going to use
JDBC.
Michael Schmidt
running. After several weeks, he tried PostgreSQL and found it much easier
to install and work with, and his department was using it.
Michael Schmidt
connection to work. Also, there is a JDBC discussion group - it
might be better to post there than on this General group.
Good luck!
Michael Schmidt
ust a thought.
Michael Schmidt
A Visual Query Builder is available in PG Lightning Admin.
Michael Schmidt
h Yourself SQL in 21 Days and Teach
Yourself SQL in 24 Hours.
Michael Schmidt
of the time) are structured
filter editors and a helpful SQL editor.
Michael Schmidt
Mr. Armbrust,
Hopefully, this isn't off topic. Just wondering why SWT instead of
swing?
Michael Schmidt
copy
and when I tried to "reverse engineer" my PostgreSQL database, got an error that
pg_relcheck doesn't exist. Since pg_relcheck isn't used in PostgreSQL 8.0,
perhaps the Chilli Source program hasn't been updated?
btw, another program that isn't bad is DBTools Manager.
Michael Schmidt
program. I
don't mean to criticize your product (which has some very nice features), just
stating what happened.
I agree - EMS PostgreSQL manager does not offer backups and restores via
pg_dump and pg_restore.
Michael Schmidt
No experience with
DataArchitect.
Michael Schmidt
ations that go beyond the basic PostgreSQL
documentation. It is well written, clear, and the authors clearly have a
strong grasp of the technical aspects of PostgreSQL. Definitely worth
having!
Michael Schmidt
Mr. Fuhr,
Thanks for your quick response. In fact, the problem doesn't occur in
psql or in EMS PostgreSQL Manager. It appears unique to pgAdmin III.
In the future, I'll check such things with psql before asking a (potentially
dumb) question. Again, thanks!
Michael Schmidt
l the boolean columns are
set 'false', including the ones I have set the default value as 'true'.
Has anyone else had this problem?
Michael Schmidt
Thanks for the comments and help! I'll set column order
accordingly.
I've searched the archives and found this question was asked in 2001 but
never answered. Does the order of fields in a table make a
difference? In Paradox (from whence I come), there was some belief that
reliability was increased if memo (text) fields were placed at the end of the
table.
I was faced with a similar issue. One suggestion I got from the
Internet was to create a shadow column that contains the values used in the
Index, with a dummy entry (in my case, the string ) for those
records in which the primary column is NULL. It works well for my
app.
There are a number of good, objective, and informative comparisons
available on the Internet, such as http://www.databasejournal.com/sqletc/article.php/3486596.
You can Google something like "Postgresql mysql firebird comparison" to access
these. I am migrating an application from Paradox a
The solutions provided by Mr. Glaeserman and Mr. Lane worked
perfectly. So that's how NULL works!
Thanks so much for the help.
ol_Score_M of NULL and Control_Score_SD = 1.0 (as it
should). However, it allows Control_Score_M = 1 and Control_Score_SD of
NULL (it shouldn't). Any thoughts about what is wrong.
Thanks!
Michael Schmidt
38 matches
Mail list logo
