Re: [SQL] Index not recognized

2003-12-06 Thread Greg Stark
"Grace C. Unson" <[EMAIL PROTECTED]> writes: > Why is it that my index for text[] data type is not recognized by the > Planner? > > I did these steps: > > 1. create function textarr(text[]) returns text language sql as 'select > $1[1]' strict immutable > 2. create index org_idx on EmpData (text

Re: [SQL] Is it possible to set a NOT NULL constraint deferrable?

2003-12-06 Thread Bruce Momjian
Olivier Hubaut wrote: > I can put all the other constaints deferrable, but the *NOT NULL* one > seems to be undeferrable. > > Is ther a way to by-pass this or is do you know if this is planned in > the future versions? Only foreign key constraints are deferrable. Many want UNIQUE to be deferra

Re: [SQL] Help converting Oracle instead of triggers to PostgreSQL

2003-12-06 Thread Robert Treat
Generally speaking you can send articles to me or to [EMAIL PROTECTED] for inclusion on the techdocs site. I'll try to update the links you mentioned below as well. thanks. Robert Treat On Thursday 04 December 2003 12:52, Clint Stotesbery wrote: > Hi Christoph, > Thanks for the links but the

Re: [SQL] What's wrong with COPY rights in 7.3.4?

2003-12-06 Thread Bruce Momjian
COPY is done with the rights of the server backend, not your client. You can also use \copy in psql and that is done in the client. --- Olivier Hubaut wrote: > Hi, > > I tried to use the COPY function in v7.3.4 but I have