Re: [HACKERS] Mysql.whynot or PG vs MySQL comparison table?

Greg Stark wrote: Before i duplicate work does anyone have a MySQL.whynot or Postgres versus MySQL comparison table? Like f.ex http://wiki.postgresql.org/wiki/Why_PostgreSQL_Instead_of_MySQL_2009 ? -- Tommy Gildseth -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To

Re: [HACKERS] [patch] fix dblink security hole

tive then would be to hardcode the password in your stored procedures, or store it in a separate table somehow? -- Tommy Gildseth -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Add dblink function to check if a named connection exists

Joe Conway wrote: Tom Lane wrote: Tommy Gildseth <[EMAIL PROTECTED]> writes: One obvious disadvantage of this approach, is that I need to connect and disconnect in every function. A possible solution to this, would be having a function f.ex dblink_exists('connection_name') th

Re: [HACKERS] Add dblink function to check if a named connection exists

. -- Tommy Gildseth -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Add dblink function to check if a named connection exists

is way, I could just check if a named connection exists, and establish a connection if not, and wait until the end of the session to disconnect all established connections. I've attached a patch with a suggested implementation of such a function. -- Tommy Gildseth

[HACKERS] How to determine if psql returns ZERO to the "shell" and finished successfully?

Hello, I'm implementing a Setup Wizard to install PostgreSQL. In the documentation it states that psql returns ZERO to the "shell" if it finished successfully. I'm implementing a wizard in Pascal and was wondering the correct syntax to check whether or not the shell received ZERO? For example,

Re: [HACKERS] DBLink's default user: postgres

pg_hba.conf only? This issue has been thoroughly discussed before. You can read more about it in f.ex these threads: http://archives.postgresql.org/pgsql-hackers/2007-06/msg00678.php http://archives.postgresql.org/pgsql-patches/2007-07/msg0.php -- Tommy Gildseth -

Re: [HACKERS] XML export function signatures

table? Could it be an idea to allow the table name to be specified as a parameter to the function? Another neat feature would be if you could specify a set of columns which should be represented as attributes instead of nodes. -- Tommy ---(end of broa

[HACKERS] Pgsql and .NET (Help!)

the odbc driver and .NET? I am getting despirate and not sure which way to turn now. A snip of the code I have been using to try to connect is below. Thanks in advance. Tommy Dim connstring As String = "Server=192.168.5.5;User Id=myname;Password=mypassword;Database=mydbname" Dim c