does postgres support materialized view.. if yes can somebody post any links which might be useful in learning how to use them...
thx
Himanshu__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
Hello folks,
Problem:
I would need some help with the system I am working on. It is an
information system built on PgSQL 8 and after searching all over the
net I found no function I could use to determine where the request to
the DB (select...) came from. I need it to prevent using fake user ID
n
"Dann Corbit" <[EMAIL PROTECTED]> writes:
> Probably, the important meaningful cases are ones that have small
> exponents (HOPEFULLY less than 25) used in interest calculations.
No, even in interest calculation floating point arithmetic is perfectly fine.
You do your floating point arithmetic to
OpenMacNews <[EMAIL PROTECTED]> writes:
The short answer seems to be "when you update to 10.4, don't forget to
update to Xcode 2 as well".
does it make sense to have configure check for min req'ts of xcode2 if os >=
v10.4?
No, I don't think so. There is such an astonishing variety of ways to
brea
At CONNX, we just do 100 digits using qfloat (about 104 actually).
Internally, all math is done using this type. Then we convert to the
smaller types [or character types] as requested.
I don't think that there is any business need for more than that.
A package like Maple might need to worry abou
OpenMacNews <[EMAIL PROTECTED]> writes:
>> The short answer seems to be "when you update to 10.4, don't forget to
>> update to Xcode 2 as well".
> does it make sense to have configure check for min req'ts of xcode2 if os >=
> v10.4?
No, I don't think so. There is such an astonishing variety of
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (Hrishikesh
Deshmukh) belched out:
> Is there a "bulk loader" in postgresql with which one can read in say
> a tab delimited format text file. Before one does all one has to do is
> create the table with text file column names as attribut
hi tom,
OpenMacNews <[EMAIL PROTECTED]> writes:
reading here, it seems builds on 'virgin' Tiger are behaving themselves ...
The short answer seems to be "when you update to 10.4, don't forget to
update to Xcode 2 as well".
regards, tom lane
does it make sense to have configure check for min req'
OpenMacNews <[EMAIL PROTECTED]> writes:
> reading here, it seems builds on 'virgin' Tiger are behaving themselves ...
The short answer seems to be "when you update to 10.4, don't forget to
update to Xcode 2 as well".
regards, tom lane
---(end of br
hi all,
reading here, it seems builds on 'virgin' Tiger are behaving themselves ...
just fyi & fwiw, a pgsql v803 build on OSX 10.4.1 is also very nicely tolerant
of a /usr/local mod'd system, resulting in:
% otool -L /usr/local/pgsql/bin/postgres
/usr/local/pgsql/bin/postgres:
/usr/lib/libSyste
Guy Rouillier wrote:
Joshua D. Drake wrote:
External storing is useful but I prefer LO because all my data (binary
and meta) is all in the same place for management.
But if that's a big L in LO, performance and maintenance will be
negatively affected, perhaps significantly.
How?
The DBMS will
Berend Tober <[EMAIL PROTECTED]> writes:
> Now what, oh most wise one?
OK, now I finally get the point: you are creating child tables in
different schemas than their parents live in. This creates a problem
because reverse-listing of the constraints varies depending on what
the search path is.
An
CSN wrote:
I'm installing PG8 for Windows and the default locale
is "C" in the installer. What is locale C?
No locale. :)
Sincerely,
Joshua D. Drake
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.ya
Tom Lane wrote:
What do you get from
select conname, consrc from pg_catalog.pg_constraint
where contype = 'c' and conrelid = 'person'::regclass;
conname
|
consrc
-
Berend Tober <[EMAIL PROTECTED]> writes:
> Interesting. The consrc column values differ in that the explicit schema
> qualification on the function calls is missing for the descendent table.
> So, you think maybe if I remove the explicit schema qualification from
> the function calls in the cons
Tom Lane wrote:
What do you get from
select conname, consrc from pg_catalog.pg_constraint
where contype = 'c' and conrelid = 'person'::regclass;
conname | consrc
--
I'm installing PG8 for Windows and the default locale
is "C" in the installer. What is locale C?
CSN
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadc
"Guy Rouillier" <[EMAIL PROTECTED]> writes:
> Joshua D. Drake wrote:
>
>> External storing is useful but I prefer LO because all my data (binary
>> and meta) is all in the same place for management.
>
> But if that's a big L in LO, performance and maintenance will be
> negatively affected, perha
Hrishikesh Deshmukh <[EMAIL PROTECTED]> writes:
> Hi All,
>
> Is there a "bulk loader" in postgresql with which one can read in say
> a tab delimited format text file. Before one does all one has to do is
> create the table with text file column names as attributes, once it is
> on DBMS world it w
Joshua D. Drake wrote:
> External storing is useful but I prefer LO because all my data (binary
> and meta) is all in the same place for management.
But if that's a big L in LO, performance and maintenance will be
negatively affected, perhaps significantly. The DBMS will have to scan
over all t
Hrishikesh Deshmukh wrote:
> Hi All,
>
> Is there a "bulk loader" in postgresql with which one can read in say
> a tab delimited format text file. Before one does all one has to do
> is create the table with text file column names as attributes, once
> it is on DBMS world it will be a simple table
Hi All,
Is there a "bulk loader" in postgresql with which one can read in say
a tab delimited format text file. Before one does all one has to do is
create the table with text file column names as attributes, once it is
on DBMS world it will be a simple table (non-relational)
Thanks,
Hrishi
Probably, the important meaningful cases are ones that have small
exponents (HOPEFULLY less than 25) used in interest calculations.
Million digit numbers are really only interesting in the field of pure
mathematics, since the number of elementary particles in the universe is
well under a googol (1
On Thu, May 19, 2005 at 02:25:58PM -0700, Dann Corbit wrote:
> Hmmm
> I underestimated.
>
> pow(9.9,9.9) =
Yeah, a number with x digits raised to the power with something y digits
long could have a length approximating:
x * (10^y) digits
So two numbers both 4 digits long can
Berend Tober <[EMAIL PROTECTED]> writes:
> I tried a simpler example than my original, as you have, and the problem
> bahavior didn't manifest, but it still happens in my dev copy of my
> production database. The immediately obvious difference between the
> simpler example, like yours, and the a
Hmmm
I underestimated.
pow(9.9,9.9) =
9.998748785736894607828527462269893046126336085
91664915498635306081273911645075964079222720857427
35641018572673827935330501923067157794798212338823
24997145234949798725508071849154834025252682619864
096759311051141601075735428135733340
If you want to create a pow() function for numeric using existing
numeric functions, it [the new function] should be aware of the
precision of the inputs, and the precision of the output should be their
product.
So, if you do pow(numeric(10,5), numeric(10,5)) then the result column
should be numer
Tom Lane wrote:
The case I tested seems to work in 7.3 as well:
CREATE TABLE person (last_name varchar(24),
first_name varchar(24),
CONSTRAINT person_name_check CHECK (((last_name IS NOT NULL) OR
(first_name IS NOT NULL;
CREATE TABLE person_change_history(
action VARCHAR(6),
update_dat
Greg Patnude wrote:
Yeah… this is where the inheritance model gets a little funky… What do
you have “SQL_INEHERITANCE” set to when you dump the database ? I’ve
never tested this so I don’t know if it makes a difference being on or
off when you dump a table…. You might try it and compare the two
On Thu, May 19, 2005 at 10:41:51AM -0700, Dann Corbit wrote:
> We use Moshier's excellent qfloat numbers.
> http://www.moshier.net/qlib.zip
> Documentation:
> http://www.moshier.net/qlibdoc.html
>
> So, if you do the following query using CONNX:
> select convert(pow(9.5,5.9), varchar)
> You will g
I also thought I saw quite a few more warnings this time than in the
past.
-M@
On May 19, 2005, at 11:05 AM, Jerry LeVan wrote:
For what it is worth...
I have 10.4.1 (Tiger) (archived and ) installed on my
old 933MHZ QuickSiver.
I also have Xcode 2.0 installed.
When I compiled 8.0.3 it seemed
Sadly, lots of people in positions of power still want scape goats,
rather than proven results.
No, it could be that the OP's organization is looking for some proof
of postgresql's results.
A lot of people are familiar with the criteria for evaluating
a company or commercial product. Open source p
What they have is for version 7.2 and i want for 7.4.7 only, i have
tried to follow instructions on how to make the pdf/ps version and all
i get is errors. If someone already has a pdf/ps and can email it,
will be a big help.
Thanks,
Hrishi
On 5/19/05, Richard Huxton wrote:
> Hrishikesh Deshmukh
The NOAA National Data Buoy Center is a government customer
(there are many commercial customers) for our wXstation(R)
product, which uses PostgreSQL as its database.
The number of government customers may increase dramatically
in the near future.
--
P. J. "Josh" Rovero
* Mark Steckel ([EMAIL PROTECTED]) wrote:
> So, if you have used Postgres (or know that it has been used) for a
> government project, especially in a 24x7 environment, I would greatly
> appreciate hearing about it. Ideally, I need more than just the project
> name. Specifically, A brief descript
For what it is worth...
I have 10.4.1 (Tiger) (archived and ) installed on my
old 933MHZ QuickSiver.
I also have Xcode 2.0 installed.
When I compiled 8.0.3 it seemed to generated many more
warnings with 4.0 gcc than the older 3.3 gcc. At least
that is my recollection...
I have installed the rascal
We use Moshier's excellent qfloat numbers.
http://www.moshier.net/qlib.zip
Documentation:
http://www.moshier.net/qlibdoc.html
So, if you do the following query using CONNX:
select convert(pow(9.5,5.9), varchar)
You will get:
586906.97548405202106027547827738573075504470845684721318303336760202394
[EMAIL PROTECTED] wrote on 05/19/2005 11:35:07 AM:
> >>> ...We are proposing that Postgres be used for the application
database.
> >>> Not too surprisingly we are being asked for additional
> information because
> >>> Postgres is open source.
> >>>
> > So is the implication that they think open
James Croft wrote:
Hi,
I've seen the session variable question pop up a fair bit on this list.
The temporary table solution seems good but I've got a question before
using it...
Another option is to use one of the procedural languages that provide
global variable storage. The attached examples a
PostgreSQL has a numeric exp() function and a numeric ln() function, so
a numeric pow() function is trivial.
pow(A,z) = exp(z*ln(A))
Probably, it could be made a bit more efficient if specially tuned so as
to not require these functions.
Newton's method (or something of that nature) could obviou
Hi,
I've seen the session variable question pop up a fair bit on this list.
The temporary table solution seems good but I've got a question before
using it...
- My app creates a temp table for session vars
- UPDATE, INSERT and DELETE triggers on tables use this data
My question is:
If I run a qu
Berend Tober <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Hmm, it shouldn't do that ... and in a quick test here I couldn't
>> reproduce any such bug. What version of pg_dump are you using?
> Sorry I failed to specify. Production version is 7.3.1 (change is
> hard!), although I origianally w
On May 19, 2005, at 9:27 AM, Jeff Trout wrote:
On May 18, 2005, at 9:27 PM, Matthew Hixson wrote:
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype
(0) file: -lSystem is not an object file (not allowed in a library)
I had some issues with this error on a few other things on my T
Stephan Szabo wrote:
On Thu, 19 May 2005, James Croft wrote:
Hi all,
I'm trying to create a trigger function for a few tables that will store
old versions of rows prior to any update on them. Part of the function
needs to creates other tables (the table to store these snapshots in).
When this trig
On Thu, 2005-05-19 at 11:35, Philip Hallstrom wrote:
> >>> ...We are proposing that Postgres be used for the application database.
> >>> Not too surprisingly we are being asked for additional information
> >>> because
> >>> Postgres is open source.
> >>>
> > So is the implication that they thin
...We are proposing that Postgres be used for the application database.
Not too surprisingly we are being asked for additional information because
Postgres is open source.
So is the implication that they think open source is a bad thing? I would
think they would question a recommendation for us
On May 18, 2005, at 9:27 PM, Matthew Hixson wrote:
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype
(0) file: -lSystem is not an object file (not allowed in a library)
I had some issues with this error on a few other things on my Tiger box.
After I installed Xcode2 things worked
lister <[EMAIL PROTECTED]> writes:
> This was the topic of 20 minutes of conversation in 2 tutorials
> at BSDCan.
Well, if the BSD people are so concerned about it, why don't they fix
their bleedin' OS? It's inexcusable to have a "jail" feature that
doesn't cover such a major part of Unix as the
Mark Steckel wrote:
I have also scrounged the Internet looking for examples of
Postgres being used in government, preferably in 24x7 capacities.
I find googling for vendors who are known to use PostgreSQL and
searching for people's resumes is a good way to find descriptions
of Government project
On 5/19/05, Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
> On 5/19/05, Jan Sunavec <[EMAIL PROTECTED]> wrote:
> > I am using libpg.so. I tryed find solution for this problem in internet
> > but, I don't find nothing yet. I have idea get rowcount throught some
> > function write in C. Or is there any p
On 5/19/05, Jan Sunavec <[EMAIL PROTECTED]> wrote:
> I am using libpg.so. I tryed find solution for this problem in internet
> but, I don't find nothing yet. I have idea get rowcount throught some
> function write in C. Or is there any plan add this feature into PostgreSQL?
Theoretically you could
On Thu, 2005-05-19 at 10:49, lister wrote:
> Scott Marlowe wrote:
>
> >On Thu, 2005-05-19 at 09:46, lister wrote:
> >
> >
> >> At the BSDCan tutorial last week on jails (and several other times)
> >>there was discussion regarding Postgres's use of system V style
> >>shared memory, and an unfortu
Tom Lane wrote:
Berend Tober <[EMAIL PROTECTED]> writes:
But after doing a dump of the modified data base, the script created by
pg dump wants to recreate the history table as
...
CONSTRAINT person_name_check CHECK (((last_name IS NOT NULL) OR
(first_name IS NOT NULL))),
Hmm, it shouldn
Scott Marlowe wrote:
On Thu, 2005-05-19 at 09:46, lister wrote:
At the BSDCan tutorial last week on jails (and several other times)
there was discussion regarding Postgres's use of system V style
shared memory, and an unfortunate side effect of making jail() less
secure. Specifically, to allow P
Scott Marlowe wrote:
On Wed, 2005-05-18 at 21:24, Mark Steckel wrote:
...We are proposing that
Postgres be used for the application database. Not too surprisingly we are
being asked for additional information because Postgres is open source.
So is the implication that they think open sour
On May 19, 2005, at 5:42 AM, John DeSoi wrote:
On May 19, 2005, at 1:34 AM, Matthew Hixson wrote:
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype
(0) file: -lSystem is not an object file (not allowed in a library)
After upgrading to 10.4.1 and using Michael's parameters to ./
Berend Tober <[EMAIL PROTECTED]> writes:
> But after doing a dump of the modified data base, the script created by
> pg dump wants to recreate the history table as
> ...
> CONSTRAINT person_name_check CHECK (((last_name IS NOT NULL) OR
> (first_name IS NOT NULL))),
Hmm, it shouldn't do that .
lister <[EMAIL PROTECTED]> writes:
> At the BSDCan tutorial last week on jails (and several other times)
> there was discussion regarding Postgres's use of system V style
> shared memory, and an unfortunate side effect of making jail() less
> secure. Specifically, to allow Postgres to operate in a
On Thu, 2005-05-19 at 09:49, [EMAIL PROTECTED] wrote:
> CREATE UNIQUE INDEX name on table(param1,param2);
>
> How to create such unique index when param2 is bool type, and this param2
> should be accepted only in case of true ?
>
> I tried: CREATE UNIQUE INDEX name on table(param1,(param2 = 'tru
On Thu, 2005-05-19 at 09:46, lister wrote:
> At the BSDCan tutorial last week on jails (and several other times)
> there was discussion regarding Postgres's use of system V style
> shared memory, and an unfortunate side effect of making jail() less
> secure. Specifically, to allow Postgres to oper
On Wed, 2005-05-18 at 21:24, Mark Steckel wrote:
> Hello,
>
> Sorry for the cross post.
>
> I am working on a requirements and recommendation document for a division
> of the State of Hawaii Attorney General's office. We are proposing that
> Postgres be used for the application database. Not to
[EMAIL PROTECTED] wrote:
CREATE UNIQUE INDEX name on table(param1,param2);
How to create such unique index when param2 is bool type, and this param2
should be accepted only in case of true ?
I tried: CREATE UNIQUE INDEX name on table(param1,(param2 = 'true'));
but it's not working.
CREATE UNIQUE I
lister <[EMAIL PROTECTED]> writes:
> At the BSDCan tutorial last week on jails (and several other times)
> there was discussion regarding Postgres's use of system V style
> shared memory, and an unfortunate side effect of making jail() less
> secure. Specifically, to allow Postgres to operate in
On Thu, May 19, 2005 at 08:58:13AM +0200, Jan Sunavec wrote:
> I am using libpg.so. I tryed find solution for this problem in internet
> but, I don't find nothing yet. I have idea get rowcount throught some
> function write in C. Or is there any plan add this feature into PostgreSQL?
You're mi
[EMAIL PROTECTED] wrote:
CREATE UNIQUE INDEX name on table(param1,param2);
How to create such unique index when param2 is bool type, and this
param2 should be accepted only in case of true ?
I tried: CREATE UNIQUE INDEX name on table(param1,(param2 = 'true'));
but it's not working.
Something like:
Hrishikesh Deshmukh wrote:
Hi All,
If someone can email Postgresql 7.4.7 docs(PDF). It will be a big
help. I am unable to get pdf docs for this version on debian system.
Please help.
Available from here:
http://www.postgresql.org/docs/manuals/
See the links on the right-hand-side of the page.
--
Omachonu Ogali <[EMAIL PROTECTED]> writes:
> PANIC: right sibling is not next child
Apparently you have a corrupted index --- REINDEX should fix it.
regards, tom lane
---(end of broadcast)---
TIP 2: you can get off all list
Hi,
I hope someone can help me out... I read some research a little while
ago about someone using TSearch2 but searching using phonemes; but I
cannot find that article anymore.
Does anyone remember it & can point me to a link of the article?
Thanks in advance.
---(end
CREATE UNIQUE INDEX name on table(param1,param2);
How to create such unique index when param2 is bool type, and this param2
should be accepted only in case of true ?
I tried: CREATE UNIQUE INDEX name on table(param1,(param2 = 'true'));
but it's not working.
Regards,
Mac
-
At the BSDCan tutorial last week on jails (and several other times)
there was discussion regarding Postgres's use of system V style
shared memory, and an unfortunate side effect of making jail() less
secure. Specifically, to allow Postgres to operate in a jail()ed
environment, the sysctl :
jail.sys
Hi All,
If someone can email Postgresql 7.4.7 docs(PDF). It will be a big
help. I am unable to get pdf docs for this version on debian system.
Please help.
Thanks,
Hrishi
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
A few months ago, a question by Scott Frankel produced a suggestion from
Greg Patnude which I found very exciting that had to do with using pg
table inheritance to maintain an audit or row change history table. I've
been testing Patnude's idea and ran into a problem, described below, and
wanted
Si necesitás una lista en español, podés ir a
http://archives.postgresql.org/pgsql-es-ayuda y suscribirte, los
suscriptores de esta lista hablan inglés y no te va a resultar fácil
conseguir ayuda :(
El tipo de datos que buscas se llama SERIAL (http://www.postgresql.org/docs/8.0/interactive/datatyp
On Thu, 19 May 2005, James Croft wrote:
> Hi all,
>
> I'm trying to create a trigger function for a few tables that will store
> old versions of rows prior to any update on them. Part of the function
> needs to creates other tables (the table to store these snapshots in).
>
> When this trigger run
I am using libpg.so. I tryed find solution for this problem in internet
but, I don't find nothing yet. I have idea get rowcount throught some
function write in C. Or is there any plan add this feature into PostgreSQL?
JOhn
On Wed, 18 May 2005 17:37:09 +0200, Sean Davis <[EMAIL PROTECTED]>
Hi all,
I'm trying to create a trigger function for a few tables that will store
old versions of rows prior to any update on them. Part of the function
needs to creates other tables (the table to store these snapshots in).
When this trigger runs I get the and error of 'syntax error at or near
"
Hello,
Sorry for the cross post.
I am working on a requirements and recommendation document for a division
of the State of Hawaii Attorney General's office. We are proposing that
Postgres be used for the application database. Not too surprisingly we are
being asked for additional information bec
i need a clarification in the pypgsql...
iam executing the statement like
result=connection.query("Update emp set empname="Don" where empid=15")
what will be result value if the empid 15 doesn't exists.
vel
Important Email Information :- The information in this email is
confidential an
Hi,
I am getting an exception when I try to use JDBC
CallableStatement for executing a stored procedure.
Exception - Callable Statements not supported at this
time.
Postgres version - 7.3.2
OS - Linux
It will be very useful for me if you could help me in
cracking this.
Regards,
RamaMohan.T
_
Hola! buenos días!
Estoy usando su base de datos y quisiera saber como creo un campo que sea auntonumérico o lo que en sql server es identiti, también quisiera como pudiera hacer una copia de toda mi base de datos (restore) para copiarla igual en otra computadora.
Saludos Maribel
Correo Ya
Hannes Dorbath wrote:
Hi,
what's the best way in pl/pgsql to call a function with a dynamic name
from inside another pl/plsql function?
like..
SELECT INTO
function_name
name
FROM
functions
WHERE
bar;
EXECUTE function_name..??
Almost
my_query = ''SELECT '' || function_name ''()'';
EXECUTE
On May 19, 2005, at 1:34 AM, Matthew Hixson wrote:
/usr/bin/libtool: for architecture: cputype (16777234) cpusubtype (0)
file: -lSystem is not an object file (not allowed in a library)
After upgrading to 10.4.1 and using Michael's parameters to
./configure I still get the exact same build error.
Hi,
what's the best way in pl/pgsql to call a function with a dynamic name
from inside another pl/plsql function?
like..
SELECT INTO
function_name
name
FROM
functions
WHERE
bar;
EXECUTE function_name..??
Thanks in advance
---(end of broadcast)--
On May 19, 2005, at 12:21 PM, Tom Lane wrote:
Michael Glaesemann <[EMAIL PROTECTED]> writes:
On May 19, 2005, at 10:27 AM, Matthew Hixson wrote:
8.0.3 does not build for me on Mac OS X 10.4. Anyone else seeing
this error, and will it be fixed in the next release?
I just built 8.0.3 on Mac OS X 10
See here for more details:
http://www.postgresql.org/docs/8.0/static/maintenance.html
In short, you don't need to do a vacuum analyze for each connection--it
is a database-specific or table-specific task, not a
connection-specific one. You can use vacuum analyze when you think
things have chang
Surabhi Ahuja wrote:
Analyze command helps increase performance.
More exactly, it updates statistics so the planner knows that (e.g.) you
have lots of different values in the invoice_date column.
Suppose i have n connections to the database..and each connection i
query. So does this mean that i n
Title: analyze at startup?
Analyze command helps increase performance.
Suppose i have n connections to the database..and each connection i query. So does this mean that i need to do an analyse over each of those connections.
Cant analyze be done one time...
and also please tell if there is a
On Wed, May 18, 2005 at 11:32:40PM -0400, Alvaro Herrera wrote:
> On Wed, May 18, 2005 at 10:46:50PM -0400, John Burger wrote:
> > For one thing. For another, I believe the standard C library only has
> > floating point exponentiation functions, not that there aren't plenty
> > of numeric librar
James Croft wrote:
The problems seems to be with the table_name arg being a variable and
not a literal but can't see how to fix this.
If anyone knows what's going on here or has any pointers it would be
appreciated.
Thanks,
James
Sorry,
I'm running PgSQL 7.4.7 on RedHat Enterprise Linux 3.
Dinesh Pandey wrote:
How can I write trigger on a columns insert/update?
CREATE TRIGGER mytrigger
BEFORE
INSERT OR UPDATE
OF mycolumn ON mytable
You don't I'm afraid. It's not a feature that's supported yet. You have
to check which column(s) were changed in your functions.
It is on the
I deleted all the rows, approximately 3 million, in a table earlier in
the day, so during the nightly routine vacuum, I received the following:
dbname=# vacuum verbose analyze table;
INFO: vacuuming "public.table"
INFO: index "table_attempt_idx" now contains 3895682 row versions in 103829
pages
How can I write trigger on a columns insert/update?
CREATE TRIGGER mytrigger
BEFORE
INSERT OR UPDATE
OF mycolumn ON mytable
FOR EACH ROW
EXECUTE PROCEDURE myfunction();
I am getting error “syntax error at or near
"OF"
Thanks
That was very helpful, many thanks
About timestamp, I understood that as long as the DB server is the one
to log times it is safe to use it without timezones?? (I am not using
any of the different timezoned clients??) am i missing the point?
about all_table_columns, it is just a simple view to ha
93 matches
Mail list logo
