Re: [ADMIN] postgres authentication

[EMAIL PROTECTED] wrote: > Hi, > > I changed my pg_hba.conf file so that I am authenticating using > md5 from passwdfile which is a file i created to hold my passwords. > I didn't add postgres onto that file but when I type psql template1 > under postgres, it prompts me for my password

Re: [ADMIN] SqlServer to PostgreSql

--- Luis Felipe Acevedo Fernandez <[EMAIL PROTECTED]> wrote: > Hi! > I triyed to migrate a database from SqlServer to > PostgreSql, but I have a > problem with char or varchar data types cos If I try > to insert or select some > information from a table the program retrieve blank > spaces, my p

Re: [ADMIN] alter table modify column?

Try this: 1) Add a new column of type DECIMAL(5,2) 2) update the table setting the new column with the value in the old column. 3) rename the old column to something not used 4) rename the new colum to the name of the old column 5) wait for a later version where you can drop column, or just leave

[ADMIN] alter table modify column?

As we transition our database, I'm finding the need to change columns types. I'm also finding this to be a major PITA. I have a column that's a something like: create table stuff ( ... rate varchar(7), ... ); However that doesn't allow math-like functions (e.g. avg), so it's gotta be chang

[ADMIN] postgres authentication

Hi, I changed my pg_hba.conf file so that I am authenticating using md5 from passwdfile which is a file i created to hold my passwords. I didn't add postgres onto that file but when I type psql template1 under postgres, it prompts me for my password. i type it in and it gives me

[ADMIN] XML to Postgre conversion

Hello: I am trying to figure out how to import xml documents into a postgres database. I am running PostgreSql 7.1.3 on Red Hat 7.2 at the moment. I have several dynamic xml documents that I want imported into the database on a regular basis(through cron entries). >From my research so far, I k

Re: [ADMIN] [GENERAL] Disabling case sensitivity

On Tue, Jul 09, 2002 at 04:11:38PM -0700, igor <[EMAIL PROTECTED]> wrote a message of 12 lines which said: > I would like to know if there is some way how to disable case > sensitivity in PostgreSQL server. Always remember that case-INsensitivity is properly defined only for US-ASCII. Many P

[ADMIN] View chached inside function

Hi all, I use Postgres 7.2.1 and I seen that if I write a funcrion that use a view and I drop and recreate the the view the function "still" remembember the old definition of that view. Does not exist some like CREATE OR REPLACE for the VIEWS ? Ciao Gaetano -- #exclude #include printf("\t\

Re: [ADMIN] SqlServer to PostgreSql

Luis Felipe Acevedo Fernandez wrote: > Hi! > I triyed to migrate a database from SqlServer to PostgreSql, but I have a > problem with char or varchar data types cos If I try to insert or select some > information from a table the program retrieve blank spaces, my program was > develop in PowerB

Re: [ADMIN] Authentication in batch processing

On Wednesday, July 10, 2002, at 08:54 AM, Kevin Brannen wrote: Stuff deleted > The order I would propose would be: env-var, command-line, STDIN, > interactive prompt if we have a tty. Reorder as you see fit. To the above list I would add a .psql (or something) file in the home dir of the pe

Re: [ADMIN] Authentication in batch processing

Bruce Momjian wrote: > Kevin Brannen wrote: > >>Bruce Momjian wrote: >>... >> >>>7.3 may remove PGPASSWORD, I think, and instead allow you to specify a >>>file that contains the password. >> >>But do you know how many hours it took me to find out about PGPASSWORD >>in the docs and now you want t

Re: [ADMIN] [GENERAL] Disabling case sensitivity

On Wed, 2002-07-10 at 00:11, igor wrote: > I would like to know if there is some way how to disable case > sensitivity in PostgreSQL server. With some varaiable or some setting > in configuration file or how? > So after this would be the same 'Good' and 'GOOD' or 'GoOd' in some > SELECT from tab

[ADMIN] Disabling case sensitivity

Hi I would like to know if there is some way how to disable case sensitivity in PostgreSQL server. With some varaiable or some setting in configuration file or how? So after this would be the same 'Good' and 'GOOD' or 'GoOd' in some SELECT from table where username='Good'. I wanna get the same

[ADMIN] SqlServer to PostgreSql

Hi! I triyed to migrate a database from SqlServer to PostgreSql, but I have a problem with char or varchar data types cos If I try to insert or select some information from a table the program retrieve blank spaces, my program was develop in PowerBuilder 7 Example If there is a table with a co

R: [ADMIN] Authentication in batch processing

> -Messaggio originale- > Da: Bruce Momjian [mailto:[EMAIL PROTECTED]] > Inviato: mercoledì 10 luglio 2002 4.11 > A: Kevin Brannen > Cc: [EMAIL PROTECTED] > Oggetto: Re: [ADMIN] Authentication in batch processing > > > Kevin Brannen wrote: > > Bruce Momjian wrote: > > ... > > > > > > 7