[GENERAL]

Hello. I have an instance of postgreSQL 7.4.7 with one database called dbmedia. We are moving to postgreSQL 8.1 running on windows2003 server. Can I just copy the entire $PGDATA directory to the new 8.1 instance of postgreSQL? Using PG_dump/restore? I heard that I might run into problems

Re: [GENERAL]

into a Windows install of postgreSQL 8.0.1? I have been researching for a while here, and I just can’t seem to find any info on this scenario. Thanks in advanced ! Adam Adam O'Toole wrote: Hello. I have an instance of postgreSQL 7.4.7 with one database called dbmedia. We are moving to postgreSQL

Re: [GENERAL] connection string - DNS

Any insight on this at all? I can't seem to find any info on it else-where.. Thanks ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] connection string - DNS

Hi there. I am connecting to my Postgresql 7.4.7 sever with psql-odbc from my VB.NET frontend. Right now I am using the Postgres server IP address in the odbc connection string. My question, I want to use a DNS server, how will my connection string change. Will I just specify the DNS address

[GENERAL] back-end triggers front-end to update

Hello everyone,I am searching for a way to have my postgresql 7.4.7 backend be triggered to let the front end know there has been a change to the database. If more then one person is connected to the database and person (x) makes a change, I want other clients to then be aware of that, and refresh

[GENERAL] INSERT INTO from a SELECT query

I am trying to INSERT multiple rows to a table using a stored procedure something like this: CREATE FUNCTION test(varchar) RETURNS int2 AS ' DECLARE id_list ALIAS FOR $1; BEGIN INSERT INTO history (media_id, media_type) SELECT media.media_id, media.media_type WHERE media.media_id IN

Re: [GENERAL] INSERT INTO from a SELECT query

I solved it. The statment worked as is, I just had to use dynamic SQL (put the statement in a string and the EXECUTE the string). Here is what I did: CREATE FUNCTION test(varchar) RETURNS int2 AS' DECLARE id_list ALIAS FOR $1; query varchar; BEGIN query := '' INSERT INTO history

[GENERAL] get the SALT

I am using VB.NET as a frontend to postGres 7.4. With MD5 authentication, how can I get the SALT value? The ODBC Connection with .NET is like a one step process, the connection string and you just send it with an open() command. Do I need it to be interactive and obtain the salt? Should I use a