[EMAIL PROTECTED] wrote:
Hello,
I bought a Dell server and I am going to use it for installing PostgrSQL
8.2.4. I always used Windows so far and I would like now to install a
Linux distribution on the new server. Any suggestion on which distribution
? Fedora, Ubuntu server, Suse or others?
Lincoln Yeoh wrote:
Hi, importantly do searches and other processing by those relationships.
So, what would be the best way to store them so that a search for the
relationship like "grass is to cow", will also turn up cow is to
tiger, and goat is to tiger, and fish is to penguin (and penguin i
Joshua D. Drake wrote:
You could preface all your queries with something like:
select * from foo where lower(bar) = lower('qualifer');
But that seems a bit silly.
And also it would prevent the optimizer from using any indexes on
"bar". Not a good idea.
Eddy
---(e
Paul Lambert wrote:
I've got an MS Access front end reporting system that has previously
used MS SQL server which I am moving to Postgres.
Are you using "PassThrough" queries? It is not clear
The front end has several hundred if not thousand inbuilt/hard-coded
queries, most of which are
[EMAIL PROTECTED] wrote:
I have a client who has had some software developed that requires a
website element and the site uses postgres for the back end database
(of course, its the best after all!)
You might like to look at Bytemark (http://www.bytemark.co.uk), or one
of the other virtua
roopa perumalraja wrote
I would like to know that what can be the maximum size of database in
postgres 8.1.4. Currently my database size is 37GB & its pretty slow.
I wonder if its b'cos of huge amount of data in it.
http://www.postgresql.org/docs/faqs.FAQ.html#item4.4
Slowness reason ca
Without seeing the SQL statements you executed in the session it is
difficult to see your problem.
Getting a current sequence after a rollback is no problem (in 8.0
anyway). Please note though, the sequence itself is NOT rolled back.
This is correct behaviour. Currval will return the last s
William Shatner wrote:
I have recently migrated from MS Access to PostgreSQL.Previously I had
a SQL command
ResultSet aGroupResultSet = aGroupPathStmt.executeQuery(
"SELECT \"groupID\",\"fullpath\" FROM \"groups\" WHERE
\"fullpath\" Like '" +
aPath + "'");
where aPath was
Alexandru Coseru wrote:
Hello..
Any ideeas ?
Fraid so and it is not good.
I am no expert in the inner-inner workings of Postgres, but my guess is
that your catalogue is, or has been, corrupt.
If this is the case it is unrecoverable. It is a matter of rescuing
what data you can (using pg_d
pgadmin3 does not seem to want to connect to the server using UNIX
sockets, it only does it through TCP.
Set up the Postgres server to use TCP (as well as UNIX sockets) - i.e. -
starting postmaster with the -i option, sorting it pg_hba.conf etc.
Eddy
Jonathan Schreiter wrote:
hi all,
running am
It looks as though you need to create your database users.
Try using the "createuser" command.
For more information:
http://www.postgresql.org/docs/7.4/interactive/user-manag.html
Eddy
Mike-Olumide Johnson wrote:
Hello,
Have RADIUS setup and working properly.
While executing SQL got the following
Hi
Announcing ShellSQL 0.7 to an unsuspecting world...
ShellSQL is a utility to allow SQL to be intergrated easily into
UNIX/LINUX shell scripts.
The web page is at http://www.edlsystems.com/shellsql - and at
sourceforge at http://sourceforge.net/projects/shellsql .
Version 0.7 includes many bu
Assuming identification_number is a unique (primary) key...
select * from my_table where date_of_birth in (select date_of_birth
from my_table group by date_of_birth having count(*) > 1)
Or - it may be quicker to do...
select * from my_table a where exists (select 'x' from my_table b where
a.da
13 matches
Mail list logo
