Re: [ADMIN] reg:FilePath error

2006-03-18 Thread Kevin Grittner
If you can't easily use the PostgreSQL extension to SQL, but need to have string literal behavior conform to the ANSI and ISO standards, I have submitted a patch for the 8.2 TODO item to support this. Since we needed it in production mode now, the patch I submitted was relative to the 8.1 stable b

[ADMIN] Libpq.dll library and its distribution in other products

2006-03-18 Thread Vladimira Nitrova
Hello PostgreSQL Team, I'm writing this email on behalf of Charonware company whose product CASE Studio 2 Database Design Tool supports PostgreSQL database, including PostgreSQL 8.1 version (you can see the news at: http://www.postgresql.org/about/news.494). I'd like to ask you for your assis

[ADMIN] Case Sensitive problem

2006-03-18 Thread Erik Ferencz
Hi, I have got problems with case sensitive sort. I need my Postgre DB to be case insensitive, but I don't know how or where  to set it.   Could anyone help me, please.   Erik Ferencz

[ADMIN] initdb creates a wrong-version database

2006-03-18 Thread Anton J. Garnik
Hello pgsql-admin, I have installed PostgreSQL 8.1.3 on Trustix Secure Linux When I have created the initial database with initdb and run postmaster, it says: --- An old version of the database format was found.\nYou need to upgrade the data format before using P ost

[ADMIN] Problem with the Connection

2006-03-18 Thread Matze
Hallo There, I've got a Problem with PostgreSQL. I installed the Windows Binary of Postgre 8.1 (postgresql-8.1.msi). During the Installation the Installer popped up several messages that some Propertys of the Server or the Tables couldn't be set correctly. But the Installer itself finished the ins

[ADMIN] table disappear from pg_class

2006-03-18 Thread marco
Hi all, I have a problem with a table which is disappeared from pg_class with all objects related (views, indexes and so on). pg_dump against this table does not work (I think because it is not present in pg_class). The strange behaviour is that I can select data from this table !! We are using a

[ADMIN] use of in psql

2006-03-18 Thread Luis P. Mendes
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I have postgres installed both in a Debian Sarge and in a Slackare 10.2 systems. When I connect to a database via psql and do a select * from table; I get the first page of results, considering \pset pager is on. In Debian, I can press the key

Re: [ADMIN] table disappear from pg_class

2006-03-18 Thread Alvaro Herrera
marco wrote: > Hi all, > I have a problem with a table which is disappeared from pg_class > with all objects related (views, indexes and so on). > pg_dump against this table does not work (I think because it is not > present in pg_class). > > The strange behaviour is that I can select data from th

Re: [ADMIN] Case Sensitive problem

2006-03-18 Thread Bruce Momjian
Erik Ferencz wrote: > Hi, > I have got problems with case sensitive sort. > I need my Postgre DB to be case insensitive, but I don't know how or where > to set it. > > Could anyone help me, please. Read our FAQ. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.

[ADMIN] Doubt

2006-03-18 Thread Babu
Hi   i have create one table and view., but i have not able to insert,update and delete view., how to solve this. Pls send me on example.   Table : Create Table Test (eno int,ename varchar(10));  View : Create or Replace view TestView as Select * from Test;  Regards  Babu.

Re: [ADMIN] Libpq.dll library and its distribution in other products

2006-03-18 Thread Alvaro Herrera
Vladimira Nitrova wrote: > I'd like to ask you for your assistance concerning libpq.dll library and > other .DLL files. > These files are not distributed with our software and our customers are > asked to install them separately from the PostgreSQL package to be able > to reverse engineer the P

Re: [ADMIN] use of in psql

2006-03-18 Thread Bruce Momjian
Luis P. Mendes wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi, > > I have postgres installed both in a Debian Sarge and in a Slackare 10.2 > systems. > > When I connect to a database via psql and do a select * from table; I > get the first page of results, considering \pset page

Re: [ADMIN] Libpq.dll library and its distribution in other products

2006-03-18 Thread Bruce Momjian
Alvaro Herrera wrote: > Vladimira Nitrova wrote: > > > I'd like to ask you for your assistance concerning libpq.dll library and > > other .DLL files. > > These files are not distributed with our software and our customers are > > asked to install them separately from the PostgreSQL package to be