On Wed, Jan 12, 2005 at 01:23:59PM +, Tristen Ennemuist wrote:
>
> It would be nice if a lock timeout was implemented.
You might be able to use statement_timeout, although it doesn't
distinguish between waiting for a lock and a query that simply
takes a long time to run.
--
Michael Fuhr
ht
On Wed, Jan 12, 2005 at 08:12:38PM +, Kanu Patel wrote:
>
> I have postgresql 7.4.6 running on linux7.2. I have created couple tables
> and loaded about 15k entries using copy command. If I try to get one
> perticular entry using "select * from table where col = 'value';" command,
> it does no
On Wed, Jan 12, 2005 at 11:08:55PM +, Fahad wrote:
> PostgreSQL version: 8.0.0rc2
8.0.0rc5 is the latest -- it would be best to test with that to get
the most recent bug fixes.
> In an empty table, if I do this:
>
> "SELECT some_field WHERE some_field = 45 ORDER BY time";
ERROR: column "s
On Tue, Jan 11, 2005 at 07:27:44AM -0400, Elvis E. Henriquez A. wrote:
> PostgreSQL RC4 Command prompt functions on Windows (Windows 2000
> Professional - Spanish with SP4) still displays a message in the format:
> could not find a "functionname" to execute when executing a psql, pg_dump,
> created
"Karl Martindale" <[EMAIL PROTECTED]> writes:
> Deletes from this particular table take a long time (~5 min for 6000rows)
This usually occurs when you have another table with a foreign key
reference to this one, and the referencing column either has no index or
isn't of the exact same datatype as
On Wed, Jan 12, 2005 at 08:31:09 +,
Holger Klawitt <[EMAIL PROTECTED]> wrote:
>
> There is no (at least no apparent) link
> to the ChangeLog for the most recent version
> of postgres in neither the announcements nor in the
> news nor in the download section (at top level).
>
> I'd think tha
"Sokolov Yura" <[EMAIL PROTECTED]> writes:
> I created triggers In Perl trusted (ActivePerl 5.8.4 build 810) and it
> crashes when triggers FOR EACH STATEMENT tried to access $_SHARED when
> triggers FOR EACH ROW not accessed it before
Actually _SHARED had nothing to do with it: the trigger handle
Alexander,
> When I add a server in Windows XP with service pack Â1 or 2 always the
> connection is refused, but when I add a server in Windows XP without
> service pack, I do not have any problem, so, I would like know how I could
> solve this problem, or if this problem is with the S.O. or confi
On Fri, Jan 14, 2005 at 10:47:52PM +1100, Fahad G. wrote:
> I'm sorry, the query, as you would have thought, was:
>
> SELECT some_field FROM some_table WHERE some_field = 45 ORDER BY time LIMIT 1;
Yes, I assumed the query looked like that, and I couldn't reproduce
the problem with it. My point
On Thu, 2005-01-13 at 23:57 +, Chris Jones wrote:
> The following bug has been logged online:
>
> Bug reference: 1397
> Logged by: Chris Jones
> Email address: [EMAIL PROTECTED]
> PostgreSQL version: 7.4.6
> Operating system: NetBSD 2.0 i386
> Description:busy-loop
Hi Michael,
Here you go:
This is the create table statement:
CREATE TABLE jobstat_lc_q4_2004 (
jobstatid_q4_2004 serial NOT NULL,
jobid integer,
fetchtime timestamp without time zone NOT NULL,
stime timestamp without time zone,
mtime timestamp without time zone,
status ch
LS,
Just to report a successfull compilation and installation of PostgreSQL
8.0.0rc5
on Intel EM64T
with Red Hat ES v3.0 update 4
with options "with-openssl --enable-thread-safety"
using the following tweak: ln
-s /usr/kerberos/include/* /usr/include/
[EMAIL PROTECTED] bin]# cat /etc/redhat
On 15/1/05 9:55 AM, "Fahad G." <[EMAIL PROTECTED]> wrote:
> -- Grants
> REVOKE ALL ON TABLE jobstat_lc_q3_2004 FROM PUBLIC;
> GRANT SELECT ON TABLE jobstat_lc_q3_2004 TO apache;
...
Sorry about that, I pasted the wrong 'grants' from the log. This should be
..._q4_... Where it says q3.
Al
The following bug has been logged online:
Bug reference: 1400
Logged by: Michel Moreira
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.0rc5
Operating system: Windows XP SP2
Description:libeay32.dll error
Details:
When i start postgres.exe, is reported a er
The following bug has been logged online:
Bug reference: 1399
Logged by: Andrew Lazarus
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8
Operating system: Not applicable
Description:web site problem
Details:
Your new light blue text on the home page is unreada
On Fri, Jan 14, 2005 at 09:50:32PM -0400, Elvis E. Henriquez A. wrote:
Hi,
Please keep the copy to the list when replying.
> C:\Documents and Settings\Elvis>psql -h localhost -U postgres -f Update13.sql
> prueba
> could not find a "psql" to execute
> Password:
> could not find a "psql" to execu
"Fahad G." <[EMAIL PROTECTED]> writes:
> -- Indexes
> CREATE INDEX jobstat_lc_q4_2004_jobid ON jobstat_lc_q4_2004 USING btree
> (jobid);
> CREATE INDEX jobstat_lc_q4_2004_fetchtime ON jobstat_lc_q4_2004 USING btree
> (fetchtime);
> CREATE UNIQUE INDEX jobstat_lc_q4_2004_walltime ON
> unq_jobstat_lc
17 matches
Mail list logo
