; language. When i select 'pgsql' as language
for creating query, an error poping up. How to create Query using 'pgsql'
language. if any new tools need to be installed. Plz rectify. Mail me back
at [EMAIL PROTECTED]
I bet you haven't enabled pl/pgsql use create
On 03/05/2004 12:49 Eric Anderson Vianet SAO wrote:
How could I record the ´ \d table ´ command to a file?
\o file
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business
the number of dead tuples you
are trying to reclaim so the vacuum is not clearing all the dead stuff
out. There's plenty of stuff about this in the archives and the docs.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Li
On 18/04/2004 19:37 Markus Bertheau wrote:
В Чтв, 15.04.2004, в 13:15, Paul Thomas пишет:
> On 15/04/2004 11:25 Dan Field wrote:
> Your "= NULL" tests are also not valid SQL (should be IS NULL).
I think = NULL _is_ valid SQL, it just doesn't do what you think.
It's valid
d comparison according to the SQL specs. You need
to use the SQL OR operator e.e.,
(DEWEY_POINT_TENS = 0 OR DEWEY_POINT_TENS = NULL) AND
~~
Your "= NULL" tests are also not valid SQL (should be IS NULL). MySQL does
not follow the specs in a number or areas. PostgreS
retty sure I could do this with an external trigger, but am
wondering about a constraint oriented approach
What about
create table foo (bar integer, baz boolean);
create unique index foo_bar_baz on foo(bar, baz) where baz = true;
--
P
On 26/03/2004 01:25 Kemin Zhou wrote:
I search far and wide and found a lot of disscussions about the
autocommit, but none about how to do it. After reading 50 pages, my
brain is numb. Could any one give me a simple help?
Thanks
Kemin
Use tranactions.
--
Paul Thomas
me to my webpage while displaying.
Regards
Raman Garg
Use UNICODE as the db encoding. You'll have to drop and re-create the db
though.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Something like
select regno from mytable group by regno having count(stockno) > 1;
might do it.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultant
e. How many rows are
there in the table?
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-mic
PG doing a seqscan if there's no alternative
plan. All set enable_seqscan = false does is make a seqscan appear very
expensive so that the planner is less likely to pick it.
HTH
--
Paul Thomas
+--+-+
| Thomas M
driver.
A total shot in the dark but do you have a primary key on the table?
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.th
pgaccess/main.tcl" line 5)
Can anyone Offer any advice on this problem?
pgaccess is a TCL application. You need to be running under X.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the
le (very!) few PostgreSQL-specific variations
from the SQL language definition.
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://
nterested to know just how far off the mark by understanding is...
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.
g for me with a
DSL line. I really feel for those on dial-up :(
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http:/
o do! Fortunately my spam filters
are up to scratch and I run Linux :) Others may not be so lucky.
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants
our DriverManager.getConnection(url,
user, password).
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http:/
on your machine increases
significantly. (and then safely increase the maximum
number of connections in your configuration (both postgresql wise
and app server (conn pool) wise).
On Tue, 29 Jul 2003, Paul Thomas wrote:
>
> On 29/07/2003 07:18 LEON wrote:
> > I use tomcat+linux_postgresql+jsp t
is not
always closing the connection so eventually you exceed max_connections.
You should always close the connection in a finally{} block so that is
guaranteed that it will be closed regardless of any earlier exceptions
which are thrown.
HTH
6 | LEAGUE BRONCOS
4 | LEAGUE PANTHERS
(2 rows)
HTH
--
Paul Thomas
+--+-+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants |
http://www.thomas-
On 17/06/2003 10:22 zhuj wrote:
hi,all:
I want to constraint the maximum number of concurrent connections to
25
in postgres
jdbc driver. There are no methods for this
change. How would i do?
The simplest way is to use a connection pool.
HTH
--
Paul Thomas
22 matches
Mail list logo
