Re: [GENERAL] xpath functions

2009-02-21 Thread Peter Eisentraut
On Thursday 19 February 2009 16:46:42 Francisco wrote: > Hi List, > I have installed postgreSQL 8.3 in my Ubuntu Hardy Heron. > I want to use xpath functions (like xpath_table), but I can't. An error > appears "xpath_table does not exists". > How could I intregrate xpath funtions with my postgreSQL

Re: [GENERAL] where to divide application and database

2009-02-21 Thread Ron Mayer
Ivan Sergio Borgonovo wrote: > On Fri, 20 Feb 2009 06:50:22 -0800 > David Fetter wrote: >>> ... moving some of the checks >>> into the database and away from the application. >> Since a useful database has *many* applications instead of "the" >> application, I think this is an excellent move. > >

Re: [GENERAL] Pointers in custom types

2009-02-21 Thread Will Harrower
Tom Lane wrote: Will Harrower writes: I'm writing a custom type in C that needs to manage two byte arrays (among other things). I have attempted to implement this using something similar to the following struct (along with corresponding input and output functions): typedef struc

Re: [GENERAL] Pointers in custom types

2009-02-21 Thread Tom Lane
Will Harrower writes: > I'm writing a custom type in C that needs to manage two byte arrays > (among other things). I have attempted to implement this using something > similar to the following struct (along with corresponding input and > output functions): > typedef struct example { > byt

Re: [GENERAL] Fixing invalid owners on pg_toast tables in 8.3.5

2009-02-21 Thread Tom Lane
I wrote: > [ scratches head... ] That example fails to misbehave for me in 8.3.6, Oh, wait, you omitted a step from the example: the ALTER has to be done as somebody other than the table owner (eg a superuser, else you'd not have the needed permissions). regression=# create user a; CREATE ROLE r

[GENERAL] Pointers in custom types

2009-02-21 Thread Will Harrower
Hi, I'm writing a custom type in C that needs to manage two byte arrays (among other things). I have attempted to implement this using something similar to the following struct (along with corresponding input and output functions): typedef struct example { bytea* first; bytea* second;

Re: [GENERAL] Fixing invalid owners on pg_toast tables in 8.3.5

2009-02-21 Thread Tom Lane
Cott Lang writes: > I fiddled around a while, found the problem, and I can repeat it at > will. It's actually related to type changes we've made over the months > since the restore. [ scratches head... ] That example fails to misbehave for me in 8.3.6, and I'm pretty certain there have been no r

Re: [GENERAL] NOVALIDATE in postgresql?

2009-02-21 Thread decibel
On Feb 19, 2009, at 1:49 PM, Adrian Klaver wrote: From the Oracle manual: ENABLE NOVALIDATE means the constraint is checked for new or modified rows, but existing data may violate the constraint. So you are looking for an incomplete constraint? More likely they want to add a constraint but

Re: [GENERAL] postgres wish list

2009-02-21 Thread Martijn van Oosterhout
On Fri, Feb 20, 2009 at 09:50:25AM +, Jasen Betts wrote: > by the default authentication for unix domain sockets is "ident" which > (AIUI) requires the caller have the a unix username that matches their > postgres username, but you can change that to "md5" (password based) > or "trust" (no aut

Re: [GENERAL] How to import/setup library functins

2009-02-21 Thread John R Pierce
c k wrote: When I installed postgres on windows using installer it gives me some options to include that library files or function OR to enable these features. but how can I setup these extra features on Linux when using rpm installers. I have tries to create such functions on linux pg, but it

[GENERAL] How to import/setup library functins

2009-02-21 Thread c k
When I installed postgres on windows using installer it gives me some options to include that library files or function OR to enable these features. but how can I setup these extra features on Linux when using rpm installers. I have tries to create such functions on linux pg, but it fails. These f