On Thu, Mar 17, 2005 at 08:48:54AM +, Spencer Riddering wrote:
> When a LOCK TABLE statement is included in a plpgsql function it does not
> actually lock the table.
How did you determine that? It's not clear from the example you
posted, and your function has its LOCK statements commented o
"Spencer Riddering" <[EMAIL PROTECTED]> writes:
> When a LOCK TABLE statement is included in a plpgsql function it does not
> actually lock the table.
Sure it does. If it doesn't, your test case surely will not prove it;
you cannot prove the existence or lack of existence of a lock in a test
cas
On Thu, Mar 17, 2005 at 08:24:06PM +, Bobby wrote:
> PostgreSQL version: 8.1
Do you mean 8.0.1? There is no 8.1; CVS HEAD is currently 8.1devel, and
it's a long way from being released.
> You guys badly need an import/export feature.
Could you be more specific? Are you familiar with COPY
On Tue, Mar 15, 2005 at 05:43:15PM +, John Smith wrote:
> When trying to create a complex type, the parser produces an error. e.g.
>CREAYE TYPE product AS (name varchar, price numeric);
> produces
> ERROR: parser: parse error at or near "as"
Is that the *exact* command you're running?
Hello,
I've probably found a temp table bug in PostgreSQL (tested with 7.4.7 and
8.0.1 on Linux x86).
Here's a demonstration of the bug:
CREATE FUNCTION testfunction()
RETURNS void
AS '
BEGIN
CREATE TEMP TABLE testtable (field int4) ON COMMIT DROP;
INSERT INTO test
The following bug has been logged online:
Bug reference: 1550
Logged by: Spencer Riddering
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: Debian Woody ( Postgresql from backports.org)
Description:LOCK TABLE in plpgsql function doesn't wor
PG version =
"PostgreSQL 8.0.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.2.3
(mingw special 20030504-1)"
Attached is the regression result of my test on Pg8.0.1 win32. The problem
is quite random. On the second round, it just disappeared.
first round --
The following bug has been logged online:
Bug reference: 1546
Logged by: Oliver Siegmar
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.7 / 8.0.1
Operating system: Linux x86
Description:Temp table isn't deleted at the end of a transaction /
ON COMMIT DROP has
The following bug has been logged online:
Bug reference: 1545
Logged by: Jason Erickson
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1,7.4.7
Operating system: Windows
Description:LIBPQ Windows Version not calling WSACleanup for every
WSAStartup
Details:
The following bug has been logged online:
Bug reference: 1548
Logged by: Javier Solís
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Windows XP
Description:The installation fails
Details:
In the installation process, at "Installing..."
The following bug has been logged online:
Bug reference: 1551
Logged by: Bobby
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: WinXP Pro
Description:You need an import/export feature
Details:
You guys badly need an import/export feature.
The following bug has been logged online:
Bug reference: 1547
Logged by: John Smith
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows 2000
Description:CREATE TYPE AS error
Details:
When trying to create a complex type, the parser pro
The following bug has been logged online:
Bug reference: 1543
Logged by: Ales Vojacek
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8
Operating system: W2000
Description:Problem with restore DB
Details:
We try to come from MSSQL. We heva no trigger or stored
On Fri, 11 Mar 2005 10:37:13 +1300, Mark Kirkwood
<[EMAIL PROTECTED]> wrote:
>Firebird 1.5.1 FreeBSD 5.3
>[correct results]
Interbase 6.0:
SQL> create table tab (col integer);
SQL> select 1 from tab having 1=0;
SQL> select 1 from tab having 1=1;
0<---:-)
Dear Tom and Neil,
Thanks very much for your help, and your explanations. This makes a lot
of sense, and I agree - this bug is definitely invalid.
Best wishes
Richard
Tom Lane wrote:
"Richard Neill" <[EMAIL PROTECTED]> writes:
SELECT instrument,priceband,pounds FROM tbl_instruments,tbl_prices WH
The following bug has been logged online:
Bug reference: 1549
Logged by: Daniel van Eeden
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Debian GNU/Linux for SPARC (sarge)
Description:initdb doesn't work
Details:
creating template1 data
On Mar 14, 2005, at 12:13 AM, Tom Lane wrote:
"John Engelhart" <[EMAIL PROTECTED]> writes:
Since I'm developing an SQL based application, I routinely "start from
scratch" with a script that deletes all the tables in my database and
rebuilds them. A problem started when I upgraded from 7.4.7 to 8.0
The following bug has been logged online:
Bug reference: 1544
Logged by: Pavlo Zhezhnych
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: Windows 2000/XP
Description:Problems with ODBC
Details:
I installed PostgreSQL and ODBC driver on my c
>Hi,
>
>I am using the Native Windows version which I downloaded it
>from the http://www.postgresql.org/ftp/v8.0.1/
The way most Windows systems are set up today, to make for a really
stong password you need at least 14 characters long. I beleive the
actual recommendation for a strong service acc
Hi,
I am using the Native Windows version which I downloaded it from the
http://www.postgresql.org/ftp/v8.0.1/
Regards,
Mehul
-Original Message-
From: Klaus Naumann [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 12:32 PM
To: Mehul Doshi-A20614
Cc: pgsql-bugs@postgresql.org
Su
Mehul,
In the service configuration gui, I entered a new service account user, as follows:
this rather sounds like some distro configuration tool. What kind of
distro are you using? If it's a problem wit hthe package you have to ask
the vendors/supporters of your distro.
Greetings, Klaus
---
Hi,
I had PostgreSQL-beta-5 installed until recently. I uninstalled it & installed
the PostgreSQL-8.01 official Postgres release. While installing, I came across
a slight problem:
In the service configuration gui, I entered a new service account user, as
follows:
Account name as "postgresnew",
22 matches
Mail list logo
