Using PostgreSQL 8.1.8 on Windows.
I have one named listedi in schema cust; that view has one column name
No I used
comment on cust.listedi.name is 'MyDescriptive Name';
and the command suceeded. Using \d+ in psql also shows me that comment (also
I find no option within pgadmin to view it :) )
On Tue, Aug 07, 2007 at 07:46:45AM -0400, Geoffrey wrote:
I don't know all the idiosyncrasies of how this works, so bear with me
on this. The developer at the vendor indicated that he's narrowed down
the problem to a set of wrapper routines in their code. They are named
OpenFile(),
Harald Armin Massa wrote:
Using PostgreSQL 8.1.8 on Windows.
I have one named listedi in schema cust; that view has one column name
No I used
comment on cust.listedi.name http://cust.listedi.name is
'MyDescriptive Name';
and the command suceeded. Using \d+ in psql also shows me that
Thanks, Dave.
reminds me to run allways newest pgadmin, even on customer sites :)
having it used within pgadmin makes it legal enough for me to rely on it
within my application
Best wishes,
Harald
You can in 1.8 - that will show a collection of columns under a view,
and allow you to
qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6742d=20070808
Hello,
One more way to do it with mouse clicking only is OpenOffice. Get OO
and install PostgreSQL driver into OpenOffice Database application,
then you'll be able to import/export spreadsheets to and from database
tables and work with DB tables just like they are spreadsheets.
Regards,
Ivan
prodotti ufficiali della Nazionale Italiana FIDAL. Vestiti di azzurro
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6907d=20070808
On Wed, Aug 08, 2007 at 01:03:54PM +0200, [EMAIL PROTECTED] wrote:
Hi.
Anybody know if is possible to install PostgreSQL in cluster mode on a
cluster formed by two windows server 2003 cluster?
Yes. Set it up as a generic service, and make sure you store the data
directory (and any other
Hello
everybody,
Im working with a small project to a client, using Postgres to store
data in a dimensional model, fact-oriented, e.g., a Datamart.
At this time, all I have is a populated database, with the "star
schemma" common relations (PKs / FKs).
Below is a list of the main goals of
I found an excellent description of how to implement a fifo que in
PostgreSQL at Greg Mullane's blog:
http://people.planetpostgresql.org/greg/index.php?/archives/89-Implementing-a-queue-in-SQL-Postgres-version.html
I have used the 'rule' approach to implement a queue that generates a
On Tue, Aug 07, 2007 at 08:15:19PM +0100, Gregory Stark wrote:
novnov [EMAIL PROTECTED] writes:
Is there any plan to add such a capability to postgres?
It's been talked about. I wouldn't be surprised to see it in 8.4 but nobody's
said they'll be doing it yet and there are a lot of other
Martijn van Oosterhout wrote:
On Tue, Aug 07, 2007 at 07:46:45AM -0400, Geoffrey wrote:
I don't know all the idiosyncrasies of how this works, so bear with me
on this. The developer at the vendor indicated that he's narrowed down
the problem to a set of wrapper routines in their code. They
Hello,
five years ago I used
CREATE OR REPLACE FUNCTION list_user_tables_sort_depend
(owner VARCHAR, revers BOOLEAN) RETURNS SETOF VARCHAR AS '
DECLARE tabulky VARCHAR[]; i INTEGER; opakovat BOOLEAN = ''t'';
pom VARCHAR; exportovano VARCHAR[] = ''{}''; r RECORD;
mohu_exportovat BOOLEAN;
Leif B. Kristensen wrote:
CREATE RULE placelimit AS
ON INSERT TO recent_places DO ALSO
DELETE FROM recent_places
WHERE
-- this clause doesn't work
-- (place_fk = NEW.place_fk AND id NEW.id) OR
id NOT IN (SELECT id FROM recent_places ORDER BY id DESC LIMIT 10);
On Wednesday 8. August 2007 15:12, Alban Hertroys wrote:
Leif B. Kristensen wrote:
CREATE RULE placelimit AS
ON INSERT TO recent_places DO ALSO
DELETE FROM recent_places
WHERE
-- this clause doesn't work
-- (place_fk = NEW.place_fk AND id NEW.id) OR
id NOT IN
Francisco Reyes writes:
ERROR: operator does not exist: text || tsvector
Also, it'd be worth to show simplified version of your function, which
demonstrates your problem.
I did include that.
The function looks like:
AS $$
DECLARE
v_sql TEXT;
BEGIN
v_sql := 'INSERT INTO
Can anyone provide a brief overview of how to go about interpreting
the information generated by the statistics collector? I've looked
around and can't find old mailing list messages or anything in the
manual beyond the basics of how to query the statistics.
Cache hit rates are easy to
Hi,
I my system, I am using postgres triggers to launch some unix tools and thus
postgres not only serves the purpose of data storage but also works as an
engine to automate the whole system. (this is about my system, talking on a
broader level )
I just wanted to know if there's any related work
On Tue, 2007-08-07 at 17:46 -0500, Decibel! wrote:
On Sun, Aug 05, 2007 at 08:18:08PM +0530, Merlin Moncure wrote:
On 8/3/07, Guy Fraser [EMAIL PROTECTED] wrote:
On Wed, 2007-08-01 at 07:14 +0530, Merlin Moncure wrote:
On 8/1/07, Decibel! [EMAIL PROTECTED] wrote:
David Fetter and I
On 8/7/07, Owen Hartnett [EMAIL PROTECTED] wrote:
At 2:15 PM -0700 8/7/07, Ben wrote:
How many users do you have? Have you considered giving each user a
schema in which to make their changes? It sounds like you don't
really have a multi-master replication issue, which makes things
easier.
On 8/8/07, Martijn van Oosterhout [EMAIL PROTECTED] wrote:
On Tue, Aug 07, 2007 at 08:15:19PM +0100, Gregory Stark wrote:
novnov [EMAIL PROTECTED] writes:
Is there any plan to add such a capability to postgres?
It's been talked about. I wouldn't be surprised to see it in 8.4 but
Hello,
On 8/8/07, Roberto Mello [EMAIL PROTECTED] wrote:
On 8/8/07, Ivan Zolotukhin [EMAIL PROTECTED] wrote:
Hello,
One more way to do it with mouse clicking only is OpenOffice. Get OO
and install PostgreSQL driver into OpenOffice Database application,
then you'll be able to
://www.email.it/f
Sponsor:
Non perderti nella giungla di facili promesse, Logos ti da credito sempre!
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6559d=20070808
---(end of broadcast)---
TIP 5: don't forget to increase your free space map
If I have a DB called foo
...and...
I want to run select name from table_a where name like 'john%'
...and...
I want no table header NAME in the output
...and...
I want to do this as a one-liner from the linux command line
...and...
I don't want to have to deal with intermediate files or
On Wed, 8 Aug 2007, Francisco Reyes wrote:
Francisco Reyes writes:
ERROR: operator does not exist: text || tsvector
what'd you expect from this operation ? In 8.2 you can cast tsvector
to text like this:
=# select textin( tsvector_out( strip( to_tsvector('1 b c'::text || 'some
See:
http://www.postgresql.org/docs/8.2/interactive/app-psql.html
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gauthier, Dave
Sent: Wednesday, August 08, 2007 11:14 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Running a query from
On Aug 8, 2007, at 13:13 , Gauthier, Dave wrote:
If I have a DB called foo
psql --dbname foo
...and...
I want to run select name from table_a where name like 'john%'
psql --dbname foo -c select name from table_a where name like 'john
%'
...and...
I want no table header NAME in
On Aug 8, 2007, at 11:13 AM, Gauthier, Dave wrote:
If I have a DB called “foo”
...and...
I want to run “select name from table_a where name like ‘john%’”
...and...
I want no table header “NAME” in the output
...and...
I want to do this as a one-liner from the linux command line
Yes, that works.
The actual sql executes a stored function that returns a set of records.
Output to the CLI looks great !!!
Thanks to all !!!
-dave
-Original Message-
From: Michael Glaesemann [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 08, 2007 2:43 PM
To: Gauthier, Dave
Cc:
Does anyone know where I can request an OR-version of plainto_tsquery()?
I don't understand why it doesn't exist already: In most cases, when
using user entered keywords to search for, there should be returned some
rows even though not ALL keywords are matched.
Hello List,
Is there a way that I can only dump all objects under a specific schema?
I'd like to dump all tables, views' definition and data under a specific
schema.
Thank you!
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I have a trigger function that updates a field in the update/insert table
which uses a not so simple sql statement to find the value to update with. I
am not getting the results I expect. I expect I'm falling into some classic
trigger gotcha.
The table being updated is for 'bids'; 'bids has a
Hi;
Hello List,
Is there a way that I can only dump all objects under a specific
schema?
I'd like to dump all tables, views' definition and data under a
specific schema.
pg_dump --help says that you're looking for the -n flag, so,
pg_dump -n your_schema -f output.sql
Hope that helps,
On Aug 8, 2007, at 14:18 , Emi Lu wrote:
Is there a way that I can only dump all objects under a specific
schema?
Have you checked the pg_dump documentation?
http://www.postgresql.org/docs/8.2/interactive/app-pgdump.html
In particular, the -n flag might interest you.
Michael Glaesemann
://adv.email.it/cgi-bin/foclick.cgi?mid=6559d=20070808
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
On Aug 8, 3:20 pm, [EMAIL PROTECTED] (novnov) wrote:
... I also don't understand ...
DDL + sample data, please...
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On Tue, Aug 07, 2007 at 06:50:14PM +0530, Rajaram J wrote:
Hi
I'm having trouble building 64-bit pgsql 7.4.17 on the latest release of
HP-UX 11.23 on ia64.
I don't believe that's supported. There was just discussion about this,
but I can't find it in the archive right now...
--
Decibel!,
On Tue, Aug 07, 2007 at 02:28:20PM -0500, Tony Caduto wrote:
Gregory Stark wrote:
novnov [EMAIL PROTECTED] writes:
Is there any plan to add such a capability to postgres?
It's been talked about. I wouldn't be surprised to see it in 8.4 but
nobody's
said they'll be doing it
On Wed, Aug 08, 2007 at 08:56:47AM -0300, Andr? Volpato wrote:
Hello everybody,
I?m working with a small project to a client, using Postgres to
store data in a dimensional model, fact-oriented, e.g., a Datamart.
At this time, all I have is a populated database, with the star
schemma common
On Wed, Aug 08, 2007 at 11:01:13AM -0400, Steve Madsen wrote:
Can anyone provide a brief overview of how to go about interpreting
the information generated by the statistics collector? I've looked
around and can't find old mailing list messages or anything in the
manual beyond the
On Wed, Aug 08, 2007 at 11:48:28AM -0400, Jasbinder Singh Bali wrote:
Hi,
I my system, I am using postgres triggers to launch some unix tools and thus
postgres not only serves the purpose of data storage but also works as an
engine to automate the whole system. (this is about my system,
Why don't you use latest version of postgresql?
On 8/8/07, Decibel! [EMAIL PROTECTED] wrote:
On Tue, Aug 07, 2007 at 06:50:14PM +0530, Rajaram J wrote:
Hi
I'm having trouble building 64-bit pgsql 7.4.17 on the latest release of
HP-UX 11.23 on ia64.
I don't believe that's supported.
I know that would be best but it'd be a major undertaking to try to repro
this situation. I was hoping for some hints, 'it sounds like xyz', because
I'm pretty sure I'm just tripping over a commonplace issue.
Rodrigo De León-2 wrote:
On Aug 8, 3:20 pm, [EMAIL PROTECTED] (novnov) wrote:
...
On Wed, Aug 08, 2007 at 03:20:00PM -0700, novnov wrote:
I know that would be best but it'd be a major undertaking to try to repro
this situation. I was hoping for some hints, 'it sounds like xyz', because
I'm pretty sure I'm just tripping over a commonplace issue.
It doesn't have to be
On Wed, Aug 08, 2007 at 08:50:41AM -0400, Geoffrey wrote:
Correct on both counts. Many of the routines are wrapper routines used
to assist in code portability.
That ok in programs, but shared libraries need to be careful not to use
names likely to be used by programs that use them. FWIW, this
On Wed, Aug 08, 2007 at 11:37:11AM -0500, Scott Marlowe wrote:
If the danger of implementing this is some subtle bug that eats my
data, I'd just as soon do without. It's not a feature I've ever felt
the need for really. And there are lots of cool features I could
think of I'd want before
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Hi All:
I'm building an application along the lines of the questionnaire
design on varlena.com [1], with slight modifications. In my design,
there's a table called chartversionquestion that collects different
questions into a bundle to create the
You can also have a trigger that records into a log table the id table of
each record inserted/updated/deleted, and then it's a simple matter of
merging changes from a certain point forward by searching that table and
using the values of the current records.
--
Scott Ribe
[EMAIL PROTECTED]
On Aug 8, 2007, at 19:23 , David Blewett wrote:
Since the number of questions to be pivoted will vary per
questionnaire the method should accept a number of columns
parameter. The crosstab in the tablefunc contrib module expects the
columns to be explicitly identified before hand. I suppose it
On Wed, 8 Aug 2007, cluster wrote:
Does anyone know where I can request an OR-version of plainto_tsquery()?
plainto_tsquery expects plain text, use to_tsquery for boolean operators.
I don't understand why it doesn't exist already: In most cases, when using
user entered keywords to search
Oleg Bartunov [EMAIL PROTECTED] writes:
On Wed, 8 Aug 2007, cluster wrote:
Does anyone know where I can request an OR-version of plainto_tsquery()?
plainto_tsquery expects plain text, use to_tsquery for boolean operators.
Are either of these definitions really right? If I type foo bar baz
On Thu, 9 Aug 2007, Tom Lane wrote:
Oleg Bartunov [EMAIL PROTECTED] writes:
On Wed, 8 Aug 2007, cluster wrote:
Does anyone know where I can request an OR-version of plainto_tsquery()?
plainto_tsquery expects plain text, use to_tsquery for boolean operators.
Are either of these
52 matches
Mail list logo