Re: [SQL] Sequence and nextval problem

2008-11-24 Thread Craig Ringer
Earlier, Craig Ringer wrote: for sample operator/cast definitions. There are some notes in the top of the "passthrough.txt" module I attached that explain the ODBC driver options you'll want. Also, note that in the message I just posted the function DSN() must be adapted to include the appro

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 acces

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 me

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 s

[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] 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 no

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] 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 novembe