> 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]
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 trigger which you can't drop with drop trigger
> > because it doesn
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,
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 functi
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
> The problem is that the syntax
>
> create table SomeTable (
> SomeColumnint4 references OtherTable ( SomeColumn ),
> . . .
>
> creates an trigger which you can't drop with drop trigger
> because it doesn't have a name. What you suggest does work for me, i.e.
> deleting from pg_
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
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.
> 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
> 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
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 er
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
--
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
"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 broadca
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 'accessor_group'
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 I
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
>
>
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 tr
"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
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?
http://www.postgresql.org/users-loung
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.
--
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?
C
"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 behavi
"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
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
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
>
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 th
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 c
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:
--- Matthew <[EMAIL PROTECTED]> wrote:
> 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?
You can only compile psql.exe and libpq.dll with VC++. You
cannot build the postgresql se
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
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 PROTE
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.
>
>Whe
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
34 matches
Mail list logo
