[HACKERS] http link to ftp download area broken

2001-10-15 Thread Zeugswetter Andreas SB SD
The http link to the snapshots no longer works on www.ca.postgresql.org/ftpsite. If you could correct that I would greatly appreciate it :-) Also this link only works on some of the mirror sites, it would be great if all of them would have it (Germany works, Austria does not). I think a

[HACKERS] Snaptshot appears fine to me ...

2001-10-15 Thread Marc G. Fournier
Right now, from what I can tell, the snapshot looks great to me: postgresql# ls -lt total 486 drwxrwxrwx 15 pgsql pgsql 512 Oct 15 04:04 src drwxrwxrwx 43 pgsql pgsql1024 Oct 15 04:04 contrib drwxrwxrwx 4 pgsql pgsql 512 Oct 15 04:04 doc drwxrwxrwx 2 pgsql pgsql 512

Re: [HACKERS] Problem in pg_dump 7.1.2 dump order

2001-10-15 Thread Joel Burton
On Wed, 10 Oct 2001, Dmitry Chernikov wrote: Hello, In dump file statement which grants permissions on view exists before statement which create view. For tables and sequences permissions dumped in correct order. --TOC Entry ID 124 (OID 150248) GRANT ALL on my_view to group sales; ...

Re: [HACKERS] Deadlock? idle in transaction

2001-10-15 Thread Michael Meskes
On Thu, Oct 11, 2001 at 03:15:36PM -0700, Rachit Siamwalla wrote: then gets stuck on a table that the transaction has modified. Now most of your other transactions will block forever. Then the connection limit for postgres will be hit. Then you can't connect to postgres at all. Really? I do

Re: [HACKERS] ecpg - GRANT bug

2001-10-15 Thread Lee Kindness
Tom Lane writes: Lee Kindness [EMAIL PROTECTED] writes: The existing code in ecpg/preproc/preproc.y to handle the WITH option simply throws an error and aborts the processing... The patch below prevents the segfault and also passes on the WITH option to the backend, probably a

Re: [HACKERS] New contrib/tsearch module for 7.2

2001-10-15 Thread Tom Lane
Teodor Sigaev [EMAIL PROTECTED] writes: I can't see tsearch in contrib directory (in contrib/README tsearch exists) in current cvs. :( It's there: I see it, and so does cvsweb. Did you use -d option in cvs update? Personally I run with a ~/.cvsrc containing cvs -z3 update -d -P checkout -P

[HACKERS] Ready for Beta?

2001-10-15 Thread Bruce Momjian
Are we ready to start beta on 7.2? -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026

Re: [HACKERS] Package support for Postgres

2001-10-15 Thread Bill Studenmund
On Sat, 13 Oct 2001, Jean-Michel POURE wrote: What do folks think? Take care, Bill Hello Bill, The community have been waiting for packages for a long time. I don't believe you did it!!! IMHO most applications do not fully benefit from the power of PostgreSQL because transactions are

Re: [HACKERS] Snaptshot appears fine to me ...

2001-10-15 Thread Marc G. Fournier
On Mon, 15 Oct 2001, Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: try ftp2.us.postgresql.org ... Ah, that one looks much better, except for one stray file: postgresql-snapshot/config/#cvs.cvsup-64286.15 this is what is holding up beta right now, we have to get

Re: [HACKERS] schema support, was Package support for Postgres

2001-10-15 Thread Bill Studenmund
On Mon, 15 Oct 2001, Tom Lane wrote: Bill Studenmund [EMAIL PROTECTED] writes: For the most part, I think packages and schemas are orthogonal. I'm taking a cue from Oracle here. Oracle considers packages to be a schema-specific object. Nonetheless, it's not clear to me that we need two

Re: [HACKERS] Snaptshot appears fine to me ...

2001-10-15 Thread Tom Lane
Marc G. Fournier [EMAIL PROTECTED] writes: try ftp2.us.postgresql.org ... Ah, that one looks much better, except for one stray file: postgresql-snapshot/config/#cvs.cvsup-64286.15 this is what is holding up beta right now, we have to get the mirrors fixed, which Vince is working on

