Gerardo Herzig escribió:
Hi dudes. Im facing a problem with pg_dump,
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR: could not identify an
ordering operator for type name
HINT: Use an explicit ordering operator or modify the query.
pg_dump: The command was: SELECT t.tabl
Bryce Nesbitt escribió:
I've got a join where a certain column name appears twice:
select username,last_name from eg_member join eg_membership using
(member_id) join eg_account using (account_id) join eg_person using
(person_id);
ERROR: common column name "person_id" appears more than once in l
Tom Lane escribió:
Martin Marques <[EMAIL PROTECTED]> writes:
Tom Lane escribió:
Martin Marques <[EMAIL PROTECTED]> writes:
I have always heard that modification queries should be EXECUTED in PL.
AFAICR.
Run far away from whatever source gave you that advice...
Sorry, it
Tom Lane escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
>
>> I have always heard that modification queries should be EXECUTED in PL.
>> AFAICR.
>
> Run far away from whatever source gave you that advice...
Sorry, it was with DDL commands.
--
Rodrigo De León escribió:
On Nov 21, 2007 8:23 AM, Martin Marques <[EMAIL PROTECTED]> wrote:
(BTW, which it that limit if it exists?).
"In any case, the longest possible character string that can be stored
is about 1 GB."
See:
http://www.postgresql.org/docs/8.2
I was doing some tests to see if I could find a max size for an argument
of type TEXT in a PL/PgSQL function (BTW, which it that limit if it
exists?).
So I made the function to test:
CREATE OR REPLACE FUNCTION datoGrande(TEXT) RETURNS BOOLEAN AS $body$
BEGIN
EXECUTE $ins1$
INSERT INTO funcdatogra
On Tue, 20 Mar 2007, Shavonne Marietta Wijesinghe wrote:
Hello
I have a postgresql table and i do a select via ASP
strSQL = "SELECT * FROM " & MioTabella & " WHERE TRIM(date_inserted) >= '" & datainizio & "' AND
TRIM(date_inserted) <= '" & datafine & "'"
oRs.open strSQL,oConn,3
schede = oRs.
T E Schmitz escribió:
QUERY PLAN
GroupAggregate (cost=1370368.19..1435888.88 rows=5801 width=56) (actual
time=11945.030..13163.156 rows=5801 loops=1)
-> Sort (cost=1370368.19..1379715.86 rows=3739067 width=56) (actual
time=11944.753..12462.623 rows=120117 loops=1)
Sort Key: histo
I create a temp table inside a plpgsql function, which is drop just before
ending (the function).
My problem is that if I execute the same function again (in the same
session) I get an error when trying to insert data into it (looks like the
session has an old reference of the table):
=> SEL
On Thu, 05 Oct 2006 14:37:24 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Martin Marques writes:
>> I just found this problem with the age() function, which AFAIK should
>> give the same resulte as a subtraction of the argument from now(),
>
> Where did you get that i
I just found this problem with the age() function, which AFAIK should give the
same resulte as a subtraction of the argument from now(), but it doesn't.
prueba=> SELECT (now() - tc.last_cron),age(tc.last_cron),tc.intervalo FROM
tareas_cron tc ;
?column? |
On Sun, 23 Jul 2006, Alvaro Herrera wrote:
Martin Marques escribió:
After the SELECT FOR UPDATE other transactions can still see the locked
rows. I want a read/write lock, so no one can access does rows.
SELECT FOR UPDATE acquires an exclusive lock, but other transactions
must try to
On Sat, 22 Jul 2006, Alvaro Herrera wrote:
Martin Marques escribió:
Is it posible to get an exclusive (read/write) lock on certain rows? I
don't want to block the whole table, only certain rows, but I want it to
be a read/write lock.
That's what SELECT FOR UPDATE does.
Hi Alva
Is it posible to get an exclusive (read/write) lock on certain rows? I
don't want to block the whole table, only certain rows, but I want it to
be a read/write lock.
AFAIK SELECT FOR UPDATE doesn't help with this.
Do I have to go for another aproche?
--
21:50:04 up 2 days, 9:07, 0 users,
On Fri, 28 Apr 2006 12:07:04 -0400, Tom Lane <[EMAIL PROTECTED]> wrote:
> Markus Schaber <[EMAIL PROTECTED]> writes:
>> I just stumbled over a slightly confused error message:
>
>> mydb=# select count(*),coverage_area from myschema.streets except select
>> cd as coverage_area from countryref.disk
On Sun, 18 Dec 2005, frank church wrote:
Does VACUUMing reorder tables on clustered indices or is it only the CLUSTER
command that can do that?
Cluster does that. Vacuum only cleans dead tuples from the tables.
--
18:02:25 up 4 days, 9:57, 5 users, load average: 1.59, 1.57, 1.62
El Mar 28 Sep 2004 11:02, T E Schmitz escribió:
> Hello,
>
> Is it possible to set up a table CHECK, which ensures that column A is
> NOT NULL if column B = 'x' ?
CONSTRAINT constraint_name ]
CHECK (expression)
CHECK (expression)
The CHECK clause specifies an expression producing a Boolean r
I have a bunch of queries in a system I'm finishing, and I bumped with a
question on performace.
Which is the best way to solve this:
I need to know if there is at least one row in the relation that comes from a
determinated query. Which is the best way to do this:
(a) Build the query with "SEL
El Mar 31 Ago 2004 09:11, Stephen Quinney escribió:
> On Tue, Aug 31, 2004 at 08:42:44AM -0300, Martin Marques wrote:
> > Does anyone know of a .el file that can be used with Emacs to get colored
> > coding when working with PL/pgSQL?
>
> Emacs 21.3 (and possibly earlier ve
Does anyone know of a .el file that can be used with Emacs to get colored
coding when working with PL/pgSQL?
--
08:40:01 up 8 days, 27 min, 1 user, load average: 2.53, 2.09, 1.70
-
Martín Marqués| select 'mmarques' || '@'
El Vie 23 Abr 2004 11:18, Tom Lane escribió:
> Martin Marques <[EMAIL PROTECTED]> writes:
> > I have a simple function made with PL/pgSQL and when I call it I get this
> > in the logs:
> >
> > 2004-04-23 10:15:32 [30669] LOG: statement: SELECT nodoSuperior(2
I have a simple function made with PL/pgSQL and when I call it I get this in
the logs:
2004-04-23 10:15:32 [30669] LOG: statement: SELECT nodoSuperior(22) AS sup
2004-04-23 10:15:32 [30669] LOG: statement: SELECT $1
CONTEXT: PL/pgSQL function "nodosuperior" line 7 at assignment
2004-04-23 10:
El Lun 19 Abr 2004 17:31, P A escribió:
> Can anyone tell me why this SQL statement is not
> matching with the row from the table below? I think
> I'm going mad!
>
> #
> SQL Statement
> #
>
> SELECT * FROM t_bell_schedule WHERE
El Jue 15 Abr 2004 07:25, Dan Field escribió:
> I've stumbled across a query I don't quite understand the error message
> for.
>
> This query is pulled from a working MySQL setup:
>
> SELECT
> DEWEY_ID, DEWEY_HUNDREDS, DEWEY_TENS, DEWEY_ONES, DEWEY_POINT_ONES,
> DEWEY_POINT_TENS,
>
El Mié 07 Abr 2004 11:26, escribió:
> Ricardo Vaz Mannrich wrote:
> > Thank you.
> >
> > I think there is an error in the Develpoer's FAQ...
> >
> > http://developer.postgresql.org/
> > http://developer.postgresql.org/readtext.php?src/FAQ/FAQ_DEV.html+Develop
> >ers-FAQ
> >
> > A lot of ugly charac
El Lun 22 Mar 2004 12:56, Dana Hudes escribió:
> If you have the option to handle the date manipulation in Perl
> use the DateTime modules. Also see Date::Calc.
NO!
Actualy what I'm doing is getting out of that (I'm using PHP's PEAR
Date::Calc) by creating some nice SQL and PL/PgSQL functions in
El Lun 22 Mar 2004 09:50, escribió:
>
> Intervals are stored as two components. One is absolute time difference,
> and the other is in months. '1 year' is equivalent to '12 months'.
> The documentation on how they work in corner cases (when added or
> subtracted from timestamp(tz)) is sparse. It is
El Vie 19 Mar 2004 09:39, Kumar escribió:
> Dear Friends,
>
> I have installed Linux Fedore and wanted to work with the default installed
> postgres 7.3.4 database.
>
> I could able to create to create user, but while try to connect, I got the
> following error message psql: FATAL 1: IDENT authenti
Is there a function that would give me the date for a given day of year?
Something like the inverse of "EXTRACT(doy FROM date)"?
--
09:04:02 up 10 days, 13:35, 4 users, load average: 0.42, 0.29, 0.33
-
Martín Marqués| sel
I have a table with names of people, email address, etc, and an identifier
that tells me which group they are in (could be a 1, 2, or 3 person group).
Is it posible to make a query that would give me the name of the persons of
each group in one row? Or do I have to do PL?
--
19:15:01 up 97 da
El Vie 26 Dic 2003 19:46, Sai Hertz And Control Systems escribió:
> Dear Martin Marques ,
>
> >>In mathematics I would have written it something like
> >>
> >>A = antilog (3·3234) = 2144
> >>
> >>
> >
> >As I can understand,
El Vie 26 Dic 2003 19:12, Sai Hertz And Control Systems escribió:
> Dear all ,
>
> In one of our project I require to calculate antilog of (3.3234)
> But I could not find any functions in Documentation for the same.
>
> In mathematics I would have written it something like
>
> A = antilog (3·32
Hi,
I'm trying to make some sort of function, rule, trigger, or what ever that
would be capable of modifing my table on an update.
Basically, I have 5 fields, one being a PK (SERIAL), 3 with information, and
the last one a timestamp field that will show the last time the register was
modified (
Why do you want it to rollback?
El Sáb 20 Sep 2003 05:43, Muhyiddin A.M Hayat escribió:
> Ok, but if i do rollback, the auto_increment don't roolback.
> How to use nextval(), currval() and setval() functions.
>
> - Original Message -
> From: Cavit Keskin
> To: 'Muhyiddin A.M Hayat'
>
El Sáb 20 Sep 2003 03:23, Oliver Elphick escribió:
> On Sat, 2003-09-20 at 06:10, Muhyiddin A.M Hayat wrote:
> > How to Create auto_increment field in PostreSQL.
> > Can I create them using Trigger.
>
> Use the SERIAL datatype. See also the functions nextval(), currval()
> and setval().
Also to a
El Mié 10 Sep 2003 10:07, Bruno Wolff III escribió:
> On Wed, Sep 10, 2003 at 20:43:25 +0800,
>
> Richard Sydney-Smith <[EMAIL PROTECTED]> wrote:
> > Tried to issue the command "vacum full" both from psql and the sql box in
> > pgadmin without success.
> >
> > How do you use the command?
> >
> >
Quoting Stephan Szabo <[EMAIL PROTECTED]>:
>
> > The problemas are two:
> >
> > 1) when I try to create the trigger, it says that the function doesn't
> exist.
> > Why is this happening?
>
> You should probably show us what you were trying to do, but I'm going to
> guess that the function doesn
I'm trying to build a trigger that will update a timestamp field in a table with
the current timestamp, and I just can't make it work.
The problemas are two:
1) when I try to create the trigger, it says that the function doesn't exist.
Why is this happening?
2) How does the trigger tell the func
38 matches
Mail list logo
