Dear Group,
Is there a way to increase the time of Dead Lock?
The default is set to 1000 msec.
Regards,
Shan.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Sat, 2004-06-19 at 06:26, Daniel Heiserer wrote:
> Hi,
> I want to administer files with postgres.
> When I "import" a file to postgres I also
> submit certain atributes the file has.
> Such as filetype or specific properties I know
> about the file (not the standard stuff like
> the OS knows ab
Hi,
I want to administer files with postgres.
When I "import" a file to postgres I also
submit certain atributes the file has.
Such as filetype or specific properties I know
about the file (not the standard stuff like
the OS knows about the file as date,and size)
I want that postgres then copies th
I agree, the current numbers are misleading, nothing other than null
really makes sense, at least the consumers of it can decide what to do if
they need to rather than check for some strange number, sounds good to me.
>
> After more thought I like returning NULL for both precision and scale in
> t
On Saturday 19 June 2004 06:57 pm, Tom Lane wrote:
> > egenome_dev=# \i
> > /Users/murphy/cvs/egora/sql/data_port/port_identifiers.sql INSERT 0
> > 1672036
> > psql:/Users/murphy/cvs/egora/sql/data_port/port_identifiers.sql:15:
> > ERROR: syntax error at or near "sourcecode" at character 2
>
> It s
Scott,
> > egenome_dev=# \i
> > /Users/murphy/cvs/egora/sql/data_port/port_identifiers.sql
> > INSERT 0 1672036
>
> This INSERT 0 part tells you it didn't actually insert anything.
Actually, that's not true. I didn't know what this number was until just now,
but I looked it up: for a single-ro
Carter Harrison <[EMAIL PROTECTED]> writes:
> Can somebody please give me some detailed
> directions on restoring the file system correctly. I think the only
> thing that is different about this new install of postgresql is that it
> is owned by a different user than before. Thanks.
Did you m
On Friday 18 June 2004 09:21, Robert Treat wrote:
> I notice we have yet to get a directory for 7.4.3 under /binary,
> are you planning on putting them up on the ftp server as well?
> Along those lines is anyone planning on doing a redhat 7.3 build ?
I'm running behind on this cycle. Been swampe
On Sat, 2004-06-19 at 16:34, Carter Harrison wrote:
> I'm running the latest version of PostgreSQL. I backed up one of my
> databases following the instructions in the postgresql documentation.
> This means that I did shut down postmaster and I tarred the data
> directory just like it says to.
I'm running the latest version of PostgreSQL. I backed up one of my
databases following the instructions in the postgresql documentation.
This means that I did shut down postmaster and I tarred the data
directory just like it says to. Now, I'd like to restore the file
system. I started by j
Kevin Murphy <[EMAIL PROTECTED]> writes:
> What should I make of this?
> egenome_dev=# \!cat /Users/murphy/cvs/egora/sql/data_port/port_identifiers.sql
> INSERT INTO public.identifiers (element_id, name, source, source_code, title)
> SELECT DISTINCT
> elementid,
>
On Sat, 2004-06-19 at 07:14, Kevin Murphy wrote:
> Using PG 7.4.3 on Mac OS X 10.2.8, the following "insert into ... select ..."
> statement completed and then announced a syntax error, which seems bizarre.
It's not actually inserting anything...
> (Don't be confused by the fact that the two t
On Sat, 19 Jun 2004, Robert Fitzpatrick wrote:
> Anytime I create an INSERT BEFORE trigger that includes a query on the
> same table as the trigger is assigned, the insert does not happen
> without error. I get 'INSERT 0 0'. It is like the query loses the insert
> information, is this something t
13 matches
Mail list logo
