se:
SELECT ... WHERE id = 12345::int8
it will use the index.
Is there a solution for PG 7.4 to choose the default datatype for this
way of casting?
--
Markus Schulz
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Am Dienstag, 27. Februar 2007 20:37 schrieb Andreas Kretschmer:
> Markus Schulz <[EMAIL PROTECTED]> schrieb:
> > > You can use pg_restore with -l to generate a listfile for all
> > > objects in the database. Then you can reorder this ($EDITOR) and
> > > then us
Am Dienstag, 27. Februar 2007 18:28 schrieb A. Kretschmer:
> am Tue, dem 27.02.2007, um 17:44:06 +0100 mailte Markus Schulz
folgendes:
> > Hello,
> >
> > i have some trouble with dumping and restoring a database with
> > postgresql 7.4.7-6sarge4 (debian sarge).
>
will be created after data was inserted).
Why DEFAULT (and NOT NULL) constraints would'nt be added after data
insertion? (like Primary-Key and Foreign-Key)
What can i do to enforce the order of plpgsql functions prior to all
table structures?
--
Markus Schul
) condition inserts don't crash
anymore. But each select on the table crashs now.
Markus Schulz
---(end of broadcast)---
TIP 6: explain analyze is your friend
On Wednesday 05 October 2005 05:01, Tom Lane wrote:
> Markus Schulz <[EMAIL PROTECTED]> writes:
> > This works fine and then i've created the new Type like:
> >
> > CREATE OR REPLACE FUNCTION etextin(cstring)
> > RETURNS etext AS
> > '$libdir/new
etext column) the server crashed after inserting the second
(first insert works) tuple or on every select.
What i've missed or doing wrong? Are there any HowTo's on this topic?
--
Markus Schulz
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
at, but somehow it eludes
> me tonight.
>
> Any pointers are greatly appreciated.
>
> UC
select user_id,image_type, count(id)
from
group by user_id,image_type
should do it.
--
Markus Schulz
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
