Re: [SQL] BULK COLLECT

2008-11-24 Thread Paul Dam
Scott and others, The following article by Steven Feuerstein from 2004 explains it quite clear, I think. http://www.oracle.com/technology/oramag/oracle/04-jan/o14tech_plsql.html Paul Dam -Oorspronkelijk bericht- Van: Scott Marlowe [mailto:[EMAIL PROTECTED] Verzonden: vrijdag 21

Re: [SQL] Permission denied for create table

2008-11-24 Thread Richard Huxton
Pascal Tufenkji wrote: P.S. I'm working on PostgreSQL 7.3.2 In case you missed Marcin's comment - don't use this version. Upgrade. Version 7.3 is no longer supported by the core developers. Even if you were determined to run 7.3 you should have upgraded to 7.3.21 at some point. Read through

Re: [SQL] Permission denied for create table

2008-11-24 Thread Tom Lane
Pascal Tufenkji [EMAIL PROTECTED] writes: Creating a normal table works fine, but creating a table with subqueries is giving me permission denied You need to explicitly grant select permission on the child tables not just the parent. P.S. I'm working on PostgreSQL 7.3.2 As already noted, you

[SQL] Sequence and nextval problem

2008-11-24 Thread Tk421
Hello everybody. I've got an vb aplication that uses an Access database. I'm trying to convert the database to postgres. The conversion was done ok, but i've got a little problem that i don't know how to solve. Let's see if anyone can help me. The conversion from access database to

Re: [SQL] Sequence and nextval problem

2008-11-24 Thread Scott Marlowe
On Mon, Nov 24, 2008 at 12:12 PM, Tk421 [EMAIL PROTECTED] wrote: Hello everybody. I've got an vb aplication that uses an Access database. I'm trying to convert the database to postgres. The conversion was done ok, but i've got a little problem that i don't know how to solve. Let's see if

Re: [SQL] Sequence and nextval problem

2008-11-24 Thread ries van Twisk
On Nov 24, 2008, at 2:12 PM, Tk421 wrote: Hello everybody. I've got an vb aplication that uses an Access database. I'm trying to convert the database to postgres. The conversion was done ok, but i've got a little problem that i don't know how to solve. Let's see if anyone can help

Re: [SQL] Sequence and nextval problem

2008-11-24 Thread Craig Ringer
Tk421 wrote: Hello everybody. I've got an vb aplication that uses an Access database. I'm trying to convert the database to postgres. The conversion was done ok, but i've got a little problem that i don't know how to solve. Let's see if anyone can help me. The conversion from