Is there a way to get the names of the arguments to a function from
psql? /df and /df+ return the parameter types, but not their names.
Thanks,
Tim
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
unsubscribe
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
Tom,
Thanks for the reply...something did in fact remove the
postmaster.pid file! We will have to look into this further to track
down the culprit.
Thank you everyone for your responses!
Tim
On Nov 28, 2005, at 3:36 PM, Tom Lane wrote:
Timothy Perrigo <[EMAIL PROTECTED]> write
On Nov 28, 2005, at 6:14 PM, Michael Glaesemann wrote:
[Reordering top-posted reply]
Conflicts with the ARD-installed server has been an issue for me on
and off in the past, though I haven't been able to connect to the
server using psql without specifying the ard database, user, and
pass
base in an embedded install that uses the
default
PostgreSQL port. That could be the cause of your trouble...
On Mon, Nov 28, 2005 at 01:24:37PM -0600, Timothy Perrigo wrote:
We just ran an OS update on an Xserve which runs our PostgreSQL
server, and now it seems that pg_ctl status doesn't rep
We just ran an OS update on an Xserve which runs our PostgreSQL
server, and now it seems that pg_ctl status doesn't report the
correct status.
~ postgres$ pg_ctl status
pg_ctl: neither postmaster nor postgres running
~ postgres$ ps auxw | grep postgres
postgres 491 0.0 -0.133156 11
Is there anything similar to pg_get_serial_sequence that will work
with tables that have an inherited serial column? For example, if I
have 2 tables:
create table base (
idserial not null primary key
);
and
create table derived (
stufftext,
constraint derived_pkey primary key(id)
)
Can you post the code for the function you are having trouble with?
The following psql query works as expected (returns a negative
interval):
select '3 days 4 hours 17 mins'::interval - '3 days 6 hours 17
mins'::interval;
?column?
---
-02:00:00
Inserting the difference into a table
On Jan 2, 2005, at 8:31 PM, Tom Lane wrote:
Timothy Perrigo <[EMAIL PROTECTED]> writes:
On Jan 2, 2005, at 12:58 PM, Tom Lane wrote:
I think you probably are trying to run two postmasters at once. You
really need to increase the OS X memory limits, instead.
No, I just ran pg_ctl status to
On Jan 2, 2005, at 12:58 PM, Tom Lane wrote:
Timothy Perrigo <[EMAIL PROTECTED]> writes:
I just downloaded and installed RC3 on my OS X system (10.3.7), and
I'm
getting a shared memory error when trying to run initdb (error message
listed below). I received a similar error a few week
I just downloaded and installed RC3 on my OS X system (10.3.7), and I'm
getting a shared memory error when trying to run initdb (error message
listed below). I received a similar error a few weeks ago after
upgrading my OS to 10.3.7, but I was able to get around that by
reducing the shared_buf
What is the syntax for inserting a unicode character literal? I
thought it would be something like '\u05D0', but that doesn't work.
Any help would be appreciated!
Thanks,
Tim
---(end of broadcast)---
TIP 6: Have you searched our list archives?
On Dec 17, 2004, at 11:10 PM, Tom Lane wrote:
Fascinating. As far as I can tell on my machine, 10.3.7 did not change
the kernel IPC limits. So if it's not working for you guys that would
suggest that 10.3.7 added some new background usage of IPC resources,
which in combination with the PG postmas
I'm getting the same error now too, although postgres was running
without problem this morning (I updated the OS yesterday). OS X 10.3.7
Server, PostgreSQL 8.0RC1. Basically, I did a pg_dump, stopped the
server and then tried to start it again.
Any ideas?
On Dec 17, 2004, at 2:41 PM, Jerry Le
On Dec 10, 2004, at 4:26 AM, Vikas Kumawat wrote:
Dear Sir /Madam,
We are working on Linux suse 9.0 and we have installed Postgres 7.3 through yast with the privileges of "root" user. But we are not able to start / configure the postgres database, Kindly help us in configuring and starting the
The first way also makes it possible to put the constraint on multiple
fields:
create unique index uidx_abc on my_table(col_a, col_b, col_c);
On Dec 2, 2004, at 1:51 PM, Ian Harding wrote:
The second is shorthand for the first. you get to choose the index
name
in the first one.
Ian Harding
Pro
:
Tim,
I'm afraid, I didn't get the point. Could you give me an example code
snippet of how to use the EXECUTE command in my case. Do I have to use
the EXECUTE within my function?
Thanks a lot,
alex.
Timothy Perrigo wrote:
You'll need to use the EXECUTE command to build the SQL
You'll need to use the EXECUTE command to build the SQL dynamically.
See:
http://www.postgresql.org/docs/7.4/interactive/plpgsql-
statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
On Nov 23, 2004, at 2:56 PM, Alexander Pucher wrote:
Hi,
struggling around with this for some time:
How can I use a ta
Autodoc might be useful: http://www.rbt.ca/autodoc/
On Nov 18, 2004, at 8:31 AM, David Pradier wrote:
Hi !
I've just inherited the responsibility of a postgresql database
of roughly 480 tables and 6460 columns, mainly without constraints,
not even foreign keys.
I'd like to make it a little more ort
(PostgreSQL 8.0 beta 4 on Mac OS X 10.3.6)
I'm working on a function which creates and populates a temporary
table, then returns the number of records it has inserted. I'm getting
an error, though, after successive invocations of the function (I can
call it once successfully, but on the next ca
On Nov 16, 2004, at 2:11 PM, Michael Fuhr wrote:
\set VERBOSITY verbose
SELECT foo();
ERROR: 42P01: table "my_temp" does not exist
CONTEXT: SQL statement "DROP TABLE my_temp"
PL/pgSQL function "foo" line 2 at SQL statement
LOCATION: DropErrorMsgNonExistent, utility.c:144
The error code is 42P01,
I'm working on a plpgsql function that creates and populates a
temporary table. I would like the function to first drop the temp
table, if it already exists. I'm not sure how to accomplish this,
though. My first inclination was to simply wrap the 'drop table'
command in an exception handling
I've been working with PostgreSQL on OS X (G4, G5 and dual G5 systems)
for a few months now, and overall I've been really pleased; for us, it
seems to be a good match.
If you have both an OS X and a Linux or BSD system available, you could
run pgbench against both and get a rough idea on how th
As you've discovered, primary key constraints (and other constraints)
do not inherit, but perhaps something like the following will work for
you:
create table base (id serial primary key, (other fields to be
inherited...));
create table derived (new_field1 varchar(10), (other new fields...),
c
I don't know if this will work in your situation, but you might look
into having table A and table B inherit from a common base table (where
the column referenced by the foreign key in C is defined).
Tim
On May 2, 2004, at 2:51 AM, Ryan Riehle wrote:
Thanks for your input. Yes, there is a lot mo
lues
(TG_RELID, TG_RELNAME, NEW.id, TG_OP);
return NEW;
END;
' language 'plpgsql';
On Apr 27, 2004, at 8:18 AM, Richard Huxton wrote:
On Tuesday 27 April 2004 13:40, Timothy Perrigo wrote:
Thanks for the reply. Do you know if triggers defined on a base table
fire for operations on
26 matches
Mail list logo
