I have postgresql-7.0.3
I'm trying to do following :
test= create table test (col1 int,col2 int);
test= grant select on test (col1) to user1;
ERROR: parser: parse error at or near "("
I'm trying to use GRANT with SQL92 extentions,(set permissions on
the individual column) but it dosn't work.
Vladislav Breus wrote:
test= create table test (col1 int,col2 int);
test= grant select on test (col1) to user1;
ERROR: parser: parse error at or near "("
I'm trying to use GRANT with SQL92 extentions,(set permissions on
the individual column) but it dosn't work.
Where I was
Pardon my ignorance on this topic, but if you compile using MS VC++ do you
need cygwin at all? Does this allow you to run postgre without cygwin
installed?
-Original Message-
From: Brent R. Matzelle [SMTP:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 1:08 PM
To: [EMAIL
On Mon, 19 Mar 2001, will trillich wrote:
On Mon, Mar 19, 2001 at 09:50:20PM -0500, Bruce Momjian wrote:
Psql backslash commands use it to describe tables, types, functions,
etc.
i realize that, coach. i'm wondering if any devious minds
out there are using it for something clever and
I have a table with an inet column, which I entered in order initially,
so they came out like:
1.2.3.4
1.2.3.5
1.2.3.40
1.2.3.41
After updating, say, 1.2.3.5, it moves to the end. I understand why,
that's not the problem. Adding an 'ORDER BY host(ip)' clause causes the
ordering to be:
I believe this is fixed in 7.1.
LER
Original Message
On 3/20/01, 11:16:42 AM, Daniel "J." Kressin [EMAIL PROTECTED]
wrote regarding [GENERAL] sorting on inet type?:
I have a table with an inet column, which I entered in order initially,
so they came out like:
1.2.3.4
1.2.3.5
I'm new to the list and recently saw an interesting thread in one of the
mailing list archives. Sorry to say I don't have a solution to the 6M
row/table + 100k inserts/day issue that the "critical mass reached" thread
discussed.
However, it did raise some questions in my mind perhaps some of
On Tue, Mar 20, 2001 at 08:26:58AM -0800, Roderick A. Anderson wrote:
On Mon, 19 Mar 2001, will trillich wrote:
i'm wondering if any devious minds out there are using it for
something clever and useful, instead of doing the
roll-your-own table cross-lookups that i've been hobbling
Larry Rosenman wrote:
I believe this is fixed in 7.1.
LER
Is there a workaround for 7.0.x? Short of adding extra columns to store
the separate octets and sorting on them?
--
Dan
Kressin .---.
/___ \/ __ \ | Unix SysAdmin
"Daniel J. Kressin" [EMAIL PROTECTED] writes:
Adding an 'ORDER BY host(ip)' clause causes the
ordering to be:
1.2.3.4
1.2.3.40
1.2.3.41
1.2.3.5
host(ip) produces a text result, so the above sort is according to
string-comparison rules. If you want a numeric sort why don't
you
"Daniel J. Kressin" [EMAIL PROTECTED] writes:
Tom Lane wrote:
host(ip) produces a text result, so the above sort is according to
string-comparison rules. If you want a numeric sort why don't
you just "ORDER BY ip"?
"ORDER BY ip" didn't work. I'm assuming this is the broken behaviour
that
I want to switch from MSAccess to Postgres.
1. I have memo fields that include new line characters (I don't know whether
it is actually a CR). How can this be exported to Postgres?
2. How do I query for strings that include single or double quotes (e.g.
O'Hara)?
Thank you all.
hello
i am trying to remove a foreign key that i placed on a database. what is
the easiest way to find/delete the constraint?
thanks
chris
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
"Mihai Gheorghiu" wrote:
I want to switch from MSAccess to Postgres.
1. I have memo fields that include new line characters (I don't know whether
it is actually a CR). How can this be exported to Postgres?
Represent a newline by `\n'.
2. How do I query for strings that include single or
On Tue, 20 Mar 2001, chris markiewicz wrote:
hello
i am trying to remove a foreign key that i placed on a database. what is
the easiest way to find/delete the constraint?
The constraint will generate three triggers in pg_trigger. You can find
the correct triggers by looking at the
On Tue, 20 Mar 2001, chris markiewicz wrote:
okay, i screwed up. i dropped some triggers from a table. now that table
is not accessible to me.
can't drop it...can't select...can't pg_dump.
message is error: RelationBuildTriggers: 2 record(s) not found for rel
accessor_group
or a
I had to give a loud "Duh!" after reading your response: that's exactly what
I wanted, thanks!
Now I wonder if there is a way for a trigger that's created on a base table
to be fired on any table that inherits from that base table. Otherwise I'm
still stuck creating triggers for each table that
okay, i screwed up. i dropped some triggers from a table. now that table
is not accessible to me.
can't drop it...can't select...can't pg_dump.
message is error: RelationBuildTriggers: 2 record(s) not found for rel
accessor_group
or a pg_dump results in: getTables(): relation
"chris markiewicz" [EMAIL PROTECTED] writes:
message is error: RelationBuildTriggers: 2 record(s) not found for rel
accessor_group
Set reltriggers to 4 (instead of 6) in the pg_class entry for that
table.
regards, tom lane
---(end of
I'd guess you could use TG_RELID or TG_RELNAME inside your trigger.
On Tue, 20 Mar 2001, Matt Magoffin wrote:
Is there any way to make use of the tableoid either as an argument to the
function or as a reference within the function (in plpgsql)? For example,
I'd like to either
CREATE
All I want to do is dump the db, which should be easy, right? If I do:
pg_dump -u worldwide worldwide.pgdump
my system just hangs and doesn't ever ask for a username or password. if
i remove the -u, it says it can't connect cause no password was
supplied. What am i missing? Thanks,
Joe
On Tue, Mar 20, 2001 at 01:41:22PM -0800, Stephan Szabo wrote:
On Tue, 20 Mar 2001, chris markiewicz wrote:
okay, i screwed up. i dropped some triggers from a table. now that table
is not accessible to me.
can't drop it...can't select...can't pg_dump.
message is error:
Shouldn't we have a "Migrating to PostgreSQL" section in the FAQ here:
http://www.postgresql.org/docs/faq-english.html ?
I remember learning this the hard way - from MS Access to PostgreSQL :(
I do have something:
ftp://candle.pha.pa.us/pub/postgresql/comparison.mbox
Seems this is
All I want to do is dump the db, which should be easy, right? If I do:
pg_dump -u worldwide worldwide.pgdump
pg_dump, with the -u, expects you to enter your username/password to
stdin or something. (guys, print the prompts to STDERR instead?) The
problem is that stdout is redirected into
ok, makes sense, so how would I get around it? Thanks,
Joe
John Madden wrote:
All I want to do is dump the db, which should be easy, right? If I do:
pg_dump -u worldwide worldwide.pgdump
pg_dump, with the -u, expects you to enter your username/password to
stdin or something. (guys,
Hi!
When will be the final release out version 7.1. Now it's at beta6.
Maybe any dates or something.
--
uros mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Tue, 20 Mar 2001, Matt Magoffin wrote:
I had to give a loud "Duh!" after reading your response: that's exactly what
I wanted, thanks!
Now I wonder if there is a way for a trigger that's created on a base table
to be fired on any table that inherits from that base table. Otherwise I'm
Is there any way to make use of the tableoid either as an argument to the
function or as a reference within the function (in plpgsql)? For example,
I'd like to either
CREATE TRIGGER set_default_value BEFORE INSERT
ON foo FOR EACH ROW EXECUTE PROCEDURE set_value('tableoid');
and within the
They are hoping put out Release Candidate (RC) 1 in the next few days. We
will see after that, hopefully we will see a final 7.1 soon, but my guess
at this point is not till the first week of April.
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday,
On Tue, Mar 20, 2001 at 02:18:23PM -0800, Stephan Szabo wrote:
The problem is that the syntax
create table SomeTable (
SomeColumn int4 references OtherTable ( SomeColumn ),
. . .
creates an unnamed trigger which you can't drop with drop trigger
because it doesn't have a
ok, makes sense, so how would I get around it? Thanks,
You type in the username/password as if the prompts were there. :)
John
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
I was configuring postmaster to allow more buffers to be used (1250 of them) and
once that change was made, postmaster would no longer allow connections. I have
since removed the option and it still does the same thing. I added -N 33 to it
to see if she would recover to no avail...
any ideas?
32 matches
Mail list logo