[GENERAL] Column privileges and Hibernate

2009-12-13 Thread Craig Ringer
Hi folks Now that column privileges are supported (fantastic!), I've been looking at replacing some of my unpleasantly verbose (and probably error-prone) trigger code that's responsible for limiting which roles can modify which columns in some tables. I've run into a bit of a roadblock, and I'm w

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

2009-12-13 Thread Nando67
Thanks, Adrian i'll keep in mind your post many thanks Adrian Klaver ha scritto: > On Saturday 12 December 2009 1:08:15 pm Nando67 wrote: > > 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 fi

Re: [GENERAL] getaddrinfo.c error

2009-12-13 Thread Tom Lane
Greg Smith writes: > ¹ØÍâÁ÷ÀË wrote: >> Hi,guys.I ama studentwho want to studyPostgreSQL.I encountered the >> following errors which I don't know how to fix while I using eclipse >> to built pgsql: > I don't know why this specific one isn't working, but we do have a very > detailed guide to ge

Re: [GENERAL] getaddrinfo.c error

2009-12-13 Thread Greg Smith
wrote: Hi,guys.I ama studentwho want to studyPostgreSQL.I encountered the following errors which I don't know how to fix while I using eclipse to built pgsql: I don't know why this specific one isn't working, but we do have a very detailed guide to getting PostgreSQL to build in Eclips

Re: [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?

2009-12-13 Thread Andy Colson
On 12/12/2009 09:59 AM, zxo102 ouyang wrote: 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: "vx6

Re: [GENERAL] getaddrinfo.c error

2009-12-13 Thread John R Pierce
Craig Ringer wrote: You should really just stick to using PostgreSQL's existing, tested build tools and a well tested and supported compiler. You can still use something like Eclipse if you want to use an IDE to edit the sources - you just need to set the project up to use the existing postgre

Re: [GENERAL] getaddrinfo.c error

2009-12-13 Thread Craig Ringer
On 13/12/2009 3:45 PM, wrote: 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: Eclipse isn't a C compiler. It's an integrated development environment. I assume you're using GCC as