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 Thompsonmailto:[EMAIL PROTECTED]
To: Geoffreymailto
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
- 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
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).
Subject: Re: [GENERAL] SQL textbook
- Original Message -
From: Michael Schmidt
To: Jan Mura ;
pgsql-general@postgresql.orgmailto:pgsql-general@postgresql.org
Sent: Thursday, February 08, 2007 12:54 PM
Subject: Re: [GENERAL] SQL textbook
Many books are available
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
-break my Java app
(and other Java apps that may be doing similar things)?
Michael Schmidt
n 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
. 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
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 22, 2006 11:49
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 Message -
From
PostgreSQL Client).
On the second question, I also like to have the database do as much of the
work as possible.
Michael Schmidt
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
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 manual.
Thanks!
Michael Schmidt
Include a "Limit" in your query.
Michael Schmidt
be shown 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
. 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 JDBCdiscussion group- it
might be better to post there than on this General group.
Good luck!
Michael Schmidt
.
Michael Schmidt
A Visual Query Builder is available in PG Lightning Admin.
Michael Schmidt
in 21 Days and Teach
Yourself SQL in 24 Hours.
Michael Schmidt
e 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
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
experience with
DataArchitect.
Michael Schmidt
the 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
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
'false', including the ones I have set the default value as 'true'.
Has anyone else had this problem?
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
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. If
Thanksfor the comments and help! I'll set column order
accordingly.
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 NULL) 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
The solutions provided by Mr. Glaeserman and Mr. Lane worked
perfectly. So that's how NULL works!
Thanks so much for the help.
d 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