Hello list,
After update a column on a table, that row goes to the top when I do a
select from that table without any order, is that the expected behavior
in postgresql? is there a way to prevent it?
Thanks in advance.
Josué Maldonado
---(end of broadcast)---
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Any comments on this? It seems like a valid confusion. What solutions
> are there?
I think we're stuck. We can't avoid the fact that the SQL syntax uses
the keyword SCHEMA to mean a namespace. We also can't avoid the very
common usage of "database sc
[EMAIL PROTECTED] writes:
> I'd find all this much easier to reason about if I understood how
> the versions of a row are organized and accessed. How does postgresql
> locate the correct version of a row?
It doesn't, particularly. A seqscan will of course visit all the
versions of a row, and an i
Andrew Rawnsley <[EMAIL PROTECTED]> writes:
> Schemas are users in Oracle, but the net effect to the SQL author is
> the same. 'SELECT * FROM SERVICES.USERS' is the same, just that
> 'SERVICES' is a user in oracle (although referred to as a schema, and
> you have to do a 'CREATE SCHEMA AUTHORIZA
On Mon, 1 Mar 2004, Ron St-Pierre wrote:
> You're right I am getting the same results. I created the same table with:
>create table category (
> category_id serial not null primary key,
> category_name character varying(100) not null
>);
>
> alter table category alter column
On 2004.03.02 08:04 Thomas Holmgren wrote:
I need an efficient way of determining if data in
a
table has been changed (either updated, deleted or inserted). Can this
be achieved without scanning the tables using expensive SQL? (my
tables
are _big_!) Is there some way to get a "time for last update
On 01/03/2004 23:22 Phil Campaigne wrote:
Hello,
I originally installed postgresql as root user and now I am setting up a
development environment with cvs and a java ide and tomcat. I have
everything with the exception of postgresql integreted using a non-root
user.
THe process I am using is to
Bruce Momjian wrote:
Any comments on this? It seems like a valid confusion. What solutions
are there?
A common interchangeable title for schema is namespace and in actuality
we use \dn in psql (\dnamespace)
to list them.
Perhaps we should change the name? I believe Oracle uses the ter
On Mon, 1 Mar 2004, Alexander Cohen wrote:
> What sql query can i use to get all relative data to the types of
> fields that a table contains?
select column_name,data_type from information_schema.columns where
table_name='test';
works in 7.4
---(end of broadcast)-
Jan, is this fixed in current CVS and 7.4.X CVS?
---
Jan Wieck wrote:
> [EMAIL PROTECTED] wrote:
>
> >> We had this in the past. I'm not sure and would have to search the
> >> archives but I vaguely remember that this has b
Any comments on this? It seems like a valid confusion. What solutions
are there?
---
Rory Campbell-Lange wrote:
> I think this is a suggestion/comment!
>
> pg_dump man page:
>
> --schema-only
> Dump o
:((
sorry
At server ther is istalled pgsql 7.1.2 but creatlang works from 7.2.X
and upper version :(
do you have any other ideas??
elein wrote:
You just need to define 'plpgsql' as a language in
your database. At the shell, to define the language use:
createlang 'plpgsql' ;
After you do
On Sat, 21 Feb 2004, Simon Windsor wrote:
> Hi
>
>
>
> I am using the standard debian testing release of postgres(7.3.4) and was
> wondering how to produce and md5 string.
>
>
>
> I had thought
>
>
>
> Select md5('joe');
>
>
>
> Would be sufficient?
Doesn't that work? It works f
hi,
the man page says pg_dump cannot dump "large objects".
can some one help me on what does this realy mean? how
large is large? if we have some icons can we still use
pg_dumpall to backup the db?
also large objects do not include large strings,
right?
thanks
cheng
=
Best wishes
Z C Wan
Hi John,
Short answer: you can do cross-schema queries, you can't (easily) do
cross database queries.
Check out this:
http://www.postgresql.org/docs/7.4/static/ddl.html
, the schema section:
http://www.postgresql.org/docs/7.4/static/ddl-schemas.html
I'm not sure when schemas were introduced, but
On Mon, 01 Mar 2004 13:12:12 +1100
Klint Gore <[EMAIL PROTECTED]> wrote:
> The counting and grouping is done after the where clause is applied.
>
> since player iplaybadly (who was 1200's opponent) didnt win any, he/she
> is not included in the result set to be grouped and counted. You need
> to
Guys,
I have approx. 8 hours to finish a deadline, so I can no longer spend time searching
google...haven't found the answer yet.
In PG, is there not a way to select amongst databases?
In other words, if I have one schema called sch1 and another called sch2, and I'm
connected to sch2, could
On Mon, 1 Mar 2004 02:14:56 +0200, Zak McGregor <[EMAIL PROTECTED]> wrote:
> to return a 0 value instead of absolutely nothing if no rows match fixture=4916
> and winner=away? I get absolutely no results at all.
>
> any ideas please?
dont group by winner. it's not returned in the statement so it
18 matches
Mail list logo
