I am in the unique situation of designing a new Red Hat 9
server to run a Postgres database in a small company.  The
database that is being converted is currently 30 MB.  There
will be 20 users maximum.

I've hit a situation where I'm getting an unexpected set of results
from a cross
join that I've narrowed down to a table alias.
If I do (a has 4 rows, b has 1 row)

Hi All - is there a way to enable multibyte encoding after I have
already installed Postgres on Linux ? I need to be able to accept
French characters.
Thanks, Sylvie.

I apologize if this is a RTFM question, but I have not been able
to find a definitive answer elsewhere.
Does a "REINDEX TABLE" lock the table while it is working?
Can applications write data to the table during the REINDEX?

I've used Postgresql 7.2 for a long time with php.
Now I'll to upgrade to Postgresql 7.3 but I have a great problem with
the query like:
select * from tab where id=''

     is there a way ,
          other than using EMS PostGreSql Extract
     to export a PostGreSql datatbase ( table structures,data ,
functions , triggers etc... )

If a row of data has been locked FOR UPDATE, how can one determine WHO has
it locked?

Hi...
I am currently working on a Java-based product that is backed by
PostgreSQL (among other databases).
I have noticed that PostgreSQL appears to truncate column alias names

I begin a transaction. I then execute a SQL command "SELECT FOR UPDATE" to lock some records on the first session. Besides, I also lock some rows using the same method on the second session. Is it possible to return an error message to indicate that some records were locked by ...

Can I install Posgresql on slackware linux? This package doesn't
include with slackware. I have visited on postgresql website, but it
only for Red Hat linux. Where can I get postgresql for Slack?

I have a set of tables partitioned horizontally. DML below. I have also
created a view that will allow me to display information stored in all
partitioned tables.
Im trying to create an INSERT RULE on the VIEW that would direct an insert

I have a postgres installation on RH8.
I want to connect to this using JDBC. I've installed the driver in
/usr/local/pgsql/share/java and set CLASSPATH.
I think the default configure option does not enable the JDBC interface so

I am trying to tuning up the performance of PSQL. I have tried
changing the cache size. I found that the default page size if 8k, I
am just wondering has any one know, if page size if biger the better
or smaller the better, what is a good number of page size? My OS is

I have a number of very common queries that the optimizer plans a very inefficient plan for. I am using postgres 7.2.3. I vacuum hourly. I'm wondering what I can do to make the queries faster.
Here are the relevant tables:
create table image(
   imageid integer not null,     /* The ...

(I apologise if this is the wrong list, I haven't posted
 to a postgresql.org mailing list before, general seemed
 like a good catch-all)
I am trying to implement a centralised authentication system