Interesting issue --
I have usually solved this by adding a specific field to each table with a
default timestamp of NOW()...
When you:
CREATE TABLE tbl (
blah...
blah
create_dt TIMESTAMP NOT NULL DEFAULT NOW()
);
each and every record now has a timestamp of exactly when th
"Mario Splivalo" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I've learned that one can't use temporary tables within the function
> unless
> EXECUTE'd the SELECTS from that temp table.
>
> So, I have a function like this:
>
> CREATE FUNCTION Foo1(int4, int4) RETURNS SETOF myType
in your postgresql.conf file near the bottom you need to enable statement
logging -- set log_statement = 'all'
and then you can
tail -f /var/logs/postgresql/postgresql.log
or tail -f wherever your postgres log is...
from the 'Nix command line
"Matthew Peter" <[EMAIL PROTECTED]> wrote in messa
I run pg_autovacuum as user postgres: owner of the database processes and an
unprivileged user (nologin)
""Zlatko Matiæ"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
For pg_dump minimum privilages is to have select right on tables.
For vacuumdb, one must be owner of tables or
You can also reverse engineer a postgreSQL RDBMS using an ODBC driver and
MicroSloth's Visio.
"Bruno Cochofel" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi you all,
>
> His there any SW that can do reverse engineering on postgreSQL
> databases? I need something that can
SELECT trim(trailing ' ' from city_name) AS city_name FROM sys_cities;
You might consider reading the manual as there are a multitude of string
manipulation functions built into postgreSQL
"Pierre Couderc" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> In a WHERE clause, I
Is your table really named "blob" ??? You said it fails when it gets to the
table named "blob" not somewhere in the process of dumping the table
"blob"...
There might be a clue in that... What happens if yo rename the table to
something other than an SQL reserverd word ?
Although postgreSQL doe
SELECT
isc.table_name,
isc.ordinal_position::integer AS ordinal_position,
isc.column_name::character varying AS column_name,
isc.column_default::character varying AS column_default,
isc.data_type::character varying AS data_type,
isc.character_maximum_length::integer AS str_length,
C
It doesnt sound to me like replication is the right answer to this
problem... You are setting yourself up to try and defeat one of the major
purposes of a database in a client-server system -- namely -- centralized
storage.
If you add up all the money you are going to spend trying to manage mul
ODBC has nothing to do with this -- you compile
postgreSQL support directly into PHP when you configure PHP just before the
install...
./Configure --with-postgres
--without-mysql
After that -- you need to join a PHP newsgroup for
PHP questions
""Bob Powell"" <[EMAIL PROTECT
You absolutely should NOT I repeat NOT -- DON'T dink around with the system
catalogs in ANY database... If you need to create UDT's then you should
follow the proper mechanisms to create your own user-defined types...
""Peter Filipov"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECT
If it is a numeric data column -- you probably want to use the "round"
function:
SELECT round(1200.01, 3);
SELECT round(12.009, 2);
"Berend Tober" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Say I want to format calculated numeric output to uniformly have a
> specific number
What is the data type for "signum" ???
"David Rysdam" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> I'm porting an application from Sybase and I've noticed that similar
> application functions take 2 to 3 times longer on postgres than they used
> to on the same machine running
formatting but this will be a string instead of a number...
SELECT round(12.0109, 3)::text;
Greg...
"Berend Tober" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> codeWarrior wrote:
>
>>If it is a numeric data column -- you probably wan
On top of that... "name" is a postgreSQL internal data type --
essentially -- you need to treat it as if it is an SQL "reserved word"
Therefore::I strongly recommend that you name your table something other
than "name"... for the same reasons you wouldn't name a table "select" (the
example
It sort of looks like you are trying to compile a Windows distro of the
source code on a 'Nix box to me...
--
Regards,
Gregory P. Patnude
Vice President - Applications & Innovations Group
iDynaTECH, Inc
120 North Pine Street
STC - Suite 162
Spokane, WA 99202
(509) 343-3104 [voice]
http://www
go in the other direction... Convert your table in MS Access to use a
pass-through query to the postgreSQL table. Connect yoour MS Access pass
through table to postgreSQL using OBBC.
Even better: Drop MS Access completely and just use postgreSQL. Access is a
totally inferior technology.
""car
In theory -- yes. In practicality -- no -- And yes... yopu are corerct --
postgreSQL needs to be installed PHP. YOu will find this to be the case with
ANY dependencies in PHP, including things like jpeg supprt, curl, etc. So
this is NOT a postgreSQL problem, not really anyway.
This is realy a
+1;
Tom:
I regularly use the inheritance features of postgreSQL -- Probably 25% of my
schemas rely on it for the techiques I use such as: history tables,
recursion tables [parent-child and trees], among others.
What is the potential impact for the "ONLY" qualifier ??? None I would
expect, as
Don't use reserved words for column names.
"Albert Vernon Smith" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have two tables, listed as below. I'm inserting values for "text" into
>table "two" (which must already exist as "text" values in table "one").
>When I do that, I'
PGAdmin III
""Gevik"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Could anyone Recommend a nice IDE for debugging and developing code for PG
> on Linux or Windows.
>
> Thanx.
>
>
>
> ---(end of broadcast)---
> TIP 6: explain analyz
You might want to consider an inheritance model for this I use it for
Sarbanes-Oxley and a viurtual rollback system...
http://www.postgresql.org/docs/8.0/interactive/tutorial-inheritance.html
"rlee0001" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I want to write a row-leve
Change your table definition and specify a defeault value for your timestamp
column this way -- when nothing is given on insert --> it will
populate...
CREATE TABLE test (
id serial not null primary key,
defaultdate timestamp not null default now()
);
"" Martin Pohl"" <[EMAIL PRO
Anyone know of a quick and dirty query that can retrieve the various type
definitions ? I am looking to retrieve the schema-equivalent representation
of a custom (user-defined) types.
---(end of broadcast)---
TIP 1: if posting/reading through Us
dynatech.com
"Tom Lane" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "codeWarrior" <[EMAIL PROTECTED]> writes:
>> Anyone know of a quick and dirty query that can retrieve the various type
>> definitions ? I am looking to retrieve the sc
During your process loop -- when / where are the updates committed ? all at
the end ?
How may rows (approx) are you updating ?
FWIW:
I think you will probably find that it is NOT the SQL update that is your
bottleneck I am inclined to speculate that the performance issue is
related to the
You can specifiy a "comment" on each field
"Don Y" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
>
> Is there any way that I can consistently (across all
> tables) add a parameter defining "what" each column
> "is"? (sorry, crappy grammar and ill-formed question).
>
> I
Turn off your indices on the table... do the
inserts... do the updates... rebuild the indices
""MG"" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]...
Hello,
I have about 100 000 records, which need about 30 minutes to write them
with single INSERTs into
This is not a postgreSQL issue -- you are having problems with your PHP
configuration...
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Help! I was trying to make an installation of PHP 5.1.2 + Apache
> 2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
> got PHP to
>From the system catalogs:
SELECT PC.relname, PD.description
FROM pg_catalog.pg_description PD, pg_catalog.pg_class PC
WHERE PD.objoid = PC.oid AND PD.objsubid = 0
"Ari Kahn" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have a comments on tables in my database.
>
> e.g. COMMEN
FWIW: From the system catalogs:
SELECT PC.relname, PD.description
FROM pg_catalog.pg_description PD, pg_catalog.pg_class PC
WHERE PD.objoid = PC.oid AND PD.objsubid = 0
"Ari Kahn" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I have a comments on tables in my database.
>
> e.g.
May I suggest you take a look at www.openldap.org and the following:
http://www.samse.fr/GPL/ldap_pg/HOWTO/
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> I saw many messages about ldap authentication but I´m still not sure if
> PostgreSQL can use it?
>
> Can I use it?
You are apparently dealing with the downside of co-mingling your clients
data... maybe you should seriously consider revising your approach and
giving each client either separate databases or separate schema's within a
given database --
This is why co-mingling should be avoided...
I'd push fo
As an alternative -- you could do an inline type cast
SELECT SUM(amount)::numeric(10, 2) FROM acc_trans WHERE trans_id=19721 AND
chart_id=10019;
"Karen Hill" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>
> "Andrew Baerg" wrote:
>> Hi,
>>
>> I am getting strange results
1 -- Drop your indexes on the table to be inserted into.
2 -- Execute a BEGIN transaction
3 -- Execute your inserts.
4 -- Execute a commit or rollback and END transaction
5 -- Rebuild / recreate your indexes
"Alex" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> i am havin
Perhaps you should look at EnterpriseDB -- It's an Oracle-compliant wrapper
for postgreSQL
"gustavo halperin" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello
>
> I need to porting many old ORACLE-oriented-SQL files and I have many
> problem with this code. Sometimes t
It's generally considered bad form to use reserved words as column names
""Frank Church"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
>I am trying to create a view based on this query
>
> 'select *, "timestamp"::timestamp from ccmanager_log'
>
>
> This is the error I get to
Could you run the unix command 'top' and figure out where your performance
degradation is before you assume it is a database issue...
"Toffy" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi,
> as i put Postrgesql and Mysql in the same server Linux (Fedora core 5),
> is it poss
38 matches
Mail list logo
