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 - regardl
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 ps
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,
>
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,
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 sequenc
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 cl
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* dec
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 n
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
>
10 matches
Mail list logo