Re: [HACKERS] schema support, was Package support for Postgres

2001-10-15 Thread Bill Studenmund
On Mon, 15 Oct 2001, Tom Lane wrote: Bill Studenmund [EMAIL PROTECTED] writes: For the most part, I think packages and schemas are orthogonal. I'm taking a cue from Oracle here. Oracle considers packages to be a schema-specific object. Nonetheless, it's not clear to me that we need two

Re: [HACKERS] schema support, was Package support for Postgres

2001-10-15 Thread Tom Lane
Bill Studenmund [EMAIL PROTECTED] writes: For the most part, I think packages and schemas are orthogonal. I'm taking a cue from Oracle here. Oracle considers packages to be a schema-specific object. Nonetheless, it's not clear to me that we need two independent concepts. Given a name search

Re: [HACKERS] Snaptshot appears fine to me ...

2001-10-15 Thread Marc G. Fournier
try ftp2.us.postgresql.org ... this is what is holding up beta right now, we have to get the mirrors fixed, which Vince is working on ... ftp2.us.postgresql.org is the only 'operational' mirror we have right now, but, since Vince isn't ready yet, we haven't broken the others yet ... once Vince

Re: [HACKERS] New contrib/tsearch module for 7.2

2001-10-15 Thread Teodor Sigaev
Committed into contrib. I made an addition of a cast to unsigned char in the tolower() calls that didn't already have one. Without this, the regression test didn't pass. With it, it still didn't pass :-( ... but I believe your original expected file was incorrect because of the lack of

[HACKERS] ecpg - GRANT bug

2001-10-15 Thread Lee Kindness
Tom Lane writes: Uh, isn't the correct fix ! $$ = cat_str(8, make_str(grant), $2, make_str(on), $4, $5, make_str(to), $7, $8); ISTM your patch loses the opt_with_grant clause. (Of course the backend doesn't currently accept that clause anyway, but that's no reason for ecpg to drop

Re: [HACKERS] New contrib/tsearch module for 7.2

2001-10-15 Thread Teodor Sigaev
It's my mistake, the problem is with locale, I'll send patch as soon as, but I can't see tsearch in contrib directory (in contrib/README tsearch exists) in current cvs. :( Ok now, I got. Please apply attached patch for contrib/tsearch. -- Teodor Sigaev [EMAIL PROTECTED]

[HACKERS] java

2001-10-15 Thread None
Hello Easy question - does Postgres support Java stored procedures ? Chris Posted Via Usenet.com Premium Usenet Newsgroup Services -- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **

Re: [HACKERS] java

2001-10-15 Thread Bruce Momjian
Hello Easy question - does Postgres support Java stored procedures ? No, only PL/pgSQL, Perl, TCL, and Python. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe

[HACKERS] Snapshot not using current CVS

2001-10-15 Thread Bruce Momjian
I can confirm that the nightly snapshots are still not pulling from current CVS. The TODO file in the snapshot of October 14th shows a Last Updated of September 13th. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 +

Re: [HACKERS] New contrib/tsearch module for 7.2

2001-10-15 Thread Tom Lane
Teodor Sigaev [EMAIL PROTECTED] writes: Please apply attached patch for contrib/tsearch. I've applied the regression-test changes. I won't apply the Makefile change. I took out those rules for a reason, which is that they cause the module to fail to build entirely if one uses a non-gcc

Re: [HACKERS] ecpg - GRANT bug

2001-10-15 Thread Bruce Momjian
Patch applied. Thanks. --- Tom Lane writes: Uh, isn't the correct fix ! $$ = cat_str(8, make_str(grant), $2, make_str(on), $4, $5, make_str(to), $7, $8); ISTM your patch loses the opt_with_grant clause. (Of

Re: [HACKERS] ecpg - GRANT bug

2001-10-15 Thread Bruce Momjian
In which case a number of other cases should be weeded out of parser.y and passed onto the backend: CREATE TABLE:GLOBAL TEMPORARY option. CREATE FUNCTION: IN/OUT/INOUT options (note there's a bug in parser.y there anyway, it would pass on 'oinut' for INOUT).