Hi,
Looks like alter table does not tells about the indexes it dropped
PG version: 7.4.3
Regds
mallah.
tradein_clients=# \d general.membership_status
Table "general.membership_status"
++---++
| Column
Hi Tom!
Thanx again for your fast help. And its helps indeed. You pointed out the problem
correct! I could
delete these triggers after scanning the system-tables by hand. Unfortunately this can
happen in the
futrue again and thatswhy i tried applying the adddepend script on a fresh restored db
El Vie 02 Jul 2004 18:39, Jan Wieck escribió:
> On 6/22/2004 11:51 PM, mike g wrote:
> > Slony version 1 is supposed to be live very soon. You can test beta3 if
> > you like.
>
> Slony-I version 1.0 is out now. It does not contain incremental backup.
> This feature is on the TODO list for 1.1.
I'
> I wonder to know if it is possible to launch a Perl program or a unix
> comand in a trigger function.
> I have tried to do that in a C trigger developed with the SPI function.
> But my examples does not work and i don't have any error messages in the
> postgres logfile.
> So, i ask you your opini
Tom Lane <[EMAIL PROTECTED]> writes:
> Christopher Cashell <[EMAIL PROTECTED]> writes:
> > 28424 postgres 18 0 16804 3044 15m D 0.0 1.6 0:06.72 postmaster
>
> > Note that it does have a process status of 'D', or uninterruptible
> > sleep. That would explain the unkillable part, though I'
Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes:
> Looks like alter table does not tells about the indexes it dropped
This is intentional --- we don't require you to say CASCADE to get rid
of an index, either. I don't recall the exact reasoning anymore, but
if you consult the mailing list archive
Please CC me.
When I connect to a database from PHP script called from the web via Apache, running on the same
machine as the DB, that's server name "localhost", right?
I can't seem to get a php script to connect with the same parameters that I can use
using telnet and 'psql'.
--
On Sat, 2004-07-03 at 11:53, Dennis Gearon wrote:
> Please CC me.
>
> When I connect to a database from PHP script called from the web via Apache, running
> on the same machine as the DB, that's server name "localhost", right?
>
> I can't seem to get a php script to connect with the same paramet
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password 'password'
I CANNOT connect using 'psql', I get authentication error.
-
ANYONE have any ideas why?
---
I now have tried an equal length name, and it logs in fine:
't012345678901_web_user' with pword 'password' works fine.
The problem below is consistent. I can drop and recrate the user, and it always cannot
be logged into using that name. I can successfully alter the user, so the system is
another name that does not work is 'H1q2W3e4R5_web_user'.
It seems to not like many alternations between numbers and letters.
Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_use
tried it with two underscores and short name:
H1q2W_web_user
with only one underscore and a long name:
H1q2W3e4R5t6Y7u8Iweb_user
with only oneunderscore and a short name:
H1q2Wweb_user
with no underscore and a long name:
H1q2W3e4R5t6Y7u8Iwebuser
with no underschore and a short name:
Dennis Gearon wrote:
> another name that does not work is 'H1q2W3e4R5_web_user'.
Sounds like a quoting problem. In the meantime, read this:
http://www.fr.postgresql.org/docs/7.4/static/bug-reporting.html
>
> It seems to not like many alternations between numbers and letters.
>
> Dennis Gearon w
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password 'password'
I CANNOT connect using 'psql', I get authentication erro
On Sat, 3 Jul 2004, Dennis Gearon wrote:
> Please CC me:
>
> If I create the user 'web_user'
> with password 'password'
> I can connect using 'psql' just fine.
>
> If I create the user 'D1Khb2g5m7FGk_web_user'
> with password 'password'
> I CANNOT connect using 'psql', I get authentication error.
On Sat, 3 Jul 2004, Dennis Gearon wrote:
> Stephan Szabo wrote:
> > On Sat, 3 Jul 2004, Dennis Gearon wrote:
> >
> >
> >>Please CC me:
> >>
> >>If I create the user 'web_user'
> >>with password 'password'
> >>I can connect using 'psql' just fine.
> >>
> >>If I create the user 'D1Khb2g5m7FGk_web_
> Briefly, my problem:
> --
> I expect the database I'm working on to reach something in the order of
> 12-16 Gigabytes, and I am interested in understanding as much as I can
> about how I can make this go as fast as possible on a linux system. I
> haven't run such a large database
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Please CC me:
If I create the user 'web_user'
with password 'password'
I can connect using 'psql' just fine.
If I create the user 'D1Khb2g5m7FGk_web_user'
with password 'pas
On Sat, 3 Jul 2004, Dennis Gearon wrote:
> Stephan Szabo wrote:
>
> > IIRC, psql (and the createuser shell script and such) treat it as if you
> > had double quoted its argument because of the way shells handle quotes
> > which would necessitate something like '"FOO"' to use a quoted uppercase
>
Stephan Szabo wrote:
On Sat, 3 Jul 2004, Dennis Gearon wrote:
Stephan Szabo wrote:
IIRC, psql (and the createuser shell script and such) treat it as if you
had double quoted its argument because of the way shells handle quotes
which would necessitate something like '"FOO"' to use a quoted upperca
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Martin Marques) belched
out:
> El Vie 02 Jul 2004 18:39, Jan Wieck escribió:
>> On 6/22/2004 11:51 PM, mike g wrote:
>> > Slony version 1 is supposed to be live very soon. You can test beta3 if
>> > you like.
>>
>> Slony-I version 1.0 i
21 matches
Mail list logo
