gable form.
Paul Thomas
+--+---+
| Thomas Micro Systems Limited | Software Solutions for Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.
n't say what version of the DB and JDBC driver you're using but I
have an app which does vavuums via JDBC no problem. Just make sure that
you've setAutoCommit(true).
--
Paul Thomas
+--+---+
| Thomas Micro Sy
your application. For an accounting application,
I would recommend using numeric and using BigDecimal in your Java code. If
small rounding errors don't matter the you'll find using double precision
(int8) in the databse and double in your Java code s
ll all 127.0.0.1/32 ident sameuser
# IPv6 local connections:
hostall all ::1/128 ident sameuser
Swap the first 2 entries round!
--
Paul Thomas
+--+---+
| Thomas Micro Systems Limite
on that
front.
OpenOffice has forms and database access. It may suit your needs.
--
Paul Thomas
+--+---+
| Thomas Micro Systems Limited | Software Solutions for Business |
| Computer Consultants | http://www.thoma
l database.
Somebody have a cooking recipe about to test if my
backup is working fine, and will help if I need
sometime?
Are you using pg_dump or pg_dumpall? I just use pg_dump on individual
databases (pg_dumpall works on the whole cluster) and can restore that to
any database.
HTH
--
P
explains how to set it up with MySQL. Maybe you could use that as a
starting point?
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http
BC. I suggest you search
the net for an ODBC tutorial. You can find the API documentation on
Microsoft's web site.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
On 17/06/2004 12:10 Adam Witney wrote:
Will this run on other platforms? OSX maybe?
It's a Java app so it runs on any any platform with a reasonably modern
Java VM.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Li
27;ve just come back from the pub after a generous quantity
of Old Speckled Hen)
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
tgresql as user "phil" in order to gain
access for my integrated develoment environment?
See above.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Co
e I should post to 'novice' for a
while! ;)
Use a sequence.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thoma
ld do as a minimum
would be to try to pg_dump each table (excluding any pga_* tables) so at
least you've got all of you accounts data.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solution
27;s no such thing as auto-increment fields in PostgreSQL
- they are SEQUENCES.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer
ongly recommend upgrading to 7.4 to take
advantage of the last ~4 years of continuous improvements.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants
valid information is
allowed,but the blank values get ignored.
By blank, I assume you mean a zero-length string or the request parameter
being absent? I think you need to detect these conditions in your perl
program anf construct the SQL accordingly.
--
Paul Thomas
.
I'll admit that I don't know what effect this would have but I'm
interested to find out.
regards
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Compu
ion?
man pg_dump
look at the -c option.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thoma
so use POSIX regular expressions.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-mic
xpand this list. I haven't used
MySQL for about 4 years and always _detested_ it. Happily, on migrating to
Linux, I discovered PostgreSQL and I've not touched MySQl since :)
HTH
--
Paul Thomas
+--+-+
| Thomas M
ct failure)
b) your user is allowed to connect to the database using tcp/ip (check
pg_hba.conf)
c) you are using the correct password for the user.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions
PostgreSQL's data dir. Obviously this may differ from distro to
distro. Probably what is happening is that you running locate as regular
user which won't have read access to that directoty (it's owned
pty fields "just in case" ?
One way would be to have a separate vendorpart table something like
CREATE TABLE vendorpart
(
vendor_id int4,
part_idint4
);
which holds the relationships. You'll to define indexes, contraints and
foreign ke
they tried their scam on me, I'd report them to the police. There are
laws against that sort of thing in the UK. By a strange coincidence, SCO
don't have an office this country...
--
Paul Thomas
+--+-+
| Thomas
many?) client-side languages you inititiate a
transaction by setting auto-commit to off (JDBC and ODBC do this) in the
client-side driver. In the case of the PostgreSQL JDBC driver, this causes
a BEGIN command to be sent to
w to PG), it made me realise why
I was thinking about a PostgreSQL for MySQL users paper.
Careful what you say - some people might think you're volunteering ;)
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software
ation. My app is currently PG-only (although I
_might_ be able to get it work with Firebird eventually). Currently I have
to sell Linux to prospective clients in addition to my app. A native
Windows version would make my life a bit easier.
--
Pa
TOAD makes Oracle a joy to use).
FWIW, TOAD as shipped with Fedora Core 1 has support for PostgreSQL :)
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer
On 23/12/2003 21:46 CSN wrote:
Is is possible to find out what options (prefix,
bindir, etc.) were specified to "configure" when
Postgres was built?
pg_config --configure
HTH
--
Paul Thomas
+--+-+
| Thomas Mic
personal opinion but here goes:
For the example you've provided I don't think theres much in it. The
second version would give you ability to change the text of the user type
if that were important and to add new user types without having to alter
constraints. So if I _had_ to choose
ll go away as soon as java version 1.5 comes out but in the
meantime, what does everyone think
Comments are welcome.
On platforms built with GCC3.2+, GCJ might be an alternative.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Li
s it mean mysql got stored procedures? Wow..
I read it to mean user-defined functions only. Maybe I missed something?
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
|
field integer default nextval('mysequence')
where you have previously created the sequence mysequence.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Compu
Partial indexes
O
--
No partial indexes? Get them to put it on their TODO list ;)
BTW, has FB got an equivalent of PG sequences?
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions
ore executing the select?
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-syst
whose WPImageStateID is now no longer 1.
Does this look correct?
I think you need to play with a couple of psql sessions to sort this out.
I think you might have a race condition here.
--
Paul Thomas
+--+-+
| Thomas Micro Sy
(www.sql-ledger.org). It
might save you months of effort.
You might not have understood me or I am not understanding you.
It feels like we're 2 people divided by a common language...
--
Paul Thomas
+--+-+
| Thomas Mi
stgres would help alot of PHP
guys that are using MySQL.
Much of the populatity of MySQL seems to stem from PHPs out-of-the-box
support for it. With the MySQL client library license change, this
situation will probably change. There was a long thread about this earlier
this year. Check the
ntally cut off a transfer, or stop one
before it ever starts.
How could a connection ever have the kind of "thread-safe" behavior you
seem to believe it should have?
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited
The developers and advocates are not making $xx per box shifted or trying
to seduce users down a supposedly free path into their licensed software
lair. That has a big effect on advocacy. Instead of smarmy marketing types
who rely on spread FUD and misinformation about every product they
consi
way to do something like this?
It has occurred to me that when table spaces are supported, then this
would
be much easier (have a HEAP table space sitting on a ramdisk).
If your table is that small, you could just cache it in your application.
--
P
On 13/11/2003 19:32 Rick Gigger wrote:
Does anyone have any experience with postgres on fedora?
Fedora ships with 7.3.4. I've got it running nicely on a laptop.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Li
ut it works quite well. Hopefully, enough people will try it and
give feedback to enable it become part of the next OO release.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Bus
closed-source derived version. Unlike the GPL, there are no issues of
derived works or licensing issues if you compile your software to include
PostgreSQL headers or libraries. So develop whatever you want and release
as either open or closed source as fits your needs.
HTH
onfig --configure to get all the
original options which the RMP version was built with. I then supply these
options to the configure script. This way, I know that the new version
will over-write the old version.
you're just starting
out experimenting with PostgreSQL and Java, it's one less thing to have to
worry about for now.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smalle
to the postgres superuser to do the backup or maybe use a
.pgpass file (needs at least 7.3 IIRC).
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer
r name so its really easy to create databases and other users
without su'ing around. On production machines, I set up a dba user.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Sm
hing similar to this ... if exists)
>
> Have you tried using AS connection-name in your EXEC SQL CONNECT ...
> statement?
>
Hi! ... I don't know thar statement ... Can you explain me more???
Thanks.
It's in section 4.2 of ECPG docs.
--
Paul Thomas
+--
x27;ve
noticed a massive drop in Code Red "get default.ida.." requests to the web
server on my DSL line.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business
t of the daily spam. Like most people from the non-M$ world, this sort
of thing just passes me by :)
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultant
perl.
Which version of Postgres would people to recommend?
The latest production release is 7.3.4. I'd recoomend using that.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Sm
l?
what files do i need to move into $libdir directory to get tsearch2 up
and running?
Thanks!
I just tried a make/make install using 7.3.3 sources. I think the problem
is that the make file copies the .so to /usr/lib/postgresql which might
not be in your lib path.
HTH
--
Pau
be a bit slower.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.
n from the user's perspective (the use
cases). What attributes are to be displayed for different parts? Are they
all similar? Do the screens make separate tables seem more natural?
HTH
--
Paul Thomas
+--+-+
| Thoma
tests with number of wal buffers and not seeing a big difference even when
large numbers were used.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Co
rogramming?
All fairly straight forward IME.
4. Overall, do you like PostgreSQL? Would you recommend it over MySQL?
100% of the time.
5. How often do your PostgreSQL run into problem or crash? Are most of
the
problem caused by PostgreSQL itself?
I've never had a problem
e . An alternative
might be to try adding an ESCAPE '' clause at the end (also in the same
doc section).
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Sol
r
Could not connect to the database
I would also like to know how to restart postmaster to reinitialize
changes
if someone could help me out on that.
Depends on which *nix flavour/distribution you're using. I use Red Hat
Linux and
service postgresql res
running very well but we
want to get rid of this message.
Thanks in advance for your response
You may have a typo in /etc/rc.d/init.d/postgresql.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the
200.200.200.1 to
200.200.200.254. The rules for sub-nets and sub-net masks can be a bit
confusing and I've yet to find a tutorial on-line which is easy to follow.
It might help you to think of 200.200.200.0 as 200.200.200.*.
HTH
--
Paul T
61 matches
Mail list logo
