[GENERAL] implicit casting bug or feature?

+--- character | text| text| yes Kristo Kaiv http://kaiv.wordpress.com (PostgreSQL blog) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet,

[GENERAL] INSERT doc discrepancy

8.2.4 Kristo Kaiv http://kaiv.wordpress.com (PostgreSQL blog)

Re: [GENERAL] Converting non-null unique idx to pkey

On 23.08.2007, at 16:10, Michael Glaesemann wrote: On Aug 23, 2007, at 7:44 , Kristo Kaiv wrote: On 23.08.2007, at 11:23, Alban Hertroys wrote: Since you're setting up replication to another database, you might as well try replicating to a newer release and swap them around once

Re: [GENERAL] Converting non-null unique idx to pkey

7;re setting up replication to another database, you might as well try replicating to a newer release and swap them around once it's done. I've seen that method of upgrading mentioned on this list a few times. Don't try this. Belive me you don't want to do it. We have had our fu

Re: [GENERAL] table column vs. out param [1:0]

On 23.08.2007, at 11:11, Kristo Kaiv wrote: On 23.08.2007, at 8:51, Kristo Kaiv wrote: I am trying to implement the new out parameters in functions and stumbled upon a problem. There is an internal requirement for our databases that every function call always returns 2 params status

Re: [GENERAL] table column vs. out param [1:0]

On 23.08.2007, at 8:51, Kristo Kaiv wrote: I am trying to implement the new out parameters in functions and stumbled upon a problem. There is an internal requirement for our databases that every function call always returns 2 params status & status_text. The problem now is that plp

[GENERAL] table column vs. out param [1:0]

text FROM service._simple_add( i_key_user ,i_key_service ,i_action ,i_subscr_len) INTO status, status_text; -[cut]- Kristo Kaiv http://kaiv.wordpress.com (PostgreSQL blog)

Re: [GENERAL] PgAdmin .sql default handler

On 14.08.2007, at 17:13, brian wrote: Select a .sql file, right-click (ctrl-click) and choose "Get Info" (or just select the file and hit CMD-I). Expand the "Open With ..." tab, choose "Other" and select the app you want to handle these from your Applications directory. brian i am not suc

[GENERAL] PgAdmin .sql default handler

How on earth can i turn off PgAdmin grabbing default program binding for .sql files on OS X? Kristo Kaiv http://kaiv.wordpress.com (PostgreSQL blog)

Re: [GENERAL] List tables in load order

//pgfoundry.org/pipermail/skytools-users/2007-July/74.html http://pgfoundry.org/pipermail/skytools-users/2007-August/thread.html AFAIK they don't have it quite ready yet but shouldn't take long... Kristo Kaiv http://kaiv.wordpress.com (PostgreSQL blog)