On 18 Apr, 14:12, [EMAIL PROTECTED] (Karsten Hilbert) wrote:
If one wants to operate on one/a range of row(s) but the
code fetches all rows (for various values of all) then I'd
suspect there's something missing in the SQL statement, say,
a LIMIT or appropriate WHERE conditions - regardless of
On 15 Apr, 17:53, [EMAIL PROTECTED] (Erik Jones) wrote:
On Apr 15, 2008, at 10:27 AM, Dawid Kuroczko wrote:
By the looks of descriptions I am slightly inclined towards
psycopg2, but I would feel better if I talked with people
who actually used these libraries.
Most definitely psycopg2,
On 21 Mar, 17:15, [EMAIL PROTECTED] (Edward Blake) wrote:
When I try and rewrite it as a Postgres statement (below), it fails at line
9.
0 SET CONSTRAINTS ALL DEFERRED;
1 CREATE TABLE products (
2 product_id serial[11] not null,
3 product_name varchar[255] not null,
4
On 14 Mar, 09:26, [EMAIL PROTECTED] (jose javier parra sanchez)
wrote:
itself open source, you have to pay to get a license. Pay for GPL
software?
You cannot be serious, GPL has no relation with monetary value. The
GPL is a 'Usage License'. If i write GPL software to my clients,
should
On 18 Feb, 13:36, django_user [EMAIL PROTECTED] wrote:
How can stop postgresql from incrementing the primary key value, so
that even after many failed insert statements it get the next id val.
Auto-incrementing columns, typically implemented using the serial
data type [1], employ sequences.
On 5 Des, 05:00, [EMAIL PROTECTED] (Tom Lane) wrote:
Yeah, this is a problem. The SELECT will acquire AccessShareLock
on R and P, and subsequently try to acquire AccessShareLock on all
the inheritance children of P (and I don't think the order in which
these locks are acquired is very
I recently encountered an interesting situation with regard to
partitioned tables, concurrent updates and deadlocks which probably
has an obvious explanation, although I can't seem to find one in the
manual. Below, I explain the situation and provide some of my own
naive reasoning about what seems
On 30 Nov, 16:12, [EMAIL PROTECTED] (Tom Lane) wrote:
[Quoting a re-telling of the myth of products living happily ever
after under the control of big companies]
Anyone who thinks that's a reason to feel good is living on some other
planet than I do. Consider that if the company *does*
On 25 Okt, 17:36, [EMAIL PROTECTED] wrote:
The design is based on access patterns, i.e. one partition represents a
group of data along a discrete axis, so the partitions are the perfect for
modeling that. Only the last partition will be used on normal cases. The
previous partitions only need
On 13 Sep, 06:12, [EMAIL PROTECTED] (Ow Mun Heng) wrote:
On Mon, 2007-09-10 at 13:00 -0600, RC Gobeille wrote:
Or this one:
http://schemaspy.sourceforge.net/
Can't seem to get it to connect to PG using the example.
java -jar schemaSpy_3.1.1.jar -t pgsql -u operator -p operator -o
test_db
10 matches
Mail list logo