Re: [ADMIN]

2004-06-21 Thread Tom Lane
"lise chhay" <[EMAIL PROTECTED]> writes: > J have created the user auth under Unix and I did : > # su - postgres > postgres$ createuser auth > User auth created > postgres$ psql auth > auth=# INSERT INTO groupes (groupe, descr) VALUES ('auth', 'Administrateurs de la > base Auth') ; > auth=#

Re: [ADMIN] UNDO

2004-06-21 Thread Tom Lane
=?iso-8859-1?q?Carlos=20Benkendorf?= <[EMAIL PROTECTED]> writes: > In 7.4 manual is written than UNDO is not implemented. > What it really means? Not much. It's unlikely that we ever will implement UNDO in the sense that passage is talking about --- which is to say, reversing out the effects of

Re: [ADMIN] bad data with Foreign Key constraint

2004-06-21 Thread Lee Wu
Hi Tom, We do not have rules on the tables. I find manipulating PG dictionary can allow violating RI data to enter database. Thanks, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane Sent: Friday, June 18, 2004 4:36 PM To: Lee Wu Cc: [EMAIL PROT

[ADMIN]

2004-06-21 Thread lise chhay
J have created the user auth under Unix and I did : # su - postgres postgres$ createuser auth User auth created postgres$ psql auth auth=# INSERT INTO groupes (groupe, descr) VALUES ('auth', 'Administrateurs de la base Auth') ; auth=# INSERT INTO utilisateurs (login, password, nom, prenom) V

[ADMIN] UNDO

2004-06-21 Thread Carlos Benkendorf
Hi, In 7.4 manual is written than UNDO is not implemented. What it really means? When should PostgreSQL do an UNDO? Are not all data only written to disk when it is committed? Why should Postgresql do an undo? Thanks in advance! ___

Re: [ADMIN] pgadminII error in connecting to PostgreSQL Server

2004-06-21 Thread Bender, Cheryl
Dojie; Have you already tried the solution below (from archives)? ** Re: [pgadmin-support] pgAdmin II connection error From: Dave Page

Re: [ADMIN] Problem saving some characters

2004-06-21 Thread Jouneau Luc
Hello, '\' is an escape character, you should double it when you insert data : insert into my_table values ('S:\\directory\\app'); I don't think it has much to do with database encoding. Luc Jouneau - Original Message - From: "Eduardo S. Fontanetti" <[EMAIL PROTECTED]> To: <[EMAIL PROTE

Re: [ADMIN] Problem saving some characters

2004-06-21 Thread Jim Seymour
"=?iso-8859-1?q?Eduardo=20S.=20Fontanetti?=" <[EMAIL PROTECTED]> wrote: > > Hello, > > I am trying to save a directory name on the Postgres, > but it is "cutting" some characters, and the result is > being diferent, and then, my app don't work properly. > > Example: > > I am trying to save "S:\

[ADMIN] Problem saving some characters

2004-06-21 Thread Eduardo S. Fontanetti
Hello, I am trying to save a directory name on the Postgres, but it is "cutting" some characters, and the result is being diferent, and then, my app don't work properly. Example: I am trying to save "S:\directory\app" to a text field on the Postgres. When I do a Select, it returns "S:directorya

Re: [ADMIN] pgadminII error in connecting to PostgreSQL Server

2004-06-21 Thread dojie pornea
Hi! I have already created database on my postgresql server and connected successfully using pgsql command on linux machine. I've installed my pgadminII build 1.6 to windows 98 machine. My problem is that when I try to connect using the said pgadmin it gives me an error of "class does not support