n't accept statements without them. The use of this convention is
extensive.
Cheers,
Rob Fielding
Development
Designer Servers Ltd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Andrew Sullivan wrote:
On Tue, Nov 04, 2003 at 11:21:35AM +, Rob Fielding wrote:
Hi,
We're currently experiencing a problem where SQL statements are failing
when entring a '' for not not-null integer columns:
Yes. This behaviour was made more compliant in 7.3. It&#
ashing? I don't know anything about the internal
stucture of the tuples.
Dependant on the above, it would probably make sense to clean up the
database, especially considering these columns are also indexed.
Cheers
--
Rob Fielding
Development
Designer Servers Ltd
the offending statements
on the few occasions where it has been valid to do this.
Consider this a non-issue.
Cheers,
--
Rob Fielding
Development
Designer Servers Ltd
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
fastest?
Is would be better to create a SEQUENCE and simply call nextval on it.
Then you are assured that you'll get a unique sequence when working in a
concurrent environment.
It would also be guaranteed faster than interrogating tables.
Hope this helps,
--
Rob Fielding
Development
Des
your application and specific situation I guess however
your counter table idea sounds exactly like what SEQUENCE provides,
without any of the guarantees.
I think I'd still recommend using a SEQUENCE for anything but the most
profound reason :)
--
Rob Fielding
[EMAIL PROTECTED]Develop
