Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> What kind of expression is allowed as the predicate now ?
Anything that doesn't involve an aggregate or a subselect.
(But what the planner can recognize as matching a query's
WHERE clause is currently much more restricted, just ANDs
and ORs of simple V
At 09:00 PM 7/16/01 -0400, Laurent Mesuré wrote:
>Actually it does that, but it start without the -i option and thus, i
>can't connect via TCP/IP
>
>What do i have to modify so the pg_ctl can start the postmaster with
>this option at boot?
I think the easiest way is to edit your postgresql.conf
Hello,
I am trying to get my head around a complex problem I've been tasked
with...
We have a set of servers spread throughout the country (100s to 1000s of
them) and I need to build a patch-distributing postgresql database. The
actual patches would be distributed via rpm's which we'd like to
hi,
i'd like to start at boot the postmaster.
Actually it does that, but it start without the -i option and thus, i
can't connect via TCP/IP
What do i have to modify so the pg_ctl can start the postmaster with
this option at boot?
--
Laurent Mesuré
France
---(end of br
On 16 Jul 2001, Tony Grant wrote:
> Hello,
>
> I have several hundred HTML (!) pages that need to be converted to a
> format that in turn can be imported into PostgreSQL. They are all built
> on a very similar grid.
>
> Any thoughts?
I've written code to store ASCII text in pg Oids. I also have
Thanks to all for the input.
Because of the limits of my knowledge of perl, C etc...
I'll do a batch job from BBEdit. I have found a Tidy plugin for BBEdit,
installed the latest version of BBEdit Lite and the HTML tools. All I
need now is to write up the description for the XML output.
While it
Tony Grant wrote:
>
> These are film and director pages in a movie site. I am looking at
> HTML->XML tools then with a parser I should be able to create a tab
> delimited text file.
I'm successfully storing scripts in tables which are pulled and executed
on a client system, works well so far exc
Radha <[EMAIL PROTECTED]> writes:
> I see something like 'Description' when i want to see the list of
> tables/fields in the table using '\d'. Have anyone used this
> 'Description'?
See
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/sql-comment.html
regards,
On Mon, 16 Jul 2001, Radha wrote:
>
>
> Hi,
>
> I need to store some comments/definition for every field in a
> table. Is there a way to give comment for the columns while creating the
> table itself or after that?
>
> I see something like 'Description' when i want to see the list of
> t
On 16 Jul 2001, Tony Grant wrote:
> Hello,
>
> I have several hundred HTML (!) pages that need to be converted to a
> format that in turn can be imported into PostgreSQL. They are all built
> on a very similar grid.
>
> Any thoughts?
For the integrated docs I wrote a C program (I suck at perl) a
I don't recal finding anything similar to MySQL's password() (quote handy if you ask
me). But if you look under the contrib directory of your source tree you'll find a
pgcrypto directory. Compile and install the functions defined in there.
The substitute which worked in my case was:
encode(dige
On Mon, 16 Jul 2001, Bryan Buchanan wrote:
> Hi,
>
> Would anyone know if it's possible to define a rule to do the folowing.
Why use a rule and not a trigger?
> I have two tables:
>
> journal_master (serial #, account, date, debit $, credit $)
> journal_summary (account, date, debit $, credi
I'd like to get the difference between two
timestamp columns expressed as an interval with units "year to month." I
believe the standard way to express this is as:
(timestamp1 - timestamp2) year to
month
But this gives me a syntax error at "year". I
also can't find a way to cast thi
I'm successfully storing
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or
colleagues]
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister com
"Vilson farias" <[EMAIL PROTECTED]> writes:
> The problem is realted with "1 | serv_acaoserv | 154406" tuple, wich
> takes 5-10 secs to be updated, whether it's called from this stored
> procedure or from a simple UPDATE clause. All other tuples goes fine,
> update time is about 10-30ms.
Have you
I dumped a 7.0 db on a RedHat box, createdb'd the db on a new debian box
sporting 7.1, ftp'd the dumped file and restored. Everything seemed to
go fine, except the names of the db and the tables are numeric
expressions instead of the actual table names. For instance, a db named
mydb containing tab
Hello,
I have several hundred HTML (!) pages that need to be converted to a
format that in turn can be imported into PostgreSQL. They are all built
on a very similar grid.
Any thoughts?
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedi
Greetings,
I have a table with only three tuples. I've been using it as primary key container
for tables, like the Sequence from postgresql. I'm not using sequences because my
application was originally created for MSSQL 6.5.
My problem is very specific, I have a stored procedure for p
On Sun, 15 Jul 2001, Randall Perry wrote:
> Any plans to work on a Mac version of PgSQL ODBC driver?
I don't know anything about mac (besides the lastest os being based on
FreeBSD 3.2), but you're using the latest version can't you use iODBC?
Also http://www.unixodbc.org has one that may work on
19 matches
Mail list logo
