Rajesh Kumar Mallah wrote:
> Tom Lane wrote:
>
> >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.
On Tue, 6 Jul 2004, Chris Smith wrote:
> Thanks for your reply. Here is the output of "explain analyze". I also
> replaced by simple values with a real query that gets run and (according to
> our profiling) takes a long time. However, the query is now taking a much
> shorter period of time tha
Hi Mike:
Thanks for your answer, I'm unable to dump the table:
-bash-2.05b$ pg_dump -Fc -t afected_table database_name -f
./afected_table.dump
pg_dump: connection not open
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "afected_ta
On 7/3/2004 9:11 AM, Martin Marques wrote:
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 i
Title: RE: [GENERAL] Formatting Function..
You could always use SUBSTR(Name,x,y) AS xxx to control the size of the output and the heading.
Duane
-Original Message-
From: Vinay Jain [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 04, 2004 10:20 PM
To: [EMAIL PROTECTED]
Subject: [GENER
Alvaro Herrera <[EMAIL PROTECTED]> wrote:
>
> On Tue, Jul 06, 2004 at 08:32:15AM -0400, Jim Seymour wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> > > Should I add an FAQ discussing hardware selection and the importance of
> > > reliable hardware?
> >
> > Scary to think that people w
Alvaro Herrera wrote:
> On Tue, Jul 06, 2004 at 08:32:15AM -0400, Jim Seymour wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> > > Should I add an FAQ discussing hardware selection and the importance of
> > > reliable hardware?
> >
> > Scary to think that people who don't know enough ab
>
> SELECT
> SUBSTRING(description FROM '(.*), \\d{1,3},') AS vname,
> SUBSTRING(description FROM '.*, (\\d{1,3}),') AS age,
> SUBSTRING(description FROM '\\d{1,3}, of (.*?),? was charged') AS
> address, SUBSTRING(description FROM ' was charged ([^ ]+)') AS dow,
> SUBSTRING(description FRO
Stephan,
Thanks for your reply. Here is the output of "explain analyze". I also
replaced by simple values with a real query that gets run and (according to
our profiling) takes a long time. However, the query is now taking a much
shorter period of time than it was profiled at by the application
Dear all,
I have a trouble with the pam authentification for PostgreSQL.
I have add in the pg_hba.conf the good line ... and I have create
a /etc/pam.d/postresql file which contains :
authrequiredpam_unix.so nullok_secure
account requiredpam_unix.so
Now like this ... imposs
On Tue, Jul 06, 2004 at 08:32:15AM -0400, Jim Seymour wrote:
> Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > Should I add an FAQ discussing hardware selection and the importance of
> > reliable hardware?
>
> Scary to think that people who don't know enough about running a proper
> server, and thu
Alberto Cabello Sanchez <[EMAIL PROTECTED]> writes:
> I can GRANT or REVOKE privileges (SELECT, INSERT and so on) on my_view
> and my_table, but insert into my_view is always allowed, even for users
> that haven't SELECT or INSERT privileges neither on my_table or my_view.
I think there was a bug
> -Ursprüngliche Nachricht-
> Von: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] Im Auftrag von Kris Jurka
> Gesendet: Dienstag, 6. Juli 2004 13:11
> An: Markus Wollny
> Cc: [EMAIL PROTECTED]
> Betreff: Re: [GENERAL] ./configure --with-java fails
> Your setup looks good, perhaps changing
=?iso-8859-1?q?Clodoaldo=20Pinto=20Neto?= <[EMAIL PROTECTED]> writes:
> The postgresql was installed by anaconda installer
> during the box setup.
Perhaps you forgot to include the postgresql-pl package? IIRC that
is where most of the plXXX.so files are distributed.
regar
"Najib Abi Fadel" <[EMAIL PROTECTED]> writes:
>> You didn't answer the question though: what timezone are you using?
> Asia/Beirut
Okay, with that I can reproduce it. That zone is one of the ones where
the DST transitions occur just at midnight. So there really isn't any
"midnight local time" o
Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> pgman wrote:
> > Jim Seymour wrote:
[snip]
> > >
> > > My position is that your data is only as reliable as your hardware,
> > > period.
[snip]
> >
> > There is a basic misconception that all PC hardware is created equal ---
> > that hard drives, m
On Tue, 6 Jul 2004, Markus Wollny wrote:
> I am trying to build PostgreSQL 7.4.3 with Java enabled; I've got Apache
> Ant version 1.5 and j2sdk1.4.1_05 installed:
>
> [javac] Modern compiler not found - looking for classic compiler
>
> BUILD FAILED
> file:/usr/src/postgresql/postgresql-7
In article <[EMAIL PROTECTED]>,
<[EMAIL PROTECTED]> writes:
> I can't seem to get right the regular expression for parsing data like
> these four sample rows (names and addresses changed to ficticious values)
> from a text-type column:
> Yolanda Harris, 38, of 40 South Main St., Newtown City, was
Hi!
I am trying to build
PostgreSQL 7.4.3 with Java enabled; I've got Apache Ant version 1.5 and j2sdk1.4.1_05
installed:
Verifiying
ant:
# which javac/usr/java/j2sdk1.4.1_05/bin/javac# ant
-versionApache Ant version 1.5 compiled on October 15
2002
Verifying
java-compiler:
# which
ja
> You didn't answer the question though: what timezone are you using?
Asia/Beirut
> If "SHOW timezone" produces something specific, that is the answer.
> If it says "unknown" then what you will need to do is work out
Show timezone says "unknown"
> which of the files under /usr/share/zoneinfo is an
I forgot to mention that in fact i will have an
ordered table of dates ( i mean by ordered i will do an order by before applying
the aggregate) for different users.
That's why i need an aggregate ( i have to do a
group by)
so i have something like this
01/01/2004 user1
08/01/2004
The postgresql was installed by anaconda installer
during the box setup.
Tried to install to template1 as postgres with no
success:
bash-2.05b$ createlang plpythonu template1
createlang: instalação da linguagem falhou: ERROR:
could not access file "$libdir/plpython": No such file
or directory
>
Hi all,
I am trying to mimic a table's behaviour on a view thru rules. More
precisely, I have a table (say, my_table(field1,field2)) and a view
(my_view as select my_field from my_table). For allowing inserts into
the view, I have create a rule on "insert into my_view" doing instead
insert into my
23 matches
Mail list logo
