Re: [SQL] OID's

Hello, Michael. Thank you for answer January, 20 2005, 21:48:30: MF> On Thu, Jan 20, 2005 at 03:45:58PM +0500, Mihail Nasedkin wrote: >> How (where) I can get all OID's of the PostgeSQL >> installation? >> In other words where OID's is stored? Is it stored in special table? MF> See the "System

Re: [SQL] still having pg_user error

"Joel Fradkin" <[EMAIL PROTECTED]> writes: > Well I re-installed Fedora 3 and updated my postgres and started the = > service > (no command line stuff). > When I connected using pgadmin I still got the sp_user error. Fedora 3? You should've mentioned that before. I'll bet you've got SELinux ena

[SQL] still having pg_user error

Well I re-installed Fedora 3 and updated my postgres and started the service (no command line stuff). When I connected using pgadmin I still got the sp_user error. I am brand new to both linux and postgres and am a bit frustrated as I have spent the entire day getting no where. Is there

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

Could very well be an install issue I was getting errors trying to see template1. I am in the process of re-installing Linux and will let you know if I still have the error what I get from the select you asked me to run. I appreciate everyones help. If anyone has an interest in the .net utility

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

"Joel Fradkin" <[EMAIL PROTECTED]> writes: > Sorry, that was the statement that caused the error. Hmm. The error is associated with trying to store an oversized row. And CREATE VIEW doesn't store any rows ... except into system catalogs. So the only theory I can think of is that the pg_rewrite ro

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

Joel Fradkin wrote: Sorry, that was the statement that caused the error. I was creating a view that exists in the MSSQL land. It actually joins a few tables. I can put a create statement for all the tables used in and then create the view and re send the txt file with those. I am reloading the LINU

Re: [SQL] OFFSET impact on Performance???

Greg Stark wrote: "Andrei Bintintan" <[EMAIL PROTECTED]> writes: If you're using this to provide "pages" of results, could you use a cursor? What do you mean by that? Cursor? Yes I'm using this to provide "pages", but If I jump to the last pages it goes very slow. The best way to do pages for is

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

Sorry, that was the statement that caused the error. I was creating a view that exists in the MSSQL land. It actually joins a few tables. I can put a create statement for all the tables used in and then create the view and re send the txt file with those. I am reloading the LINUX from scratch at th

Re: [SQL] automatic table locking on too many locked records?

KÖPFERL Robert wrote: Hi all and Michael. An MS-SQL experienced developer warned me that on MS-SQLsvr a whole table gets locked if a certain percentage or amount of records are locked due to an update. And then shortly nothing goes. Does there exist a similar behaviour on pgSQL? Get tables locked i

Re: [SQL] OFFSET impact on Performance???

"Andrei Bintintan" <[EMAIL PROTECTED]> writes: > > If you're using this to provide "pages" of results, could you use a cursor? > What do you mean by that? Cursor? > > Yes I'm using this to provide "pages", but If I jump to the last pages it goes > very slow. The best way to do pages for is not t

Re: [PERFORM] [SQL] OFFSET impact on Performance???

Alex Turner wrote: I am also very interesting in this very question.. Is there any way to declare a persistant cursor that remains open between pg sessions? Not sure how this would work. What do you do with multiple connections? Only one can access the cursor, so which should it be? This would b

Re: [SQL] OID's

On Thu, Jan 20, 2005 at 03:45:58PM +0500, Mihail Nasedkin wrote: > How (where) I can get all OID's of the PostgeSQL > installation? > In other words where OID's is stored? Is it stored in special table? See the "System Columns" section in the "Data Definition" chapter of the PostgreSQL documentat

[SQL] automatic table locking on too many locked records?

Hi all and Michael. An MS-SQL experienced developer warned me that on MS-SQLsvr a whole table gets locked if a certain percentage or amount of records are locked due to an update. And then shortly nothing goes. Does there exist a similar behaviour on pgSQL? Get tables locked if too many records ar

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

On Thu, Jan 20, 2005 at 08:56:12AM -0500, Joel Fradkin wrote: > I am enclosing a text file if this is not the correct manner let me know > whats best way its not a lot of lines. The file you attached contains a view definition but it doesn't show the underlying tables, nor the statement that resu

Re: [SQL] OFFSET impact on Performance???

