Michael Fuhr <[EMAIL PROTECTED]> writes:
> On Fri, Mar 11, 2005 at 11:12:07AM +, biju wrote:
>> i tried to execute alter table statement for a particular table. i did it
>> many ways, but not worked.
> Please show the exact statement you executed and describe how it
> didn't work. If you got
"Avram" <[EMAIL PROTECTED]> writes:
> The SELECT command using a 'uuid' field indexed with pk_situation returns no
> result. The error dissapear after the backup and the restore of the database
> or after deleting the index.
There is no uuid datatype in the standard Postgres distribution. I
suppo
"Henk van den Toorn" <[EMAIL PROTECTED]> writes:
> CREATE RULE rulename AS ON UPDATE
> table WHERE OLD.index = NEW.index
> DO INSTEAD NOTHING;
> Postgresql responds with
> ERROR: relation "*OLD*" does not exist
Hm, works for me:
regression=# create table tab1 (index serial primary key, data tex
"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.1 in
> that the first run after the cle
"Patrick Boulay" <[EMAIL PROTECTED]> writes:
> Is it possible to change a prompt character during a transaction?
Yes, read the psql reference page's section about "Prompting".
regards, tom lane
---(end of broadcast)---
TIP 7
"Richard Neill" <[EMAIL PROTECTED]> writes:
> SELECT instrument,priceband,pounds FROM tbl_instruments,tbl_prices WHERE
> tbl_instruments.priceband=tbl_prices.priceband;
> ERROR: column reference "priceband" is ambiguous
> I think that the first query ought to succeed, since although priceband is
On Fri, Mar 11, 2005 at 11:12:07AM +, biju wrote:
> PostgreSQL version: 7.2.2
This version is pretty old -- if you must use 7.2, then consider
upgrading to 7.2.7. Better yet, try a newer release like 8.0.1.
> i tried to execute alter table statement for a particular table. i did it
> many w
Richard Neill wrote:
I think that the first query ought to succeed, since although priceband is
ambiguous (it could mean either tbl_prices.priceband or
tbl_instruments.priceband), the information in the WHERE clause means that
they are explicitly equal, and so it doesn't matter which one we use.
We
Joe Brown wrote:
> joe=> select to_date('19450323','CCYYMMDD');
> to_date
>
> 2045-03-23
> (1 row)
>
> joe=> select to_date('19450323','MMDD');
> to_date
>
> 1945-03-23
> (1 row)
>
> I thought the former would be "more" correct. But it seems I am mistaken.
The following bug has been logged online:
Bug reference: 1530
Logged by: Avram
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6 testing
Operating system: Debian kernel 2.4.18 testing (pg-uuid 0.01)
Description:search on uuid indexed article returns no result
I encounter the similar problem in "make check" (win2k-mingw, 8.0.1). The
regression test could randomly fail due to "could not write block (Invalid
argument)" problem or could not "remove file" problem.
Regards,
Qingqing
p.s. I believe this could be a potential serious problem, so I forward it t
joe=> select to_date('19450323','CCYYMMDD');
to_date
2045-03-23
(1 row)
joe=> select to_date('19450323','MMDD');
to_date
1945-03-23
(1 row)
I thought the former would be "more" correct. But it seems I am mistaken.
---(end of broadcast)-
The following bug has been logged online:
Bug reference: 1532
Logged by: Ezequiel Tolnay
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Windows 2003 Server
Description:typecast problem between arrays of an int8 derived
datatype and varcha
It could be a pgAdmin III presentation fault.
I'm using PostgreSQL 8.0.0 on Windows 2k and I've got the same problem
but only when inquiring via pgAdmin, using psql from command line all
goes ok. I think that the resulting string are correct, that's why the
function "position(\'.\' in userName);" d
> What that means is that neither the HAVING clause nor the targetlist
> can use any ungrouped columns except within aggregate calls; that is,
>
> select col from tab having 2>1
Informix:
select tabname from systables having 2 > 1;
294: The column (tabname) must be in the GROUP BY list.
The following bug has been logged online:
Bug reference: 1533
Logged by: Henk van den Toorn
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.3-7
Operating system: Freebsd 5.3
Description:"*OLD*" relation not recognized in CREATE RULE
Details:
When creating a
Tom Lane wrote:
Would those of you with access to other DBMSes try this:
create table tab (col integer);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
insert into tab values(1);
insert into tab values(2);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
I claim that a SQL-c
The following bug has been logged online:
Bug reference: 1534
Logged by: yingqun wang
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0
Operating system: fedora
Description:2^32-1 commands limitation in one transcation
Details:
My plpgsql function loop throug
On Oracle 9.2 you get 0, 0, 0, and 2 rows.
--Barry
SQL> create table tab (col integer);
Table created.
SQL> select 1 from tab having 1=0;
no rows selected
SQL> select 1 from tab having 1=1;
no rows selected
SQL> insert into tab values (1);
1 row created.
SQL> insert into tab values (2);
On Thu, Mar 10, 2005 at 12:44:50PM -0500, Tom Lane wrote:
> Would those of you with access to other DBMSes try this:
DB2/LINUX 8.1.6
> create table tab (col integer);
> select 1 from tab having 1=0;
1
---
0 record(s) selected.
> select 1 from tab having 1=1;
1
-
Tom Lane wrote:
Would those of you with access to other DBMSes try this:
create table tab (col integer);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
insert into tab values(1);
insert into tab values(2);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
I claim that a SQL-c
On Thu, 10 Mar 2005, Tom Lane wrote:
Would those of you with access to other DBMSes try this:
create table tab (col integer);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
insert into tab values(1);
insert into tab values(2);
select 1 from tab having 1=0;
select 1 from tab having 1=1;
The following bug has been logged online:
Bug reference: 1536
Logged by: biju
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.2
Operating system: linux-gnu
Description:alter command
Details:
i tried to run alter command , but it didnt work.
can u help for
The following bug has been logged online:
Bug reference: 1541
Logged by: John Engelhart
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: FreeBSD 5.3-p5
Description:Unusually long INSERT times after fresh clean/CREATE
TABLES
Details:
Recen
The following bug has been logged online:
Bug reference: 1538
Logged by: Ludwig Lim
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Windows XP SP.1
Description:Unable to reattach to shared memory
Details:
2005-03-11 12:32:23 LOG: backgr
The following bug has been logged online:
Bug reference: 1537
Logged by: biju
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.2
Operating system: linux-gnu
Description:alter table statement
Details:
i tried to execute alter table statement for a particular
The following bug has been logged online:
Bug reference: 1539
Logged by: Patrick Boulay
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.5
Operating system: Unix Solaris
Description:Suggestion
Details:
Sometime I do transaction and I do a couple of commands
The following bug has been logged online:
Bug reference: 1535
Logged by: Miguel Juan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.2
Operating system: W2000Pro
Description:ODBC bug in pgslqodbc-08_00_0101
Details:
Hy,
I have installed the last version of
The following bug has been logged online:
Bug reference: 1540
Logged by: Richard Neill
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.01
Operating system: Linux
Description:Enhancement request: 'ambiguous' column reference in
psql
Details:
Dear Postgresql te
29 matches
Mail list logo
