sqlalchemy-tickets Mailing List for SQLAlchemy (Page 99)
Brought to you by:
zzzeek
Menu
▾
▴
sqlalchemy-tickets — trac tickets and updates forwarded to this list
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
(174) |
Apr
(50) |
May
(71) |
Jun
(129) |
Jul
(113) |
Aug
(141) |
Sep
(82) |
Oct
(142) |
Nov
(97) |
Dec
(72) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2007 |
Jan
(159) |
Feb
(213) |
Mar
(156) |
Apr
(151) |
May
(58) |
Jun
(166) |
Jul
(296) |
Aug
(198) |
Sep
(89) |
Oct
(133) |
Nov
(150) |
Dec
(122) |
| 2008 |
Jan
(144) |
Feb
(65) |
Mar
(71) |
Apr
(69) |
May
(143) |
Jun
(111) |
Jul
(113) |
Aug
(159) |
Sep
(81) |
Oct
(135) |
Nov
(107) |
Dec
(200) |
| 2009 |
Jan
(168) |
Feb
(109) |
Mar
(141) |
Apr
(128) |
May
(119) |
Jun
(132) |
Jul
(136) |
Aug
(154) |
Sep
(151) |
Oct
(181) |
Nov
(223) |
Dec
(169) |
| 2010 |
Jan
(103) |
Feb
(209) |
Mar
(201) |
Apr
(183) |
May
(134) |
Jun
(113) |
Jul
(110) |
Aug
(159) |
Sep
(138) |
Oct
(96) |
Nov
(116) |
Dec
(94) |
| 2011 |
Jan
(97) |
Feb
(188) |
Mar
(157) |
Apr
(158) |
May
(118) |
Jun
(102) |
Jul
(137) |
Aug
(113) |
Sep
(104) |
Oct
(108) |
Nov
(91) |
Dec
(162) |
| 2012 |
Jan
(189) |
Feb
(136) |
Mar
(153) |
Apr
(142) |
May
(90) |
Jun
(141) |
Jul
(67) |
Aug
(77) |
Sep
(113) |
Oct
(68) |
Nov
(101) |
Dec
(122) |
| 2013 |
Jan
(60) |
Feb
(77) |
Mar
(77) |
Apr
(129) |
May
(189) |
Jun
(155) |
Jul
(106) |
Aug
(123) |
Sep
(53) |
Oct
(142) |
Nov
(78) |
Dec
(102) |
| 2014 |
Jan
(143) |
Feb
(93) |
Mar
(35) |
Apr
(26) |
May
(27) |
Jun
(41) |
Jul
(45) |
Aug
(27) |
Sep
(37) |
Oct
(24) |
Nov
(22) |
Dec
(20) |
| 2015 |
Jan
(17) |
Feb
(15) |
Mar
(34) |
Apr
(55) |
May
(33) |
Jun
(31) |
Jul
(27) |
Aug
(17) |
Sep
(22) |
Oct
(26) |
Nov
(27) |
Dec
(22) |
| 2016 |
Jan
(20) |
Feb
(24) |
Mar
(23) |
Apr
(13) |
May
(17) |
Jun
(14) |
Jul
(31) |
Aug
(23) |
Sep
(24) |
Oct
(31) |
Nov
(23) |
Dec
(16) |
| 2017 |
Jan
(24) |
Feb
(20) |
Mar
(27) |
Apr
(24) |
May
(28) |
Jun
(18) |
Jul
(18) |
Aug
(23) |
Sep
(30) |
Oct
(17) |
Nov
(12) |
Dec
(12) |
| 2018 |
Jan
(27) |
Feb
(23) |
Mar
(13) |
Apr
(19) |
May
(21) |
Jun
(29) |
Jul
(11) |
Aug
(22) |
Sep
(14) |
Oct
(9) |
Nov
(24) |
Dec
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:07:05
|
Deleted User for user Nada Dieteman50 -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:07:05
|
Deleted User for user dukang1010 -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:07:05
|
Deleted User for user discounteddisco -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:07:03
|
Deleted User for user brennan10 -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:07:01
|
Deleted User for user christovski -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:07:01
|
Deleted User for user carsondobsonwt -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:07:00
|
Deleted User for user ahussein -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:06:55
|
Deleted User for user Sherron Gwinn -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:06:55
|
Deleted User for user Inseday18 -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:06:55
|
Deleted User for user NitPlaidelate -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:04:15
|
Deleted User for user foobar -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-18 18:00:09
|
New user registration for user foobar -- sqlalchemy <http://www.sqlalchemy.org/> The Database Toolkit for Python |
|
From: sqlalchemy <mi...@zz...> - 2013-05-16 16:59:38
|
#2728: potential glitch in schema calcs for metadata.reflect
--------------------+------------------------------------
Reporter: zzzeek | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: schema | Severity: major - 1-3 hours
Keywords: | Progress State: needs tests
--------------------+------------------------------------
{{{
#!diff
diff -r e57b8df1f95e lib/sqlalchemy/schema.py
--- a/lib/sqlalchemy/schema.py Wed May 15 15:46:29 2013 -0400
+++ b/lib/sqlalchemy/schema.py Thu May 16 12:58:47 2013 -0400
@@ -2716,20 +2716,28 @@
if schema is not None:
reflect_opts['schema'] = schema
- available = util.OrderedSet(bind.engine.table_names(schema,
-
connection=conn))
+ available = util.OrderedSet(bind.engine.table_names(schema,
connection=conn))
if views:
available.update(
bind.dialect.get_view_names(conn, schema)
)
+ if schema is not None:
+ available_w_schema = util.OrderedSet(["%s.%s" % (schema,
name)
+ for name in available])
+ else:
+ available_w_schema = available
+
current = set(self.tables.iterkeys())
if only is None:
- load = [name for name in available if name not in
current]
+ load = [name for name, schname in
+ zip(available, available_w_schema)
+ if schname not in current]
elif util.callable(only):
- load = [name for name in available
- if name not in current and only(name, self)]
+ load = [name for name, schname
+ in zip(available, available_w_schema)
+ if schname not in current and only(name, self)]
else:
missing = [name for name in only if name not in
available]
if missing:
}}}
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2728>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-16 06:35:59
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by ashkop):
Number of elements in indkey is stored in pg_index.indnatts so potentialy
all of them could be checked in some kind of array.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:10>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-16 06:21:51
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by ashkop):
RedShift is based on PostgreSQL 8.0.2 and int2vector could be treated as
array only since 8.1. In amazon they suggested to use pg_get_indexdef(),
but I don't think it could help much in our case.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:9>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 19:47:40
|
#2682: is_ and isnot in conjunction with boolean values / MySQL
-----------------------------------+-------------------------------
Reporter: lievensd | Owner:
Type: defect | Status: closed
Priority: medium | Milestone: 0.8.xx
Component: mysql | Severity: major - 1-3 hours
Resolution: fixed | Keywords: sql, operators
Progress State: completed/closed |
-----------------------------------+-------------------------------
Comment (by zzzeek):
re57b8df1f95e for SQL server
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2682#comment:6>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 19:44:16
|
#2682: is_ and isnot in conjunction with boolean values / MySQL
-----------------------------------+-------------------------------
Reporter: lievensd | Owner:
Type: defect | Status: closed
Priority: medium | Milestone: 0.8.xx
Component: mysql | Severity: major - 1-3 hours
Resolution: fixed | Keywords: sql, operators
Progress State: completed/closed |
-----------------------------------+-------------------------------
Comment (by zzzeek):
see also r70bc2186286b where we added true/false conversion for oracle,
SQL Server is also broken and that's coming up...
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2682#comment:5>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 16:01:28
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by ashkop):
I've asked this on AWS forum. None of the ways I know for Postgres works
on RedShift. Will update as soon as I will receive answer from Amazon.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:8>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 15:48:08
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by zzzeek):
yeah, so indkey can be theoretically any length. how do I tell on
redshift if an int2vector contains the number "12" ?
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:7>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 15:43:49
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by ashkop):
Well, \d+ in psql shows that ix.indkey is int2vector and I can select
indkey[0], indkey[1]. But ANY function does not work.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:6>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 15:26:13
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by zzzeek):
The query there would have to be reworked to work on redshift. It's
certainly possible but would take some time to dive into how redshift has
altered the information schemas.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:5>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 15:21:23
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by ashkop):
RedShift is not postgres, they forked it some time ago and re-worked it a
lot.
I just found info that RedShift does not support arrays and array
functions so it looks like that is not sqlalchemy issue, but limitation of
RedShift. http://docs.aws.amazon.com/redshift/latest/dg/c_unsupported-
postgresql-datatypes.html. Sorry to bother you for nothing.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:4>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 15:12:48
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by zzzeek):
what is the postgresql version they run with redshift? if its like pre
8.0, I'm not sure that I have an immediate solution here.
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:3>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 15:09:30
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Comment (by ashkop):
Nope. But error changed:
{{{
sqlalchemy.exc.ProgrammingError: (ProgrammingError) cannot cast type
int2vector to smallint[]
"\n SELECT a.attname\n FROM\n
pg_class t\n join pg_index ix on t.oid = ix.indrelid\n
join pg_attribute a\n on t.oid=a.attrelid and
a.attnum=ANY(ix.indkey::smallint[])\n WHERE\n
t.oid = %(table_oid)s and ix.indisprimary = 't'\n ORDER BY
a.attnum\n " {'table_oid': 165790}
}}}
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
|
From: sqlalchemy <mi...@zz...> - 2013-05-15 14:52:46
|
#2727: ProgrammingError when autoload from PostgreSQL (Amazon Redshift)
---------------------------+----------------------------------
Reporter: ashkop | Owner: zzzeek
Type: defect | Status: new
Priority: medium | Milestone: 0.8.xx
Component: postgres | Severity: minor - half an hour
Resolution: | Keywords:
Progress State: in queue |
---------------------------+----------------------------------
Changes (by zzzeek):
* component: cextensions => postgres
* severity: no triage selected yet => minor - half an hour
* status_field: awaiting triage => in queue
Comment:
can you tell me if this patch helps please:
{{{
#!diff
diff -r 7699a1080742 lib/sqlalchemy/dialects/postgresql/base.py
--- a/lib/sqlalchemy/dialects/postgresql/base.py Mon May 13
16:13:15 2013 -0400
+++ b/lib/sqlalchemy/dialects/postgresql/base.py Wed May 15
10:52:03 2013 -0400
@@ -1802,7 +1802,7 @@
pg_class t
join pg_index ix on t.oid = ix.indrelid
join pg_attribute a
- on t.oid=a.attrelid and a.attnum=ANY(ix.indkey)
+ on t.oid=a.attrelid and
a.attnum=ANY(ix.indkey::smallint[])
WHERE
t.oid = :table_oid and ix.indisprimary = 't'
ORDER BY a.attnum
}}}
--
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/2727#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python
|
186 messages has been excluded from this view by a project administrator.
