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
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
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
"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