[GENERAL] 7.4.2 on Solaris 9 - Error

Hi. I want to install postgres 7.4.2 on solaris 9. I configure with: ./configure --enable-thread-safety and it works fine (no error). When I do "gmake", I get this error: thread.c: In function `pqGetpwuid': thread.c:116: error: too many arguments to function `getpwuid_r' make[3]: *** [thread.o]

[GENERAL] Problem with ecpg

Hello! I'm working with Postgres 7.4 on Tru64. When I execute an ecpg program (in an insert on a table), I get this error: EYE000: message type 0x5a arrived from server while idle How can I resolve this? Thanks. CG ---(end of broadcast)--- TIP

[GENERAL] Execute vacuum

Hello! Can I execute VACUUM ANALYZE from ecpg? How I do that??? /* I do: EXEC SQL VACUUM ANALYZE ; But I get error: 'ERROR: VACUUM cannot run inside a transaction block' */ Thanks for your help. CG ---(end of broadcast)--- TIP 2: you can ge

Re: [GENERAL] Problem with exec sql include

Thanks for you suggestion. In the test.pgc file, I do: EXEC SQL BEGIN DECLARE SECTION; exec sql include test; struct_cursor t_cursor; EXEC SQL END DECLARE SECTION; ... and it works fine. It is correct Thank you again. CG > ECPG does not parse anything outside EXEC

[GENERAL] Problem with exec sql include

Hello. I have a 2 files: test.h and test.pgc. In test.h, I defined: typedef struct { long curid; char curnombre[20]; char curfecha[10]; } struct_cursor; And, in test.pgc, I want to declare: EXEC SQL BEGIN DECLARE SECTION; struct_cursor t_cursor; EXEC SQ

Re: [GENERAL] Schema

Thanks. Exists a one to one relationship between schemas and users? Bruno Wolff III wrote: > Yes. Schemas got added to Postgres in 7.3. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-