Andrei Bintintan wrote: If you're using this to provide "pages" of results, could you use a cursor? What do you mean by that? Cursor? Yes I'm using this to provide "pages", but If I jump to the last pages it goes very slow. DECLARE mycursor CURSOR FOR SELECT * FROM ... FETCH FORWARD 10 IN mycurso

Re: [SQL] pg_user relationship does not exist

O Joel Fradkin έγραψε στις Jan 20, 2005 : > Not sure this is the correct place to ask, but when I log in with pgadminIII > I get that message. Maybe do extensive logging (show queries,etc..)(see in postgresql.conf), and then examine your log to see what pgadminIII is asking for. > > > > Any

[SQL] pg_user relationship does not exist

Not sure this is the correct place to ask, but when I log in with pgadminIII I get that message.   Any ideas how to fix? Do I need to redo my data base or something?   Joel Fradkin   Wazagua, LLC 2520 Trailmate Dr Sarasota, Florida 34243 Tel.  941-753-7111 ext 305   [EMAIL P

Re: [SQL] ERROR: row is too big: size 9856, maximum size 8136

I am enclosing a text file if this is not the correct manner let me know whats best way its not a lot of lines. ServerVersion: 07.03.0200 PostgreSQL 7.4.6 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2 ERROR: row is too big: size 9856, maximum

Re: [SQL] OFFSET impact on Performance???

If you're using this to provide "pages" of results, could you use a cursor? What do you mean by that? Cursor? Yes I'm using this to provide "pages", but If I jump to the last pages it goes very slow. Andy. - Original Message - From: "Richard Huxton" To: "Andrei Bintintan" <[EMAIL PROTE

Re: [SQL] OFFSET impact on Performance???

Andrei Bintintan wrote: Hi to all, I have the following 2 examples. Now, regarding on the offset if it is small(10) or big(>5) what is the impact on the performance of the query?? I noticed that if I return more data's(columns) or if I make more joins then the query runs even slower if the OFFS

[SQL] OFFSET impact on Performance???

Hi to all, I have the following 2 examples. Now, regarding on the offset if it is small(10) or big(>5) what is the impact on the performance of the query?? I noticed that if I return more data's(columns) or if I make more joins then the query runs even slower if the OFFSET is bigger. Ho

[SQL] OID's

Hi, I have a question about OID. How (where) I can get all OID's of the PostgeSQL installation? In other words where OID's is stored? Is it stored in special table? I would like use some SQL queries with the all OID's. Is this possible? I hadn't find the answer in the FAQ ( 4.16 What is an OID

Re: [SQL] Problem on Geometric functions

On Thu, Jan 20, 2005 at 10:39:47AM +0100, Silke Trissl wrote: > Table "reference.coord_test" >Column| Type | Modifiers > -+-+--- > node_name | integer | > plane_coord | point | > > > I would like to find all points from the table that are within a squ

Re: [SQL] SQL timestamp to date cast

On Thu, Jan 20, 2005 at 11:41:41AM +0200, Andrei Bintintan wrote: > >Another possibility would be to create a functional index on datetime: > > > >CREATE INDEX user_action_date_idx ON user_action (date(datetime)); > > GREAT!!! I thought it is possible but I didn't knew how to make such > indexes.

Re: [SQL] SQL timestamp to date cast

Another possibility would be to create a functional index on datetime: CREATE INDEX user_action_date_idx ON user_action (date(datetime)); GREAT!!! I thought it is possible but I didn't knew how to make such indexes. :)) Thank you !!! Andy. - Original Message - From: "Michael Fuhr" <[EMAI

[SQL] Problem on Geometric functions

Hello, I have a table that has an attribute 'identifier', declared as integer and an attribute 'plane_coord' defined as 'point': Table "reference.coord_test" Column| Type | Modifiers -+-+--- node_name | integer | plane_coord | point | I would like to fi

Re: [SQL] SQL timestamp to date cast

On Thu, Jan 20, 2005 at 10:52:50AM +0200, Andrei Bintintan wrote: > SELECT DISTINCT(nummer) > FROM user_action > WHERE datetime::date='11/11/2004' AND id_action IN (5,6,9) > > Now, datetime has the type timestamp. How can I make an index or write > different this query so that it runs faster? Yo

[SQL] SQL timestamp to date cast

Hi,   I have the following query:   SELECT DISTINCT(nummer) FROM user_action WHERE datetime::date='11/11/2004' AND id_action IN (5,6,9)   Now, datetime has the type timestamp. How can I make an index or write different this query so that it runs faster? It really takes some time sometimes.