On Wed, Jan 11, 2006 at 05:23:03PM +0530, Praveen Kumar (TUV) wrote:
> I want to create one table with from many different tables using outer
> joins.Please can you guide how is possible to create in Postgresql.
> Let we have syntax for creating table in oracle.If we want to create
> same table in
On Wed, Jan 11, 2006 at 02:26:25PM +0530, Krishnendra Nandi wrote:
> Could you please tell me how do i record information as to which ip
> address the connection was when doing an update/insert in postgres..
> I need a trigger which would capture this information
In 8.0 and later you could use in
On Thu, Jan 05, 2006 at 03:17:02PM -0500, Colton A Smith wrote:
> SELECT attname, typname, attnum
>FROM pg_attribute INNER JOIN pg_type
> ON pg_attribute.atttypid = pg_type.typelem
>WHERE pg_attribute.attrelid = $oid (derived above)
>
Colton A Smith <[EMAIL PROTECTED]> writes:
> SELECT attname, typname, attnum
> FROM pg_attribute INNER JOIN pg_type
> ON pg_attribute.atttypid = pg_type.typelem
> WHERE pg_attribute.attrelid = $oid (derived above)
>
Stefan Holzheu <[EMAIL PROTECTED]> writes:
> Other queries with the equal operator do match rows. Am I missing something?
> Postgresql: 8.1.1
> Fieldtype: text
> Database encoding: Latin9
What LC_COLLATE locale are you using? Your report looks a whole lot
like the recently identified problem wit
"Krishnendra Nandi" <[EMAIL PROTECTED]> writes:
> Could you please tell me how do i record information as to which ip
> address the connection was when doing an update/insert in postgres..
> I need a trigger which would capture this information
In recent PG releases this info is available, see "S
Hello
All,
I want to create one
table with from many different tables using outer joins.Please can you guide how
is possible to create in Postgresql.
Let we have syntax
for creating table in oracle.If we want to create same table in Postgresql
then how will we replace (+) in syntax sothat
Tsirkin Evgeny wrote:
> On Mon, 6 Sep 2004, Michael Paesold wrote:
> Does not the Serializable Isolation Level do insure that?
> what i thought is that while using this level then i am getting
> the BEGIN and COMMIT to behave the same as the code you wrote!
> since the second concarent transaction
Hi:
I use v8.1.0, and have a table named pressure:
Table "public.pressure"
Column |Type |
Modifiers
--+-+---
Could you please tell me how do i record
information as to which ip address the connection was when doing an update/insert
in postgres..
I need a trigger which would capture
this information
Thanks and Regards
Krishnendra Nandi
Hewitt Associates India (Pvt.) Ltd.
Unitech World
Sector-39, Gurgaon
Hallo,
I just encountered a stange behaviour:
The following query gives zero rows.
bitoek=> SELECT name from file where name =
'mitarbeiter/mit/mitarbeiter_ehemalig.php';
name
--
(0 Zeilen)
Replacing "=" by like and escaping the underscore gives the row I knew
to be there:
bitoek=> SELECT
Hi,
How do I know vacuum is need or not? I mean, are there any query to know status of statistics, tables, indexes, etc?
(7.4.7)
Our database size bigger than just go and do it. :(
Thanks
Szabek
Navicat PostgreSQL Manager for Windows has been enhanced with the below new features and improvements.
New features: 1. Support of Views/Stored Procedures Backup and Restore. 2. Support of View/Stored Procedures Data Transfer. 3. Support of View creation in Query Builder.
Significantly impro
> Hi,
>
> I got a third party utility to run pgsql in non
> administrative users account and without prompting password.
> The utility providers ensure that the utility will work in
> NT. I used this utility for running pg8.1.1 and it shows me
> the following error with a prompt titled "ININT
Juan Miguel <[EMAIL PROTECTED]> writes:
> DEBUG: server process (pid 25276) was terminated by signal 11
Looks like you have run into a Postgres bug. My advice is to update to
a newer PG version ... 7.2.1 is ancient. So ancient that we stopped
supporting the entire 7.2 branch some time ago. It
On 1/11/06, Eran L <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I must be missing some obvious and trivial thing, since I simply can
> get pg_autovacuum to work.
>
> Im working on FC4, postgresql 8.0.6.
> In the "postgresql.conf" file, I've set:
>
> stats_row_level = true
>
> I've restarted the postmaster.
Eran L <[EMAIL PROTECTED]> writes:
> Im working on FC4, postgresql 8.0.6.
> In the "postgresql.conf" file, I've set:
> stats_row_level = true
> I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it says:
> [2006-01-11 12:11:07 IST] ERROR: GUC variable stats_row_level must be
>
> I think I've narrowed it down to Slony and Mammoth.
> Any pro's or con's on one vs the other?
Slony is more complicated to setup.
Slony requires triggers and cron.
Slony is asynchronous
Slony is Open Source
If Slony breaks you can call Command Prompt
It used to be that Slony was timed replic
Am Donnerstag, 31. März 2005 15:49 schrieb Tsirkin Evgeny:
> Is there any relation between the locale and character set?
Every locale expects a certain character set to be used. You can find that
out using
$ LC_ALL=foo locale charmap
If you want things to function correctly, you have to use a
Am Donnerstag, 31. März 2005 16:12 schrieb Tsirkin Evgeny:
> The question is how it will behave will this eraise an error or it will
> just not sork correctly?
That depends entirely on your operating system's C library.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Adam Witney <[EMAIL PROTECTED]> writes:
> Shouldn't there be something in current_query?
Only if (a) you have stats_command_string turned on, *and* (b) you
are a superuser or the owner of the target process.
regards, tom lane
---(end of broadcast)-
People:
> All of these recent threads about fastest hardware and "who's better than
> who" has inspired me to create a new website:
>
> http://www.dbtuning.org
Well, time to plug my web site, too, I guess:
http://www.powerpostgresql.com
I've got a configuration primer up there, and the 8.0 Annot
Ken,
Table partitioning doesn't really exist, to the best of my knowledge,
but tablespaces, which are new to 8.0, allow for partitioning of data
(individual tables, indexes) across multiple locations on disk.
See
http://www.postgresql.org/docs/8.0/static/sql-createtablespace.html
-tfo
--
T
Tsirkin Evgeny wrote:
> one moer question ,how did you tested it?
>
> > I have tested this here. I don't really know if this is just the case
with
> > Best Regards,
> > Michael Paesold
First I created the your schedule table. Then I opened two psql sessions...
Session ASession B
Jos van Roosmalen <[EMAIL PROTECTED]> writes:
> Can someone explain me how to repair a table?
> If I execute a 'select * from ' in PSQL I get the next
> error. A pg_dump export only partially export the broken table and
> ends with the same error:
> "Invalid memory alloc request size: 429496
Dataarchitect looked good to me, but it could not handle a large schema.
We are using EMS's PG Manager tool. Good for DBA'n and generating erds.
(http://ems-hitech.com/pgmanager/). Only downside is for erd's, you have to
use the windows version, not the linux version.
HTH,
Chris
--
>
> Generally speaking I'd expect Mammoth to handle high loads a little
> better since it's a log shipper and not trigger based. So, if slony
> proves too slow for this situation, then I'd recommend asking the folks
> at Command Prompt for a demo of their system to see if it can.
http://www.com
On Tuesday 21 December 2004 12:57, Tony and Bryn Reina wrote:
> http://gborg.postgresql.org/project/pgdiff/projdisplay.php
>
> pgdiff should compare two PostgreSQL databases.
>
I looked at this a while back and it seemed to compare the data within two
identical databases, not compare the schema b
A while back, I wrote this:
http://www.sitening.com/auto_pg_autovacuum
While not exactly an init script, it sanely avoids multiply starting
pg_autovacuum.
Then I did this:
http://www.sitening.com/pgautovacuum
which is a proper init script.
Thanks for prompting me to post it! Now there are
Title: RE: [ADMIN] caching complete table for optimizing search ?
I'm not sure what to do to cache a single table, but we use a tool called memcached to accomplish what you are describing. Memcached will cache the db in RAM, allowing you to do all of your reads from memory. Writes are more e
Dario Pudlo wrote:
Problem: Not being able to restore a database with lo. I have already read
forums and doc. Probably I'm loosing something, but I just can figure.
Reading forums I though I finally got a "right" way to do it.
I'm running this as OS user "postgres" which is a super user
pg
Is postgres actually running? And is your pg_hba.conf file configured
to allow local UNIX socket connections?
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On Mar 16, 200
Please Unsuscribe me.
Thanks.
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi,
I must be missing some obvious and trivial thing, since I simply can
get pg_autovacuum to work.
Im working on FC4, postgresql 8.0.6.
In the "postgresql.conf" file, I've set:
stats_row_level = true
I've restarted the postmaster. Yet, when I'm running pg_autovacuum, it says:
[2006-01-11 12:1
> When I start the server, the service start and shut down immediately.
> Nothing is written in the log file.
Try starting it from the command line to get more verbose debugging
output?
~BAS
> I did check the *.conf files and everything looks OK.
>
> Did anybody already had this problem ? Doe
35 matches
Mail list logo
