I read in the documentation (section 37.4.3 of the 7.4 docs) that
"Parameters to a function can be composite types," but when I try to
call such a function, I get an error. I've attached my test functions
below. Can anyone tell me what's wrong? I've tried the same function
using RECORD types, and i
In addition to Beau Bummel post, here is a startup script that I find
very useful:
- Begin snip -
#! /bin/sh
# chkconfig: 2345 98 02
# description: PostgreSQL RDBMS
# This is an example of a start/stop script for SysV-style init, such
# as is used on Linux systems. You should edit some
If I have a table that I only use for INSERTs and queries (no UPDATEs or DELETEs), is
it enough to just run ANALYZE on the table instead of VACUUM ANALYZE? In other words,
is running a VACUUM on a table useful if all that you're doing is INSERTing into it?
My understanding of VACUUM is that it
hi to all
does anybody know about uITRON..
What is uITRON core...
any help appreciated
thanks in advance..
regds
smitha
*
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended s
> >
> > We did it with C++ and a memory mapped file for persistence.
> > We had to use a 64bit cpu and 12G of RAM.
>
> Wow! That's only 300 bytes of RAM for every 10 digit phone number!
We didn't use all of that, last time I checked it was using apx 4G of
RAM,
We had to plan for every possible U
The way PostgreSQL deals with the date format is confusing me...
I need PostgreSQL to return dates from selects at this format: "dd/mm/",
but it insists in returning it as "-mm-dd". I say "insists" cause I had
already set datestyle to "European" (in postgresql.conf) which represents
the for
From: Nagib Abi Fadel
[mailto:[EMAIL PROTECTED] Sent: 11 December 2003
14:37To: generalpost; developPostSubject: [HACKERS]
Should we consider empty fields as NULL values when dealing with string
columns ?
HI,
let's say we have the following table :
# CREATE TA
Bret,
Thanks for voicing your opinion. I'll second it as loudly as I can.
I work for a small 5 member team in a major hospitality corporation.
Our team has a mish mash of responsibilities (help desk, tool design
through MS Excel and MS Access, and corporate reporting). We are just
pushing the l
Bret.
> The MySQL certifications, are international skillset certifications,
> like MCAD, MCSD, MCSE, RHCE, and LPI certifications, and, from what I
> understand, similarly, internationally recognised.
In my experience these have less to do with being proficient at a
disipline and more to do
Hi there,
Ive been reading but not getting far, so thought i
would ask here. IN SQL im trying to do this.
What its meant to do is look in Column partno. Then check if there are any
part numbers starting with 5R. Once it done that it should insert the
value 5R RACING into the blank SEAR
[EMAIL PROTECTED] ("Corey W. Gibbs") writes:
> Just curious what problems, if any, have you had compiling/using Posgres on
> an AIX system. Up until now, my main experience with PG has been on Linux
> systems, and I was just wondering what differences there are in using the
> software on an AI
MySQL is CLEARLY SUPERIOR in terms of
- usability
- see above
- performance
- uses index for for min()/max()
- reliability
- no need to use vacuum
- no need to dump and restore databases for version upgrade
- never screwed up any of my databases
You forgot space saving storage of floatin
Hi,
Why worry? I'm sure that most of the guys in this list didn't have
dedicated PostgreSQL training (I didn't for sure).
You have lots of tutorials and (not to forget) a great documentation set
on the Postgres website.
There are also the mailing lists with people who like to help you. And
reme
When I'm running my app, I occaisonally receive this error message:
PostgreSQL Error Code(1)
"could not create socket: An address incompatible with the requested
protocol was used"
It appears to be a PostgreSQL Error, but I can't find Any documentation on
it at all in the PostgreSQL docs, or web
When you create a table (subTable) which enherits from an other table (superTable),
what are the actual relationship between theese tables.
Is there a foreign key in the subTable, or does the subTable just have the same
columns as the superTable plus some extra?
I am askin because I would like
Is there a version of PostgreSQL that runs on a Windows machine?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Am Mon, den 15.12.2003 schrieb Sai Hertz And Control Systems um 16:26:
> Dear Markus Rebbert ,
>
> >what happens with sequences if i dump a database and i want to reload
> >it?
> >
> >
> The pg_dump command also dumps the index value of sequences and you do
> not have to do any thing
> Just mak
"C G" <[EMAIL PROTECTED]> writes:
> SET SESSION AUTHORIZATION username;
> ERROR: syntax error at or near "$1" at character 28
You'll need to use EXECUTE to do this. Utility statements in general
aren't prepared to deal with parameters.
regards, tom lane
-
Jeff Rogers <[EMAIL PROTECTED]> writes:
> However, the documentation says that using a SRF in the select list of
> a query, but this capability is deprecated. I can't figure out how to
> call this function in the from clause with it referring to a column in
> a table, I get an error like
> ERROR:
I am running OSDL-dbt1 - an e-commerce workload
(http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/osdl_dbt-1/)
against PostgreSQL: 7.3.3. During the test, I saw a lot of messages in
the database log file:
NOTICE: _sc_id=0, _add_flag=0, _itemcount=0, _i_id=597, _pp_i_id=
On Mon, 15 Dec 2003 09:32:34 -0800, Roderick A. Anderson wrote:
> want to ask if the LIMIT modifier is SQL standard?
No. The standard doesn't have anything like that, unfortunately.
> MS SQL Server uses a TOP modifier.
Yes, but it accepts an optional "WITH TIES" modifier which PostgreSQL
doesn'
On Mon, 15 Dec 2003, Arjen van der Meijden wrote:
> "Nonstandard Clauses
>
> The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL
> standard."
Humm. Is there a SQL standard to return a subset of the selected tuples?
This being contrary to relational theory I believe. :-)
>
On Mon, 15 Dec 2003, Johnson, Shaunn wrote:
> Howdy:
> Silly questions -
>
> Is it possible (or, has anyone got brave enough) to run
> PostgreSQL on Windows Server 2003?
>
> If so, what does it entail and how do I start?
The best and easiest way for normal folks is likely gonna be to use
cygwi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Mon, 15 Dec 2003 09:13:49 +, Tony wrote:
>excel it's previous incantation.
>
The spelling is "its", not "it's".
"Its" is a possessive pronoun. "It's" is a contraction for "it is".
- --
jimoe at sohnen-moe dot com
pgp/gpg public key: ht
Dear All,
I have a simple table
CREATE TABLE table1{
user name,
si numeric
};
Also I have function:
CREATE FUNCTION check1(numeric) RETURN text AS'
DECLARE
SI ALIAS AS $1;
username name;
BEGIN
username:=(SELECT user FROM table1 WHERE si=SI)
SET SESSION AUTHORIZATION username;
RETURN username;
END;
Rod,
Have a look at the bottom of this page:
http://www.postgresql.org/docs/current/static/sql-select.html
"Nonstandard Clauses
The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL
standard."
TOP x isn't in the standard as well, afaik.
Best regards,
Arjen
Roderick A. Anderso
On 12/13/2003 3:47 PM, Bruno Wolff III wrote :
On Fri, Dec 12, 2003 at 14:40:34 -0800,
Nathaniel Price <[EMAIL PROTECTED]> wrote:
Sorry, that's not really what I'm looking for. When I said that the sort
order could be arbitrary, I meant /arbitrary/. As in "no amount of ORDER
BYs will save me
I'm dealing with a project that requires me to query a MS SQL Server. Not
a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL
standard? MS SQL Server uses a TOP modifier.
select top 1 * from xxx;
Whereas all the SQL RDBMS' I've used before used
select * f
On Monday 15 December 2003 08:30 am, Tino Wildenhain wrote:
> Hi Harsi,
>
> snpe schrieb:
> > On Sunday 14 December 2003 03:51 pm, Tino Wildenhain wrote:
> >>Hi snpwhatever,
> >>
> >>snpe wrote:
> >>>Hello,
> >>> Can PostgreSQL resolve object dependencies automatic
> >>>If we delete any object the
Doug McNaught <[EMAIL PROTECTED]> writes:
> "Manu M P" <[EMAIL PROTECTED]> writes:
>> I then created the "passwords" file in $PGDATA using pg_pasword and
>> added entries for the two users "test1" and "test2".
> I've never heard of a 'pg_password' program and it is not part of the
> standard distr
Dear Markus Rebbert ,
what happens with sequences if i dump a database and i want to reload
it?
The pg_dump command also dumps the index value of sequences and you do
not have to do any thing
Just make sure your pg_restore and pg_dump with option --disable-tiggers
Regards,
Vishal kashyap
---
Johnson, Shaunn wrote:
> Howdy:
> Silly questions -
>
> Is it possible (or, has anyone got brave enough) to run
> PostgreSQL on Windows Server 2003?
>
> If so, what does it entail and how do I start?
See the FAQ entry for Win32. You can use Cygwin.
--
Bruce Momjian|
"Manu M P" <[EMAIL PROTECTED]> writes:
> Hi
>
> I have the data base "test" and two users "test1" "test2". I added the following
> record to pg_hba.conf
>
> local test password passwords
>
> I then created the "passwords" file in $PGDATA using pg_pasword and
> added entries for the two users "tes
Title: PostgreSQL on Windows Server 2003
Howdy:
Silly questions -
Is it possible (or, has anyone got brave enough) to run
PostgreSQL on Windows Server 2003?
If so, what does it entail and how do I start?
Thanks.
-X
34 matches
Mail list logo
