[GENERAL] getaddrinfo.c error

Hi,guys.I am a student who want to study PostgreSQL.I encountered the following errors which I don't know how to fix while I using eclipse to built pgsql: " ../src/port/getaddrinfo.c:360: error: conflicting types for 'getnameinfo' /usr/inlclude/netdb.h:653: note: previous declaration of 'get

Re: [GENERAL] two field table: field1, field2, how to add a third one with the auto-generated value replace(field2,'channel','AAAA')?

On Sat, Dec 12, 2009 at 7:05 PM, zxo102 ouyang wrote: > Hi evreyone, >    I have a table with two fields > >    field1    field2 >     1 1channel >     2 2channel >     3 3channel > > Now I want to add the third one with the value > replace(field2,'channel','') like > >

[GENERAL] two field table: field1, field2, how to add a third one with the auto-generated value replace(field2,'channel','AAAA')?

Hi evreyone, I have a table with two fields field1field2 1 1channel 2 2channel 3 3channel Now I want to add the third one with the value replace(field2,'channel','') like field1field2 field3 1 1channelreplace(fie

Re: [GENERAL] how can i change encoding in template1 DB?

On Saturday 12 December 2009 1:08:15 pm Nando67 wrote: > Thank you, Adrian > > i solve my problem > > thanks for you post anyway > > Bye > > I would still go read the section I pointed you at earlier as well as this: http://www.postgresql.org/docs/8.4/interactive/charset.html You may find you hav

Re: [GENERAL] how can i change encoding in template1 DB?

Hi, scott i've just tried to remove the e-mail field from my client newsgroup but after it i can't send message! sorry, but what do i have to do to satisfy your request? I wouldn't put my e-mail, is it possible? Hi Nando Scott Marlowe ha scritto: > ** > PLEASE do

Re: [GENERAL] how can i change encoding in template1 DB?

thank you Scott, what i needed of i found it to the follow link http://www.postgresql.org/docs/8.2/static/app-initdb.html so 1. i stopped postgres daemon 2. i removed the PGROOT directory 3. i modified the start-up script at the line where there is the initdb comand: - (removed line) . su - pos

Re: [GENERAL] how can i change encoding in template1 DB?

Thank you, Adrian i solve my problem thanks for you post anyway Bye Adrian Klaver ha scritto: > On Saturday 12 December 2009 5:32:34 am Nando67 wrote: > > Then I would read the Notes section of: > http://www.postgresql.org/docs/8.4/interactive/sql-createdatabase.html > There is a description

Re: [GENERAL] how can i change encoding in template1 DB?

On Saturday 12 December 2009 5:32:34 am Nando67 wrote: > I installed postgresql by pacman (i'm using an ArchLinux Distr) > the default encoding of template1 is SQL_ASCII, i want to change this > one with UTF8 encoding > > i try to use ALTER DATABASE but this statemanent hasn't the clause > encoding

Re: [GENERAL] how can i change encoding in template1 DB?

** PLEASE do not send emails to the list from a bogus email address. If you have spam considerations there are other, more polite ways of handling it. On Sat, Dec 12, 2009 at 6:32 AM, Nando67 wrote: > I installed postgresql by pacman (i'm using an ArchLinux Distr) >

Re: [GENERAL] how can i change encoding in template1 DB?

On Sat, Dec 12, 2009 at 6:32 AM, Nando67 wrote: > I installed postgresql by pacman (i'm using an ArchLinux Distr) > the default encoding of template1 is SQL_ASCII, i want to change this > one with UTF8 encoding > > i try to use ALTER DATABASE but this statemanent hasn't the clause > encoding (whil

[GENERAL] how can i change encoding in template1 DB?

I installed postgresql by pacman (i'm using an ArchLinux Distr) the default encoding of template1 is SQL_ASCII, i want to change this one with UTF8 encoding i try to use ALTER DATABASE but this statemanent hasn't the clause encoding (while the CREATE DATABASE has it) so i can't modify the template

[GENERAL] How to save the results of replace(split_part(trim(both ' ' from "vx6000__12channel"),'__',2),'channel','myChannel') in my query into a temp variable?

Hi everyone, I have a big query (see below attached) in which all where clauses have sc.channel = replace(split_part(trim(both ' ' from ec.instantance_flux),'__',2),'channel','myChannel'). The value of ec.instantance_flux is like the format: "vx6000__12channel". I want to replace "channel" wit

Re: [GENERAL] Large Objects and Replication question

Symmetric-ds it is a replication solution that handles large objects, it is asynchronous and multi-master, i have been using between 30 separate postgresql connected by a slow link and until now i have been working without problems, i think this project should be in the wiki. http://symmetricd

Re: [HACKERS] [GENERAL] Installing PL/pgSQL by default

Hi, Le 11 déc. 2009 à 01:43, Bruce Momjian a écrit : >> Would you be up for writing the extension facility? > > Uh, well, I need to help with the patch commit process at this point --- > if I find I have extra time, I could do it. I will keep this in mind. If you ever find the time to do it, t

Re: [GENERAL] "setsockopt(TCP_KEEPCNT) failed: Invalid argument" on Debian Lenny

O, wait. I think i misinterpreted the man page. I intended to send a maximum of 200 keepalives, but that doesn't seem to be what the value means. The manpage says:"...if no response is obtained from the other end." More elaborate, somewhere on the internet: "When the SO_KEEPALIVE option is enabled