Re: [GENERAL] Mixed Case column names (php 4.3.5 & pg 7.4.2)

Matthew Morvant wrote: Typo on that post. Here is what is should be: echo pg_fetch_result($rsTest,0,"ridStudent"); which still doesn't work. Try: echo pg_fetch_result($rsTest,0,"\"ridStudent\""); Shachar -- Shachar Shemesh Lingnu Open Source Consulting http://www.lingnu.com/ --

Re: [GENERAL] Per-session data?

Steve Atkins wrote: > I need to keep a small amount of information (things like a unique > session identifier, the application - as opposed to database - > username and so on) that is local to each database session. It needs > to be visible from within plpgsql trigger functions and will be used > o

[GENERAL] XID Data Types

Hello everyone, Take the query below: select *,xmin from settings where xmin > '187167023'::xid limit 5; Although the docs say this is a 32 bit datatype, I have casted the integer '187167023' also to an xid type, but it seems that there is no operator to do a comparison, since I get this error:

[GENERAL] Per-session data?

I have an application where each user session opens and maintains a long-lived connection to the postgresql backend database. I need to keep a small amount of information (things like a unique session identifier, the application - as opposed to database - username and so on) that is local to each

[GENERAL] pdx pug or pug domain owner

How do I contact the owner of http://pugs.postgres.org/pdx/ or http://pugs.postgres.org/ ? I'd like to talk to the pdx guy(s)/gal(s) about a speaker meeting. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropria

[GENERAL] set autocommit TO FALSE on postgres 7.4

Dear Friends As Subject How to resolve, since i use with out problem on postgresql 7.3 Regards Luiz ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [GENERAL] set autocommit TO FALSE on postgres 7.4

> > Dear Friends > > As Subject > > How to resolve, since i use with out problem on postgresql 7.3 Don't know, being as I know I've turned off autocommit within Perl, and I'm *fairly* sure I've done so playing around with psql, and it's worked as expected. -- Jim Seymour| Spa

[GENERAL] Constrint Name Length...

What is the maximum length a constraint name can be? Example, Foreign Key constraint name (FK_Table1Field1_Table2Field1). Thanks, ThomasLL _ Mother’s Day is May 9. Make it special with great ideas from the Mother’s Day Guide! http://s

Re: [GENERAL] 1 foreign key to 2 different tables?

I don't know if this will work in your situation, but you might look into having table A and table B inherit from a common base table (where the column referenced by the foreign key in C is defined). Tim On May 2, 2004, at 2:51 AM, Ryan Riehle wrote: Thanks for your input. Yes, there is a lot mo

[GENERAL] Change Records to other DB.

Hello,       How can i do to change, with security, my all database and records from MySQL to PostgreSQL. Can Anybody help me??           Grettings             Kilmer Cruz