Hello
im working in a proyect in ORACLE 10g and one of the things i like is
using the INSERT RETURNING with the parameters, im not sure that i read
about postgres 8.2 suporting this feature... if its true where can i
read more about it.
regards Cesar Alvarez.
begin:vcard
fn:Cesar Alvarez
On Sun, Oct 14, 2007 at 12:01:45AM -0600, Cesar Alvarez wrote:
Hello
im working in a proyect in ORACLE 10g and one of the things i like is
using the INSERT RETURNING with the parameters, im not sure that i read
about postgres 8.2 suporting this feature... if its true where can i
read more
I have a recover situation related to:
Oct 13 23:04:58 66-162-145-116 postgres[16955]: [1-1] LOG: database
system was shut down at 2007-10-13 23:04:54 PDT
Oct 13 23:04:58 66-162-145-116 postgres[16955]: [2-1] LOG: checkpoint
record is at F0/E21C
Oct 13 23:04:58 66-162-145-116
At 2:17a -0400 on 14 Oct 2007, Jason L. Buberel wrote:
create file '00A4' and fill it with 256k zeros. Is there a quick and
easy linux-way of creating such a beast?
The tool is 'dd' and /dev. /dev/zero in this case. The summary of what
you asked:
$ dd if=/dev/zero of=./zblah count=1 bs=256k
On 10/13/07, syan tan [EMAIL PROTECTED] wrote:
I was wondering whether there could be an atomic commit;begin command
for postgresql, in order to open up a transaction at the beginning of
a unit of work in a client session, so that client applications don't
have to duplicate work with having
Hi, I'm calling an arbitrary user-defined function from the backend.
Although I can do it via FunctionCallInvoke, I have a weird problem when
calling fmgr_info. The call results in a argument variable (eventType)
being cleared. A gdb hardware watch says that the variable is modified by
this
I am trying to use postgresql-autodoc. The autodoc finds all the Perl
modules and compiles but when I go to /usr/local/bin and run
postgresql_autodoc like this
I had a good luck with schema-spy (done in java)...
http://schemaspy.sourceforge.net/
Vlad
ps: the command I use is (all on one
I think pg_sleep is not implemented in 8.1 and earlier versions. Is there
any alternative if someone is using versions before 8.2 ?
On 10/9/07, Guy Rouillier [EMAIL PROTECTED] wrote:
Jasbinder Singh Bali wrote:
Hi,
I have a while loop and I want to re-iterate after every 't' seconds.
I
Any ideas what to do next?
Well, I am going to try the same with 8.3 beta1, will see what happens...
Vlad
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining
Hi,
Is it possible to change the current role to another arbitrary role
using a PLPGSQL function?
In essence I've a function authorise created by the db superuser with
'SECURITY DEFINER' specificied.
However from within plpgsql the 'superuser' attribute isn't honored when
trying to change
On Wednesday 10 October 2007 01:00, Jasbinder Singh Bali wrote:
I'm using Postgresql Version 8.1.4. on fedora core 6
I'm pretty sure that pg_sleep is not implemented in 8.1.
Am not sure what is the work around
Yeah can code your own sleep function in plpgsql, but it tends to be resource
Hello!
Running postgresql 8.2.5 (build from source on debian testing, amd64) i run
into following error when running vacuum full analyze:
ERROR: invalid page header in block 1995925 of relation data_pkey
The database was freshly initialized and contains around 1.4 billion records
in the main
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
Andrus.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please
Background:
Ok..I've got a view which returns agency_id, fiscal_year, reporting_month,
count_col0, count_col1...grouping by agency_id, fiscal_year and
reporting_month. Now, if I just select * from myreport; it returns all the
various counts for the various fiscal years and all that within 4
I was trying this example program out of a well known postgresql book and keep
getting errors whenever I try to compile.
Error messages ##make client1
cc -g -I /usr/include -I /usr/include/pgsql -I /usr/include/pgsql/server -c
-o client1.o client1.c
cc -g client1.o -L /usr/lib -L
Hi all, I am writing a few pg/plsql and have no great experience, so
i'm asking here.
I need to obtain X1,X2,.. from N queryes like these:
SELECT X1 FROM tab GROUP BY Y1
SELECT X2 FROM tab GROUP BY Y2
SELECT X3 FROM tab WHERE C3 GROUP BY Y3 [eventually ORDER BY Z3];
example:
SELECT
When user login has disabled by
CREATE USER NOLOGIN
Postgres 8.2 returns Password authentication failure error message on
login.
This is very confusing to users.
How to force Postgres to return message like in Windows:
Login is disabled.
?
Andrus.
---(end
We had a crash of one of our db systems last night. After doing a fsck
of he file system and getting the db backup, we're getting a lot of
these messages in our logs. The DB will also occasionally crash now.
Oct 12 07:40:16 postgres[30770]: [3-1] 2007-10-12 07:40:16 PDTERROR:
could not access
Hello,
I have a 'strange' situation:
I need to make a replica copy of my database to a reduntant spare
computer.
The reduntant computer is not running postgres, but postgres is
installed. The redundant computer is running in a special run-level (I'm
talking Linux here) in which Pg is _not_
got it. thanks very much.
On 10/2/07, Martijn van Oosterhout [EMAIL PROTECTED] wrote:
On Thu, Sep 27, 2007 at 02:28:27AM -0700, [EMAIL PROTECTED] wrote:
I am now importing the dump file of wikipedia into my postgresql using
maintains/importDump.php. It fails on 'ERROR: invalid byte sequence
Hello folks,
I'm new to postgres and I'm using version 8.1
Here's the problem anyway:
If I insert a sequence later on table creation with alter table, drop
table cascade simply doesn't drop this sequence even when I specify
CASCADE.
works
create table bla(id serial);
drop
On 5 oct, 01:06, [EMAIL PROTECTED] (Chris) wrote:
Jeff Lanzarotta wrote:
Hello,
I have a MySQL dump file that I would like to import into our PostgreSQL
8.2 database. Is there a way to do this?
You'll need to convert the table definitions then the data.
For example, mysql has int(11)
On 10/10/07, vladimir konrad [EMAIL PROTECTED] wrote:
Hello!
Running postgresql 8.2.5 (build from source on debian testing, amd64) i run
into following error when running vacuum full analyze:
ERROR: invalid page header in block 1995925 of relation data_pkey
Check your hardware...
Most
On 10/10/07, Guilherme [EMAIL PROTECTED] wrote:
Hello folks,
I'm new to postgres and I'm using version 8.1
Here's the problem anyway:
If I insert a sequence later on table creation with alter table, drop
table cascade simply doesn't drop this sequence even when I specify
CASCADE.
This is
I meant commit and continue current transaction. The transaction is opened
on the user application caching composite data from many tables regarding
a root object. Because almost all applications cache data, there is apparently
a pattern optimistic offline lock where orb middleware basically adds
On 10/14/07, Syan Tan [EMAIL PROTECTED] wrote:
I meant commit and continue current transaction. The transaction is opened
on the user application caching composite data from many tables regarding
a root object. Because almost all applications cache data, there is apparently
a pattern
On 10 Oct 2007, at 02:25, [EMAIL PROTECTED] wrote:
I was trying this example program out of a well known postgresql
book and keep getting errors whenever I try to compile.
Error messages ##make client1
cc -g -I /usr/include -I /usr/include/pgsql -I /usr/include/pgsql/
server -c -o
[EMAIL PROTECTED] writes:
I was trying this example program out of a well known postgresql book and
keep getting errors whenever I try to compile.
cc -g -I /usr/include -I /usr/include/pgsql -I /usr/include/pgsql/server
-c -o client1.o client1.c
cc -g client1.o -L /usr/lib -L
illusina [EMAIL PROTECTED] writes:
Ok..I've got a view which returns agency_id, fiscal_year, reporting_month,
count_col0, count_col1...grouping by agency_id, fiscal_year and
reporting_month. Now, if I just select * from myreport; it returns all the
various counts for the various fiscal years
Scott Marlowe [EMAIL PROTECTED] writes:
On 10/10/07, Guilherme [EMAIL PROTECTED] wrote:
If I insert a sequence later on table creation with alter table, drop
table cascade simply doesn't drop this sequence even when I specify
CASCADE.
This is normal.
In 8.2 and up you can use ALTER SEQUENCE
My project is currently SQL_ASCII encoded. I will need to accomodate both
French and Spanish in addition to English. I don't anticipate needing Far
East languages. Reading here on the forums I come up with Latin9 as perhaps
adequate. But others recommend unicode for relatively simple needs like
novnov wrote:
My project is currently SQL_ASCII encoded. I will need to accomodate
both French and Spanish in addition to English. I don't anticipate
needing Far East languages. Reading here on the forums I come up with
Latin9 as perhaps adequate. But others recommend unicode for
relatively
Martin,
Can you explain this a little further?
My client-application would somehow set the the environment-variable
PGUSER e.g. to 42.
Then create an odbc connection with user='john' and password='doe' to
the remote pg-server.
Later the triggers that run on the server would access this
Good Evening Andreas-
Windows Control Panel/System/Advanced/EnvironmentVariables/Set System
Variables as mentioned
PGHOST=localhost
all processes for all users will see these env vars
Unix bash (to set system wide variables)
go to /etc/profile
vi .profile
PGHOST=localhost
export PGHOST
:w!
:q
Tom Lane [EMAIL PROTECTED] schrieb:
Scott Marlowe [EMAIL PROTECTED] writes:
On 10/10/07, Guilherme [EMAIL PROTECTED] wrote:
If I insert a sequence later on table creation with alter table, drop
table cascade simply doesn't drop this sequence even when I specify
CASCADE.
This is
Andreas Kretschmer [EMAIL PROTECTED] writes:
Tom Lane [EMAIL PROTECTED] schrieb:
In 8.2 and up you can use ALTER SEQUENCE ... OWNED BY ... to establish a
link that will make a manually created sequence go away when its owner
column is dropped. In 8.1 that aspect of SERIAL is hidden magic :-(
Andrus wrote:
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
Thanks, we're looking for something that will run natively on Linux.
--
Until later, Geoffrey
Those who would give up
Geoffrey [EMAIL PROTECTED] wrote:
Andrus wrote:
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
Thanks, we're looking for something that will run natively on Linux.
I
On 10/13/07, wido [EMAIL PROTECTED] wrote:
hi! but what happens when somebody sent you a dump file and you can't
convert the tables? all i have is a 116MB sql file, and i won't
convert it by hand :P
And chances are no one on the list will do it for you,
either, specially not when you stick out
Bill Moran wrote:
Geoffrey [EMAIL PROTECTED] wrote:
Andrus wrote:
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
Thanks, we're looking for something that will run natively on
If I do an update using the FROM clause, and that clause has a sub-query
that refers to the table I am updating, will I be waiting for ever for a
table to lock to release?
The update before seems to stall, and it occurs to me that perhaps this is
the problem.
BTW - I rarely do anything but
On Tue, 9 Oct 2007, [EMAIL PROTECTED] wrote:
following are the rpms I have installed on a RHEL5 system.
compat-postgresql-libs-4-2PGDG.rhel4
Yes I see the compat one and will install rhel5 if I find one.
It has no bearing on what you were running into, and unless you're having
a problem
On 10/14/2007 6:41 PM Geoffrey wrote:
Bill Moran wrote:
Geoffrey [EMAIL PROTECTED] wrote:
Andrus wrote:
I guess I should have noted that we will need to run this on Linux
clients.
Geoffrey,
You can run FYIReporting engine in Linux using MONO ( www.go-mono.com )
Thanks, we're looking for
I just want to clarify that the following will always behave the way I
think it's supposed to behave:-
update tableA
set date_field = case when date_field is null then some_date
else date_field end;
If the current value of date_field for
44 matches
Mail list logo