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
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
) 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
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
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).
>
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
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
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]
