[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 is
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
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
[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
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
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
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 equal to
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
Alexandru Coseru wrote:
Hello..
snip content=Error Details/
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
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
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
13 matches
Mail list logo