Evgeny Duzhakow <[EMAIL PROTECTED]> writes:
> I have found a bug in version 7.3.2.
> At creation of tables the user not having grants on it can create the table
> in database. (For temporary tables all works normally).
Oh?
regression=# create user z;
CREATE USER
regression=# create schema s;
CREA
Hello,
I think this must be a bug, because I can't drop any of my
tables in PostgresQL v. 7.3.2, which seems strange because I'm sure it would
have been tested or reported?
Thank you,
Eddie
Sorry, never mind. The semi-colon key on the keyboard
being used does not function correctly.
Eddie
- Original Message -
From: Eddie J.
Smith
To: [EMAIL PROTECTED]
Sent: Wednesday, March 12, 2003 1:52 PM
Subject: DROP TABLE
Hello,
I think this must be a bug, because I can't
I have found a bug in version 7.3.2.
At creation of tables the user not having grants on it can create the table
in database. (For temporary tables all works normally).
I have written small patch, it can be incorrect, but it works for me.
see atach
Diabolo.
---
i cannot compile your last release of postgresql (7.3.2). i'm using right
now the 7.2.1 on a red hat 7.3.
if you could help me find the problem :
gmake check
install:
/var/tmp/postgresql-7.3.2/src/test/regress/./tmp_check/install/usr/lib/postg
resql/ascii_and_mic.so does not exist
what is this a
This query never returns:
select log(93094::numeric/92908::numeric);
If I type it in to psql on the three different systems I'm running postgresql
on, the query never returns, I can't cancel it (if I hit ctl-C psql says
"cancel request sent" but I don't get the prompt back), and postmaste
I believe I have found a bug in the vacuum procedures. I am helping out
a friend who is running a "alumni" sites of sorts using postgresql 7.2.3
as the backend. The first page someone loads does most of the queries
that any page will need and stores it in a session file (php style) and
hands a co
"shura" <[EMAIL PROTECTED]> writes:
> I get following output for time_f field
> 00:00:00
> I use PostgreSQL 7.3
Please update to 7.3.2 --- there were some relevant bug fixes.
regards, tom lane
---(end of broadcast)---
TIP 2
Hello,
I create a table
CREATE TABLE test
(
time_f TIME(7)
)
Table was created succesffull
INSERT INTO test VALUES ('16:28:45.1234567')
Row was added
When I try
SELECT * FROM test
I get following output for time_f field
00:00:00
Same result i has for all precisions greate than six,
and fo
I'm sorry if this is not a bug.
I build a shared library that contains a single function.
I loaded it into postgres and uset it to create an index and a view.
After that i modify rebuild the shared library ,
copy the ".so" file in "/usr/lib/postgres/lib" and reload it with
"LOAD 'funzioniGDB.so';"
On Mon, 2003-03-10 at 13:29, Trever L. Adams wrote:
> If I never do a vacuum analyze, it takes between 8-11 (high spikes
> around 23) seconds most of the time for this first page to load. If I
> do vacuum, nothing seems to change. If I do a vacuum analyze, the
> minimum load time is between 41-44
Josh Berkus <[EMAIL PROTECTED]> writes:
> Oh. I see what you mean. Given that I (along with at least a dozen posters
> to the SQL list) was confused that our HAVING/ORDER BY will accept column
> aliases but not sub-select aliases, would this be worthy of a FAQ item?
I think you may still be co
Tom,
> No, because it's not a bug. The SELECT list is evaluated after HAVING,
> so what you are asking for is an impossibility in the SQL semantic
> model.
>
> (Yeah, I know there's some laxity in GROUP BY ... one of our worse
> mistakes IMHO ...)
Oh. I see what you mean. Given that I (alon
On Wed, 12 Mar 2003, Theodore Petrosky wrote:
> This isn't all my problem...
>
> I was going through tutorials, and I typed in the
> example for inheritance. I had a typo that did not
> throw an error and I think it should.
>
> i created the tables from the cities, capitals example
> and then tri
On Wed, 12 Mar 2003, cn cn wrote:
> CREATE TABLE tt1 (
> c1int primary key
> )WITHOUT OIDS;
>
> CREATE TABLE tt2 (
> PRIMARY KEY (c1,c2),
> c1int,
> c2int
> )INHERITS (tt1) WITHOUT OIDS;
>
> CREATE TABLE tt3 (
> CONSTRAINT fktt3c1 FOREIGN KEY (c1) REFERENCES tt1 (c1),
> PRIMARY KEY (c1,c2),
> c1in
This isn't all my problem...
I was going through tutorials, and I typed in the
example for inheritance. I had a typo that did not
throw an error and I think it should.
i created the tables from the cities, capitals example
and then tried to insert.
test-db=# insert into capitals (name, populatio
I forget to mention the version: postgreSQL 7.3.2.
Regards,
CN
-
CREATE TABLE tt1 (
c1 int primary key
)WITHOUT OIDS;
CREATE TABLE tt2 (
PRIMARY KEY (c1,c2),
c1 int,
c2 int
)INHERITS (tt1) WITHOUT OI---DS;
CREATE TABLE tt3 (
CONSTRAINT fktt3c1 FOREIGN KEY (c1) REFERENCES tt1 (c1),
P
Hi!
Please try the following.
Regards,
CN
-
CREATE TABLE tt1 (
c1int primary key
)WITHOUT OIDS;
CREATE TABLE tt2 (
PRIMARY KEY (c1,c2),
c1int,
c2int
)INHERITS (tt1) WITHOUT OIDS;
CREATE TABLE tt3 (
CONSTRAINT fktt3c1 FOREIGN KEY (c1) REFERENCES tt1 (c1),
PRIMARY KEY (c1,c2),
c1int,
18 matches
Mail list logo
